Forum Discussion

craig811's avatar
craig811
Helper III
3 years ago
Solved

M-Query GETDATA - Filter

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

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.