address json element in M code

[Anonymous]

I'm trying to get a specific value from a json return, to use as a variable in the pagination script.

Postman returns this on the query:

{

    "collection": [],

    "pagination": {

        "maxPageSizeAllowed": 1000,

        "skipPages": 0,

        "pageSize": 1,

        "results": 120,

        "resultsWithoutFilter": 120,

        "firstPage": "https://restapi.e-conomic.com/invoices/booked?pagesize=1&skippages=0",

        "nextPage": "https://restapi.e-conomic.com/invoices/booked?pagesize=1&skippages=1",

        "lastPage": "https://restapi.e-conomic.com/invoices/booked?pagesize=1&skippages=119"

    },

    "self": "https://restapi.e-conomic.com/invoices/booked?pagesize=1&skippages=0"

}

How do I address the field resultsWithoutFilter

I have some code snippet from powerbi:

= () =>
let Url = BaseUrl & "pagesize=1&skippages=0", //get the first entry for sake of getting the total
Json = GetJson(Url),
Count = Json{{1}{4}}
in Count

it's the Count=Json ... part I'm looking for.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Based on the JSON above you should see this when you click on the Json step 

So you can use this to get the value in resultsWithoutFilter

Count = Json[pagination][resultsWithoutFilter]

Regards

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.

[amitchandak]

@Anonymous , refer if this blog can help

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

[Anonymous]

Hi @amitchandak , thanks. I'm using that code as basis, but it's not an odata streamt. I'm having trouble extracting (addressing) the "resultsWithoutPages" attribute from the json response. If a just put a constant the code works just fine. It's me just not getting/ finding information on how to address the attributes in the json response, I guess.