Hansmuffs | 2023-01-05 10:52:48 UTC | #1

Hey,

currently i'm working with the Python conversation-detials-query. I have to build a delta load based an the interval field.

create an instance of the API class

api_instance = PureCloudPlatformClientV2.ConversationsApi(apiclient) body = PureCloudPlatformClientV2.ConversationQuery()

body.interval = '2023-01-03T00:00:00.000Z/2023-01-04T00:00:00.000Z'

How to set the body.interval variable that I have the filter on greater than?

In SQL: WHERE INTERVAL >= 2023-01-03T00:00:00.000Z

tim.smith | 2023-01-05 14:46:23 UTC | #2

Hansmuffs, post:1, topic:17856
How to set the body.interval variable that I have the filter on greater than?

That's not how intervals work. Intervals consist of a discrete start and end timestamp. The intervals portion of the ISO 8601 specification is covered here: https://en.wikipedia.org/wiki/ISO_8601#Time_intervals.

Eos_Rios | 2023-01-05 15:01:59 UTC | #3

Hansmuffs, post:1, topic:17856
body.interval = '2023-01-03T00:00:00.000Z/2023-01-04T00:00:00.000Z'

Because it has to be an explicit BETWEEN the two dates in the interval to achieve a 'greater than minimum threshold' equivalent you would just set your ends to a future date like;

body.interval = '2023-01-03T00:00:00.000Z/2023-01-06T00:00:00.000Z'

Hansmuffs | 2023-01-06 12:54:03 UTC | #4

Is it possible to filter on conversation_start timestamp?

Something like body.conversation_start >= 2023-01-03T00:00:00.000Z?

tim.smith | 2023-01-06 15:04:57 UTC | #5

No, please refer to the documentation to explore options for creating queries. https://developer.genesys.cloud/analyticsdatamanagement/analytics/detail/#interval

system | 2023-02-05 15:05:35 UTC | #6

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: 17856