Ticket Data to update survey data | XM Community

Ticket Data to update survey data

  • 23 September 2022
  • 3 replies
  • 63 views

Userlevel 5
Badge +31
  • Level 4 ●●●●
  • 164 replies

I have a scenario where the public will submit a Qualtrics form (application to attend an event), the form creates a Qualtrics Ticket, and a user reviews the Ticket and approves/rejects the applications (radio button in the ticket).
I need to be able to pass only the approved applications to an external SFTP server in XML format to be injected by another system.
I know how to do all the steps above except write data from the ticket back to the survey to flag it as approved.
Open to any suggestions, including a total process rewrite.

Thank you in advance!


3 replies

Userlevel 7
Badge +18

The only thing I can think of is have API pull ticket data (which should include the response ID), and then it push the necessary update back to survey data based on that response ID via another API call. I think this API work would need to happen outside of Qualtrics, but maybe someone will have a better idea.

Userlevel 5
Badge +31

Thank you for the suggestion, I'm reading up on the API to see if I can put something together.

Userlevel 7
Badge +36

Radam
As mentioned by InessaG the only possible way is through API. I would like to provide more specifics here.
You can create a ticket event based workflow. Within which you can choose status changed. Have the condition to say if status is Approved. Here, kindly include an embedded data in survey flow called ResponseID to record the response id and then include it in the ticket data as well while you create ticket task. Post which use this in the API task to update the response.
Once done include an webservice task: API task of update response. Configure to update an embedded data to approved. If the above conditions are satisfied. Your URL would look like: https://yul1.qualtrics.com/API/v3/responses/${tck://Field/responseId}.
This is how your configuration would look:
image.pngStatus : Approved in your case.
image.pngHope this helps!

Leave a Reply