Forum Discussion

Jigar1276's avatar
Jigar1276
Icon for Helper I rankHelper I
5 years ago
Solved

Need to get total of records returned by API in a variable

I am making API call in Power BI: Source = Json.Document(Web.Contents( APIURL & "/commonapi/search?name=myName&eCode=FCD&recordStart=1&recordLimit=1")), Total = Source[results-total] The resp...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    It may be Source[responseHeader][response-total], unless either of those are arrays, but why not just use the Power BI interface to drill into the JSON, which will create the needed Navigation step?

     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

It may be Source[responseHeader][response-total], unless either of those are arrays, but why not just use the Power BI interface to drill into the JSON, which will create the needed Navigation step?

 

Regards,

Pat