CDLROUSER | 2019-08-22 22:52:09 UTC | #1
We are acquiring the user status details data from the /api/v2/analytics/users/details/query into our data warehouse.
We want to ensure that we have acquired all the data.
The /api/v2/analytics/users/details/query endpoing restricts the amount of data we can acquire based on pagesize and pagenumber.
Is there a way to get a count of records in the /api/v2/analytics/users/details/query endpoint?
This will help us in ensuring that we have acquired all the required data.
Is there any other way of doing this?
Kind Regards Samir
tim.smith | 2019-08-23 14:29:41 UTC | #2
PureCloud Analytics data is a Data as a Service API and is meant to be consumed in real-time whenever an application needs to access data. Exporting that data to a database is generally not advisable because when data is updated in PureCloud, your exported data will be outdated and incorrect. There are several posts on the forum discussing this if you'd like to read further about the pitfalls of this.
That said, analytics data does not have a finite result set. When querying for analytics data, you should iterate through the pages until a page returns no results; that's when you know you've reached the end of the result set. Best practice is to use filters and an interval short enough to keep results to around 10 pages, and definitely not more than 100. Analytics queries are less performant the deeper you go into paging, causing slower queries and eventually timeouts if you go deep enough. This is why filtering and appropriately sized intervals are important.
system | 2019-09-23 14:29:44 UTC | #3
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: 5853