Which API call do I have to make to figure out how many people the survey was sent to? | XM Community
Question

Which API call do I have to make to figure out how many people the survey was sent to?

  • 28 July 2021
  • 1 reply
  • 90 views

I am a person working at an organization trying to set up an automated ETL through the API for BI reporting.
Generally the data points I'm looking for are going to come from "Surveys Response Import/Export" and the number of rows in that data set for each survey will give me the number for the numerator calculate the numerator for response rate.
I'm not sure how to get the denominator.Ideally looking in the documentation, I thought it would be a key under "Get Survey" or "Get Survey Metadata".
Any guidance would be greatly appreciated. Thank you!


1 reply

Badge +1

I'm using EX, so your mileage may vary. But what I did was get all the distributions for the survey, and then all the mailing lists those distributions went to.
API_base_URL/distributions?offset=0&surveyId={SurveyID}
gets all distributions
Each one has a list of recipients, and those contain MailingListIDs, which you can use with
API_base_URL/mailinglists/{MailingListID}/contacts
To get all the individuals in the mailing list.
Then just count.

Leave a Reply