Forum Discussion
Solved
using a colon in a Query - Invalid Identifier
Hi I have a query setup to a json API source and i want to filter the query by department ID. the API developer reference states the format as /api/v2/agents?query=department_id:123456 which works t...
Got there in the end. I was missing query at the start of the filter. Thanks for your help
Thanks. This is what im getting:
let
Source = Json.Document(Web.Contents(FreshserviceBaseURL,
[RelativePath = "Agents",
Query = [#"department_id" = "12456798"]]))
in
SourceThanks. This passes sytnax verification but fails on the Get Web contents as the = needs to be a :
Its like i need to escape the : or something
Got there in the end. I was missing query at the start of the filter. Thanks for your help