leo_con | 2017-03-09 14:35:36 UTC | #1
Hi, Could you help me out please. I did an app (C# with PureCloud API SDK) that extracts all the conversations from a Customer, it is scheduled daily at 2:00am and stores the records in SQL Server Yesterday at 2:00am were generated the records for March 07 and there is 39273 in Segments table Now I run the same period (March 07) and I see 39502 records (229 more)
This difference has sense in PureCloud or do you think could be an error in my app?
Organization ID : 76250396-84b7-44ed-932b-a9c25efb6af1
PureCloudApiSdk Version: 0.96.13.397
<img src="https://drive.google.com/uc?export=view&id=0B-De80DLqnrbNlZNRGp0cG0wMFE" >
<img src="https://drive.google.com/uc?export=view&id=0B-De80DLqnrbVVBmVUxReWkxcmM">
Regards, Leonel Contreras
tim.smith | 2017-03-09 16:11:48 UTC | #2
This difference has sense in PureCloud
You'd have to take a look at the actual data that's different to see if there's a reason it wasn't included in one result set but was in another.
do you think could be an error in my app?
It certainly could be. Try running your process multiple times back to back and see if it produces different results.
This isn't .NET, but there may be some stuff of interest to you since it's doing something similar: https://github.com/MyPureCloud/open-data-exporter
leo_con | 2017-03-09 21:36:51 UTC | #3
I see the API doesn't always brings 100 records per page, each time I run it changes pages/number of records per pages brought.
API Should always brings 100 records as I setted, isn't it?
(I updated C# SDK to v0.104.13.409)
tim.smith | 2017-03-09 21:39:13 UTC | #4
What's the resource and body of the request you're sending?
leo_con | 2017-03-10 13:32:23 UTC | #5
Thank you Tim, URL: https://api.mypurecloud.com/api/v2/analytics/conversations/details/query
body: { "interval": "2017-03-07T04:00:00.000Z/2017-03-08T04:00:00.000Z", "paging": { "pageSize": 100, "pageNumber": 1 } }
<img src="https://drive.google.com/uc?export=view&id=0B-De80DLqnrbbmk2d2tWRWQ3TVk">
In C# API Function : PostConversationsDetailsQuery
<img src="https://drive.google.com/uc?export=view&id=0B-De80DLqnrbcmMxUHJuTlZpM0k">
tim.smith | 2017-03-10 16:19:10 UTC | #6
You shouldn't arbitrarily get different results for the same request when the interval doesn't include the current time. If the interval does include the current time, expect to get different results each time you request it because the data you're accessing is changing. The interval you're requesting appears to be well enough in the past that this shouldn't be causing an issue. Can you open a ticket with PureCloud Support to troubleshoot further?
leo_con | 2017-03-13 15:40:08 UTC | #7
thank you Tim, I will open the ticket.
system | 2017-08-28 19:32:50 UTC | #8
This post was migrated from the old Developer Forum.
ref: 1027