Forum Discussion

Indrasena's avatar
Indrasena
Regular Visitor
4 years ago
Solved

Iterating through table values in M query and store the results in new table as records

I need to pass the Id values that are present in a Employee table to a web url
Below is the table

 

 


for each row in the above table the below command needs to be executed and store the result as a record

 

Source = Web.Contents("XXXXXXXXXXXXXXXXXXXX/employeeId="&Id, [Headers=[Authorization="Bearer "&access_token,ContentType="application/json"]]),
FormatAsJson = Json.Document(GetJson),

 

Note; I am able to pass only 1 id(Web.Contents("XXXXXXXXXXXXXXXXXXXX/employeeId="&Employee[Id]{0}) and unable to find something that loops and writes to a table.

 

1 Reply