Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |