Solved: M-Query GETDATA - Filter

craig811 · ‎01-13-2023

Hi ,

Currently my query is grabing all the data from the sever, however I need to just pull the data by 'Plant', Is there a way to filter the data at the GETDATA function so it ony pulls the records by 'PLANT' ?

Current function:

GetData = Json.Document(Web.Contents(url & "rawdata/responses" & "?tenant=" & tenant,
[
Timeout=#duration(0, 0, 10, 0),
Headers=[Authorization="test" & access_token, #"content-type" = "application/json:charset = utf-5"],
Content=Text.ToBinary(body)
])),

TotalPages = GetData[TotalPages],
ListNumbers = List.Numbers(1,TotalPages,1),

I need a filter added to above to pull the data by 'Plant' name , which is a column name within the body of each page.

Many thanks

Daryl-Lynch-Bzy · ‎01-13-2023

Hi @craig811 - it might be possible but it will depend on the API provider. You will need to look at the API instructions to determine how the filter can be included in the "body". If is possible, try using another tool like Postman or VS Code to test the syntax required by API. This can then be replicated in this in your M code.

View solution in original post

Daryl-Lynch-Bzy · ‎01-13-2023

Hi @craig811 - it might be possible but it will depend on the API provider. You will need to look at the API instructions to determine how the filter can be included in the "body". If is possible, try using another tool like Postman or VS Code to test the syntax required by API. This can then be replicated in this in your M code.