Importing data with API which includes a list parameter

[Anonymous]

Hi ,

I need to download All contacts from a survey.

1. Each Survey has multiple Campaigns.
2. Each Campaign has multiple Contacts.

query "Contacts" :

= Json.Document(Web.Contents("https://api.alchemer.eu/v5/survey/"&SurveyIdParameter&"/surveycampaign/"&CampaignIdParameter&"/surveycontact?&api_token=123456&api_token_secret=123456"))

SurveyIdParameter is a single value eneterd manually.

CampaignIdParameter is a query parameter that get a list of values

How do I "make" PQ to loop on the values of the CampaignIdParameter ?

Appreciating any help,

Tamir

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can transform your list to a table, create a new custom functon like this:

(A as text) =>
let 
    Source = = Json.Document(Web.Contents("https://api.alchemer.eu/v5/survey/"&SurveyIdParameter&"/surveycampaign/"&A&"/surveycontact?&api_token=123456&api_token_secret=123456"))

Invoke this function to the table to craete a new column to get each content.

Refer: Scrape Data from Multiple Web Pages with Power Query 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Add a custom column to construct each individual URL and fetch its contents, then combine the results as records or tables as needed.