I am not sure if and how that would work for you.
But you can add End date as a filter.
Original Message:
Sent: 02-24-2023 06:46
From: Rahul Yadav
Subject: Media Type = email, changes ConversationEndDate for each Interaction
Hi Dewald,
Is there a way to read data based on Conversation End date instead of Conversation Start Date?
e.g. we have a Conversation which started on 27-Dec-2022 and Ended on 29-Dec-2022. When our API ran on 27-Dec-2022 it returned data for this Conversation. But, when we ran for 29-Dec-2022 it did not return this conversation as the Conversation started on 27th. so, we are missing the Segments after start date.
We are running the API's for the interval of the current date only, as we are doing Incremental Loads in our Datawarehouse.
Thanks,
Rahul
------------------------------
Rahul Yadav
Allscripts Healthcare Solutions Inc.
Original Message:
Sent: 02-20-2023 15:48
From: Dewald Smit
Subject: Media Type = email, changes ConversationEndDate for each Interaction
Give this a go and see if it maybe helps:
{
"interval": "2022-12-22T05:00:00.000Z/2022-12-31T05:00:00.000Z",
"order": "asc",
"orderBy": "conversationStart",
"paging": {
"pageSize": 25,
"pageNumber": 1
},
"segmentFilters": [
{
"type": "and",
"predicates": [
{
"type": "dimension",
"dimension": "mediaType",
"operator": "matches",
"value": "email"
},
{
"type": "dimension",
"dimension": "purpose",
"operator": "matches",
"value": "customer"
}
]
}
]
}
------------------------------
Dewald Smit
Altron Systems Integration a Division of Altron TMT (Pty) Ltd
Original Message:
Sent: 02-20-2023 09:05
From: Rahul Yadav
Subject: Media Type = email, changes ConversationEndDate for each Interaction
We have a Rest API POST framework in place which pulls the data from Conversation Detail API in Incremental way. Means takes max(ConversationStart) and queries PureCloud API with Dates after that.
But, for Email MediaType whenever a new email message arrives for same Conversation, the ConversationStart Date remains same for the new Segments/Sessions but the ConversationEnd Changes for the entire conversation. So, in our scenario we miss the details of messages.
Is there a way to load the ConversationDetail for MediaType=email in incremental way based on any other date field in the filters. Instead of ConversationStart & ConversationEnd (Interval) Date filter in the query.
Current Query:
{ "interval": "2022-12-26T05:00:00.000Z/2022-12-31T05:00:00.000Z", "order": "asc", "orderBy": "conversationStart", "paging": { "pageSize": 25, "pageNumber": 1 }, "segmentFilters": [ { "type": "or", "predicates": [ { "type": "dimension", "dimension": "mediaType", "operator": "matches", "value": "email" } ] } ]}
Thanks,
Rahul
#Reporting/Analytics
------------------------------
Rahul Yadav
Allscripts Healthcare Solutions Inc.
------------------------------