Chilkat Online Tools

DataFlex / Salesforce Platform APIs / Get a Record

Back to Collection Items

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    Boolean iSuccess
    Variant vSbResponseBody
    Handle hoSbResponseBody
    Handle hoJResp
    Integer iRespStatusCode
    String sApiName
    String sETag
    String sDisplayValue
    String sValue
    String sRatingDisplayValue
    String sRatingValue
    String sId
    String sLastModifiedById
    String sLastModifiedDate
    String sRecordTypeId
    String sRecordTypeInfo
    String sSystemModstamp
    Integer iWeakEtag
    String sTemp1

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    // Adds the "Authorization: Bearer <access_token>" header.
    Set ComAuthToken Of hoHttp To "<access_token>"

    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
    If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
        Send CreateComObject of hoSbResponseBody
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComQuickGetSb Of hoHttp "https://domain.com/services/data/v{{version}}/ui-api/records/:RECORD_ID" vSbResponseBody To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
    If (Not(IsComObjectCreated(hoJResp))) Begin
        Send CreateComObject of hoJResp
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
    Set ComEmitCompact Of hoJResp To False

    Showln "Response Body:"
    Get ComEmit Of hoJResp To sTemp1
    Showln sTemp1

    Get ComLastStatus Of hoHttp To iRespStatusCode
    Showln "Response Status Code = " iRespStatusCode
    If (iRespStatusCode >= 400) Begin
        Showln "Response Header:"
        Get ComLastHeader Of hoHttp To sTemp1
        Showln sTemp1
        Showln "Failed."
        Procedure_Return
    End

    // Sample JSON response:
    // (Sample code for parsing the JSON response is shown below)

    // {
    //   "apiName": "Account",
    //   "childRelationships": {},
    //   "eTag": "8897eb60da3dea171b0d755821bf2c36",
    //   "fields": {
    //     "Name": {
    //       "displayValue": null,
    //       "value": "Burlington Textiles Corp of America"
    //     },
    //     "Rating": {
    //       "displayValue": "Warm",
    //       "value": "Warm"
    //     }
    //   },
    //   "id": "001B000000UnQ2wIAF",
    //   "lastModifiedById": "005B0000003TOI6IAO",
    //   "lastModifiedDate": "2017-08-18T14:46:22.000Z",
    //   "recordTypeId": "012000000000000AAA",
    //   "recordTypeInfo": null,
    //   "systemModstamp": "2017-08-18T14:46:22.000Z",
    //   "weakEtag": 1503067582000
    // }

    // Sample code for parsing the JSON response...
    // Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

    Get ComStringOf Of hoJResp "apiName" To sApiName
    Get ComStringOf Of hoJResp "eTag" To sETag
    Get ComStringOf Of hoJResp "fields.Name.displayValue" To sDisplayValue
    Get ComStringOf Of hoJResp "fields.Name.value" To sValue
    Get ComStringOf Of hoJResp "fields.Rating.displayValue" To sRatingDisplayValue
    Get ComStringOf Of hoJResp "fields.Rating.value" To sRatingValue
    Get ComStringOf Of hoJResp "id" To sId
    Get ComStringOf Of hoJResp "lastModifiedById" To sLastModifiedById
    Get ComStringOf Of hoJResp "lastModifiedDate" To sLastModifiedDate
    Get ComStringOf Of hoJResp "recordTypeId" To sRecordTypeId
    Get ComStringOf Of hoJResp "recordTypeInfo" To sRecordTypeInfo
    Get ComStringOf Of hoJResp "systemModstamp" To sSystemModstamp
    Get ComIntOf Of hoJResp "weakEtag" To iWeakEtag


End_Procedure

Curl Command

curl -X GET
	-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/ui-api/records/:RECORD_ID

Postman Collection Item JSON

{
  "name": "Get a Record",
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/records/:RECORD_ID",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "ui-api",
        "records",
        ":RECORD_ID"
      ],
      "query": [
        {
          "key": "childRelationships",
          "value": "",
          "description": "A collection of child relationship names. The records with those child relationship names are included in the response. Specify names in the format ObjectApiName.ChildRelationshipName or ObjectApiName.ChildRelationshipName.FieldApiName. For example, to specify the Contacts relationship on an Account, use Account.Contacts. You can get child relationships one level deep.\nTo get a relationship name, look in the Object Info response body.",
          "disabled": true
        },
        {
          "key": "fields",
          "value": "",
          "description": "Specifies the fields to return. If this property is specified, the response is a union of fields and optionalFields.\nIf the context user doesn’t have access to a field, an error is returned.\n\nIf you’re not sure whether the context user has access to a field and you don’t want the request to fail if they don’t, use the optionalFields parameter.\n\nSpecify names in the format ObjectApiName.FieldName. You can get any field that has a named relationship to this record. There is no limit to the number of fields you can specify.",
          "disabled": true
        },
        {
          "key": "layoutTypes",
          "value": "",
          "description": "Specifies the fields to return. If this property is specified, the response is a union of layoutTypes, modes, and optionalFields.\nA collection containing any of these values:\nCompact—Use this value to get a layout that contains a record’s key fields.\nFull—(Default) Use this value to get a full layout.",
          "disabled": true
        },
        {
          "key": "modes",
          "value": "",
          "description": "The access mode for the record. This value determines which fields to get from a layout. Layouts have different fields for create, edit, and view modes. For example, formula fields are rendered in view mode, but not in create mode because they’re calculated at run time, like formulas in a spreadsheet. A collection containing any of these values:\nCreate—Use this mode if you intend to build UI that lets a user create a record. This mode is used by the /ui-api/record-defaults/create/<SOBJECT_API_NAME> resource.\nEdit—Use this mode if you intend to build UI that lets a user edit a record. This mode is used by the /ui-api/record-defaults/clone/<RECORD_ID> resource.\nView—(Default) Use this mode if you intend to build UI that displays a record.",
          "disabled": true
        },
        {
          "key": "optionalFields",
          "value": "",
          "description": "A collection of optional field names. If a field is accessible to the context user, it’s included in the response. If a field isn’t accessible to the context user, it isn’t included in the response, but it doesn’t cause an error.\nSpecify names in the format ObjectApiName.FieldName. You can get any field that has a named relationship to this record. There is no limit to the number of fields you can specify.",
          "disabled": true
        },
        {
          "key": "pageSize",
          "value": "",
          "description": "The maximum number of child records to return on a page. The default value is 5.",
          "disabled": true
        },
        {
          "key": "updateMru",
          "value": "",
          "description": "To add to the most recently used (MRU) list view, set to true. The default value is false.",
          "disabled": true
        }
      ],
      "variable": [
        {
          "key": "RECORD_ID",
          "value": ""
        }
      ]
    },
    "description": "Get a record’s data."
  },
  "response": [
    {
      "name": "Get a Record",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/records/:RECORD_ID?fields=Account.Name,Account.Rating",
          "host": [
            "{{_endpoint}}"
          ],
          "path": [
            "services",
            "data",
            "v{{version}}",
            "ui-api",
            "records",
            ":RECORD_ID"
          ],
          "query": [
            {
              "key": "childRelationships",
              "value": "",
              "description": "A collection of child relationship names. The records with those child relationship names are included in the response. Specify names in the format ObjectApiName.ChildRelationshipName or ObjectApiName.ChildRelationshipName.FieldApiName. For example, to specify the Contacts relationship on an Account, use Account.Contacts. You can get child relationships one level deep.\nTo get a relationship name, look in the Object Info response body.",
              "disabled": true
            },
            {
              "key": "fields",
              "value": "Account.Name,Account.Rating",
              "description": "Specifies the fields to return. If this property is specified, the response is a union of fields and optionalFields.\nIf the context user doesn’t have access to a field, an error is returned.\n\nIf you’re not sure whether the context user has access to a field and you don’t want the request to fail if they don’t, use the optionalFields parameter.\n\nSpecify names in the format ObjectApiName.FieldName. You can get any field that has a named relationship to this record. There is no limit to the number of fields you can specify."
            },
            {
              "key": "layoutTypes",
              "value": "",
              "description": "Specifies the fields to return. If this property is specified, the response is a union of layoutTypes, modes, and optionalFields.\nA collection containing any of these values:\nCompact—Use this value to get a layout that contains a record’s key fields.\nFull—(Default) Use this value to get a full layout.",
              "disabled": true
            },
            {
              "key": "modes",
              "value": "",
              "description": "The access mode for the record. This value determines which fields to get from a layout. Layouts have different fields for create, edit, and view modes. For example, formula fields are rendered in view mode, but not in create mode because they’re calculated at run time, like formulas in a spreadsheet. A collection containing any of these values:\nCreate—Use this mode if you intend to build UI that lets a user create a record. This mode is used by the /ui-api/record-defaults/create/<SOBJECT_API_NAME> resource.\nEdit—Use this mode if you intend to build UI that lets a user edit a record. This mode is used by the /ui-api/record-defaults/clone/<RECORD_ID> resource.\nView—(Default) Use this mode if you intend to build UI that displays a record.",
              "disabled": true
            },
            {
              "key": "optionalFields",
              "value": "",
              "description": "A collection of optional field names. If a field is accessible to the context user, it’s included in the response. If a field isn’t accessible to the context user, it isn’t included in the response, but it doesn’t cause an error.\nSpecify names in the format ObjectApiName.FieldName. You can get any field that has a named relationship to this record. There is no limit to the number of fields you can specify.",
              "disabled": true
            },
            {
              "key": "pageSize",
              "value": "",
              "description": "The maximum number of child records to return on a page. The default value is 5.",
              "disabled": true
            },
            {
              "key": "updateMru",
              "value": "",
              "description": "To add to the most recently used (MRU) list view, set to true. The default value is false.",
              "disabled": true
            }
          ],
          "variable": [
            {
              "key": "RECORD_ID",
              "value": "001B000000UnQ2wIAF",
              "description": "Record ID"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Date",
          "value": "Wed, 27 Sep 2023 15:58:57 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": "\"8897eb60da3dea171b0d755821bf2c36--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    \"apiName\": \"Account\",\n    \"childRelationships\": {},\n    \"eTag\": \"8897eb60da3dea171b0d755821bf2c36\",\n    \"fields\": {\n        \"Name\": {\n            \"displayValue\": null,\n            \"value\": \"Burlington Textiles Corp of America\"\n        },\n        \"Rating\": {\n            \"displayValue\": \"Warm\",\n            \"value\": \"Warm\"\n        }\n    },\n    \"id\": \"001B000000UnQ2wIAF\",\n    \"lastModifiedById\": \"005B0000003TOI6IAO\",\n    \"lastModifiedDate\": \"2017-08-18T14:46:22.000Z\",\n    \"recordTypeId\": \"012000000000000AAA\",\n    \"recordTypeInfo\": null,\n    \"systemModstamp\": \"2017-08-18T14:46:22.000Z\",\n    \"weakEtag\": 1503067582000\n}"
    }
  ]
}