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