@wodnicki, I am not using the contents of external file here. All i need
to do is to send the below circled variable which is just a calcualted
feild in additional data to API so that it can pipe in email template :
my javascript which i kept after a query activity : i want to pipe in
the delivery there :
Hi @MarceL, I tried to send out the delivery through API method like
below. I am pulling the emails from query activity and looping through
the API like below: This is my workflow : inside the javascript:
logInfo("Table name:"+vars.tableName);var cnx =
application.getConnection();var details = cnx.query("select semail from
"+vars.tableName);for each(var row in
details){logInfo("row[1]:"+row[0]);var emailCondition = "@email =
'"+row[0]+"'";var deliveryname = "prdDM30934274";logInfo("before
...
Hi @DavidKangni, I am new to this. Can you give me an example ?
Currently i am able to send the deliveries through API but there are
some variables of recipient table which i need to pass to delivery
template like ( recipient.firstname) how can i do so ? along with email
i need to pass two more variables of recipient table. Currently this is
my code : // vars.tableName = table which is generated by query activity
and it has email columnvar cnx = application.getConnection();var details
= cnx.quer...
Hi Guys, I have email template with the feilds in recipient table like
<%= recipient.firstname%>, <%=targetData.anneversary%> Currently I am
passing email field to SubmitNotification API call like below : Note:
When i pass @ID instead of @email my recipient.firstname piped
correctly. But the question is how can i get a personalized feild that
is "anneversary" which i calculated in additional data of query activity
into email template through API. Do we have any tags for this like
etc..,, var em...
hi @kgiribabu, I have encountered with same situation. i need to pass
the variables which are calculated in query activity like
targetData.currentDate which are piped in the email template. Any ideas
here? @_Manoj_Kumar : the example you have given is not working for me
passing the variables through API. Do you have any other solution for
this.? @wodnicki any suggestions here?
Hi Team, I am seding emails through javascript API like the below : in
my javascript code : var emailCondition = "@email = 'abc@gmail.com'";var
deliveryId = nms.delivery.SubmitNotification
("prdDM30608",);logInfo("deliveryid
: "+deliveryId) Currently it is taking the email address statically. I
want the email address to be taken dynamically from the query activity.
How can i do that ? solution which I am following ( but i don't think so
this is a nice solution as when i follow this solution the ...
Your example :
by the way what is @ID here ( is it the primary key of recipient table?
) so can I write like below : pulling the primary keys from
vars.tablename (which is a table generated from query activity) var
arrayValues=[primary keys OR Email ids]; for ( var
i=0;i)}Will
this work?
I just want to send real emails not the notifications through the API
function from javascript. the target will be coming from the query
activity and in the api call i need to pass the respondents which i got
from query activity. Is there a documentation on how to do that. i found
documentation functions like
https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/sm-operation-StartDelivery.html
but i want to send delivery by passing respondent emails from query
activity t...
Hi Folks, My task is to send emails through API methods which are
available in adobe campaign classic. I am pulling records from query
activity and the next i am placing a javascript node and calling the
method : logInfo(NLWS.nmsDelivery.SubmitDelivery("prdDM30931",""); where
prdDM30931 is the delivery template name which i created manually. this
is the method declaration given in documentation. Number deliveryId =
SubmitDelivery ( String scenarioName, XML content )so i assume something
has to b...
We can allow dynamic selection of email templates based on country,
language of a reicipient grabbed from a query activity. The idea is that
there will be one common workflow and it will select the email template
based on the recipient country, language criteria and send out the
email. I think we can leverage API's to create these workflows. Do we
have any ideas here.
I am calling trustpilot api through javascript node and sending some
records to that api so the api will send invitations to the records
which send. the javascript is running fine but once a time i am
encountering below error : 11/06/2020 3:23:01 PM js2 IOB-090008 Failure
while resolving address 'invitations-api.trustpilot.com' (errno=-11)
followed by the below error messages : 11/06/2020 3:23:03 PM
Automatically resuming workflow (number of consecutive times:
1).11/06/2020 3:23:01 PM WDB-200000...
In the deployment wizard we have an option for storing audit logs for
360days : but if i got to workflow journal and filter the logs of last
month it shows 0 messages : can i know where i can see the last months
logs of workflows?
so basically here is where we need to update the headers in email
templates- but my question is how to update them in bulk ? and how to do
that in typology rules. can you give us an example.
How can i include a header in emails? Is there any way to bulk update
the templates in email to incorporate the headers for any future emails
that are sent out.
What are the partners available for SMPP. Has anyone implemented bulk
SMS in Adobe, if so what partners they have used for US. What are the
steps involved in that. Can you please suggest?
Knowing that Twilio has an options for bulk SMS. Our company uses Twilio
for different purpose. Now i wanted to know one thing. If in order to
send bulk sms querying from adobe do i need to add a twilio setting OR
so i need to call the twilio API for that. All i need to know is does
Adobe needs an API or is it just settings that needs to be done on Adobe
side to send out bulk SMS messages
Hi Team, How can i connect to mysql/snowflake databases which are
outside adobe. Can you please let me know the steps for this. Can i
execute snowflake/mysql queries from adobe campaign after configuring in
adobe. Can you please let me know if there is any documentation.
Hi Team, i got an alert from adobe saying that database is full upto
82%. What i am doing is applying some data retention rules on the custom
tables. For example : in my prod instance it has lot of custom tables
with large data and i am applying a delete based on some criteria. i am
using a javascript node : and executing a delete function like below :
var delete = "delete from tablename where created date > some
date"sqlexec(delete); Note : i am not commiting this. i am doing like
this for two ...
I see these two functions used in javascript node and written some code
under these functions ( they defined the function ) like for example: in
the javascript node of a workflow they added : function onBeforeCall()
{logInfo("task.activity:" + task.activity);if
((activity.img.indexOf("nms:activities/delivery.png") != -1) ||
(activity.img.indexOf("nms:activities/email.png") != -1) ||
((activity.img.indexOf("nms:activities/notification.png") != -1) &&
(task.activity == 'notification'))) { // some ...
Hi @milan tried like this and it says id should be in group by :
09/03/2020 6:00:51 AM query PGS-220000 PostgreSQL error: ERROR: column
"n0.id" must appear in the GROUP BY clause or be used in an aggregate
function LINE 1: ...ATED_DATE, 'America/Chicago')), N0.RESPONDENT_ID,
N0.ID FROM... if i keep id in group by it is giving me all the counts
like : So for each respondent it is giving me min date of the unique id
which is not what we need : here the resp is same but because of group
by unique i...
Hi Team, Can any one let me know how to configure SMS channel in Adobe
classic. Currently we are only using email channel. Questions : 1. is it
chargable if we use SMS channel2. Can we configure this channel or is it
Adobe's task to configure for us3. Can you provde me some documentations
if we can configure ourselfs.
