Failed status request

wongkunheng · May 27, 2022, 7:18am

Above image with using java code as query to request post generate a IVR performance summary view. I have checked the view status by redirect to specific view with export view's id and it shows failed as refer to image below

here is the request body I have tried in API. It works ok in API.
{
"exportFormat": "CSV",
"name": "Flow Performance Summary",
"timeZone": "Asia/Kuala_Lumpur",
"interval": "2022-03-21T16:00:00/2022-03-22T16:00:00",
"period": "P1D",
"viewType": "IVR_PERFORMANCE_SUMMARY_VIEW",
"locale": "en-us",
"filter":{
"mediaTypes":["chat"]

},
"read": true,
"hasSplitByMedia": true,
"hasFormatDurations": true,
"selectedColumns":[
{"columnOrder": 1,"columnName": "flow_performance_view_interval_start"},
{"columnOrder": 2,"columnName": "flow_performance_view_interval_end"},
{"columnOrder": 3,"columnName": "flow_performance_view_interval_complete"},
{"columnOrder": 4,"columnName": "flow_performance_view_aggregate_or_detail"},
{"columnOrder": 5,"columnName": "flow_performance_view_filters"},
{"columnOrder": 6,"columnName": "flow_performance_view_media_type"},
{"columnOrder": 7,"columnName": "flow_performance_view_flow_id"},
{"columnOrder": 8,"columnName": "flow_performance_view_flow_name"},
{"columnOrder": 9,"columnName": "flow_performance_view_flow_version"},
{"columnOrder": 10,"columnName": "flow_performance_view_type"},
{"columnOrder": 11,"columnName": "flow_performance_view_entries"},
{"columnOrder": 12,"columnName": "flow_performance_view_total_flow"},
{"columnOrder": 13,"columnName": "flow_performance_view_average_flow"},
{"columnOrder": 14,"columnName": "flow_performance_view_disconnect"},
{"columnOrder": 15,"columnName": "flow_performance_view_disconnect_rate"},
{"columnOrder": 16,"columnName": "flow_performance_view_total_disconnect"},
{"columnOrder": 17,"columnName": "flow_performance_view_average_disconnect"},
{"columnOrder": 18,"columnName": "flow_performance_view_flow_disconnect"},
{"columnOrder": 19,"columnName": "flow_performance_view_flow_disconnect_rate"},
{"columnOrder": 20,"columnName": "flow_performance_view_system_error_disconnect"},
{"columnOrder": 21,"columnName": "flow_performance_view_system_error_disconnect_rate"},
{"columnOrder": 22,"columnName": "flow_performance_view_customer_disconnect"},
{"columnOrder": 23,"columnName": "flow_performance_view_customer_disconnect_rate"},
{"columnOrder": 24,"columnName": "flow_performance_view_customer_short_disconnect"},
{"columnOrder": 25,"columnName": "flow_performance_view_customer_short_disconnect_rate"},
{"columnOrder": 26,"columnName": "flow_performance_view_average_exit"},
{"columnOrder": 27,"columnName": "flow_performance_view_acd_exit"},
{"columnOrder": 28,"columnName": "flow_performance_view_acd_exit_rate"},
{"columnOrder": 29,"columnName": "flow_performance_view_flow_exit"},
{"columnOrder": 30,"columnName": "flow_performance_view_flow_exit_rate"}

}

The java SDK response body of "exportErrorMesageType" shows ENUM-"FAILED_GETTING_DATA_FROM_SERVICE". Is something precondition that i have missed?

wongkunheng · May 29, 2022, 11:22am

Hi, I may post here for the comparison for java SDK and API explorer query and result here to clarify the case.
APIExplorerRequest :-`
{
"exportFormat": "CSV",
"name": "Flow Performance Summary_2022-05-29",
"timeZone": "Asia/Kuala_Lumpur",
"interval": "2022-05-27T16:00:00/2022-05-28T16:00:00",
"period": "P1D",
"viewType": "IVR_PERFORMANCE_SUMMARY_VIEW",
"locale": "en-us",
"filter":{

"mediaTypes":["chat"]

},
"hasFormatDurations": true,
"hasSplitByMedia" : true
}

APIExplorerResponse :-

{
"id": "e8fcbe3e-e64a-4afd-a5af-64c93968d182",
"name": "Flow Performance Summary_2022-05-29",
"status": "SUBMITTED",
"timeZone": "Asia/Kuala_Lumpur",
"exportFormat": "CSV",
"interval": "2022-05-27T16:00:00.000Z/2022-05-28T16:00:00.000Z",
"viewType": "IVR_PERFORMANCE_SUMMARY_VIEW",
"period": "P1D",
"filter": {
"mediaTypes": [
"chat"
]
},
"read": false,
"createdDateTime": "2022-05-29T10:40:22Z",
"modifiedDateTime": "2022-05-29T10:40:22Z",
"locale": "en-us",
"percentageComplete": 0,
"hasFormatDurations": true,
"hasSplitFilters": false,
"excludeEmptyRows": false,
"hasSplitByMedia": true,
"hasSummaryRow": false,
"csvDelimiter": "COMMA",
"hasCustomParticipantAttributes": false,
"dateLastConfirmed": "2022-05-29T10:40:22Z",
"intervalKeyType": "ConversationStart",
"enabled": false,
"selfUri": "/api/v2/analytics/reporting/exports/e8fcbe3e-e64a-4afd-a5af-64c93968d182"
}

Java SDK request:-
class ReportingExportJobRequest {
name: Flow Performance Summary_2022-05-29
timeZone: Asia/Kuala_Lumpur
exportFormat: CSV
interval: 2022-05-27T16:00:00/2022-05-28T16:00:00
period: P1D
viewType: IVR_PERFORMANCE_SUMMARY_VIEW
filter: class ViewFilter {
mediaTypes: [chat]
queueIds: []
skillIds: []
skillGroups: []
languageIds: []
languageGroups: []
directions: []
originatingDirections: []
wrapUpCodes: []
dnisList: []
sessionDnisList: []
filterQueuesByUserIds: []
filterUsersByQueueIds: []
userIds: []
managementUnitIds: []
addressTos: []
addressFroms: []
outboundCampaignIds: []
outboundContactListIds: []
contactIds: []
externalContactIds: []
externalOrgIds: []
aniList: []
durationsMilliseconds: []
acdDurationsMilliseconds: []
talkDurationsMilliseconds: []
acwDurationsMilliseconds: []
handleDurationsMilliseconds: []
holdDurationsMilliseconds: []
abandonDurationsMilliseconds: []
evaluationScore: null
evaluationCriticalScore: null
evaluationFormIds: []
evaluatedAgentIds: []
evaluatorIds: []
transferred: null
abandoned: null
answered: null
messageTypes: []
divisionIds: []
surveyFormIds: []
surveyTotalScore: null
surveyNpsScore: null
mos: null
surveyQuestionGroupScore: null
surveyPromoterScore: null
surveyFormContextIds: []
conversationIds: []
sipCallIds: []
isEnded: null
isSurveyed: null
surveyScores: []
promoterScores: []
isCampaign: null
surveyStatuses: []
conversationProperties: null
isBlindTransferred: null
isConsulted: null
isConsultTransferred: null
remoteParticipants: []
flowIds: []
flowOutcomeIds: []
flowOutcomeValues: []
flowDestinationTypes: []
flowDisconnectReasons: []
flowTypes: []
flowEntryTypes: []
flowEntryReasons: []
flowVersions: []
groupIds: []
hasJourneyCustomerId: null
hasJourneyActionMapId: null
hasJourneyVisitId: null
hasMedia: null
roleIds: []
reportsTos: []
locationIds: []
flowOutTypes: []
providerList: []
callbackNumberList: []
callbackInterval: null
usedRoutingTypes: []
requestedRoutingTypes: []
hasAgentAssistId: null
transcripts: []
transcriptLanguages: []
participantPurposes: []
showFirstQueue: null
teamIds: []
filterUsersByTeamIds: []
journeyActionMapIds: []
journeyOutcomeIds: []
journeySegmentIds: []
journeyActionMapTypes: []
developmentRoleList: []
developmentTypeList: []
developmentStatusList: []
developmentModuleIds: []
developmentActivityOverdue: null
customerSentimentScore: null
customerSentimentTrend: null
flowTransferTargets: []
developmentName: null
topicIds: []
externalTags: []
isNotResponding: null
isAuthenticated: null
botIds: []
botVersions: []
botMessageTypes: []
botProviderList: []
botProductList: []
botRecognitionFailureReasonList: []
botIntentList: []
botFinalIntentList: []
botSlotList: []
botResultList: []
blockedReasons: []
isRecorded: null
hasEvaluation: null
hasScoredEvaluation: null
emailDeliveryStatusList: []
isAgentOwnedCallback: null
agentCallbackOwnerIds: []
transcriptTopics: []
journeyFrequencyCapReasons: []
journeyBlockingActionMapIds: []
journeyActionTargetIds: []
journeyBlockingScheduleGroupIds: []
journeyBlockingEmergencyScheduleGroupIds: []
journeyUrlEqualConditions: []
journeyUrlNotEqualConditions: []
journeyUrlStartsWithConditions: []
journeyUrlEndsWithConditions: []
journeyUrlContainsAnyConditions: []
journeyUrlNotContainsAnyConditions: []
journeyUrlContainsAllConditions: []
journeyUrlNotContainsAllConditions: []
flowMilestoneIds: []
isAssessmentPassed: null
conversationInitiators: []
hasCustomerParticipated: null
isAcdInteraction: null
}
read: null
locale: en-us
hasFormatDurations: true
hasSplitFilters: null
excludeEmptyRows: null
hasSplitByMedia: null
hasSummaryRow: null
csvDelimiter: null
selectedColumns: []
hasCustomParticipantAttributes: null
recipientEmails: []
}

Java SDK response :-
class ReportingExportJobResponse {
id: fbb62e6b-e3db-4cb8-8c02-3c5ecd41794c
name: Flow Performance Summary_2022-05-29
runId: null
status: SUBMITTED
timeZone: Asia/Kuala_Lumpur
exportFormat: CSV
interval: 2022-05-27T16:00:00.000Z/2022-05-28T16:00:00.000Z
downloadUrl: null
viewType: IVR_PERFORMANCE_SUMMARY_VIEW
exportErrorMessagesType: null
period: P1D
filter: class ViewFilter {
mediaTypes: [chat]
queueIds: []
skillIds: []
skillGroups: []
languageIds: []
languageGroups: []
directions: []
originatingDirections: []
wrapUpCodes: []
dnisList: []
sessionDnisList: []
filterQueuesByUserIds: []
filterUsersByQueueIds: []
userIds: []
managementUnitIds: []
addressTos: []
addressFroms: []
outboundCampaignIds: []
outboundContactListIds: []
contactIds: []
externalContactIds: []
externalOrgIds: []
aniList: []
durationsMilliseconds: []
acdDurationsMilliseconds: []
talkDurationsMilliseconds: []
acwDurationsMilliseconds: []
handleDurationsMilliseconds: []
holdDurationsMilliseconds: []
abandonDurationsMilliseconds: []
evaluationScore: null
evaluationCriticalScore: null
evaluationFormIds: []
evaluatedAgentIds: []
evaluatorIds: []
transferred: null
abandoned: null
answered: null
messageTypes: []
divisionIds: []
surveyFormIds: []
surveyTotalScore: null
surveyNpsScore: null
mos: null
surveyQuestionGroupScore: null
surveyPromoterScore: null
surveyFormContextIds: []
conversationIds: []
sipCallIds: []
isEnded: null
isSurveyed: null
surveyScores: []
promoterScores: []
isCampaign: null
surveyStatuses: []
conversationProperties: null
isBlindTransferred: null
isConsulted: null
isConsultTransferred: null
remoteParticipants: []
flowIds: []
flowOutcomeIds: []
flowOutcomeValues: []
flowDestinationTypes: []
flowDisconnectReasons: []
flowTypes: []
flowEntryTypes: []
flowEntryReasons: []
flowVersions: []
groupIds: []
hasJourneyCustomerId: null
hasJourneyActionMapId: null
hasJourneyVisitId: null
hasMedia: null
roleIds: []
reportsTos: []
locationIds: []
flowOutTypes: []
providerList: []
callbackNumberList: []
callbackInterval: null
usedRoutingTypes: []
requestedRoutingTypes: []
hasAgentAssistId: null
transcripts: []
transcriptLanguages: []
participantPurposes: []
showFirstQueue: null
teamIds: []
filterUsersByTeamIds: []
journeyActionMapIds: []
journeyOutcomeIds: []
journeySegmentIds: []
journeyActionMapTypes: []
developmentRoleList: []
developmentTypeList: []
developmentStatusList: []
developmentModuleIds: []
developmentActivityOverdue: null
customerSentimentScore: null
customerSentimentTrend: null
flowTransferTargets: []
developmentName: null
topicIds: []
externalTags: []
isNotResponding: null
isAuthenticated: null
botIds: []
botVersions: []
botMessageTypes: []
botProviderList: []
botProductList: []
botRecognitionFailureReasonList: []
botIntentList: []
botFinalIntentList: []
botSlotList: []
botResultList: []
blockedReasons: []
isRecorded: null
hasEvaluation: null
hasScoredEvaluation: null
emailDeliveryStatusList: []
isAgentOwnedCallback: null
agentCallbackOwnerIds: []
transcriptTopics: []
journeyFrequencyCapReasons: []
journeyBlockingActionMapIds: []
journeyActionTargetIds: []
journeyBlockingScheduleGroupIds: []
journeyBlockingEmergencyScheduleGroupIds: []
journeyUrlEqualConditions: []
journeyUrlNotEqualConditions: []
journeyUrlStartsWithConditions: []
journeyUrlEndsWithConditions: []
journeyUrlContainsAnyConditions: []
journeyUrlNotContainsAnyConditions: []
journeyUrlContainsAllConditions: []
journeyUrlNotContainsAllConditions: []
flowMilestoneIds: []
isAssessmentPassed: null
conversationInitiators: []
hasCustomerParticipated: null
isAcdInteraction: null
}
read: false
createdDateTime: Sun May 29 18:43:56 SGT 2022
modifiedDateTime: Sun May 29 18:43:56 SGT 2022
locale: en-us
percentageComplete: 0.0
hasFormatDurations: true
hasSplitFilters: false
excludeEmptyRows: false
hasSplitByMedia: false
hasSummaryRow: false
csvDelimiter: COMMA
selectedColumns: []
hasCustomParticipantAttributes: false
recipientEmails: []
emailStatuses: null
emailErrorDescription: null
enabled: false
selfUri: /api/v2/analytics/reporting/exports/fbb62e6b-e3db-4cb8-8c02-3c5ecd41794c
}

anon14299330 · June 3, 2022, 8:38am

Hi,

I will take a look at this issue and get back to you soon.

Thanks,

Mike

anon14299330 · June 9, 2022, 10:07am

Hi,

There appears to be some strange behaviour with this api. The java SDK will call POST /api/v2/analytics/reporting/exports with the full request body initializing properties (that have not been set by the user) with default values. The requests are being understood by the server (200 responses) so this leads me to believe the formatting of the request body is correct (no malformed syntax). But the API is not behaving as it should. I would suggest opening a ticket with Genesys Cloud Customer Care. Customer Care may engage the reporting dev team to help identify the problem.

Thanks,

Mike

wongkunheng · June 9, 2022, 10:44am

Hi, Mike.
Thanks for your response and information provided. I have raise this issue to Genesys cloud Customer care. We would look forward for a solution for this matter.

John_Carnell · June 9, 2022, 1:07pm