Send From and To dates in graph.microsoft.com/beta/communications/callRecords/getPstnCalls as Query

kroman — Tue, 10 Oct 2023 14:16:15 GMT

Hi All

I am looking for the way to change

OData.Feed("https://graph.microsoft.com/v1.0/communications/callRecords/getDirectRoutingCalls(fromDateTime="&DateTime.ToText(Date.AddDays(DateTime.LocalNow(),-1),"yyyy-MM-dd")&",toDateTime="&DateTime.ToText(DateTime.LocalNow(),"yyyy-MM-dd")&")", [ Authorization = "Bearer " & access_token ], [ ExcludedFromCacheKey = {"Authorization"}, ODataVersion = 4, Implementation = "2.0" ])

to something like

Web.Contents("https://graph.microsoft.com/v1.0/communications/callRecords/getDirectRoutingCalls", [ Headers = [#"Content-Type"="application/json", #"Authorization"="Bearer " & access_token], Query = [#"fromDateTime"=DateTime.ToText(Date.AddDays(DateTime.LocalNow(),-1),"yyyy-MM-dd"), #"toDateTime"=DateTime.ToText(DateTime.LocalNow(),"yyyy-MM-dd")] ] )

I am trying to use it in Power BI query and its required to avoid dynamic source issue on dataset refresh in PBI service
Thanks

Re: Send From and To dates in graph.microsoft.com/beta/communications/callRecords/getPstnCalls as Qu

lbendlin — Wed, 11 Oct 2023 23:07:46 GMT

You will need to use RelativePath rather than Query.

topic Send From and To dates in graph.microsoft.com/beta/communications/callRecords/getPstnCalls as Query in Developer

Send From and To dates in graph.microsoft.com/beta/communications/callRecords/getPstnCalls as Query

Re: Send From and To dates in graph.microsoft.com/beta/communications/callRecords/getPstnCalls as Qu