Legacy Dev Forum Posts

rama.meenavilli | 2021-02-09 10:12:12 UTC | #1

Our schedule jobs are running every 5 mins to get the data from the below 2 API's. We observed some data is not updated in our records but it was exist when checked in Genesys report tool.

POST /api/v2/analytics/conversations/aggregates/query GET /api/v2/analytics/conversations/{conversations}/details

Example:

1. for conversation_id 'e88dd8cc-a031-4bcc-96eb-ac342b67bb7b', we have only one record in our DB but in Genesys reports tool, 3 records exist.

Can we delay the time interval instead of live time to get the proper data. If yes, how much delay you suggested.

Maisey_Harris | 2021-02-09 15:15:40 UTC | #2

Hey Rama,

Can you clarify for me a couple things:

1. What Genesys reports tool are you using? Is it a specific view, a report, an export, etc.?
2. What query bodies are you using?
3. What frequency are you querying?

Thanks, Maisey Harris

rama.meenavilli | 2021-02-10 03:33:23 UTC | #3

Hi Maisey,

1. What Genesys reports tool are you using? Is it a specific view, a report, an export, etc.?

We are verifying with analytics-query-builder of developer-tools https://developer.mypurecloud.jp/developer-tools/#/analytics-query-builder

2. What query bodies are you using?

Generated Query here. Here 2 results but when we processed at that time it might be only 1 result. Hence DB is updated with only one record. { "interval": "2020-10-02T12:33:12.000Z/2020-10-02T12:38:12.000Z", "groupBy": [ "conversationId", "userId" ], "filter": { "type": "or", "clauses": [ { "type": "and", "predicates": [ { "type": "dimension", "dimension": "mediaType", "operator": "matches", "value": "voice" } ] } ] }, "views": [], "metrics": [ "nError", "nOffered", "nOutbound", "nOutboundAbandoned", "nOutboundAttempted", "nOutboundConnected", "nOverSla", "nTransferred", "oServiceLevel", "oServiceTarget", "tAbandon", "tAcd", "tAcw", "tAgentResponseTime", "tAlert", "tAnswered", "tHandle", "tHeld", "tHeldComplete", "tIvr", "tWait" ] }

3. What frequency are you querying?

We have custom job scheduler which runs every 5 mins. At that time of task scheduler retrieved only 1 record. That record dont have agent details. Hence DB is updated with only one record. Now when we check with analytics-query-builder tool, it retrieved 2 records. 1 record with agent details and another record without agent details.

What could be the reason? Is it because of live time interval? Can we delay the time interval instead of live time to get the proper data. If yes, how much delay you suggested?

Thanks, Rama

rama.meenavilli | 2021-02-17 06:05:18 UTC | #4

Hi team, any update on this query?

rama.meenavilli | 2021-02-19 12:34:36 UTC | #5

Hi team, waiting for your reply?

rama.meenavilli | 2021-02-22 06:56:50 UTC | #6

Dear Team,

Any update on this query? Awaiting for your update to set the new schedule time to delay the job schedule.

Thanks, Rama

rama.meenavilli | 2021-03-02 03:10:49 UTC | #7

Hi Team, awaiting for your update on this query.

Maisey_Harris | 2021-03-02 14:00:06 UTC | #8

I apologize for the delay; my notifications for this thread must have ended up in spam.

I'm still not exactly sure what'd be causing the issues you're having, but my recommendations would be:

• Avoid polling every 5 minutes if possible. We have notification support that you can set up to get live updating.
• If you do need to poll, don't query the last 5 minutes but rather something like the 5 minutes prior. Even better would be to up your polling time to something more like 30 minutes.
• If you still have issues, let's get a Care case opened up, and supply them with this thread for reference, so we can figure out what's going on.

Maisey

system | 2021-04-01 14:00:08 UTC | #9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

This post was migrated from the old Developer Forum.

ref: 9941