Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Sforce-Call-Options', 'client=postman'
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://domain.com/services/data', @sbResponseBody
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
PRINT 'Response status code = ' + @iTmp0
EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
END
GO
Curl Command
curl -X GET
-H "Content-Type: application/json"
-H "Sforce-Call-Options: client=postman"
https://domain.com/services/data
Postman Collection Item JSON
{
"name": "Versions",
"event": [
{
"listen": "prerequest",
"script": {
"exec": [
""
],
"type": "text/javascript"
}
}
],
"request": {
"auth": {
"type": "noauth"
},
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
},
{
"key": "Sforce-Call-Options",
"value": "client=postman",
"type": "text"
}
],
"url": {
"raw": "{{_endpoint}}/services/data",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data"
]
},
"description": "Lists summary information about each Salesforce version currently available, including the version, label, and a link to each version's root."
},
"response": [
{
"name": "Versions",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "{{_endpoint}}/services/data",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data"
]
}
},
"_postman_previewlanguage": "json",
"header": null,
"cookie": [
],
"body": "[\n {\n \"label\": \"Spring '11\",\n \"url\": \"/services/data/v21.0\",\n \"version\": \"21.0\"\n },\n {\n \"label\": \"Summer '11\",\n \"url\": \"/services/data/v22.0\",\n \"version\": \"22.0\"\n },\n {\n \"label\": \"Winter '12\",\n \"url\": \"/services/data/v23.0\",\n \"version\": \"23.0\"\n },\n {\n \"label\": \"Spring '12\",\n \"url\": \"/services/data/v24.0\",\n \"version\": \"24.0\"\n },\n {\n \"label\": \"Summer '12\",\n \"url\": \"/services/data/v25.0\",\n \"version\": \"25.0\"\n },\n {\n \"label\": \"Winter '13\",\n \"url\": \"/services/data/v26.0\",\n \"version\": \"26.0\"\n },\n {\n \"label\": \"Spring '13\",\n \"url\": \"/services/data/v27.0\",\n \"version\": \"27.0\"\n },\n {\n \"label\": \"Summer '13\",\n \"url\": \"/services/data/v28.0\",\n \"version\": \"28.0\"\n },\n {\n \"label\": \"Winter '14\",\n \"url\": \"/services/data/v29.0\",\n \"version\": \"29.0\"\n },\n {\n \"label\": \"Spring '14\",\n \"url\": \"/services/data/v30.0\",\n \"version\": \"30.0\"\n },\n {\n \"label\": \"Summer '14\",\n \"url\": \"/services/data/v31.0\",\n \"version\": \"31.0\"\n },\n {\n \"label\": \"Winter '15\",\n \"url\": \"/services/data/v32.0\",\n \"version\": \"32.0\"\n },\n {\n \"label\": \"Spring '15\",\n \"url\": \"/services/data/v33.0\",\n \"version\": \"33.0\"\n },\n {\n \"label\": \"Summer '15\",\n \"url\": \"/services/data/v34.0\",\n \"version\": \"34.0\"\n },\n {\n \"label\": \"Winter '16\",\n \"url\": \"/services/data/v35.0\",\n \"version\": \"35.0\"\n },\n {\n \"label\": \"Spring '16\",\n \"url\": \"/services/data/v36.0\",\n \"version\": \"36.0\"\n },\n {\n \"label\": \"Summer '16\",\n \"url\": \"/services/data/v37.0\",\n \"version\": \"37.0\"\n },\n {\n \"label\": \"Winter '17\",\n \"url\": \"/services/data/v38.0\",\n \"version\": \"38.0\"\n },\n {\n \"label\": \"Spring '17\",\n \"url\": \"/services/data/v39.0\",\n \"version\": \"39.0\"\n },\n {\n \"label\": \"Summer '17\",\n \"url\": \"/services/data/v40.0\",\n \"version\": \"40.0\"\n },\n {\n \"label\": \"Winter '18\",\n \"url\": \"/services/data/v41.0\",\n \"version\": \"41.0\"\n },\n {\n \"label\": \"Spring ’18\",\n \"url\": \"/services/data/v42.0\",\n \"version\": \"42.0\"\n },\n {\n \"label\": \"Summer '18\",\n \"url\": \"/services/data/v43.0\",\n \"version\": \"43.0\"\n },\n {\n \"label\": \"Winter '19\",\n \"url\": \"/services/data/v44.0\",\n \"version\": \"44.0\"\n },\n {\n \"label\": \"Spring '19\",\n \"url\": \"/services/data/v45.0\",\n \"version\": \"45.0\"\n },\n {\n \"label\": \"Summer '19\",\n \"url\": \"/services/data/v46.0\",\n \"version\": \"46.0\"\n },\n {\n \"label\": \"Winter '20\",\n \"url\": \"/services/data/v47.0\",\n \"version\": \"47.0\"\n },\n {\n \"label\": \"Spring '20\",\n \"url\": \"/services/data/v48.0\",\n \"version\": \"48.0\"\n },\n {\n \"label\": \"Summer '20\",\n \"url\": \"/services/data/v49.0\",\n \"version\": \"49.0\"\n },\n {\n \"label\": \"Winter '21\",\n \"url\": \"/services/data/v50.0\",\n \"version\": \"50.0\"\n },\n {\n \"label\": \"Spring '21\",\n \"url\": \"/services/data/v51.0\",\n \"version\": \"51.0\"\n },\n {\n \"label\": \"Summer '21\",\n \"url\": \"/services/data/v52.0\",\n \"version\": \"52.0\"\n },\n {\n \"label\": \"Winter '22\",\n \"url\": \"/services/data/v53.0\",\n \"version\": \"53.0\"\n }\n]"
}
]
}
