Chilkat Online Tools

DataFlex / Salesforce Platform APIs / Access Records

Back to Collection Items

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    Boolean iSuccess
    Variant vSbResponseBody
    Handle hoSbResponseBody
    Handle hoJResp
    Integer iRespStatusCode
    Integer iLocationColumn
    Integer iLocationLine
    String sName
    String sV_type
    Integer j
    Integer iCount_j
    String sStrVal
    String sReturnType
    String sV_Type
    String sV_Url
    String sId
    String sNamespacePrefix
    String sName
    Integer iApiVersion
    String sStatus
    Boolean iIsValid
    Integer iBodyCrc
    String sBody
    Integer iLengthWithoutComments
    String sCreatedDate
    String sCreatedById
    String sLastModifiedDate
    String sLastModifiedById
    String sSystemModstamp
    String sManageableState
    String sSymbolTableId
    String sKey
    String sSymbolTableName
    String sNamespace
    String sParentClass
    Integer iColumn
    Integer iLine
    String sTableDeclarationName
    String sTableDeclarationType
    Integer iMetadataApiVersion
    String sMetadataStatus
    String sUrls
    String sFullName
    Integer i
    Integer iCount_i
    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}}/tooling/sobjects/:SOBJECT_API_NAME/: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)

    // {
    //   "attributes": {
    //     "type": "ApexClass",
    //     "url": "/services/data/v59.0/tooling/sobjects/ApexClass/01p4H00000A4kfqQAB"
    //   },
    //   "Id": "01p4H00000A4kfqQAB",
    //   "NamespacePrefix": "smon",
    //   "Name": "GenericEventPostMock",
    //   "ApiVersion": 59,
    //   "Status": "Active",
    //   "IsValid": false,
    //   "BodyCrc": -1,
    //   "Body": "/*\nThis file is generated and isn't the actual source code for this\nmanaged global class.\nThis read-only file shows the class's global constructors,\nmethods, variables, and properties.\nTo enable code to compile, all methods return null.\n*/\nglobal class GenericEventPostMock implements System.HttpCalloutMock {\n    global GenericEventPostMock(Integer statusCode) {\n\n    }\n    global System.HttpResponse respond(System.HttpRequest req) {\n        return null;\n    }\n}\n",
    //   "LengthWithoutComments": -1,
    //   "CreatedDate": "2023-11-20T08:03:40.000+0000",
    //   "CreatedById": "00558000000yFyDAAU",
    //   "LastModifiedDate": "2023-11-20T08:03:40.000+0000",
    //   "LastModifiedById": "00558000000yFyDAAU",
    //   "SystemModstamp": "2023-11-26T14:10:11.000+0000",
    //   "ManageableState": "installed",
    //   "SymbolTable": {
    //     "constructors": [
    //       {
    //         "annotations": [
    //         ],
    //         "location": {
    //           "column": 12,
    //           "line": 5
    //         },
    //         "modifiers": [
    //           "global"
    //         ],
    //         "name": "GenericEventPostMock",
    //         "parameters": [
    //           {
    //             "name": "statusCode",
    //             "type": "Integer"
    //           }
    //         ],
    //         "references": [
    //         ],
    //         "type": null
    //       }
    //     ],
    //     "externalReferences": [
    //     ],
    //     "id": "smon.GenericEventPostMock",
    //     "innerClasses": [
    //     ],
    //     "interfaces": [
    //       "System.HttpCalloutMock"
    //     ],
    //     "key": "smon.GenericEventPostMock",
    //     "methods": [
    //       {
    //         "annotations": [
    //         ],
    //         "location": {
    //           "column": 25,
    //           "line": 9
    //         },
    //         "modifiers": [
    //           "global"
    //         ],
    //         "name": "respond",
    //         "parameters": [
    //           {
    //             "name": "req",
    //             "type": "System.HttpRequest"
    //           }
    //         ],
    //         "references": [
    //         ],
    //         "returnType": "System.HttpResponse",
    //         "type": null
    //       }
    //     ],
    //     "name": "GenericEventPostMock",
    //     "namespace": "smon",
    //     "parentClass": "",
    //     "properties": [
    //     ],
    //     "tableDeclaration": {
    //       "annotations": [
    //         {
    //           "name": "IsTest"
    //         }
    //       ],
    //       "location": {
    //         "column": 14,
    //         "line": 2
    //       },
    //       "modifiers": [
    //         "testMethod",
    //         "global"
    //       ],
    //       "name": "GenericEventPostMock",
    //       "references": [
    //       ],
    //       "type": "smon.GenericEventPostMock"
    //     },
    //     "variables": [
    //     ]
    //   },
    //   "Metadata": {
    //     "apiVersion": 59,
    //     "packageVersions": [
    //     ],
    //     "status": "Active",
    //     "urls": null
    //   },
    //   "FullName": "smon__GenericEventPostMock"
    // }

    // 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 "attributes.type" To sV_Type
    Get ComStringOf Of hoJResp "attributes.url" To sV_Url
    Get ComStringOf Of hoJResp "Id" To sId
    Get ComStringOf Of hoJResp "NamespacePrefix" To sNamespacePrefix
    Get ComStringOf Of hoJResp "Name" To sName
    Get ComIntOf Of hoJResp "ApiVersion" To iApiVersion
    Get ComStringOf Of hoJResp "Status" To sStatus
    Get ComBoolOf Of hoJResp "IsValid" To iIsValid
    Get ComIntOf Of hoJResp "BodyCrc" To iBodyCrc
    Get ComStringOf Of hoJResp "Body" To sBody
    Get ComIntOf Of hoJResp "LengthWithoutComments" To iLengthWithoutComments
    Get ComStringOf Of hoJResp "CreatedDate" To sCreatedDate
    Get ComStringOf Of hoJResp "CreatedById" To sCreatedById
    Get ComStringOf Of hoJResp "LastModifiedDate" To sLastModifiedDate
    Get ComStringOf Of hoJResp "LastModifiedById" To sLastModifiedById
    Get ComStringOf Of hoJResp "SystemModstamp" To sSystemModstamp
    Get ComStringOf Of hoJResp "ManageableState" To sManageableState
    Get ComStringOf Of hoJResp "SymbolTable.id" To sSymbolTableId
    Get ComStringOf Of hoJResp "SymbolTable.key" To sKey
    Get ComStringOf Of hoJResp "SymbolTable.name" To sSymbolTableName
    Get ComStringOf Of hoJResp "SymbolTable.namespace" To sNamespace
    Get ComStringOf Of hoJResp "SymbolTable.parentClass" To sParentClass
    Get ComIntOf Of hoJResp "SymbolTable.tableDeclaration.location.column" To iColumn
    Get ComIntOf Of hoJResp "SymbolTable.tableDeclaration.location.line" To iLine
    Get ComStringOf Of hoJResp "SymbolTable.tableDeclaration.name" To sTableDeclarationName
    Get ComStringOf Of hoJResp "SymbolTable.tableDeclaration.type" To sTableDeclarationType
    Get ComIntOf Of hoJResp "Metadata.apiVersion" To iMetadataApiVersion
    Get ComStringOf Of hoJResp "Metadata.status" To sMetadataStatus
    Get ComStringOf Of hoJResp "Metadata.urls" To sUrls
    Get ComStringOf Of hoJResp "FullName" To sFullName
    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.constructors" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComIntOf Of hoJResp "SymbolTable.constructors[i].location.column" To iLocationColumn
        Get ComIntOf Of hoJResp "SymbolTable.constructors[i].location.line" To iLocationLine
        Get ComStringOf Of hoJResp "SymbolTable.constructors[i].name" To sName
        Get ComStringOf Of hoJResp "SymbolTable.constructors[i].type" To sV_type
        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.constructors[i].annotations" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.constructors[i].modifiers" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Get ComStringOf Of hoJResp "SymbolTable.constructors[i].modifiers[j]" To sStrVal
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.constructors[i].parameters" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Get ComStringOf Of hoJResp "SymbolTable.constructors[i].parameters[j].name" To sName
            Get ComStringOf Of hoJResp "SymbolTable.constructors[i].parameters[j].type" To sV_type
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.constructors[i].references" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Move (j + 1) To j
        Loop

        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.externalReferences" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.innerClasses" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.interfaces" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComStringOf Of hoJResp "SymbolTable.interfaces[i]" To sStrVal
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.methods" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComIntOf Of hoJResp "SymbolTable.methods[i].location.column" To iLocationColumn
        Get ComIntOf Of hoJResp "SymbolTable.methods[i].location.line" To iLocationLine
        Get ComStringOf Of hoJResp "SymbolTable.methods[i].name" To sName
        Get ComStringOf Of hoJResp "SymbolTable.methods[i].returnType" To sReturnType
        Get ComStringOf Of hoJResp "SymbolTable.methods[i].type" To sV_type
        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.methods[i].annotations" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.methods[i].modifiers" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Get ComStringOf Of hoJResp "SymbolTable.methods[i].modifiers[j]" To sStrVal
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.methods[i].parameters" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Get ComStringOf Of hoJResp "SymbolTable.methods[i].parameters[j].name" To sName
            Get ComStringOf Of hoJResp "SymbolTable.methods[i].parameters[j].type" To sV_type
            Move (j + 1) To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJResp "SymbolTable.methods[i].references" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJResp To j
            Move (j + 1) To j
        Loop

        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.properties" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.tableDeclaration.annotations" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComStringOf Of hoJResp "SymbolTable.tableDeclaration.annotations[i].name" To sName
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.tableDeclaration.modifiers" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComStringOf Of hoJResp "SymbolTable.tableDeclaration.modifiers[i]" To sStrVal
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.tableDeclaration.references" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "SymbolTable.variables" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop

    Move 0 To i
    Get ComSizeOfArray Of hoJResp "Metadata.packageVersions" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Move (i + 1) To i
    Loop



End_Procedure

Curl Command

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

Postman Collection Item JSON

{
  "name": "Access Records",
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/tooling/sobjects/:SOBJECT_API_NAME/:RECORD_ID",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "tooling",
        "sobjects",
        ":SOBJECT_API_NAME",
        ":RECORD_ID"
      ],
      "variable": [
        {
          "key": "SOBJECT_API_NAME",
          "value": ""
        },
        {
          "key": "RECORD_ID",
          "value": ""
        }
      ]
    }
  },
  "response": [
    {
      "name": "Access Records",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{_endpoint}}/services/data/v{{version}}/tooling/sobjects/:SOBJECT_API_NAME/:RECORD_ID",
          "host": [
            "{{_endpoint}}"
          ],
          "path": [
            "services",
            "data",
            "v{{version}}",
            "tooling",
            "sobjects",
            ":SOBJECT_API_NAME",
            ":RECORD_ID"
          ],
          "variable": [
            {
              "key": "SOBJECT_API_NAME",
              "value": "ApexClass"
            },
            {
              "key": "RECORD_ID",
              "value": "01p4H00000A4kfqQAB"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Date",
          "value": "Mon, 11 Dec 2023 10:38:26 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": "Sforce-Limit-Info",
          "value": "api-usage=308/15000"
        },
        {
          "key": "Last-Modified",
          "value": "Sun, 26 Nov 2023 14:10:11 GMT"
        },
        {
          "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    \"attributes\": {\n        \"type\": \"ApexClass\",\n        \"url\": \"/services/data/v59.0/tooling/sobjects/ApexClass/01p4H00000A4kfqQAB\"\n    },\n    \"Id\": \"01p4H00000A4kfqQAB\",\n    \"NamespacePrefix\": \"smon\",\n    \"Name\": \"GenericEventPostMock\",\n    \"ApiVersion\": 59,\n    \"Status\": \"Active\",\n    \"IsValid\": false,\n    \"BodyCrc\": -1,\n    \"Body\": \"/*\\nThis file is generated and isn't the actual source code for this\\nmanaged global class.\\nThis read-only file shows the class's global constructors,\\nmethods, variables, and properties.\\nTo enable code to compile, all methods return null.\\n*/\\nglobal class GenericEventPostMock implements System.HttpCalloutMock {\\n    global GenericEventPostMock(Integer statusCode) {\\n\\n    }\\n    global System.HttpResponse respond(System.HttpRequest req) {\\n        return null;\\n    }\\n}\\n\",\n    \"LengthWithoutComments\": -1,\n    \"CreatedDate\": \"2023-11-20T08:03:40.000+0000\",\n    \"CreatedById\": \"00558000000yFyDAAU\",\n    \"LastModifiedDate\": \"2023-11-20T08:03:40.000+0000\",\n    \"LastModifiedById\": \"00558000000yFyDAAU\",\n    \"SystemModstamp\": \"2023-11-26T14:10:11.000+0000\",\n    \"ManageableState\": \"installed\",\n    \"SymbolTable\": {\n        \"constructors\": [\n            {\n                \"annotations\": [],\n                \"location\": {\n                    \"column\": 12,\n                    \"line\": 5\n                },\n                \"modifiers\": [\n                    \"global\"\n                ],\n                \"name\": \"GenericEventPostMock\",\n                \"parameters\": [\n                    {\n                        \"name\": \"statusCode\",\n                        \"type\": \"Integer\"\n                    }\n                ],\n                \"references\": [],\n                \"type\": null\n            }\n        ],\n        \"externalReferences\": [],\n        \"id\": \"smon.GenericEventPostMock\",\n        \"innerClasses\": [],\n        \"interfaces\": [\n            \"System.HttpCalloutMock\"\n        ],\n        \"key\": \"smon.GenericEventPostMock\",\n        \"methods\": [\n            {\n                \"annotations\": [],\n                \"location\": {\n                    \"column\": 25,\n                    \"line\": 9\n                },\n                \"modifiers\": [\n                    \"global\"\n                ],\n                \"name\": \"respond\",\n                \"parameters\": [\n                    {\n                        \"name\": \"req\",\n                        \"type\": \"System.HttpRequest\"\n                    }\n                ],\n                \"references\": [],\n                \"returnType\": \"System.HttpResponse\",\n                \"type\": null\n            }\n        ],\n        \"name\": \"GenericEventPostMock\",\n        \"namespace\": \"smon\",\n        \"parentClass\": \"\",\n        \"properties\": [],\n        \"tableDeclaration\": {\n            \"annotations\": [\n                {\n                    \"name\": \"IsTest\"\n                }\n            ],\n            \"location\": {\n                \"column\": 14,\n                \"line\": 2\n            },\n            \"modifiers\": [\n                \"testMethod\",\n                \"global\"\n            ],\n            \"name\": \"GenericEventPostMock\",\n            \"references\": [],\n            \"type\": \"smon.GenericEventPostMock\"\n        },\n        \"variables\": []\n    },\n    \"Metadata\": {\n        \"apiVersion\": 59,\n        \"packageVersions\": [],\n        \"status\": \"Active\",\n        \"urls\": null\n    },\n    \"FullName\": \"smon__GenericEventPostMock\"\n}"
    }
  ]
}