VB6 / Salesforce Platform APIs / Get Most Recently Used List View Records and Metadata
Back to Collection Items
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
Dim success As Long
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://domain.com/services/data/v{{version}}/ui-api/mru-list-ui/:SOBJECT_API_NAME",sbResponseBody)
If (success = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0
Debug.Print "Response Body:"
Debug.Print jResp.Emit()
Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print http.LastHeader
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "eTag": "2227b993464298233d1c6d2e65ffe857",
' "info": {
' "cloneable": false,
' "createable": true,
' "deletable": false,
' "displayColumns": [
' {
' "fieldApiName": "Name",
' "label": "Account Name",
' "lookupId": null,
' "sortable": true
' },
' {
' "fieldApiName": "Site",
' "label": "Account Site",
' "lookupId": null,
' "sortable": true
' },
' {
' "fieldApiName": "Phone",
' "label": "Phone",
' "lookupId": null,
' "sortable": true
' },
' {
' "fieldApiName": "Owner.Alias",
' "label": "Account Owner Alias",
' "lookupId": null,
' "sortable": true
' }
' ],
' "eTag": "4c63719f66dbb57c7cb86c2effc5f08b",
' "filterLogicString": null,
' "filteredByInfo": [
' ],
' "label": "Recently Viewed",
' "listReference": {
' "id": null,
' "listViewApiName": null,
' "objectApiName": "Account",
' "type": "mru"
' },
' "objectApiNames": [
' ],
' "orderedByInfo": [
' ],
' "updateable": false,
' "userPreferences": {
' "columnWidths": {
' "Site": -1,
' "Owner.Alias": -1,
' "Phone": -1,
' "Name": -1
' },
' "columnWrap": {
' "Site": false,
' "Owner.Alias": false,
' "Phone": false,
' "Name": false
' }
' },
' "visibility": "Public",
' "visibilityEditable": false
' },
' "records": {
' "count": 4,
' "currentPageToken": "0",
' "currentPageUrl": "/services/data/v58.0/ui-api/mru-list-records/Account?pageSize=50&pageToken=0",
' "fields": [
' ],
' "listInfoETag": "4c63719f66dbb57c7cb86c2effc5f08b",
' "listReference": {
' "id": null,
' "listViewApiName": null,
' "objectApiName": "Account",
' "type": "mru"
' },
' "nextPageToken": null,
' "nextPageUrl": null,
' "optionalFields": [
' ],
' "pageSize": 50,
' "previousPageToken": null,
' "previousPageUrl": null,
' "records": [
' {
' "apiName": "Account",
' "childRelationships": {},
' "eTag": "f7f6e483706369d93dc673d2afff3d4b",
' "fields": {
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00158000006QBOlAAO"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "06/10/2023 11:14",
' "value": "2023-10-06T09:14:04.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "United Oil & Gas Corp."
' },
' "Owner": {
' "displayValue": "Philippe Ozil",
' "value": {
' "apiName": "User",
' "childRelationships": {},
' "eTag": "a12d0b3adcc7691ad4ffd5dc82bd3276",
' "fields": {
' "Alias": {
' "displayValue": null,
' "value": "POzil"
' },
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "Philippe Ozil"
' },
' "SystemModstamp": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' }
' },
' "id": "00558000000yFyDAAU",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-06T08:34:22.000Z",
' "recordTypeId": null,
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-06T08:34:22.000Z",
' "weakEtag": 1696581262000
' }
' },
' "OwnerId": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "Phone": {
' "displayValue": null,
' "value": "(212) 842-5500"
' },
' "Site": {
' "displayValue": null,
' "value": null
' },
' "SystemModstamp": {
' "displayValue": "06/10/2023 11:14",
' "value": "2023-10-06T09:14:04.000Z"
' }
' },
' "id": "00158000006QBOlAAO",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-06T09:14:04.000Z",
' "recordTypeId": "012000000000000AAA",
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-06T09:14:04.000Z",
' "weakEtag": 1696583644000
' },
' {
' "apiName": "Account",
' "childRelationships": {},
' "eTag": "08edfcddd69a2afecdf0ebb41cb56796",
' "fields": {
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00158000006QBOiAAO"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "11/05/2016 10:48",
' "value": "2016-05-11T08:48:05.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "Pyramid Construction Inc."
' },
' "Owner": {
' "displayValue": "Philippe Ozil",
' "value": {
' "apiName": "User",
' "childRelationships": {},
' "eTag": "a12d0b3adcc7691ad4ffd5dc82bd3276",
' "fields": {
' "Alias": {
' "displayValue": null,
' "value": "POzil"
' },
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "Philippe Ozil"
' },
' "SystemModstamp": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' }
' },
' "id": "00558000000yFyDAAU",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-06T08:34:22.000Z",
' "recordTypeId": null,
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-06T08:34:22.000Z",
' "weakEtag": 1696581262000
' }
' },
' "OwnerId": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "Phone": {
' "displayValue": null,
' "value": "(014) 427-4427"
' },
' "Site": {
' "displayValue": null,
' "value": null
' },
' "SystemModstamp": {
' "displayValue": "11/05/2016 10:48",
' "value": "2016-05-11T08:48:05.000Z"
' }
' },
' "id": "00158000006QBOiAAO",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2016-05-11T08:48:05.000Z",
' "recordTypeId": "012000000000000AAA",
' "recordTypeInfo": null,
' "systemModstamp": "2016-05-11T08:48:05.000Z",
' "weakEtag": 1462956485000
' },
' {
' "apiName": "Account",
' "childRelationships": {},
' "eTag": "2e6480ff0176177161db7d13b49b6a70",
' "fields": {
' "CreatedDate": {
' "displayValue": "27/02/2020 10:28",
' "value": "2020-02-27T09:28:06.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "0014H00002LbR7QQAV"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "04/10/2023 20:35",
' "value": "2023-10-04T18:35:13.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "ABC Computing"
' },
' "Owner": {
' "displayValue": "Philippe Ozil",
' "value": {
' "apiName": "User",
' "childRelationships": {},
' "eTag": "a12d0b3adcc7691ad4ffd5dc82bd3276",
' "fields": {
' "Alias": {
' "displayValue": null,
' "value": "POzil"
' },
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "Philippe Ozil"
' },
' "SystemModstamp": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' }
' },
' "id": "00558000000yFyDAAU",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-06T08:34:22.000Z",
' "recordTypeId": null,
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-06T08:34:22.000Z",
' "weakEtag": 1696581262000
' }
' },
' "OwnerId": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "Phone": {
' "displayValue": null,
' "value": "123123123"
' },
' "Site": {
' "displayValue": null,
' "value": null
' },
' "SystemModstamp": {
' "displayValue": "04/10/2023 20:35",
' "value": "2023-10-04T18:35:13.000Z"
' }
' },
' "id": "0014H00002LbR7QQAV",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-04T18:35:13.000Z",
' "recordTypeId": "012000000000000AAA",
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-04T18:35:13.000Z",
' "weakEtag": 1696444513000
' },
' {
' "apiName": "Account",
' "childRelationships": {},
' "eTag": "5577bcfb6590f3f00dfa044865276944",
' "fields": {
' "CreatedDate": {
' "displayValue": "14/09/2023 00:04",
' "value": "2023-09-13T22:04:24.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "0014H00004GXwPnQAL"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "14/09/2023 00:04",
' "value": "2023-09-13T22:04:24.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "test"
' },
' "Owner": {
' "displayValue": "Philippe Ozil",
' "value": {
' "apiName": "User",
' "childRelationships": {},
' "eTag": "a12d0b3adcc7691ad4ffd5dc82bd3276",
' "fields": {
' "Alias": {
' "displayValue": null,
' "value": "POzil"
' },
' "CreatedDate": {
' "displayValue": "09/05/2016 15:51",
' "value": "2016-05-09T13:51:39.000Z"
' },
' "Id": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedById": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "LastModifiedDate": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' },
' "Name": {
' "displayValue": null,
' "value": "Philippe Ozil"
' },
' "SystemModstamp": {
' "displayValue": "06/10/2023 10:34",
' "value": "2023-10-06T08:34:22.000Z"
' }
' },
' "id": "00558000000yFyDAAU",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-10-06T08:34:22.000Z",
' "recordTypeId": null,
' "recordTypeInfo": null,
' "systemModstamp": "2023-10-06T08:34:22.000Z",
' "weakEtag": 1696581262000
' }
' },
' "OwnerId": {
' "displayValue": null,
' "value": "00558000000yFyDAAU"
' },
' "Phone": {
' "displayValue": null,
' "value": null
' },
' "Site": {
' "displayValue": null,
' "value": null
' },
' "SystemModstamp": {
' "displayValue": "14/09/2023 00:04",
' "value": "2023-09-13T22:04:24.000Z"
' }
' },
' "id": "0014H00004GXwPnQAL",
' "lastModifiedById": "00558000000yFyDAAU",
' "lastModifiedDate": "2023-09-13T22:04:24.000Z",
' "recordTypeId": "012000000000000AAA",
' "recordTypeInfo": null,
' "systemModstamp": "2023-09-13T22:04:24.000Z",
' "weakEtag": 1694642664000
' }
' ],
' "sortBy": null
' }
' }
' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Dim fieldApiName As String
Dim label As String
Dim lookupId As String
Dim sortable As Long
Dim apiName As String
Dim DisplayValue As String
Dim Value As String
Dim IdDisplayValue As String
Dim IdValue As String
Dim LastModifiedByIdDisplayValue As String
Dim LastModifiedByIdValue As String
Dim LastModifiedDateDisplayValue As String
Dim LastModifiedDateValue As String
Dim NameDisplayValue As String
Dim NameValue As String
Dim OwnerDisplayValue As String
Dim ApiName As String
Dim ValueETag As String
Dim AliasDisplayValue As String
Dim AliasValue As String
Dim CreatedDateDisplayValue As String
Dim CreatedDateValue As String
Dim SystemModstampDisplayValue As String
Dim SystemModstampValue As String
Dim ValueId As String
Dim LastModifiedById As String
Dim LastModifiedDate As String
Dim RecordTypeId As String
Dim RecordTypeInfo As String
Dim SystemModstamp As String
Dim WeakEtag As Long
Dim OwnerIdDisplayValue As String
Dim OwnerIdValue As String
Dim PhoneDisplayValue As String
Dim PhoneValue As String
Dim SiteDisplayValue As String
Dim SiteValue As String
Dim id As String
Dim lastModifiedById As String
Dim lastModifiedDate As String
Dim recordTypeId As String
Dim recordTypeInfo As String
Dim systemModstamp As String
Dim weakEtag As Long
Dim eTag As String
eTag = jResp.StringOf("eTag")
Dim Cloneable As Long
Cloneable = jResp.BoolOf("info.cloneable")
Dim Createable As Long
Createable = jResp.BoolOf("info.createable")
Dim Deletable As Long
Deletable = jResp.BoolOf("info.deletable")
Dim ETag As String
ETag = jResp.StringOf("info.eTag")
Dim FilterLogicString As String
FilterLogicString = jResp.StringOf("info.filterLogicString")
Dim Label As String
Label = jResp.StringOf("info.label")
Dim Id As String
Id = jResp.StringOf("info.listReference.id")
Dim ListViewApiName As String
ListViewApiName = jResp.StringOf("info.listReference.listViewApiName")
Dim ObjectApiName As String
ObjectApiName = jResp.StringOf("info.listReference.objectApiName")
Dim v_Type As String
v_Type = jResp.StringOf("info.listReference.type")
Dim Updateable As Long
Updateable = jResp.BoolOf("info.updateable")
Dim Site As Long
Site = jResp.IntOf("info.userPreferences.columnWidths.Site")
Dim Owner_Alias As Long
Owner_Alias = jResp.IntOf("info.userPreferences.columnWidths.""Owner.Alias""")
Dim Phone As Long
Phone = jResp.IntOf("info.userPreferences.columnWidths.Phone")
Dim Name As Long
Name = jResp.IntOf("info.userPreferences.columnWidths.Name")
Dim ColumnWrapSite As Long
ColumnWrapSite = jResp.BoolOf("info.userPreferences.columnWrap.Site")
Dim ColumnWrapOwner_Alias As Long
ColumnWrapOwner_Alias = jResp.BoolOf("info.userPreferences.columnWrap.""Owner.Alias""")
Dim ColumnWrapPhone As Long
ColumnWrapPhone = jResp.BoolOf("info.userPreferences.columnWrap.Phone")
Dim ColumnWrapName As Long
ColumnWrapName = jResp.BoolOf("info.userPreferences.columnWrap.Name")
Dim Visibility As String
Visibility = jResp.StringOf("info.visibility")
Dim VisibilityEditable As Long
VisibilityEditable = jResp.BoolOf("info.visibilityEditable")
Dim Count As Long
Count = jResp.IntOf("records.count")
Dim CurrentPageToken As String
CurrentPageToken = jResp.StringOf("records.currentPageToken")
Dim CurrentPageUrl As String
CurrentPageUrl = jResp.StringOf("records.currentPageUrl")
Dim ListInfoETag As String
ListInfoETag = jResp.StringOf("records.listInfoETag")
Dim ListReferenceId As String
ListReferenceId = jResp.StringOf("records.listReference.id")
Dim ListReferenceListViewApiName As String
ListReferenceListViewApiName = jResp.StringOf("records.listReference.listViewApiName")
Dim ListReferenceObjectApiName As String
ListReferenceObjectApiName = jResp.StringOf("records.listReference.objectApiName")
Dim ListReferenceType As String
ListReferenceType = jResp.StringOf("records.listReference.type")
Dim NextPageToken As String
NextPageToken = jResp.StringOf("records.nextPageToken")
Dim NextPageUrl As String
NextPageUrl = jResp.StringOf("records.nextPageUrl")
Dim PageSize As Long
PageSize = jResp.IntOf("records.pageSize")
Dim PreviousPageToken As String
PreviousPageToken = jResp.StringOf("records.previousPageToken")
Dim PreviousPageUrl As String
PreviousPageUrl = jResp.StringOf("records.previousPageUrl")
Dim SortBy As String
SortBy = jResp.StringOf("records.sortBy")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("info.displayColumns")
Do While i < count_i
jResp.I = i
fieldApiName = jResp.StringOf("info.displayColumns[i].fieldApiName")
label = jResp.StringOf("info.displayColumns[i].label")
lookupId = jResp.StringOf("info.displayColumns[i].lookupId")
sortable = jResp.BoolOf("info.displayColumns[i].sortable")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("info.filteredByInfo")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("info.objectApiNames")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("info.orderedByInfo")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("records.fields")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("records.optionalFields")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("records.records")
Do While i < count_i
jResp.I = i
apiName = jResp.StringOf("records.records[i].apiName")
eTag = jResp.StringOf("records.records[i].eTag")
DisplayValue = jResp.StringOf("records.records[i].fields.CreatedDate.displayValue")
Value = jResp.StringOf("records.records[i].fields.CreatedDate.value")
IdDisplayValue = jResp.StringOf("records.records[i].fields.Id.displayValue")
IdValue = jResp.StringOf("records.records[i].fields.Id.value")
LastModifiedByIdDisplayValue = jResp.StringOf("records.records[i].fields.LastModifiedById.displayValue")
LastModifiedByIdValue = jResp.StringOf("records.records[i].fields.LastModifiedById.value")
LastModifiedDateDisplayValue = jResp.StringOf("records.records[i].fields.LastModifiedDate.displayValue")
LastModifiedDateValue = jResp.StringOf("records.records[i].fields.LastModifiedDate.value")
NameDisplayValue = jResp.StringOf("records.records[i].fields.Name.displayValue")
NameValue = jResp.StringOf("records.records[i].fields.Name.value")
OwnerDisplayValue = jResp.StringOf("records.records[i].fields.Owner.displayValue")
ApiName = jResp.StringOf("records.records[i].fields.Owner.value.apiName")
ValueETag = jResp.StringOf("records.records[i].fields.Owner.value.eTag")
AliasDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Alias.displayValue")
AliasValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Alias.value")
CreatedDateDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.CreatedDate.displayValue")
CreatedDateValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.CreatedDate.value")
IdDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Id.displayValue")
IdValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Id.value")
LastModifiedByIdDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.LastModifiedById.displayValue")
LastModifiedByIdValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.LastModifiedById.value")
LastModifiedDateDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.LastModifiedDate.displayValue")
LastModifiedDateValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.LastModifiedDate.value")
NameDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Name.displayValue")
NameValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.Name.value")
SystemModstampDisplayValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.SystemModstamp.displayValue")
SystemModstampValue = jResp.StringOf("records.records[i].fields.Owner.value.fields.SystemModstamp.value")
ValueId = jResp.StringOf("records.records[i].fields.Owner.value.id")
LastModifiedById = jResp.StringOf("records.records[i].fields.Owner.value.lastModifiedById")
LastModifiedDate = jResp.StringOf("records.records[i].fields.Owner.value.lastModifiedDate")
RecordTypeId = jResp.StringOf("records.records[i].fields.Owner.value.recordTypeId")
RecordTypeInfo = jResp.StringOf("records.records[i].fields.Owner.value.recordTypeInfo")
SystemModstamp = jResp.StringOf("records.records[i].fields.Owner.value.systemModstamp")
WeakEtag = jResp.IntOf("records.records[i].fields.Owner.value.weakEtag")
OwnerIdDisplayValue = jResp.StringOf("records.records[i].fields.OwnerId.displayValue")
OwnerIdValue = jResp.StringOf("records.records[i].fields.OwnerId.value")
PhoneDisplayValue = jResp.StringOf("records.records[i].fields.Phone.displayValue")
PhoneValue = jResp.StringOf("records.records[i].fields.Phone.value")
SiteDisplayValue = jResp.StringOf("records.records[i].fields.Site.displayValue")
SiteValue = jResp.StringOf("records.records[i].fields.Site.value")
SystemModstampDisplayValue = jResp.StringOf("records.records[i].fields.SystemModstamp.displayValue")
SystemModstampValue = jResp.StringOf("records.records[i].fields.SystemModstamp.value")
id = jResp.StringOf("records.records[i].id")
lastModifiedById = jResp.StringOf("records.records[i].lastModifiedById")
lastModifiedDate = jResp.StringOf("records.records[i].lastModifiedDate")
recordTypeId = jResp.StringOf("records.records[i].recordTypeId")
recordTypeInfo = jResp.StringOf("records.records[i].recordTypeInfo")
systemModstamp = jResp.StringOf("records.records[i].systemModstamp")
weakEtag = jResp.IntOf("records.records[i].weakEtag")
i = i + 1
Loop
Curl Command
curl -X GET
-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/ui-api/mru-list-ui/:SOBJECT_API_NAME
Postman Collection Item JSON
{
"name": "Get Most Recently Used List View Records and Metadata",
"event": [
{
"listen": "prerequest",
"script": {
"exec": [
""
],
"type": "text/javascript"
}
}
],
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
],
"body": {
"mode": "raw",
"raw": "",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/mru-list-ui/:SOBJECT_API_NAME",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"mru-list-ui",
":SOBJECT_API_NAME"
],
"variable": [
{
"key": "SOBJECT_API_NAME",
"value": "",
"description": "Object API name"
}
]
},
"description": "Returns record data and metadata for an object’s most recently used (MRU) list view."
},
"response": [
{
"name": "Get Most Recently Used List View Records and Metadata",
"originalRequest": {
"method": "GET",
"header": [
],
"body": {
"mode": "raw",
"raw": "",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/mru-list-ui/:SOBJECT_API_NAME",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"mru-list-ui",
":SOBJECT_API_NAME"
],
"variable": [
{
"key": "SOBJECT_API_NAME",
"value": "Account",
"description": "Object API name"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Fri, 06 Oct 2023 10:00:19 GMT"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=63072000; includeSubDomains"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-Robots-Tag",
"value": "none"
},
{
"key": "Cache-Control",
"value": "no-cache,must-revalidate,max-age=0,no-store,private"
},
{
"key": "ETag",
"value": "\"2227b993464298233d1c6d2e65ffe857--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\": \"2227b993464298233d1c6d2e65ffe857\",\n \"info\": {\n \"cloneable\": false,\n \"createable\": true,\n \"deletable\": false,\n \"displayColumns\": [\n {\n \"fieldApiName\": \"Name\",\n \"label\": \"Account Name\",\n \"lookupId\": null,\n \"sortable\": true\n },\n {\n \"fieldApiName\": \"Site\",\n \"label\": \"Account Site\",\n \"lookupId\": null,\n \"sortable\": true\n },\n {\n \"fieldApiName\": \"Phone\",\n \"label\": \"Phone\",\n \"lookupId\": null,\n \"sortable\": true\n },\n {\n \"fieldApiName\": \"Owner.Alias\",\n \"label\": \"Account Owner Alias\",\n \"lookupId\": null,\n \"sortable\": true\n }\n ],\n \"eTag\": \"4c63719f66dbb57c7cb86c2effc5f08b\",\n \"filterLogicString\": null,\n \"filteredByInfo\": [],\n \"label\": \"Recently Viewed\",\n \"listReference\": {\n \"id\": null,\n \"listViewApiName\": null,\n \"objectApiName\": \"Account\",\n \"type\": \"mru\"\n },\n \"objectApiNames\": [],\n \"orderedByInfo\": [],\n \"updateable\": false,\n \"userPreferences\": {\n \"columnWidths\": {\n \"Site\": -1,\n \"Owner.Alias\": -1,\n \"Phone\": -1,\n \"Name\": -1\n },\n \"columnWrap\": {\n \"Site\": false,\n \"Owner.Alias\": false,\n \"Phone\": false,\n \"Name\": false\n }\n },\n \"visibility\": \"Public\",\n \"visibilityEditable\": false\n },\n \"records\": {\n \"count\": 4,\n \"currentPageToken\": \"0\",\n \"currentPageUrl\": \"/services/data/v58.0/ui-api/mru-list-records/Account?pageSize=50&pageToken=0\",\n \"fields\": [],\n \"listInfoETag\": \"4c63719f66dbb57c7cb86c2effc5f08b\",\n \"listReference\": {\n \"id\": null,\n \"listViewApiName\": null,\n \"objectApiName\": \"Account\",\n \"type\": \"mru\"\n },\n \"nextPageToken\": null,\n \"nextPageUrl\": null,\n \"optionalFields\": [],\n \"pageSize\": 50,\n \"previousPageToken\": null,\n \"previousPageUrl\": null,\n \"records\": [\n {\n \"apiName\": \"Account\",\n \"childRelationships\": {},\n \"eTag\": \"f7f6e483706369d93dc673d2afff3d4b\",\n \"fields\": {\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00158000006QBOlAAO\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"06/10/2023 11:14\",\n \"value\": \"2023-10-06T09:14:04.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"United Oil & Gas Corp.\"\n },\n \"Owner\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"a12d0b3adcc7691ad4ffd5dc82bd3276\",\n \"fields\": {\n \"Alias\": {\n \"displayValue\": null,\n \"value\": \"POzil\"\n },\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n },\n \"SystemModstamp\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n }\n },\n \"id\": \"00558000000yFyDAAU\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-06T08:34:22.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-06T08:34:22.000Z\",\n \"weakEtag\": 1696581262000\n }\n },\n \"OwnerId\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"Phone\": {\n \"displayValue\": null,\n \"value\": \"(212) 842-5500\"\n },\n \"Site\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SystemModstamp\": {\n \"displayValue\": \"06/10/2023 11:14\",\n \"value\": \"2023-10-06T09:14:04.000Z\"\n }\n },\n \"id\": \"00158000006QBOlAAO\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-06T09:14:04.000Z\",\n \"recordTypeId\": \"012000000000000AAA\",\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-06T09:14:04.000Z\",\n \"weakEtag\": 1696583644000\n },\n {\n \"apiName\": \"Account\",\n \"childRelationships\": {},\n \"eTag\": \"08edfcddd69a2afecdf0ebb41cb56796\",\n \"fields\": {\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00158000006QBOiAAO\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"11/05/2016 10:48\",\n \"value\": \"2016-05-11T08:48:05.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Pyramid Construction Inc.\"\n },\n \"Owner\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"a12d0b3adcc7691ad4ffd5dc82bd3276\",\n \"fields\": {\n \"Alias\": {\n \"displayValue\": null,\n \"value\": \"POzil\"\n },\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n },\n \"SystemModstamp\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n }\n },\n \"id\": \"00558000000yFyDAAU\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-06T08:34:22.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-06T08:34:22.000Z\",\n \"weakEtag\": 1696581262000\n }\n },\n \"OwnerId\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"Phone\": {\n \"displayValue\": null,\n \"value\": \"(014) 427-4427\"\n },\n \"Site\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SystemModstamp\": {\n \"displayValue\": \"11/05/2016 10:48\",\n \"value\": \"2016-05-11T08:48:05.000Z\"\n }\n },\n \"id\": \"00158000006QBOiAAO\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2016-05-11T08:48:05.000Z\",\n \"recordTypeId\": \"012000000000000AAA\",\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2016-05-11T08:48:05.000Z\",\n \"weakEtag\": 1462956485000\n },\n {\n \"apiName\": \"Account\",\n \"childRelationships\": {},\n \"eTag\": \"2e6480ff0176177161db7d13b49b6a70\",\n \"fields\": {\n \"CreatedDate\": {\n \"displayValue\": \"27/02/2020 10:28\",\n \"value\": \"2020-02-27T09:28:06.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"0014H00002LbR7QQAV\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"04/10/2023 20:35\",\n \"value\": \"2023-10-04T18:35:13.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"ABC Computing\"\n },\n \"Owner\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"a12d0b3adcc7691ad4ffd5dc82bd3276\",\n \"fields\": {\n \"Alias\": {\n \"displayValue\": null,\n \"value\": \"POzil\"\n },\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n },\n \"SystemModstamp\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n }\n },\n \"id\": \"00558000000yFyDAAU\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-06T08:34:22.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-06T08:34:22.000Z\",\n \"weakEtag\": 1696581262000\n }\n },\n \"OwnerId\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"Phone\": {\n \"displayValue\": null,\n \"value\": \"123123123\"\n },\n \"Site\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SystemModstamp\": {\n \"displayValue\": \"04/10/2023 20:35\",\n \"value\": \"2023-10-04T18:35:13.000Z\"\n }\n },\n \"id\": \"0014H00002LbR7QQAV\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-04T18:35:13.000Z\",\n \"recordTypeId\": \"012000000000000AAA\",\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-04T18:35:13.000Z\",\n \"weakEtag\": 1696444513000\n },\n {\n \"apiName\": \"Account\",\n \"childRelationships\": {},\n \"eTag\": \"5577bcfb6590f3f00dfa044865276944\",\n \"fields\": {\n \"CreatedDate\": {\n \"displayValue\": \"14/09/2023 00:04\",\n \"value\": \"2023-09-13T22:04:24.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"0014H00004GXwPnQAL\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"14/09/2023 00:04\",\n \"value\": \"2023-09-13T22:04:24.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"test\"\n },\n \"Owner\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"a12d0b3adcc7691ad4ffd5dc82bd3276\",\n \"fields\": {\n \"Alias\": {\n \"displayValue\": null,\n \"value\": \"POzil\"\n },\n \"CreatedDate\": {\n \"displayValue\": \"09/05/2016 15:51\",\n \"value\": \"2016-05-09T13:51:39.000Z\"\n },\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n },\n \"SystemModstamp\": {\n \"displayValue\": \"06/10/2023 10:34\",\n \"value\": \"2023-10-06T08:34:22.000Z\"\n }\n },\n \"id\": \"00558000000yFyDAAU\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-10-06T08:34:22.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-10-06T08:34:22.000Z\",\n \"weakEtag\": 1696581262000\n }\n },\n \"OwnerId\": {\n \"displayValue\": null,\n \"value\": \"00558000000yFyDAAU\"\n },\n \"Phone\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Site\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SystemModstamp\": {\n \"displayValue\": \"14/09/2023 00:04\",\n \"value\": \"2023-09-13T22:04:24.000Z\"\n }\n },\n \"id\": \"0014H00004GXwPnQAL\",\n \"lastModifiedById\": \"00558000000yFyDAAU\",\n \"lastModifiedDate\": \"2023-09-13T22:04:24.000Z\",\n \"recordTypeId\": \"012000000000000AAA\",\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-09-13T22:04:24.000Z\",\n \"weakEtag\": 1694642664000\n }\n ],\n \"sortBy\": null\n }\n}"
}
]
}
