filter option for web api power M query

[gomandy99]

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=ticketnumber eq " & CaseNumber))

New url i am trying

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

Problem Statement: Old Url is exactly giving me single record which is expected. The new url i am trying is working but its giving me 999+ records which i dont want. 

CaseNumber is parameter I am using.

Thanks in advance for help.

[gomandy99]

I already tried that. Its not helping. 

[Daryl-Lynch-Bzy · Accepted solution]

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]))

[gomandy99]

Thanks. the second option did the trick. 

[Daryl-Lynch-Bzy]

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"]))