Forum Discussion

jdibala's avatar
jdibala
Frequent Visitor
5 years ago
Solved

Web.Contents with complex Query parameter names

Hi All I've got a REST API which allows filter as a parameter. Everything works fine when I concat URL with parameters and variables in one string. Source = Json.Document(Web.Contents("https://dat...
Need Help
  • KNP's avatar
    KNP
    5 years ago

    Hi jdibala, 

     

    Does it work if they're quoted?

     

    Source = Json.Document(Web.Contents("https://datasource.com"), 
    [
        RelativePath="ItemHistory",
        Query=
        [
            "filter(HistoryDate;GREATEREQUALS)"=from_dt,
            "filter(HistoryDate;LESS)"=to_dt,
        ]
    ])

     

KNP's avatar
KNP
Super User
5 years ago

Hi jdibala, 

 

Does it work if they're quoted?

 

Source = Json.Document(Web.Contents("https://datasource.com"), 
    [
        RelativePath="ItemHistory",
        Query=
        [
            "filter(HistoryDate;GREATEREQUALS)"=from_dt,
            "filter(HistoryDate;LESS)"=to_dt,
        ]
    ])