Forum Discussion

MyThumbsClick's avatar
MyThumbsClick
Helper II
2 years ago
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...
Need Help
  • MyThumbsClick's avatar
    MyThumbsClick
    2 years ago

    Got there in the end. I was missing query at the start of the filter. Thanks for your help

     

     

lbendlin's avatar
lbendlin
Super User
2 years ago
let
    Source = Json.Document(Web.Contents(FreshserviceBaseURL,
        [RelativePath="Agents",
        Query=[#"department_id": "12456798"]])) 
in 
    Source
  • MyThumbsClick's avatar
    MyThumbsClick
    Helper II
    2 years ago

    Thanks. This is what im getting:

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago
      let
    Source = Json.Document(Web.Contents(FreshserviceBaseURL,
        [RelativePath = "Agents",
        Query = [#"department_id" = "12456798"]])) 
in 
    Source
      • MyThumbsClick's avatar
        MyThumbsClick
        Helper II
        2 years ago

        Thanks. 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