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

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

  • July 28, 2021
  • 1 reply
  • 171 views
E

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

    D
    Forum|alt.badge.img+1
    • dsebba
    • August 11, 2021

    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.

    Terms & ConditionsAccessibility statement