Legacy Dev Forum Posts

henan | 2021-11-24 10:36:04 UTC | #1

Hello,

I'm trying to create an export with /api/v2/analytics/reporting/exports and have had this working until recently when a new column was added to the report.

To tackle this I was hoping to set the selected column to the specific columns I need, but I can't figure out how this should be formatted.

My current request looks like this:

[details="Summary"] { "name": "TEST", "timeZone": "Europe/Berlin", "exportFormat": "CSV", "interval": "2021-10-27T00:00:00/2021-10-28T00:00:00", "period": "P1D", "viewType": "AGENTPERFORMANCESUMMARY_VIEW", "filter": { "mediaTypes": ["voice"] }, "read": true, "locale": "en-us", "hasFormatDurations": true, "hasSplitFilters": true, "excludeEmptyRows": true, "hasSplitByMedia": true, "hasSummaryRow": true, "csvDelimiter": "COMMA", "selectedColumns": [ { "columnOrder": 0, "columnName": "agent id" }, { "columnOrder": 1, "columnName": "status" } ], "hasCustomParticipantAttributes": true, "recipientEmails": [] } [/details]

However this returns 400 Bad request with the following message: "Invalid selectedColumns name value(s) requested: [agent id]"

I've tried different values for the columns, but none worked and I could not find any documentation on this.

Any help would be greatly appreciated!

Jerome.Saint-Marc | 2021-11-24 12:22:28 UTC | #2

Hello,

The best way to see what columns you need/want in your selectedColumns would be to request the export of the report from the Genesys Desktop UI - in Performance views. And check via your Browser tools what request is sent over the network (e.g. with Chrome Developer Tools - Network tab - checking the body/payload of your POST /api/v2/analytics/reporting/exports).

Four comments:

1. I think that if you do not specify/include the selectedColumns in your request body, all available fields will be exported in the report.
2. the columnOrder starts at 1 (not 0).
3. I don't think you have to specify the Agent ID in the selectedColumns. You can but it is included by default in the export.
4. There is no status in the export for the Agent Performance Summary View.

I just triggered an export of the Agent Performance Summary View with all available columns as of today (Role and Media Types are not supported in the export). Here's the list:

[ { "columnOrder": 1, "columnName": "agentperformanceviewagentname" }, { "columnOrder": 2, "columnName": "agentperformanceviewdivisionname" }, { "columnOrder": 3, "columnName": "agentperformanceviewskills" }, { "columnOrder": 4, "columnName": "agentperformanceviewagentid" }, { "columnOrder": 5, "columnName": "agentperformanceviewagentemail" }, { "columnOrder": 6, "columnName": "agentperformanceviewgroup" }, { "columnOrder": 7, "columnName": "agentperformanceviewreportsto" }, { "columnOrder": 8, "columnName": "agentperformanceviewlocation" }, { "columnOrder": 9, "columnName": "agentperformanceviewanswered" }, { "columnOrder": 10, "columnName": "agentperformanceviewhandle" }, { "columnOrder": 11, "columnName": "agentperformanceviewaveragehandle" }, { "columnOrder": 12, "columnName": "agentperformanceviewaveragetalk" }, { "columnOrder": 13, "columnName": "agentperformanceviewaveragehold" }, { "columnOrder": 14, "columnName": "agentperformanceviewaverageacw" }, { "columnOrder": 15, "columnName": "agentperformanceviewaveragedialing" }, { "columnOrder": 16, "columnName": "agentperformanceviewaveragecontacting" }, { "columnOrder": 17, "columnName": "agentperformanceviewtotalhandle" }, { "columnOrder": 18, "columnName": "agentperformanceviewtotaltalk" }, { "columnOrder": 19, "columnName": "agentperformanceviewtotalhold" }, { "columnOrder": 20, "columnName": "agentperformanceviewtotalacw" }, { "columnOrder": 21, "columnName": "agentperformanceviewtotaldialing" }, { "columnOrder": 22, "columnName": "agentperformanceviewtotalcontacting" }, { "columnOrder": 23, "columnName": "agentperformanceviewheld" }, { "columnOrder": 24, "columnName": "agentperformanceviewtransferred" }, { "columnOrder": 25, "columnName": "agentperformanceviewoutbound" }, { "columnOrder": 26, "columnName": "agentperformanceviewnotresponding" }, { "columnOrder": 27, "columnName": "agentperformanceviewtotalnotresponding" }, { "columnOrder": 28, "columnName": "agentperformanceviewalert" }, { "columnOrder": 29, "columnName": "agentperformanceviewtotalalert" }, { "columnOrder": 30, "columnName": "agentperformanceviewtransferpercent" }, { "columnOrder": 31, "columnName": "agentperformanceviewtotalmonitor" }, { "columnOrder": 32, "columnName": "agentperformanceviewavgmonitor" }, { "columnOrder": 33, "columnName": "agentperformanceviewmaxmonitor" }, { "columnOrder": 34, "columnName": "agentperformanceviewminmonitor" }, { "columnOrder": 35, "columnName": "agentperformanceviewmonitor" }, { "columnOrder": 36, "columnName": "agentperformanceviewminalert" }, { "columnOrder": 37, "columnName": "agentperformanceviewmaxalert" }, { "columnOrder": 38, "columnName": "agentperformanceviewminnotresponding" }, { "columnOrder": 39, "columnName": "agentperformanceviewmaxnotresponding" }, { "columnOrder": 40, "columnName": "agentperformanceviewminhandle" }, { "columnOrder": 41, "columnName": "agentperformanceviewmaxhandle" }, { "columnOrder": 42, "columnName": "agentperformanceviewmintalk" }, { "columnOrder": 43, "columnName": "agentperformanceviewmaxtalk" }, { "columnOrder": 44, "columnName": "agentperformanceviewminhold" }, { "columnOrder": 45, "columnName": "agentperformanceviewmaxhold" }, { "columnOrder": 46, "columnName": "agentperformanceviewminanswer" }, { "columnOrder": 47, "columnName": "agentperformanceviewmaxanswer" }, { "columnOrder": 48, "columnName": "agentperformanceviewminacw" }, { "columnOrder": 49, "columnName": "agentperformanceviewmaxacw" }, { "columnOrder": 50, "columnName": "agentperformanceviewblindtransfer" }, { "columnOrder": 51, "columnName": "agentperformanceviewblindtransferpercent" }, { "columnOrder": 52, "columnName": "agentperformanceviewconsulttransfer" }, { "columnOrder": 53, "columnName": "agentperformanceviewconsulttransferpercent" }, { "columnOrder": 54, "columnName": "agentperformanceviewtitle" }, { "columnOrder": 55, "columnName": "agentperformanceviewdepartment" }, { "columnOrder": 56, "columnName": "agentperformanceviewprimaryphone" }, { "columnOrder": 57, "columnName": "agentperformanceviewstandardrequestedcount" }, { "columnOrder": 58, "columnName": "agentperformanceviewstandardrequestedrate" }, { "columnOrder": 59, "columnName": "agentperformanceviewstandardusedcount" }, { "columnOrder": 60, "columnName": "agentperformanceviewstandardusedrate" }, { "columnOrder": 61, "columnName": "agentperformanceviewbullseyerequestedcount" }, { "columnOrder": 62, "columnName": "agentperformanceviewbullseyerequestedrate" }, { "columnOrder": 63, "columnName": "agentperformanceviewbullseyeusedcount" }, { "columnOrder": 64, "columnName": "agentperformanceviewbullseyeusedrate" }, { "columnOrder": 65, "columnName": "agentperformanceviewpreferredrequestedcount" }, { "columnOrder": 66, "columnName": "agentperformanceviewpreferredrequestedrate" }, { "columnOrder": 67, "columnName": "agentperformanceviewpreferredusedcount" }, { "columnOrder": 68, "columnName": "agentperformanceviewpreferredusedrate" }, { "columnOrder": 69, "columnName": "agentperformanceviewlastrequestedcount" }, { "columnOrder": 70, "columnName": "agentperformanceviewlastrequestedrate" }, { "columnOrder": 71, "columnName": "agentperformanceviewlastusedcount" }, { "columnOrder": 72, "columnName": "agentperformanceviewlastusedrate" }, { "columnOrder": 73, "columnName": "agentperformanceviewmanualusedcount" }, { "columnOrder": 74, "columnName": "agentperformanceviewmanualusedrate" }, { "columnOrder": 75, "columnName": "agentperformanceviewpredictiverequestedcount" }, { "columnOrder": 76, "columnName": "agentperformanceviewpredictiverequestedrate" }, { "columnOrder": 77, "columnName": "agentperformanceviewpredictiveusedcount" }, { "columnOrder": 78, "columnName": "agentperformanceviewpredictiveusedrate" }, { "columnOrder": 79, "columnName": "agentperformanceviewsentimentinstancestotal" }, { "columnOrder": 80, "columnName": "agentperformanceviewsentimentinstancespositive" }, { "columnOrder": 81, "columnName": "agentperformanceviewsentimentinstancesnegative" }, { "columnOrder": 82, "columnName": "agentperformanceviewsentimentavg" } ]

Regards,

henan | 2021-11-24 12:24:05 UTC | #3

Thansk Jerome!

This worked!

system | 2021-12-25 12:24:47 UTC | #4

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

This post was migrated from the old Developer Forum.

ref: 12750