Updating Database Response using Qualtrics API | XM Community
Skip to main content
Solved

Updating Database Response using Qualtrics API

  • 18 July 2024
  • 4 replies
  • 61 views

Hi!

I have two different situation for which I´d need to use API to fix.

  1. Situation 1: Update a response database spliting Response Date column into Day, Month and Year.
  2. Situation 2: Just update response matadata.

To both of them, I was planning to use this API, which is something I´m used to use. However it is depreceated. Does anyone has any ideas or thoughts on what should I use instead?

4 replies

chackbusch
Rank
Userlevel 5
Badge +17

@cami_mq Are you actually working with a imported data project or do you have a usual survey project for which you need to adjust the response data? 

With this API you can update records in an imported data project: 

https://api.qualtrics.com/ff082082294c7-update-a-record-in-an-imported-data-project

If you first need to export all responses: 

  1. Start export: https://api.qualtrics.com/3c1b2b90c48dd-starts-an-idp-export
  2. Get export process: https://api.qualtrics.com/9b6d4d29b99ce-get-export-progress
  3. Get export file: https://api.qualtrics.com/63e2f1bf0316f-get-export-file

If you only need to update usual survey responses (no imported data project), choose this one: 

https://api.qualtrics.com/daed82306b1ea-update-response

Best
Christian

Driving Qualtrics @ MHP – A Porsche Company 🚀
cami_mq
Rank
Badge +1

Hi, @chackbusch !

 

I´m actually in the second situation: I need to update a survey that is already in place. I was not clear enough in my question, I´m sorry about that!

 

Thanks a lot for your clarification. I´ll work with the option you gave! 😊

D
Badge

Hello @chackbusch,

I was wondering, with the update record in imported data project API, I tried using it but I am getting an error “Supplied record does not contain uniqueID: EMAIL”.

My unique ID is the email and when I test, I am using an email address I am 100% sure is in the imported data file.

I was wondering why I am encountering this error? 

chackbusch
Rank
Userlevel 5
Badge +17

@DaniD I assume you refer to this API. You provide the email in uniqueField?

Have you also defined the email address as ID in your project? Should have some id info:

 

Driving Qualtrics @ MHP – A Porsche Company 🚀

Leave a Reply


Terms & Conditions