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

     

lbendlin's avatar
lbendlin
Super User
5 years ago

Learn about partitions and the impact of meta data changes on the refresh scope.