Importing many Surveys in Power Query

[TamirBasin]

Hi,
I would like to import multiple surveys from a SaaS company into Excel.

I managed to create a flow that will import 1 survet at a time with all its pages (there is a pagination every 50 records).

Created a parameter called SurveyNumber:

"90365258" meta [IsParameterQuery=true, List={"90365285", "90365336", "90365258"}, DefaultValue="90365285", Type="Text", IsParameterQueryRequired=true]

Created a function called fxGetAllPages to handle the pagination and the parameter for the Survey

(PageStart as text)=>
let
    Source = Json.Document(Web.Contents("https://api.alchemer.eu/v4/survey/"&SurveyNumber&"/surveyresponse?&api_token=9999999999999999999999999999999999&api_token_secret=99999999999999999999999999="&PageStart&""))
in
    Source

When I select the survey number from the list I get the data in a table.

The question:
How can I loop through the list of surveys to union the data from all of them into one query?

Thank you,
Tamir

 

[GraH]

Wild guess here, since this is something I never need to do in Power Query. Maybe this works:

List.Transform({SurveyNumbers}, each fxGetAllPages( _ ))

EDIT: Maybe you need to pass the parameter for SurveyNumber as well in the function. Something like

List.Transform({SurveyNumbers}, each fxGetAllPages(PageStart, _ ))