Forum Discussion

274188A's avatar
274188A
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Shaping / Transforming JSON Data

I have a public API that's freely availabe to use by anyone (no auth required).  The Request URL I have is: https://myhospitalsapi.aihw.gov.au/api/v1/measure-downloads/measure-download-codes This r...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago
    let
    Source = Web.Contents("https://myhospitalsapi.aihw.gov.au/api/v1/measure-downloads/measure-download-codes"),
    Custom1 = Table.FromRecords(List.Combine(Record.ToList(Json.Document(Source)[result])))
in
    Custom1

     

274188A's avatar
274188A
Icon for Advocate I rankAdvocate I
2 years ago

Life Saver - thanks so much