List View Results

1curl https://na1.salesforce.com/services/data/v32.0/sobjects/Account/listviews/00BD0000005WcCNMA0/results -H "Authorization: Bearer token"

1{
2  "columns" : [ {
3    "ascendingLabel" : "Z-A",
4    "descendingLabel" : "A-Z",
5    "fieldNameOrPath" : "Name",
6    "hidden" : false,
7    "label" : "Account Name",
8    "selectListItem" : "Name",
9    "sortDirection" : "ascending",
10    "sortIndex" : 0,
11    "sortable" : true,
12    "type" : "string"
13  }, {
14    "ascendingLabel" : "Z-A",
15    "descendingLabel" : "A-Z",
16    "fieldNameOrPath" : "Site",
17    "hidden" : false,
18    "label" : "Account Site",
19    "selectListItem" : "Site",
20    "sortDirection" : null,
21    "sortIndex" : null,
22    "sortable" : true,
23    "type" : "string"
24  }, {
25    "ascendingLabel" : "Z-A",
26    "descendingLabel" : "A-Z",
27    "fieldNameOrPath" : "BillingState",
28    "hidden" : false,
29    "label" : "Billing State/Province",
30    "selectListItem" : "BillingState",
31    "sortDirection" : null,
32    "sortIndex" : null,
33    "sortable" : true,
34    "type" : "string"
35  }, {
36    "ascendingLabel" : "9-0",
37    "descendingLabel" : "0-9",
38    "fieldNameOrPath" : "Phone",
39    "hidden" : false,
40    "label" : "Phone",
41    "selectListItem" : "Phone",
42    "sortDirection" : null,
43    "sortIndex" : null,
44    "sortable" : true,
45    "type" : "phone"
46  }, {
47    "ascendingLabel" : "Low to High",
48    "descendingLabel" : "High to Low",
49    "fieldNameOrPath" : "Type",
50    "hidden" : false,
51    "label" : "Type",
52    "selectListItem" : "toLabel(Type)",
53    "sortDirection" : null,
54    "sortIndex" : null,
55    "sortable" : true,
56    "type" : "picklist"
57  }, {
58    "ascendingLabel" : "Z-A",
59    "descendingLabel" : "A-Z",
60    "fieldNameOrPath" : "Owner.Alias",
61    "hidden" : false,
62    "label" : "Account Owner Alias",
63    "selectListItem" : "Owner.Alias",
64    "sortDirection" : null,
65    "sortIndex" : null,
66    "sortable" : true,
67    "type" : "string"
68  }, {
69    "ascendingLabel" : null,
70    "descendingLabel" : null,
71    "fieldNameOrPath" : "Id",
72    "hidden" : true,
73    "label" : "Account ID",
74    "selectListItem" : "Id",
75    "sortDirection" : null,
76    "sortIndex" : null,
77    "sortable" : false,
78    "type" : "id"
79  }, {
80    "ascendingLabel" : null,
81    "descendingLabel" : null,
82    "fieldNameOrPath" : "CreatedDate",
83    "hidden" : true,
84    "label" : "Created Date",
85    "selectListItem" : "CreatedDate",
86    "sortDirection" : null,
87    "sortIndex" : null,
88    "sortable" : false,
89    "type" : "datetime"
90  }, {
91    "ascendingLabel" : null,
92    "descendingLabel" : null,
93    "fieldNameOrPath" : "LastModifiedDate",
94    "hidden" : true,
95    "label" : "Last Modified Date",
96    "selectListItem" : "LastModifiedDate",
97    "sortDirection" : null,
98    "sortIndex" : null,
99    "sortable" : false,
100    "type" : "datetime"
101  }, {
102    "ascendingLabel" : null,
103    "descendingLabel" : null,
104    "fieldNameOrPath" : "SystemModstamp",
105    "hidden" : true,
106    "label" : "System Modstamp",
107    "selectListItem" : "SystemModstamp",
108    "sortDirection" : null,
109    "sortIndex" : null,
110    "sortable" : false,
111    "type" : "datetime"
112  } ],
113  "developerName" : "MyAccounts",
114  "done" : true,
115  "id" : "00BD0000005WcCN",
116  "label" : "My Accounts",
117  "records" : [ {
118    "columns" : [ {
119      "fieldNameOrPath" : "Name",
120      "value" : "Burlington Textiles Corp of America"
121    }, {
122      "fieldNameOrPath" : "Site",
123      "value" : null
124    }, {
125      "fieldNameOrPath" : "BillingState",
126      "value" : "NC"
127    }, {
128      "fieldNameOrPath" : "Phone",
129      "value" : "(336) 222-7000"
130    }, {
131      "fieldNameOrPath" : "Type",
132      "value" : "Customer - Direct"
133    }, {
134      "fieldNameOrPath" : "Owner.Alias",
135      "value" : "TUser"
136    }, {
137      "fieldNameOrPath" : "Id",
138      "value" : "001D000000JliSTIAZ"
139    }, {
140      "fieldNameOrPath" : "CreatedDate",
141      "value" : "Fri Aug 01 21:15:46 GMT 2014"
142    }, {
143      "fieldNameOrPath" : "LastModifiedDate",
144      "value" : "Fri Aug 01 21:15:46 GMT 2014"
145    }, {
146      "fieldNameOrPath" : "SystemModstamp",
147      "value" : "Fri Aug 01 21:15:46 GMT 2014"
148    } ]
149  }, {
150    "columns" : [ {
151      "fieldNameOrPath" : "Name",
152      "value" : "Dickenson plc"
153    }, {
154      "fieldNameOrPath" : "Site",
155      "value" : null
156    }, {
157      "fieldNameOrPath" : "BillingState",
158      "value" : "KS"
159    }, {
160      "fieldNameOrPath" : "Phone",
161      "value" : "(785) 241-6200"
162    }, {
163      "fieldNameOrPath" : "Type",
164      "value" : "Customer - Channel"
165    }, {
166      "fieldNameOrPath" : "Owner.Alias",
167      "value" : "TUser"
168    }, {
169      "fieldNameOrPath" : "Id",
170      "value" : "001D000000JliSVIAZ"
171    }, {
172      "fieldNameOrPath" : "CreatedDate",
173      "value" : "Fri Aug 01 21:15:46 GMT 2014"
174    }, {
175      "fieldNameOrPath" : "LastModifiedDate",
176      "value" : "Fri Aug 01 21:15:46 GMT 2014"
177    }, {
178      "fieldNameOrPath" : "SystemModstamp",
179      "value" : "Fri Aug 01 21:15:46 GMT 2014"
180    } ]
181  }, {
182    "columns" : [ {
183      "fieldNameOrPath" : "Name",
184      "value" : "Edge Communications"
185    }, {
186      "fieldNameOrPath" : "Site",
187      "value" : null
188    }, {
189      "fieldNameOrPath" : "BillingState",
190      "value" : "TX"
191    }, {
192      "fieldNameOrPath" : "Phone",
193      "value" : "(512) 757-6000"
194    }, {
195      "fieldNameOrPath" : "Type",
196      "value" : "Customer - Direct"
197    }, {
198      "fieldNameOrPath" : "Owner.Alias",
199      "value" : "TUser"
200    }, {
201      "fieldNameOrPath" : "Id",
202      "value" : "001D000000JliSSIAZ"
203    }, {
204      "fieldNameOrPath" : "CreatedDate",
205      "value" : "Fri Aug 01 21:15:46 GMT 2014"
206    }, {
207      "fieldNameOrPath" : "LastModifiedDate",
208      "value" : "Fri Aug 01 21:15:46 GMT 2014"
209    }, {
210      "fieldNameOrPath" : "SystemModstamp",
211      "value" : "Fri Aug 01 21:15:46 GMT 2014"
212    } ]
213  }, {
214    "columns" : [ {
215      "fieldNameOrPath" : "Name",
216      "value" : "Express Logistics and Transport"
217    }, {
218      "fieldNameOrPath" : "Site",
219      "value" : null
220    }, {
221      "fieldNameOrPath" : "BillingState",
222      "value" : "OR"
223    }, {
224      "fieldNameOrPath" : "Phone",
225      "value" : "(503) 421-7800"
226    }, {
227      "fieldNameOrPath" : "Type",
228      "value" : "Customer - Channel"
229    }, {
230      "fieldNameOrPath" : "Owner.Alias",
231      "value" : "TUser"
232    }, {
233      "fieldNameOrPath" : "Id",
234      "value" : "001D000000JliSXIAZ"
235    }, {
236      "fieldNameOrPath" : "CreatedDate",
237      "value" : "Fri Aug 01 21:15:46 GMT 2014"
238    }, {
239      "fieldNameOrPath" : "LastModifiedDate",
240      "value" : "Fri Aug 01 21:15:46 GMT 2014"
241    }, {
242      "fieldNameOrPath" : "SystemModstamp",
243      "value" : "Fri Aug 01 21:15:46 GMT 2014"
244    } ]
245  }, {
246    "columns" : [ {
247      "fieldNameOrPath" : "Name",
248      "value" : "GenePoint"
249    }, {
250      "fieldNameOrPath" : "Site",
251      "value" : null
252    }, {
253      "fieldNameOrPath" : "BillingState",
254      "value" : "CA"
255    }, {
256      "fieldNameOrPath" : "Phone",
257      "value" : "(650) 867-3450"
258    }, {
259      "fieldNameOrPath" : "Type",
260      "value" : "Customer - Channel"
261    }, {
262      "fieldNameOrPath" : "Owner.Alias",
263      "value" : "TUser"
264    }, {
265      "fieldNameOrPath" : "Id",
266      "value" : "001D000000JliSPIAZ"
267    }, {
268      "fieldNameOrPath" : "CreatedDate",
269      "value" : "Fri Aug 01 21:15:46 GMT 2014"
270    }, {
271      "fieldNameOrPath" : "LastModifiedDate",
272      "value" : "Fri Aug 01 21:15:46 GMT 2014"
273    }, {
274      "fieldNameOrPath" : "SystemModstamp",
275      "value" : "Fri Aug 01 21:15:46 GMT 2014"
276    } ]
277  }, {
278    "columns" : [ {
279      "fieldNameOrPath" : "Name",
280      "value" : "Grand Hotels and Resorts Ltd"
281    }, {
282      "fieldNameOrPath" : "Site",
283      "value" : null
284    }, {
285      "fieldNameOrPath" : "BillingState",
286      "value" : "IL"
287    }, {
288      "fieldNameOrPath" : "Phone",
289      "value" : "(312) 596-1000"
290    }, {
291      "fieldNameOrPath" : "Type",
292      "value" : "Customer - Direct"
293    }, {
294      "fieldNameOrPath" : "Owner.Alias",
295      "value" : "TUser"
296    }, {
297      "fieldNameOrPath" : "Id",
298      "value" : "001D000000JliSWIAZ"
299    }, {
300      "fieldNameOrPath" : "CreatedDate",
301      "value" : "Fri Aug 01 21:15:46 GMT 2014"
302    }, {
303      "fieldNameOrPath" : "LastModifiedDate",
304      "value" : "Fri Aug 01 21:15:46 GMT 2014"
305    }, {
306      "fieldNameOrPath" : "SystemModstamp",
307      "value" : "Fri Aug 01 21:15:46 GMT 2014"
308    } ]
309  }, {
310    "columns" : [ {
311      "fieldNameOrPath" : "Name",
312      "value" : "Pyramid Construction Inc."
313    }, {
314      "fieldNameOrPath" : "Site",
315      "value" : null
316    }, {
317      "fieldNameOrPath" : "BillingState",
318      "value" : null
319    }, {
320      "fieldNameOrPath" : "Phone",
321      "value" : "(014) 427-4427"
322    }, {
323      "fieldNameOrPath" : "Type",
324      "value" : "Customer - Channel"
325    }, {
326      "fieldNameOrPath" : "Owner.Alias",
327      "value" : "TUser"
328    }, {
329      "fieldNameOrPath" : "Id",
330      "value" : "001D000000JliSUIAZ"
331    }, {
332      "fieldNameOrPath" : "CreatedDate",
333      "value" : "Fri Aug 01 21:15:46 GMT 2014"
334    }, {
335      "fieldNameOrPath" : "LastModifiedDate",
336      "value" : "Fri Aug 01 21:15:46 GMT 2014"
337    }, {
338      "fieldNameOrPath" : "SystemModstamp",
339      "value" : "Fri Aug 01 21:15:46 GMT 2014"
340    } ]
341  }, {
342    "columns" : [ {
343      "fieldNameOrPath" : "Name",
344      "value" : "sForce"
345    }, {
346      "fieldNameOrPath" : "Site",
347      "value" : null
348    }, {
349      "fieldNameOrPath" : "BillingState",
350      "value" : "CA"
351    }, {
352      "fieldNameOrPath" : "Phone",
353      "value" : "(415) 901-7000"
354    }, {
355      "fieldNameOrPath" : "Type",
356      "value" : null
357    }, {
358      "fieldNameOrPath" : "Owner.Alias",
359      "value" : "TUser"
360    }, {
361      "fieldNameOrPath" : "Id",
362      "value" : "001D000000JliSaIAJ"
363    }, {
364      "fieldNameOrPath" : "CreatedDate",
365      "value" : "Fri Aug 01 21:15:46 GMT 2014"
366    }, {
367      "fieldNameOrPath" : "LastModifiedDate",
368      "value" : "Fri Aug 01 21:15:46 GMT 2014"
369    }, {
370      "fieldNameOrPath" : "SystemModstamp",
371      "value" : "Fri Aug 01 21:15:46 GMT 2014"
372    } ]
373  }, {
374    "columns" : [ {
375      "fieldNameOrPath" : "Name",
376      "value" : "United Oil and Gas Corp."
377    }, {
378      "fieldNameOrPath" : "Site",
379      "value" : null
380    }, {
381      "fieldNameOrPath" : "BillingState",
382      "value" : "NY"
383    }, {
384      "fieldNameOrPath" : "Phone",
385      "value" : "(212) 842-5500"
386    }, {
387      "fieldNameOrPath" : "Type",
388      "value" : "Customer - Direct"
389    }, {
390      "fieldNameOrPath" : "Owner.Alias",
391      "value" : "TUser"
392    }, {
393      "fieldNameOrPath" : "Id",
394      "value" : "001D000000JliSZIAZ"
395    }, {
396      "fieldNameOrPath" : "CreatedDate",
397      "value" : "Fri Aug 01 21:15:46 GMT 2014"
398    }, {
399      "fieldNameOrPath" : "LastModifiedDate",
400      "value" : "Fri Aug 01 21:15:46 GMT 2014"
401    }, {
402      "fieldNameOrPath" : "SystemModstamp",
403      "value" : "Fri Aug 01 21:15:46 GMT 2014"
404    } ]
405  }, {
406    "columns" : [ {
407      "fieldNameOrPath" : "Name",
408      "value" : "United Oil and Gas, Singapore"
409    }, {
410      "fieldNameOrPath" : "Site",
411      "value" : null
412    }, {
413      "fieldNameOrPath" : "BillingState",
414      "value" : "Singapore"
415    }, {
416      "fieldNameOrPath" : "Phone",
417      "value" : "(650) 450-8810"
418    }, {
419      "fieldNameOrPath" : "Type",
420      "value" : "Customer - Direct"
421    }, {
422      "fieldNameOrPath" : "Owner.Alias",
423      "value" : "TUser"
424    }, {
425      "fieldNameOrPath" : "Id",
426      "value" : "001D000000JliSRIAZ"
427    }, {
428      "fieldNameOrPath" : "CreatedDate",
429      "value" : "Fri Aug 01 21:15:46 GMT 2014"
430    }, {
431      "fieldNameOrPath" : "LastModifiedDate",
432      "value" : "Fri Aug 01 21:15:46 GMT 2014"
433    }, {
434      "fieldNameOrPath" : "SystemModstamp",
435      "value" : "Fri Aug 01 21:15:46 GMT 2014"
436    } ]
437  }, {
438    "columns" : [ {
439      "fieldNameOrPath" : "Name",
440      "value" : "United Oil and Gas, UK"
441    }, {
442      "fieldNameOrPath" : "Site",
443      "value" : null
444    }, {
445      "fieldNameOrPath" : "BillingState",
446      "value" : "UK"
447    }, {
448      "fieldNameOrPath" : "Phone",
449      "value" : "+44 191 4956203"
450    }, {
451      "fieldNameOrPath" : "Type",
452      "value" : "Customer - Direct"
453    }, {
454      "fieldNameOrPath" : "Owner.Alias",
455      "value" : "TUser"
456    }, {
457      "fieldNameOrPath" : "Id",
458      "value" : "001D000000JliSQIAZ"
459    }, {
460      "fieldNameOrPath" : "CreatedDate",
461      "value" : "Fri Aug 01 21:15:46 GMT 2014"
462    }, {
463      "fieldNameOrPath" : "LastModifiedDate",
464      "value" : "Fri Aug 01 21:15:46 GMT 2014"
465    }, {
466      "fieldNameOrPath" : "SystemModstamp",
467      "value" : "Fri Aug 01 21:15:46 GMT 2014"
468    } ]
469  }, {
470    "columns" : [ {
471      "fieldNameOrPath" : "Name",
472      "value" : "University of Arizona"
473    }, {
474      "fieldNameOrPath" : "Site",
475      "value" : null
476    }, {
477      "fieldNameOrPath" : "BillingState",
478      "value" : "AZ"
479    }, {
480      "fieldNameOrPath" : "Phone",
481      "value" : "(520) 773-9050"
482    }, {
483      "fieldNameOrPath" : "Type",
484      "value" : "Customer - Direct"
485    }, {
486      "fieldNameOrPath" : "Owner.Alias",
487      "value" : "TUser"
488    }, {
489      "fieldNameOrPath" : "Id",
490      "value" : "001D000000JliSYIAZ"
491    }, {
492      "fieldNameOrPath" : "CreatedDate",
493      "value" : "Fri Aug 01 21:15:46 GMT 2014"
494    }, {
495      "fieldNameOrPath" : "LastModifiedDate",
496      "value" : "Fri Aug 01 21:15:46 GMT 2014"
497    }, {
498      "fieldNameOrPath" : "SystemModstamp",
499      "value" : "Fri Aug 01 21:15:46 GMT 2014"
500    } ]
501  } ],
502  "size" : 12
503}