M-Query GETDATA - Filter

[craig811]

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

[Anonymous · Accepted solution]

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.