Forum Discussion

gomandy99's avatar
gomandy99
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

filter option for web api power M query

Hello experts I am trying to convert my dynamic query to relative path so that it can refreshed automatically. Old url :  Source = Json.Document(Web.Contents("weburl& "incidents?$" & "filter=ticke...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    How about changing the way you reference the Case Number:

    Source = Json.Document(Web.Contents("weburl", [RelativePath = "api/data/v9.2/incidents", Query = "$filter=ticketnumber eq " & CaseNumber]))

    or the other option include everything in the relative path

    Source = Json.Document(Web.Contents("weburl", [RelativePath = "api/data/v9.2/incidents?$filter=ticketnumber eq " & CaseNumber]))

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi gomandy99 - I think the "?" is unnecessary.  Can you please try removing it?

Source = Json.Document(Web.Contents("weburl", [RelativePath = "api/data/v9.2/incidents", Query = "$filter=ticketnumber eq CaseNumber"]))