Call Rest for every Row in List

[ClAgi]

Hello,

this is my first post in this PowerBI Forum 

I'm currently developing a PowerBI Connector with calls to a REST service.

I call the webservice '/contacts' which returns all contacts, but only with
id 1234567890

display Test
path /contacts/1234567890

I extracted the path to each contact because i need that to call another webservice to get more details

about the contact.

And now i don't know how to continue.
My thoughts:

- Call the webservice for each row in the list to get detail information about contact

- expand all records in response with ExpandAllRecords.
- add expanded response to a table

Goal:

A table with 12 (this example) rows with detail information about the contact.

I know there a function like 

List.Accumulate, Table.AddRows etc etc

but i don't see the big thing with all together.

Cheers

[Greg_Deckler]

I would create a function that did the REST call. Then you could simply create a new column that calls that function with your contact column (Liste) as a parameter.

[ClAgi]

Thank you for your response. That was a good advise !

        deletedAllOthers = Table.SelectColumns(expandedPathColumn,{"$items.$path"}),
        columnRenamed = Table.RenameColumns(deletedAllOthers, {"$items.$path", "path"}),
        newCompleteTable = Table.AddColumn(columnRenamed, "expanded", each S.GetResponseSecondLayer([path])),
        expandedAllColumns = Table.ExpandTableColumn(newCompleteTable, "expanded", 
            Table.ColumnNames(Table.Combine(newCompleteTable[expanded])),
            Table.ColumnNames(Table.Combine(newCompleteTable[expanded])))

I only got one last question. I needed 

Table.RenameColumns(deletedAllOthers, {"$items.$path", "path"}),

because 

S.GetResponseSecondLayer([path])

doesn't take [$items.$path]. That gives me an error. How can i use special character in the [] brackets. I got that problem with another function but i can't use RenameColumns there.