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}}/tooling/sobjects/:SOBJECT_API_NAME/:RECORD_ID",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)
' {
' "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
v_Type = jResp.StringOf("attributes.type")
v_Url = jResp.StringOf("attributes.url")
Id = jResp.StringOf("Id")
NamespacePrefix = jResp.StringOf("NamespacePrefix")
Name = jResp.StringOf("Name")
ApiVersion = jResp.IntOf("ApiVersion")
Status = jResp.StringOf("Status")
IsValid = jResp.BoolOf("IsValid")
BodyCrc = jResp.IntOf("BodyCrc")
Body = jResp.StringOf("Body")
LengthWithoutComments = jResp.IntOf("LengthWithoutComments")
CreatedDate = jResp.StringOf("CreatedDate")
CreatedById = jResp.StringOf("CreatedById")
LastModifiedDate = jResp.StringOf("LastModifiedDate")
LastModifiedById = jResp.StringOf("LastModifiedById")
SystemModstamp = jResp.StringOf("SystemModstamp")
ManageableState = jResp.StringOf("ManageableState")
SymbolTableId = jResp.StringOf("SymbolTable.id")
Key = jResp.StringOf("SymbolTable.key")
SymbolTableName = jResp.StringOf("SymbolTable.name")
Namespace = jResp.StringOf("SymbolTable.namespace")
ParentClass = jResp.StringOf("SymbolTable.parentClass")
Column = jResp.IntOf("SymbolTable.tableDeclaration.location.column")
Line = jResp.IntOf("SymbolTable.tableDeclaration.location.line")
TableDeclarationName = jResp.StringOf("SymbolTable.tableDeclaration.name")
TableDeclarationType = jResp.StringOf("SymbolTable.tableDeclaration.type")
MetadataApiVersion = jResp.IntOf("Metadata.apiVersion")
MetadataStatus = jResp.StringOf("Metadata.status")
Urls = jResp.StringOf("Metadata.urls")
FullName = jResp.StringOf("FullName")
i = 0
count_i = jResp.SizeOfArray("SymbolTable.constructors")
Do While i < count_i
jResp.I = i
locationColumn = jResp.IntOf("SymbolTable.constructors[i].location.column")
locationLine = jResp.IntOf("SymbolTable.constructors[i].location.line")
name = jResp.StringOf("SymbolTable.constructors[i].name")
v_type = jResp.StringOf("SymbolTable.constructors[i].type")
j = 0
count_j = jResp.SizeOfArray("SymbolTable.constructors[i].annotations")
Do While j < count_j
jResp.J = j
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.constructors[i].modifiers")
Do While j < count_j
jResp.J = j
strVal = jResp.StringOf("SymbolTable.constructors[i].modifiers[j]")
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.constructors[i].parameters")
Do While j < count_j
jResp.J = j
name = jResp.StringOf("SymbolTable.constructors[i].parameters[j].name")
v_type = jResp.StringOf("SymbolTable.constructors[i].parameters[j].type")
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.constructors[i].references")
Do While j < count_j
jResp.J = j
j = j + 1
Loop
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.externalReferences")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.innerClasses")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.interfaces")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("SymbolTable.interfaces[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.methods")
Do While i < count_i
jResp.I = i
locationColumn = jResp.IntOf("SymbolTable.methods[i].location.column")
locationLine = jResp.IntOf("SymbolTable.methods[i].location.line")
name = jResp.StringOf("SymbolTable.methods[i].name")
returnType = jResp.StringOf("SymbolTable.methods[i].returnType")
v_type = jResp.StringOf("SymbolTable.methods[i].type")
j = 0
count_j = jResp.SizeOfArray("SymbolTable.methods[i].annotations")
Do While j < count_j
jResp.J = j
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.methods[i].modifiers")
Do While j < count_j
jResp.J = j
strVal = jResp.StringOf("SymbolTable.methods[i].modifiers[j]")
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.methods[i].parameters")
Do While j < count_j
jResp.J = j
name = jResp.StringOf("SymbolTable.methods[i].parameters[j].name")
v_type = jResp.StringOf("SymbolTable.methods[i].parameters[j].type")
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("SymbolTable.methods[i].references")
Do While j < count_j
jResp.J = j
j = j + 1
Loop
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.properties")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.tableDeclaration.annotations")
Do While i < count_i
jResp.I = i
name = jResp.StringOf("SymbolTable.tableDeclaration.annotations[i].name")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.tableDeclaration.modifiers")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("SymbolTable.tableDeclaration.modifiers[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.tableDeclaration.references")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("SymbolTable.variables")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("Metadata.packageVersions")
Do While i < count_i
jResp.I = i
i = i + 1
Loop
outFile.Close
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}"
}
]
}
