Get ContactID for a Response

igress
igress Community Member - Trial User Qubie ✭

Hi,
Is there a way to get the ContactId of the response. Currently when I export the response data for a survey via API, the csv has a Recipient email/first name/last name etc however it does not have any ContactId.

Background:
Currently I am trying to create prototype and in order to relate the response data to contact data I am doing the following:
(1) That gets a Survey data for an SurveyID
(2) Get's the Distribution list and MailingListID (I have only 1 distribution list)
(3) Get's the contacts from the Distribution list
(4) Download the response data
(5) Join the response data to contact data based on email address
(6) Save it to another database

I don't want to use the email as the "Joining" entity.

Thanks

Best Answer

  • AravindA
    AravindA SeattleCommunity Member - Trial User Qubie ✭
    edited May 2018 Accepted Answer

    Unfortunately, we don't have an API endpoint to do this right now. However, we have heard this request a few times now. I have since notified the Target Audience team to add this to their backlog!

Answers

  • Michael_Campbell_RedPepper
    Michael_Campbell_RedPepper Pleasant Grove, UTCommunity Member, Qualtrics Partner Sage ✭✭✭

    Let me look into this - I would expect that the ContactID would be included with the export, but I haven't worked much with it. Perhaps you could include it as an Embedded Field?

  • TomG
    TomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭

    You can include RecipientID as an embedded data field. If you are using Target Audience RecipientID and contact id are not the same thing. Including ContactID as an embedded data field doesn't work.

  • igress
    igress Community Member - Trial User Qubie ✭

    Yeah there is no way to include ContactID as an embedded field. Look's like the only way to join them is use email as I suggested in my post

  • TomG
    TomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭
    edited March 2018

    Why not use RecipientID as the joining field? It is a unique identifier for a recipient in a mailing list and doesn't change.

  • igress
    igress Community Member - Trial User Qubie ✭

    How to include RecipientID in the response export?

  • TomG
    TomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭

    Just add it as an embedded variable:

  • igress
    igress Community Member - Trial User Qubie ✭

    Thanks! that works. I am looking if there is an existing API call (or chain of calls) that I can use to get the Contact details using the RecepientID