Questions tagged [responsys]
37 questions
0
votes
2 answers
How can i save the campaign name from responsys on a form
I'm trying to get the name of the campaign where the person opened the form and save it in the supplemental table of the form.
I saw that it has the campaignname() function but I didn't know how to use it.
the form call in the body of the…
0
votes
2 answers
Freemarker (Responsys RPL variant) Interpret & exec a key/value pair from a table
I'm reading a key/value pair from a table which is denoted as such:
fruit:${my_fruit} in the FOOD column.
In my Freemarker code, I have, say:
<#assign my_fruit = "banana">
I want to wind up with the equivalent of
<#assign fruit = ${my_fruit}>…
ikonoklast
- 1
- 1
0
votes
1 answer
Rendering HTML from string in email using Oracle Responsys
I'm looking to render html by passing a string to Responsys.
DynamicVariable.TEXT would be a string that looks like:
0
votes
0 answers
Connect job notification alert in reponsys
In oracle responsys, I am doing connect job to import a file from the server but in the notification step I observed that, there is an limit to add the emails so I entered the group email id (XYZ@outlook.com) to check whether it triggers or not to…
Akshay
- 359
- 1
- 3
- 14
0
votes
1 answer
How I filter SQL using curdate? (example: registers that column "created_date" are more than 180 ago) (responsys - oracle)
I need to filter my list based on date time.
Example: "people who purchased 180 days ago"
However I need that the comparison be with actual date (system date), so that I don't have to filter manually every day.
Lu174094
- 3
- 1
0
votes
1 answer
mailto: valid address doesn't prompt mail app?
I'm trying to include a mailto link to a specific email address within the body copy of my HTML email.
For some reason, this particular email address does not register with my mailing app. My HTML here is:
vkwan
- 1
0
votes
1 answer
How use notification icon from React Native app to some RNBridge?
I created a bridge to React Native to work with Oracle-Responsys SDK.
The bridge is working pretty well, but the only thing that I'm stuck is in how can I set the notifications icons from my react native app to this bridge.
Following the…
Diego Oliveira
- 31
- 4
0
votes
2 answers
Why are the columns in my html table not uniform when scaling down
I am building out an email to be compatible across all devices/screen sizes. Since it is an email, I have to use tables which as we all know were spawned in hell. I am having an issue where I have three columns side-by-side with identical code but…
AFlyingLemon
- 53
- 1
- 2
- 7
0
votes
1 answer
Oracle Responsys RPL: Render HTML from a String in email
Im trying to render html tags from a string in Responsys RPL
<#assign text = "hello world">
${text}
Output: hello world
I want it to be
Output: hello world
Are there any metodes for executing the html tag when rendered?
Bidstrup
- 1,597
- 2
- 16
- 32
0
votes
1 answer
Logic to Find the position of last node in Responys EMD Version
0
votes
0 answers
How to do this Birthdays in the next two weeks using Responsys MYSQL
I'm setting up a segment using SQL and I need to capture contacts that birthday will be 15 days from now.
SELECT *
FROM $A$
WHERE EXTRACT(month FROM BIRTHDATE) = EXTRACT(month FROM CURRENT_TIMESTAMP)
AND EXTRACT(day FROM BIRTHDATE) =…
Peter
- 1
0
votes
1 answer
Responsys: Create a tracked link with dynamic path
I am looking to create a dynamic/tracked link from a supplementary tabled based on product ID.
The URL format is:
https: // site.com/product/{$id}
Using the ${clickthrough('my_products',table.id)} method hasn't worked. The resulting URL, while…
Rich McPharlin
- 3
- 3
0
votes
1 answer
Getting Data together for program and campaigns from three tables
I'm facing the following problem.
I have a list of Back in Stock requests. Each request gets its own RIID and the email is hashed. I also have the product id of the product.
What I then created is a SQL view that pulls the contact data from the…
Sebastian Hansen
- 1
- 2
0
votes
1 answer
Why does limiting a working query by WHERE ROWNUM <=10 result in an error from the EXPLAIN PLAN "ORA-12899: value too large for column"?
I am executing this query and explain plan inside Responsys.
The explain plan for this query works fine and returns about 70 rows of count data:
select * from ( Select LOCATION, count(LOCATION) COUNT_LOCATION From TABLE Group By LOCATION Order By…
Cale Sweeney
- 1,014
- 1
- 15
- 37
0
votes
1 answer
SQL Multiple Selects with COUNT(*)
I do not normally work in SQL, but I am working in Oracle Responsys and have run into a bit of a complicated list filtering request which I feel can be solved with SQL.
I have a list of 250,000 Customer IDs managed by 10,000 Representatives. Each…
Nick W
- 1
- 1