Delphi (ActiveX) / Salesforce Platform APIs / Get Values for All Picklist Fields of a Record Type
Back to Collection Items
var
begin
http.AuthToken := '<access_token>';success := http.QuickGetSb('https://domain.com/services/data/v{{version}}/ui-api/object-info/:SOBJECT_API_NAME/picklist-values/:RECORD_TYPE_ID',sbResponseBody.ControlInterface);jResp.LoadSb(sbResponseBody.ControlInterface);jResp.EmitCompact := 0;jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.CleanStatus.values[i].attributes');label := jResp.StringOf('picklistFieldValues.CleanStatus.values[i].label');value := jResp.StringOf('picklistFieldValues.CleanStatus.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.CleanStatus.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;i := 0;count_i := jResp.SizeOfArray('picklistFieldValues.LeadSource.values');jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.LeadSource.values[i].attributes');label := jResp.StringOf('picklistFieldValues.LeadSource.values[i].label');value := jResp.StringOf('picklistFieldValues.LeadSource.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.LeadSource.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;i := 0;count_i := jResp.SizeOfArray('picklistFieldValues.Level__c.values');jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.Level__c.values[i].attributes');label := jResp.StringOf('picklistFieldValues.Level__c.values[i].label');value := jResp.StringOf('picklistFieldValues.Level__c.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.Level__c.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;i := 0;count_i := jResp.SizeOfArray('picklistFieldValues.MailingGeocodeAccuracy.values');jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.MailingGeocodeAccuracy.values[i].attributes');label := jResp.StringOf('picklistFieldValues.MailingGeocodeAccuracy.values[i].label');value := jResp.StringOf('picklistFieldValues.MailingGeocodeAccuracy.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.MailingGeocodeAccuracy.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;i := 0;count_i := jResp.SizeOfArray('picklistFieldValues.OtherGeocodeAccuracy.values');jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.OtherGeocodeAccuracy.values[i].attributes');label := jResp.StringOf('picklistFieldValues.OtherGeocodeAccuracy.values[i].label');value := jResp.StringOf('picklistFieldValues.OtherGeocodeAccuracy.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.OtherGeocodeAccuracy.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;i := 0;count_i := jResp.SizeOfArray('picklistFieldValues.Salutation.values');jResp.I := i;attributes := jResp.StringOf('picklistFieldValues.Salutation.values[i].attributes');label := jResp.StringOf('picklistFieldValues.Salutation.values[i].label');value := jResp.StringOf('picklistFieldValues.Salutation.values[i].value');j := 0;count_j := jResp.SizeOfArray('picklistFieldValues.Salutation.values[i].validFor');jResp.J := j;j := j + 1;i := i + 1;
Curl Command
curl -X GET
-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/ui-api/object-info/:SOBJECT_API_NAME/picklist-values/:RECORD_TYPE_ID
Postman Collection Item JSON
{
"name": "Get Values for All Picklist Fields of a Record Type",
"request": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/object-info/:SOBJECT_API_NAME/picklist-values/:RECORD_TYPE_ID",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"object-info",
":SOBJECT_API_NAME",
"picklist-values",
":RECORD_TYPE_ID"
],
"variable": [
{
"key": "SOBJECT_API_NAME",
"value": "",
"description": "Object API Name"
},
{
"key": "RECORD_TYPE_ID",
"value": "",
"description": "Record type Id. Use `012000000000000AAA` as default when there are no custom record types."
}
]
},
"description": "Get metadata about a specific object. The response includes metadata describing fields, child relationships, record type, and theme."
},
"response": [
{
"name": "Get Values for All Picklist Fields of a Record Type",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/object-info/:SOBJECT_API_NAME/picklist-values/:RECORD_TYPE_ID",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"object-info",
":SOBJECT_API_NAME",
"picklist-values",
":RECORD_TYPE_ID"
],
"variable": [
{
"key": "SOBJECT_API_NAME",
"value": "Contact"
},
{
"key": "RECORD_TYPE_ID",
"value": "012000000000000AAA"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Wed, 27 Sep 2023 15:55:22 GMT"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=63072000; includeSubDomains"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "X-Robots-Tag",
"value": "none"
},
{
"key": "Cache-Control",
"value": "no-cache,must-revalidate,max-age=0,no-store,private"
},
{
"key": "ETag",
"value": "\"ef21257ca08f8952ff154f57dc775336--gzip\""
},
{
"key": "Content-Type",
"value": "application/json;charset=UTF-8"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"eTag\": \"ef21257ca08f8952ff154f57dc775336\",\n \"picklistFieldValues\": {\n \"CleanStatus\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"bd535d2876948d8bb91fad409b69e359\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/CleanStatus\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"In Sync\",\n \"validFor\": [],\n \"value\": \"Matched\"\n },\n {\n \"attributes\": null,\n \"label\": \"Different\",\n \"validFor\": [],\n \"value\": \"Different\"\n },\n {\n \"attributes\": null,\n \"label\": \"Reviewed\",\n \"validFor\": [],\n \"value\": \"Acknowledged\"\n },\n {\n \"attributes\": null,\n \"label\": \"Not Found\",\n \"validFor\": [],\n \"value\": \"NotFound\"\n },\n {\n \"attributes\": null,\n \"label\": \"Inactive\",\n \"validFor\": [],\n \"value\": \"Inactive\"\n },\n {\n \"attributes\": null,\n \"label\": \"Not Compared\",\n \"validFor\": [],\n \"value\": \"Pending\"\n },\n {\n \"attributes\": null,\n \"label\": \"Select Match\",\n \"validFor\": [],\n \"value\": \"SelectMatch\"\n },\n {\n \"attributes\": null,\n \"label\": \"Skipped\",\n \"validFor\": [],\n \"value\": \"Skipped\"\n }\n ]\n },\n \"LeadSource\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"edb5c49da4ff7bfe2cf15ecae67a306c\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/LeadSource\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"Web\",\n \"validFor\": [],\n \"value\": \"Web\"\n },\n {\n \"attributes\": null,\n \"label\": \"Phone Inquiry\",\n \"validFor\": [],\n \"value\": \"Phone Inquiry\"\n },\n {\n \"attributes\": null,\n \"label\": \"Partner Referral\",\n \"validFor\": [],\n \"value\": \"Partner Referral\"\n },\n {\n \"attributes\": null,\n \"label\": \"Purchased List\",\n \"validFor\": [],\n \"value\": \"Purchased List\"\n },\n {\n \"attributes\": null,\n \"label\": \"Other\",\n \"validFor\": [],\n \"value\": \"Other\"\n }\n ]\n },\n \"Level__c\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"ffef8adfed014c3057fd14658f5202c4\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/Level__c\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"Secondary\",\n \"validFor\": [],\n \"value\": \"Secondary\"\n },\n {\n \"attributes\": null,\n \"label\": \"Tertiary\",\n \"validFor\": [],\n \"value\": \"Tertiary\"\n },\n {\n \"attributes\": null,\n \"label\": \"Primary\",\n \"validFor\": [],\n \"value\": \"Primary\"\n }\n ]\n },\n \"MailingGeocodeAccuracy\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"776a2f5e98c411bafb45081e39a6f1ec\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/MailingGeocodeAccuracy\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"Address\",\n \"validFor\": [],\n \"value\": \"Address\"\n },\n {\n \"attributes\": null,\n \"label\": \"NearAddress\",\n \"validFor\": [],\n \"value\": \"NearAddress\"\n },\n {\n \"attributes\": null,\n \"label\": \"Block\",\n \"validFor\": [],\n \"value\": \"Block\"\n },\n {\n \"attributes\": null,\n \"label\": \"Street\",\n \"validFor\": [],\n \"value\": \"Street\"\n },\n {\n \"attributes\": null,\n \"label\": \"ExtendedZip\",\n \"validFor\": [],\n \"value\": \"ExtendedZip\"\n },\n {\n \"attributes\": null,\n \"label\": \"Zip\",\n \"validFor\": [],\n \"value\": \"Zip\"\n },\n {\n \"attributes\": null,\n \"label\": \"Neighborhood\",\n \"validFor\": [],\n \"value\": \"Neighborhood\"\n },\n {\n \"attributes\": null,\n \"label\": \"City\",\n \"validFor\": [],\n \"value\": \"City\"\n },\n {\n \"attributes\": null,\n \"label\": \"County\",\n \"validFor\": [],\n \"value\": \"County\"\n },\n {\n \"attributes\": null,\n \"label\": \"State\",\n \"validFor\": [],\n \"value\": \"State\"\n },\n {\n \"attributes\": null,\n \"label\": \"Unknown\",\n \"validFor\": [],\n \"value\": \"Unknown\"\n }\n ]\n },\n \"OtherGeocodeAccuracy\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"776a2f5e98c411bafb45081e39a6f1ec\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/OtherGeocodeAccuracy\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"Address\",\n \"validFor\": [],\n \"value\": \"Address\"\n },\n {\n \"attributes\": null,\n \"label\": \"NearAddress\",\n \"validFor\": [],\n \"value\": \"NearAddress\"\n },\n {\n \"attributes\": null,\n \"label\": \"Block\",\n \"validFor\": [],\n \"value\": \"Block\"\n },\n {\n \"attributes\": null,\n \"label\": \"Street\",\n \"validFor\": [],\n \"value\": \"Street\"\n },\n {\n \"attributes\": null,\n \"label\": \"ExtendedZip\",\n \"validFor\": [],\n \"value\": \"ExtendedZip\"\n },\n {\n \"attributes\": null,\n \"label\": \"Zip\",\n \"validFor\": [],\n \"value\": \"Zip\"\n },\n {\n \"attributes\": null,\n \"label\": \"Neighborhood\",\n \"validFor\": [],\n \"value\": \"Neighborhood\"\n },\n {\n \"attributes\": null,\n \"label\": \"City\",\n \"validFor\": [],\n \"value\": \"City\"\n },\n {\n \"attributes\": null,\n \"label\": \"County\",\n \"validFor\": [],\n \"value\": \"County\"\n },\n {\n \"attributes\": null,\n \"label\": \"State\",\n \"validFor\": [],\n \"value\": \"State\"\n },\n {\n \"attributes\": null,\n \"label\": \"Unknown\",\n \"validFor\": [],\n \"value\": \"Unknown\"\n }\n ]\n },\n \"Salutation\": {\n \"controllerValues\": {},\n \"defaultValue\": null,\n \"eTag\": \"2de0a04925bdf8e3c70fe1177129a63f\",\n \"url\": \"/services/data/v58.0/ui-api/object-info/Contact/picklist-values/012000000000000AAA/Salutation\",\n \"values\": [\n {\n \"attributes\": null,\n \"label\": \"Mr.\",\n \"validFor\": [],\n \"value\": \"Mr.\"\n },\n {\n \"attributes\": null,\n \"label\": \"Ms.\",\n \"validFor\": [],\n \"value\": \"Ms.\"\n },\n {\n \"attributes\": null,\n \"label\": \"Mrs.\",\n \"validFor\": [],\n \"value\": \"Mrs.\"\n },\n {\n \"attributes\": null,\n \"label\": \"Dr.\",\n \"validFor\": [],\n \"value\": \"Dr.\"\n },\n {\n \"attributes\": null,\n \"label\": \"Prof.\",\n \"validFor\": [],\n \"value\": \"Prof.\"\n }\n ]\n }\n }\n}"
}
]
}
