Web API - Extract All Records from Multiple Lists

[Anonymous]

Hi,

I'm connecting to a Web API to bring data into my PBIX file. I'm not quite sure how to extract all the records from the multiple list options available. Here's a screenshot of what I can see:

I'd like to extract these into one table without having to create separate ones to blend together.

Here's the code from my Advanced Editor at present - I've hidden the URL and Authorisation:

let
    Source = Json.Document(Web.Contents("URL", [Headers=[Accept="application/json", Authorization="AUTHORISATION"]])),
    #"Converted to Table" = Record.ToTable(Source)
in
    #"Converted to Table"

Can anyone help me with this? My M Language skills are a bit rusty.

Thanks,

Mark

[PhilipTreacy]

Hi @Anonymous 

Can you please share the JSON data you've got from the API?  Or at least an anonymised sample?

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Hi @PhilipTreacy ,

I'm afraid not, it's sensitive data. But that shouldn't really matter, as long as the dimensions, measures and data fields from the table can be extracted.

Thanks,

Mark

[PhilipTreacy]

@Anonymous 

Hard to know how to extract it without knowing the underlying data structure

[amitchandak]

@Anonymous , difficult to tell, refer if these can help

https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMI7Za92YSi6wIVFSQrCh0vDgIgEAAYASAAEgLd5_D_BwE