bicomapp | 2024-09-10 11:51:10 UTC | #1
I am trying to import data into PowerBI using the GET API conversations/details/query.
The problem lies in the fact that not all conversations for a day are imported into PowerBI. For example, I find in PowerBI for the day 2024-09-06, 8 conversationsID, while querying the Analytics APIs in [totalHits] I see 21 conversations.
Are there any parameters to set?
This is part of the query:
Source = Json.Document(Web.Contents("https://api.mypurecloud.ie", [ RelativePath = "/api/v2/analytics/conversations/details/query", Headers = [#"Authorization"="Bearer "&access_token, #"Content-Type"="application/json"], Content = Text.ToBinary("{ ""interval"": """ & startDate & "/" & endDate & """, ""order"": ""asc"", ""orderBy"": ""conversationStart"", ""paging"": { ""pageSize"": 100 } }") ])),
system | 2024-10-11 11:51:42 UTC | #2
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 28985