Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Accessing Event Variables in ACS (Transactional Messaging)

davidh2892249
Level 5
Level 5

Hi there,

 

I'm setting up some Transactional messages whereby the email trigger must be real time, but I cannot guarantee the profile will exist in the ACS profiles table.

Therefore I am setting up as an event transactional message rather than a profile transactional message.

 

At a later date, I'd like to be able to access details of each record of the event for follow up processing. This could be:

* Exporting back to data warehouse

* Updating a custom resource in ACS

* Cross referencing with profile data

 

For any of these activities, I need to be able to query the event and access the custom fields (and their values) that were created for the event. However, when i use a workflow query and change the resource to one of the events that has been set up... only the standard attributes (e.g. status) are visible, not the custom ones created for the event.

 

Can anyone share any insight on this? Is there a way to access those event fields? (they must be stored as i'm still able to view a mirror version of each email sent).

 

Thanks

 

David 

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

True, they are not accessible in a query/enrichment activity.

Though they can be used in an Export File activity.

 

Either to upload them somewhere or you could directly parse the same file again in the workflow and then have the values accessible

View solution in original post

4 Replies
ramon_bisswanger
Correct answer by
Employee
Employee

True, they are not accessible in a query/enrichment activity.

Though they can be used in an Export File activity.

 

Either to upload them somewhere or you could directly parse the same file again in the workflow and then have the values accessible

View solution in original post

davidh2892249
Level 5
Level 5

Hi @ramon_bisswanger

 

Thanks for the answer, really useful to see the ctx data available for export.

 

Are you essentially saying a workflow something like:

Query (delivery logs of event) --> Data Extract (including ctx fields) --> File Transfer (upload) to SFTP --> File Transfer (download) from SFTP --> Data Loading --> I'd now have the CTX data in a workflow temp schema for further processing.

 

And one more question if you don't mind....
Is it possible to query all delivery logs of all events (and then export a common ctx field?)

I think in my use case i'd like to export all delivery logs of all events (without having to specifically query explicit events) and a common ctx field they should all most likely have (e.g. ctx.customerID).

 

I hope that makes sense.

 

Thanks for the help.

ramon_bisswanger
Employee
Employee

For the workflow, you can link the Data Extract directly with the Data Loading activity.

There is no need to send that to the SFTP server in between.

 

For the query part, unfortunately I think it won't work.

You would have to process them event by event.

davidh2892249
Level 5
Level 5

Thanks for responding.Good to know you can cut out the SFTP step.

 

Shame you can't query multiple events, but makes sense why. Sounds like a solution for a handful of events but not really flexible scaleable.

Thanks again