wongkunheng | 2022-05-29 11:27:41 UTC | #1
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/KualaLumpur", "interval": "2022-03-21T16:00:00/2022-03-22T16:00:00", "period": "P1D", "viewType": "IVRPERFORMANCESUMMARYVIEW", "locale": "en-us", "filter":{ "mediaTypes":["chat"]
}, "read": true, "hasSplitByMedia": true, "hasFormatDurations": true, "selectedColumns":[ {"columnOrder": 1,"columnName": "flowperformanceviewintervalstart"}, {"columnOrder": 2,"columnName": "flowperformanceviewintervalend"}, {"columnOrder": 3,"columnName": "flowperformanceviewintervalcomplete"}, {"columnOrder": 4,"columnName": "flowperformanceviewaggregateordetail"}, {"columnOrder": 5,"columnName": "flowperformanceviewfilters"}, {"columnOrder": 6,"columnName": "flowperformanceviewmediatype"}, {"columnOrder": 7,"columnName": "flowperformanceviewflowid"}, {"columnOrder": 8,"columnName": "flowperformanceviewflowname"}, {"columnOrder": 9,"columnName": "flowperformanceviewflowversion"}, {"columnOrder": 10,"columnName": "flowperformanceviewtype"}, {"columnOrder": 11,"columnName": "flowperformanceviewentries"}, {"columnOrder": 12,"columnName": "flowperformanceviewtotalflow"}, {"columnOrder": 13,"columnName": "flowperformanceviewaverageflow"}, {"columnOrder": 14,"columnName": "flowperformanceviewdisconnect"}, {"columnOrder": 15,"columnName": "flowperformanceviewdisconnectrate"}, {"columnOrder": 16,"columnName": "flowperformanceviewtotaldisconnect"}, {"columnOrder": 17,"columnName": "flowperformanceviewaveragedisconnect"}, {"columnOrder": 18,"columnName": "flowperformanceviewflowdisconnect"}, {"columnOrder": 19,"columnName": "flowperformanceviewflowdisconnectrate"}, {"columnOrder": 20,"columnName": "flowperformanceviewsystemerrordisconnect"}, {"columnOrder": 21,"columnName": "flowperformanceviewsystemerrordisconnectrate"}, {"columnOrder": 22,"columnName": "flowperformanceviewcustomerdisconnect"}, {"columnOrder": 23,"columnName": "flowperformanceviewcustomerdisconnectrate"}, {"columnOrder": 24,"columnName": "flowperformanceviewcustomershortdisconnect"}, {"columnOrder": 25,"columnName": "flowperformanceviewcustomershortdisconnectrate"}, {"columnOrder": 26,"columnName": "flowperformanceviewaverageexit"}, {"columnOrder": 27,"columnName": "flowperformanceviewacdexit"}, {"columnOrder": 28,"columnName": "flowperformanceviewacdexitrate"}, {"columnOrder": 29,"columnName": "flowperformanceviewflowexit"}, {"columnOrder": 30,"columnName": "flowperformanceviewflowexit_rate"}
] }
The java SDK response body of "exportErrorMesageType" shows ENUM-"FAILEDGETTINGDATAFROMSERVICE". Is something precondition that i have missed?
wongkunheng | 2022-05-29 11:22:37 UTC | #2
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 Summary2022-05-29", "timeZone": "Asia/KualaLumpur", "interval": "2022-05-27T16:00:00/2022-05-28T16:00:00", "period": "P1D", "viewType": "IVRPERFORMANCESUMMARY_VIEW", "locale": "en-us", "filter":{
"mediaTypes":["chat"]
}, "hasFormatDurations": true, "hasSplitByMedia" : true }
APIExplorerResponse :-
{ "id": "e8fcbe3e-e64a-4afd-a5af-64c93968d182", "name": "Flow Performance Summary2022-05-29", "status": "SUBMITTED", "timeZone": "Asia/KualaLumpur", "exportFormat": "CSV", "interval": "2022-05-27T16:00:00.000Z/2022-05-28T16:00:00.000Z", "viewType": "IVRPERFORMANCESUMMARY_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 Summary2022-05-29 timeZone: Asia/KualaLumpur exportFormat: CSV interval: 2022-05-27T16:00:00/2022-05-28T16:00:00 period: P1D viewType: IVRPERFORMANCESUMMARY_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 Summary2022-05-29 runId: null status: SUBMITTED timeZone: Asia/KualaLumpur exportFormat: CSV interval: 2022-05-27T16:00:00.000Z/2022-05-28T16:00:00.000Z downloadUrl: null viewType: IVRPERFORMANCESUMMARY_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 | 2022-06-03 08:38:56 UTC | #3
Hi,
I will take a look at this issue and get back to you soon.
Thanks,
Mike
anon14299330 | 2022-06-09 10:07:22 UTC | #4
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 | 2022-06-09 10:44:12 UTC | #5
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 | 2022-06-09 13:07:27 UTC | #6
This post was migrated from the old Developer Forum.
ref: 14904