Get ContactID for a Response | Experience Community
Skip to main content
JoseS
Administrator
1 year ago
Solved

Get ContactID for a Response

  • Mar 19, 2018 4:13 PM UTC
  • 8 replies
  • 1218 views
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 by AravindA

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!
View original

    8 replies

    Michael_Campbell_RedPepper
    QPN Level 3 ●●●
    Forum|alt.badge.img+3
    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
    Level 8 ●●●●●●●●
    Forum|alt.badge.img+27
    • TomG
    • Level 8 ●●●●●●●●
    • Mar 19, 2018 7:17 PM UTC
    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
    • Author
    • Mar 19, 2018 8:00 PM UTC
    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
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • Mar 19, 2018 8:04 PM UTC
      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
        • Author
        • Mar 19, 2018 8:33 PM UTC
        How to include RecipientID in the response export?
        TomG
        Level 8 ●●●●●●●●
        Forum|alt.badge.img+27
        • TomG
        • Level 8 ●●●●●●●●
        • Mar 19, 2018 8:38 PM UTC
        Just add it as an embedded variable: !
          • igress
          • Author
          • Mar 19, 2018 9:04 PM UTC
          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
          AravindA
          Qualtrics Employee
          • AravindA
          • Qualtrics Employee
          • Answer
          • May 2, 2018 2:17 AM UTC
          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!
            Terms & ConditionsAccessibility statement