API to get Transaction Automations of the day | XM Community
Skip to main content

Hi Community,

We’re using this API https://api.qualtrics.com/e1a3a30cd376b-upload-a-file to upload a file every day for Automation in Directory to run the Profile and Transaction import
 

This import then linked to 11 distribution

Some of the email got sent but some does not so we have this API https://api.qualtrics.com/8840efb2c71a8-list-distribution-history to get the status of each email and filter the failed to send. Now, how can I track back to the Transaction on that day that linked with the failed to send email? We need the transaction info to send the survey over other channel.
Thank you in advance!

@Nam Nguyen Not sure if there is some reliable link but question from business perspective…

Can it be that the same contact is part of the import for different transactions (nearly) at the same time? If not, I would probably add some type to the transactions when they are important, such as „Purchase“ and later read all transactions of the contact and search them for the „Purchase“ transaction with the same date as the distribution. Or if you have like a blocking period defined from business perspective (e.g., same contact can only be considered for important once each 30 days), I would just consider the last „Purchase“ transaction of the contact…

API to get all transactions:

https://api.qualtrics.com/4d20708240964-list-contact-transactions

Because e.g., the response ID provided in the distribution history API can not be used for the link because there is no response ID in failure case.

Best

Christian


Thank you, @chackbusch for your response. Just to anyone who stumble upon the similar problem, I found the answer after a week.

It’s turn out the Automation Transaction Import run everything in a form of Transaction Batch. So all you need is this API https://api.qualtrics.com/d476c17b493db-list-transaction-batches which will give you all the batches of that day and then this API. https://api.qualtrics.com/eaaba8f962f0d-list-transactions-in-a-batch will get all the detail.

I even have a diagram for the process

 


Leave a Reply