Retrieving CSV Export

You can fetch the history of the CSV export by making an Apex call.

Sample Apex Request

1<namespace>.OffPlatformCallout request = new <namespace>.OffPlatformCallout('GET_RTR_EXPORT_HISTORY','0001');
2Map<String, String> params = new Map<String, String>();
3params.put('metaname', 'ReportData0001');
4<namespace>.OffPlatformCalloutResponse response = request.execute(<namespace>.TransactionHandler.getTransactionIdentifier(), params, null);
5
6System.debug(response);

Sample Response

1[
2  {
3    "csvGuid": "e9b73d84-2a08-4815-a6ff-88a787dc007a",
4    "metaname": "ReportData0001",
5    "metaversion": 1,
6    "businessyear": 2022,
7    "salesorg": "0001",
8    "status": "Ready",
9    "fullExportFile": "full/e9b73d84-2a08-4815-a6ff-88a787dc007a.csv.gz",
10    "deltaExportFile": "delta/e9b73d84-2a08-4815-a6ff-88a787dc007a.csv.gz",
11    "fileexpiry": "2022-06-15T08:20:35.000Z",
12    "commitdate": "2022-05-16T08:24:53.000Z",
13    "deltaAgainst": "c32a1252-ee4d-457d-98b2-3f72029c1722",
14    "statistics": {
15      "csvGuid": "e9b73d84-2a08-4815-a6ff-88a787dc007a",
16      "jobStartTime": "Mon, 16 May 2022 08:21:24 GMT",
17      "hasDelta": true,
18      "deltaToCsvGuid": "c32a1252-ee4d-457d-98b2-3f72029c1722",
19      "metaName": "ReportData0001",
20      "metaVersion": 1,
21      "totalAccounts": 1,
22      "totalCategories": 6,
23      "dimDataRetrievalDuration": 1401,
24      "numRecords": 1392,
25      "numAccountCategoryKeys": 6,
26      "runDuration": 2032,
27      "processedAccountCategories": 6,
28      "jobCompletionTime": "Mon, 16 May 2022 08:21:27 GMT",
29      "jobDuration": 2441
30    }
31  }
32]

Consumer Goods Cloud Developer Guide

Retrieving CSV Export