Checking CSV Export Status

The next step is to check the status of this export.

As soon as it’s ready (that is, “Status” = “Ready”), you can continue with the actual download of the file.

Sample Apex Request:

1<namespace>.OffPlatformCallout request = new <namespace>.OffPlatformCallout('GET_RTR_EXPORT_STATUS','0001');
2Map<String, String> params = new Map<String, String>();
3params.put('csvGuid', '<CSV Guid received as response from Triggering CSV Export>');
4<namespace>.OffPlatformCalloutResponse response = request.execute(<namespace>.TransactionHandler.getTransactionIdentifier(), params, null);

Sample Response

1{
2  "Status": "Ready",
3  "RequestDate": "2021-09-14T13:33:29.000Z",
4  "MetaName": "AccountAndPromotionMeasures",
5  "BusinessYear": 2020,
6  "Statistics": {
7    "csvGuid": "94f49a3f-37bc-4794-8051-123456789",
8    "jobStartTime": "Tue, 14 Sep 2021 13:34:02 GMT",
9    "hasDelta": false,
10    "deltaToCsvGuid": null,
11    "metaName": "AccountAndPromotionMeasures",
12    "metaVersion": 8,
13    "totalAccounts": 1,
14    "totalCategories": 6,
15    "dimDataRetrievalDuration": 1188,
16    "numRecords": 0,
17    "numAccountCategoryKeys": 6,
18    "runDuration": 1592,
19    "processedAccountCategories": 6,
20    "jobCompletionTime": "Tue, 14 Sep 2021 13:34:06 GMT",
21    "jobDuration": 4734
22  },
23  "FullExport": "tpm/long/export/full/94f49a3f-37bc-4794-8051-396f545500eb.csv.gz",
24  "DeltaExport": "tpm/long/export/delta/94f49a3f-37bc-4794-8051-396f545500eb.csv.gz"
25}