Hi @wpomeroy, Not sure I completely understood your question, but you
can add a where clause or a group by clause to get an aggregate or a
single row. You can also add a lineCount to your query def to get the
number of row you want. Hope that helps.Thanks,David
Hi @wpomeroy , You should write var query = xtk.queryDef.create
()var itemsXML =
query.ExecuteQuery();vars.itemsXMLString = itemsXML.toXMLString();
sortDesc="true" will return descending sortThanks,David
In this case the end point will be your marketing instance.You'll need a
logon method first to get the session token then you will need a write
method to write in your schema You need to specify the operation and the
key (example: I’m updating my gender and status using email as
reconciliation key)Here is an example of a call:
Thanks,David
Hi there,Assuming you want to use last name under recipient schema. If
your block is a JS recipient.lastNameIf your block is html then <%=
recipient.lastName %> Basically make sure you can read you calculated
data from the workflow. Thanks,David
Hi Rodney, You need to get the xtk:session WSDL too.URL syntax for
generating the session and rtEvent WSDL's.Generate session token WSDL
http://hostname/nl/jsp/schemawsdl.jsp?schema=xtk:sessionGenerate rtEvent
WSDL http://hostname/nl/jsp/schemawsdl.jsp?schema=nms:rtEventThen you
can use the session WSDL first to request the logon methodOnce you log
in, you will need two information for your rtEvent call header:
sessionToken and SecurityToken (pstrSessionToken and pstrSecurityToken
from your logo...
Maybe someone purge the logs or you have a technical workflow that is
doing it. Go to the audit trail and search the last actions on your
workflow there.
Hi,Add this to smtp headerPrecedence: bulkList-Unsubscribe: <%=
provider.errorAddress !='' ?
provider.errorAddress:delivery.mailParameters.errorAddress
%>?subject=unsubscribe<%=escape(message.mimeMessageId) %>> For bulk
upload, you can try to do it in a JS. Moving forward you can add a
typology rules to add it automatically to all deliveries. Thanks,David
Hi,Add an enrichment with the Org unit nameUse a reconciliation to Org
unit table on the name Then you should be able to use the result in an
update data activity ThanksDavid
Hi, You can not achieve this by using option but you can use a typology
to exclude certain domains or email addresses from your deliveries.See
below, I'm blocking all domains except adobe, mailinator, yopmail, etc
Thanks,David
Hi, First of all for union activity, your targeting dimension needs to
be the same. Then you can rename your join fields (label and alias) in
each transition and use it in you union. Thanks,David
Hi,invalid_client can have two reasons:400 invalid_client: Integration
does not exist. This applies both to the client_id parameter and the aud
in the JWT. The client_id parameter and the aud field in the JWT do not
match.401 invalid_client: Integration does not have the exchange_jwt
scope. This indicates an improper client configuration. Contact the
Adobe I/O team to resolve it. The client ID and client secret
combination is invalid.You need to connect to Adobe IO Console to get
the correct inf...
So If I understand, the structure is correct but you're not getting the
data. Can you check your response body in Postman? Then make sure it
matches with column definition in your activity.
Hi,The activity also can do HTTP POST to web services. You can try:*
Define any query (can have record count 0)* Then define any field
mapping in the outbound mappingThis then shall trigger a POST call.
Thanks,David
Hi,You can request a python code from Adobe Support. It is a set of 3
python files (config.py, create_JWT.py and
get_accessToken_from_JWT.py)You can also follow this process Using
Postman for JWT Authentication on Adobe I/OThanksDavid
Hi, You may fetch temp schema like this:var schemaName =
vars.targetSchema.substr(vars.targetSchema.indexOf(":") +
1);logInfo(schemaName);var query = xtk.queryDef.create();If you are sure in this above, you
may try this for writing:var some_variable =
;xtk.session.Write(some_variable);Thanks,David
Hi Nitesh, Create your libraries in a perso blocks. Call your blocks at
the beginning of your deliveries and then you can used function as in
the url below <%@ include view='AesLibrary' %> --> crypto js library<%@
include view='AesModeOfOperation' %> --> crypto function (cbc, etc,)
href="http://xxxx.com/email_unsubscribe.aspx?email=<%=
cbcEncrypt(recipient.targetData.email) %>&source=ACC" Thanks,David
Hi, You need to extend the seed schema to match your custom recipient
schema. See the Adobe Documentation Seed Address. The example is showing
how to do it for email but it's almost the same process for DM.
Thanks,David
Hi Ramaswami, You may need to do a defragmentation of data across the
database as it removes bloat from the system which is caused by constant
deletes done to the schemas.In high transactional databases, deletes
performed on schemas cause bloat or empty spaces. This bloat
continuously grows until a defragmentation is carried out.Some of the
indexes also need to be deleted or recomputed. You can find more details
Data model best practices or Technical maintenance Basically, you will
need a DBA to...
Hi Nitesh, You will need to download some crypto js libraries and write
down some functions.You can take a look at Creating JSON Web Token in
JavaScript or this demo video Thanks,David
