Chilkat Online Tools

VBScript / Salesforce Platform APIs / Get Most Recently Used List View Records and Metadata

Back to Collection Items

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb("https://domain.com/services/data/v{{version}}/ui-api/mru-list-ui/:SOBJECT_API_NAME",sbResponseBody)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jResp = CreateObject("Chilkat.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

outFile.WriteLine("Response Body:")
outFile.WriteLine(jResp.Emit())

respStatusCode = http.LastStatus
outFile.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
    outFile.WriteLine("Response Header:")
    outFile.WriteLine(http.LastHeader)
    outFile.WriteLine("Failed.")
    WScript.Quit
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

eTag = jResp.StringOf("eTag")
Cloneable = jResp.BoolOf("info.cloneable")
Createable = jResp.BoolOf("info.createable")
Deletable = jResp.BoolOf("info.deletable")
ETag = jResp.StringOf("info.eTag")
FilterLogicString = jResp.StringOf("info.filterLogicString")
Label = jResp.StringOf("info.label")
Id = jResp.StringOf("info.listReference.id")
ListViewApiName = jResp.StringOf("info.listReference.listViewApiName")
ObjectApiName = jResp.StringOf("info.listReference.objectApiName")
v_Type = jResp.StringOf("info.listReference.type")
Updateable = jResp.BoolOf("info.updateable")
Site = jResp.IntOf("info.userPreferences.columnWidths.Site")
Owner_Alias = jResp.IntOf("info.userPreferences.columnWidths.""Owner.Alias""")
Phone = jResp.IntOf("info.userPreferences.columnWidths.Phone")
Name = jResp.IntOf("info.userPreferences.columnWidths.Name")
ColumnWrapSite = jResp.BoolOf("info.userPreferences.columnWrap.Site")
ColumnWrapOwner_Alias = jResp.BoolOf("info.userPreferences.columnWrap.""Owner.Alias""")
ColumnWrapPhone = jResp.BoolOf("info.userPreferences.columnWrap.Phone")
ColumnWrapName = jResp.BoolOf("info.userPreferences.columnWrap.Name")
Visibility = jResp.StringOf("info.visibility")
VisibilityEditable = jResp.BoolOf("info.visibilityEditable")
Count = jResp.IntOf("records.count")
CurrentPageToken = jResp.StringOf("records.currentPageToken")
CurrentPageUrl = jResp.StringOf("records.currentPageUrl")
ListInfoETag = jResp.StringOf("records.listInfoETag")
ListReferenceId = jResp.StringOf("records.listReference.id")
ListReferenceListViewApiName = jResp.StringOf("records.listReference.listViewApiName")
ListReferenceObjectApiName = jResp.StringOf("records.listReference.objectApiName")
ListReferenceType = jResp.StringOf("records.listReference.type")
NextPageToken = jResp.StringOf("records.nextPageToken")
NextPageUrl = jResp.StringOf("records.nextPageUrl")
PageSize = jResp.IntOf("records.pageSize")
PreviousPageToken = jResp.StringOf("records.previousPageToken")
PreviousPageUrl = jResp.StringOf("records.previousPageUrl")
SortBy = jResp.StringOf("records.sortBy")
i = 0
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

outFile.Close

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 &amp; 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}"
    }
  ]
}