Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help building query with dynamic data source to set with scheduled refresh

I've seen lots of articles for a workaround in setting a scheduled refresh with a dynamic data source but can't get the query right...    The query that I have is below and unfortunately unable to ...
  • Anonymous's avatar
    Anonymous
    6 years ago

     

    Web.Contents("https://communications.contoso.com ", [RelativePath=" ssv3/odata/SentMessages(" & Text.From([ID]) & ")/ContactReads"])

    was able to get it with the above ^ 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

anyone? 😞 ðŸ˜«

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Web.Contents("https://communications.contoso.com ", [RelativePath=" ssv3/odata/SentMessages(" & Text.From([ID]) & ")/ContactReads"])

    was able to get it with the above ^