API to get Transaction Automations of the day

Question

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 distributionSome 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 · Accepted Answer

Thank you,@chackbuschfor 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 APIhttps://api.qualtrics.com/d476c17b493db-list-transaction-batcheswhich will give you all the batches of that day and then this API.https://api.qualtrics.com/eaaba8f962f0d-list-transactions-in-a-batchwill get all the detail.I even have a diagram for the process

chackbusch · Answer

@Nam NguyenNot 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-transactionsBecause 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.BestChristian

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded