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
Icon for Super User rankSuper User
5 years ago

That sounds more like an issue with your data source (that URL parameter format looks iffy). Can you ask them for documentation and/or support?

jdibala's avatar
jdibala
Frequent Visitor
5 years ago

I've got documentation and everything works well with this code in PBI Desktop.

Source = Json.Document(Web.Contents("https://datasource.com/ItemHistory?filter(HistoryDate;GREATEREQUALS)="&from_dt&"&filter(HistoryDate;LESSTHAN)="&to_dt), 1252)

  

However, when I publish to the service it says that this data source is a dynamic type which is not possible to refresh. Therefore I am trying to reshape the code using RelativePath and Query.