GET /api/v2/query/{nextBatchId}

Syntax

HTTP method

GET

Availability

Data Cloud v2.0, Salesforce 54.0

Formats

REST

URI

/api/v2/query/{nextBatchId}

Examples

Request Header

1Authorization: Bearer {{cdpAuthToken}}

Response

The placeInOrder parameter indicates the position of the column in each data row. For example, in the following response InternalOrganization__c is the second column in a data row. Similarly quantity__c is the third column. For information on the typeCodes, refer to SQL data type codes.

Note

1{
2"data": [
3[
4"1103658353",
5"123",
6"2020-09-28T00:00:00.000+00:00",
7
8
9], [], [] ...
10]
11],  "startTime": "2024-05-08T13:30:31.241168Z",
12    "endTime": "2024-05-08T13:30:35.571609Z",
13    "rowCount": 2,
14    "queryId": "20240508_133031_00088_p25a7",
15    "nextBatchId": "09151b49-54ed-4948-8139-1f4c7c3a9581",
16    "done": false,
17    "metadata": {
18        "state__c": {
19            "type": "VARCHAR",
20            "placeInOrder": 28,
21            "typeCode": 12
22        },
23        "sales__c": {
24            "type": "DECIMAL",
25            "placeInOrder": 23,
26            "typeCode": 3
27        },
28        "productid__c": {
29            "type": "VARCHAR",
30            "placeInOrder": 17,
31            "typeCode": 12
32        },
33        "segment__c": {
34            "type": "VARCHAR",
35            "placeInOrder": 24,
36            "typeCode": 12
37        },
38        "individualid__c": {
39            "type": "VARCHAR",
40            "placeInOrder": 12,
41            "typeCode": 12
42        },
43        "shipdate1__c": {
44            "type": "TIMESTAMP WITH TIME ZONE",
45            "placeInOrder": 25,
46            "typeCode": 2014
47        },
48        "shipmode__c": {
49            "type": "VARCHAR",
50            "placeInOrder": 27,
51            "typeCode": 12
52        },
53        "rowid__c": {
54            "type": "VARCHAR",
55            "placeInOrder": 22,
56            "typeCode": 12
57        },
58        "InternalOrganization__c": {
59            "type": "VARCHAR",
60            "placeInOrder": 2,
61            "typeCode": 12
62        },
63        "orderdate1__c": {
64            "type": "TIMESTAMP WITH TIME ZONE",
65            "placeInOrder": 13,
66            "typeCode": 2014
67        },
68        "customername__c": {
69            "type": "VARCHAR",
70            "placeInOrder": 10,
71            "typeCode": 12
72        },
73        "quantity__c": {
74            "type": "DECIMAL",
75            "placeInOrder": 20,
76            "typeCode": 3
77        },
78        "DataSource__c": {
79            "type": "VARCHAR",
80            "placeInOrder": 1,
81            "typeCode": 12
82        },
83        "orderdate__c": {
84            "type": "DATE",
85            "placeInOrder": 14,
86            "typeCode": 91
87        },
88        "cdp_sys_PartitionDate__c": {
89            "type": "DATE",
90            "placeInOrder": 5,
91            "typeCode": 91
92        },
93        "orderid__c": {
94            "type": "VARCHAR",
95            "placeInOrder": 15,
96            "typeCode": 12
97        },
98        "region__c": {
99            "type": "VARCHAR",
100            "placeInOrder": 21,
101            "typeCode": 12
102        },
103        "KQ_orderid__c": {
104            "type": "VARCHAR",
105            "placeInOrder": 3,
106            "typeCode": 12
107        },
108        "discount__c": {
109            "type": "DECIMAL",
110            "placeInOrder": 11,
111            "typeCode": 3
112        },
113        "postalcode__c": {
114            "type": "DECIMAL",
115            "placeInOrder": 16,
116            "typeCode": 3
117        },
118        "city__c": {
119            "type": "VARCHAR",
120            "placeInOrder": 7,
121            "typeCode": 12
122        },
123        "profit__c": {
124            "type": "DECIMAL",
125            "placeInOrder": 19,
126            "typeCode": 3
127        },
128        "customerid__c": {
129            "type": "VARCHAR",
130            "placeInOrder": 9,
131            "typeCode": 12
132        },
133        "category__c": {
134            "type": "VARCHAR",
135            "placeInOrder": 4,
136            "typeCode": 12
137        },
138        "sub_category__c": {
139            "type": "VARCHAR",
140            "placeInOrder": 29,
141            "typeCode": 12
142        },
143        "cdp_sys_SourceVersion__c": {
144            "type": "VARCHAR",
145            "placeInOrder": 6,
146            "typeCode": 12
147        },
148        "country__c": {
149            "type": "VARCHAR",
150            "placeInOrder": 8,
151            "typeCode": 12
152        },
153        "shipdate__c": {
154            "type": "DATE",
155            "placeInOrder": 26,
156            "typeCode": 91
157        },
158        "productname__c": {
159            "type": "VARCHAR",
160            "placeInOrder": 18,
161            "typeCode": 12
162        },
163        "DataSourceObject__c": {
164            "type": "VARCHAR",
165            "placeInOrder": 0,
166            "typeCode": 12
167        }
168    }
169}

HTTP Responses