Forum Discussion

sceccolini's avatar
sceccolini
Frequent Visitor
2 years ago
Solved

Recursive execution of REST from Power BI table

I have a table with a column containing the services I need to call to retrieve some other data, which needs to be modified with other further steps once I can return the records from these services....
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    sceccolini 

    Can you use below query in a blank query and paste any one of the URL and let me know what you see?

    let
    Source =Json.Document(Web.Contents("URL"))
    in
    Source

    Or use the below file and let me know.

sceccolini's avatar
sceccolini
Frequent Visitor
2 years ago

Hi Naveen,

 

thanks for the reply. This is an extract of the properties returned by each service in the column

 

 

Of course, tthe REST invocations are always on the same service, which returnes the same properties; each service will just change the values of the returned properties. Among the above properties, we will need some of them, which will be configured as dedicated columns.

 

Thanks

Simone

 

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

sceccolini 

Can you use below query in a blank query and paste any one of the URL and let me know what you see?

let
Source =Json.Document(Web.Contents("URL"))
in
Source

Or use the below file and let me know.

  • sceccolini's avatar
    sceccolini
    Frequent Visitor
    2 years ago

    It works! I can just add a new custom column with this formula, and then I can manage it like any other transformation. Thank you!