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
-- 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, 'API-Key', '{{API_KEY}}'
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://api.shipengine.com/v1/carriers/se-963358/packages', @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
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "packages": [
-- {
-- "package_id": null,
-- "package_code": "flat_rate_envelope",
-- "name": "Flat Rate Envelope",
-- "description": "USPS flat rate envelope. A special cardboard envelope provided by the USPS that clearly indicates \"Flat Rate\"."
-- },
-- {
-- "package_id": null,
-- "package_code": "flat_rate_legal_envelope",
-- "name": "Flat Rate Legal Envelope",
-- "description": "Flat Rate Legal Envelope"
-- },
-- {
-- "package_id": null,
-- "package_code": "flat_rate_padded_envelope",
-- "name": "Flat Rate Padded Envelope",
-- "description": "Flat Rate Padded Envelope"
-- },
-- {
-- "package_id": null,
-- "package_code": "large_envelope_or_flat",
-- "name": "Large Envelope or Flat",
-- "description": "Large envelope or flat. Has one dimension that is between 11 1/2\" and 15\" long, 6 1/18\" and 12\" high, or 1/4\" and 3/4\" thick."
-- },
-- {
-- "package_id": null,
-- "package_code": "large_flat_rate_box",
-- "name": "Large Flat Rate Box",
-- "description": "Large Flat Rate Box"
-- },
-- {
-- "package_id": null,
-- "package_code": "large_package",
-- "name": "Large Package (any side > 12\")",
-- "description": "Large package. Longest side plus the distance around the thickest part is over 84\" and less than or equal to 108\"."
-- },
-- {
-- "package_id": null,
-- "package_code": "letter",
-- "name": "Letter",
-- "description": "Letter"
-- },
-- {
-- "package_id": null,
-- "package_code": "medium_flat_rate_box",
-- "name": "Medium Flat Rate Box",
-- "description": "USPS flat rate box. A special 11\" x 8 1/2\" x 5 1/2\" or 14\" x 3.5\" x 12\" USPS box that clearly indicates \"Flat Rate Box\""
-- },
-- {
-- "package_id": null,
-- "package_code": "package",
-- "name": "Package",
-- "description": "Package. Longest side plus the distance around the thickest part is less than or equal to 84\""
-- },
-- {
-- "package_id": null,
-- "package_code": "regional_rate_box_a",
-- "name": "Regional Rate Box A",
-- "description": "Regional Rate Box A"
-- },
-- {
-- "package_id": null,
-- "package_code": "regional_rate_box_b",
-- "name": "Regional Rate Box B",
-- "description": "Regional Rate Box B"
-- },
-- {
-- "package_id": null,
-- "package_code": "small_flat_rate_box",
-- "name": "Small Flat Rate Box",
-- "description": "Small Flat Rate Box"
-- },
-- {
-- "package_id": null,
-- "package_code": "thick_envelope",
-- "name": "Thick Envelope",
-- "description": "Thick envelope. Envelopes or flats greater than 3/4\" at the thickest point."
-- }
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @package_id nvarchar(4000)
DECLARE @package_code nvarchar(4000)
DECLARE @name nvarchar(4000)
DECLARE @description nvarchar(4000)
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'packages'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @package_id OUT, 'packages[i].package_id'
EXEC sp_OAMethod @jResp, 'StringOf', @package_code OUT, 'packages[i].package_code'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'packages[i].name'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'packages[i].description'
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -X GET
-H "API-Key: {{API_KEY}}"
https://api.shipengine.com/v1/carriers/se-963358/packages
Postman Collection Item JSON
{
"name": "List a carrier's packaging",
"event": [
{
"listen": "test",
"script": {
"exec": [
"let response = pm.response.json();",
"",
"if (response.packages.length > 0) {",
" const template = `",
" <link rel=\"stylesheet\" href=\"https://cdnjs.cloudflare.com/ajax/libs/meyer-reset/2.0/reset.min.css\">",
" <link rel=\"stylesheet\" href=\"https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css\">",
"",
" <h1>Package Types</h1>",
" <table class=\"table\">",
" <thead class=\"thead-dark\">",
" <tr>",
" <th>Package</th>",
" <th>Code</th>",
" <th>Description</th>",
" </tr>",
" </thead>",
" <tbody>",
" {{#each packages}}",
" <tr>",
" <td>{{name}}</td>",
" <td>",
" <samp>{{package_code}}</samp>",
" </td>",
" <td>{{description}}</td>",
" </tr>",
" {{/each}}",
" </tbody>",
" </table>",
" `;",
"",
" pm.visualizer.set(template, response);",
"}"
],
"type": "text/javascript"
}
}
],
"request": {
"method": "GET",
"header": [
],
"url": {
"raw": "https://api.shipengine.com/v1/carriers/{{stamps_com}}/packages",
"protocol": "https",
"host": [
"api",
"shipengine",
"com"
],
"path": [
"v1",
"carriers",
"{{stamps_com}}",
"packages"
]
},
"description": "Most carriers have several different types of packaging, and which type you use can affect the cost of shipping a package. This request shows you how to list the packaging that a specific carrier offers."
},
"response": [
{
"name": "List a carrier's packaging",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "https://api.shipengine.com/v1/carriers/{{stamps_com}}/packages",
"protocol": "https",
"host": [
"api",
"shipengine",
"com"
],
"path": [
"v1",
"carriers",
"{{stamps_com}}",
"packages"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Mon, 16 Sep 2019 20:59:33 GMT"
},
{
"key": "Content-Type",
"value": "application/json; charset=utf-8"
},
{
"key": "Content-Length",
"value": "2749"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "Access-Control-Allow-Origin",
"value": "https://www.shipengine.com"
},
{
"key": "Vary",
"value": "Origin"
},
{
"key": "server",
"value": "Microsoft-IIS/8.0"
},
{
"key": "x-newrelic-app-data",
"value": "PxQGVFZXCgITVVZbAwMCV1YGFB9AMQYAZBBZDEtZV0ZaCldOZgRRIzR/GCIHEUpaVRYSTXtYRBI0UFVYAwEGERJOCEwICAQLC1IOTQFPA1BWBw5WVE8VAhxGViB1Ag5RU3QGcFRTWld2VBpOXllYQVY4"
},
{
"key": "x-powered-by",
"value": "ASP.NET"
},
{
"key": "x-shipengine-environment",
"value": "j"
},
{
"key": "x-shipengine-requestid",
"value": "ed9ca71b-b641-44b9-a8a5-d4d209d52660"
},
{
"key": "x-shipengine-server",
"value": "SS-J-WEB03"
}
],
"cookie": [
],
"body": "{\n \"packages\": [\n {\n \"package_id\": null,\n \"package_code\": \"flat_rate_envelope\",\n \"name\": \"Flat Rate Envelope\",\n \"description\": \"USPS flat rate envelope. A special cardboard envelope provided by the USPS that clearly indicates \\\"Flat Rate\\\".\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"flat_rate_legal_envelope\",\n \"name\": \"Flat Rate Legal Envelope\",\n \"description\": \"Flat Rate Legal Envelope\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"flat_rate_padded_envelope\",\n \"name\": \"Flat Rate Padded Envelope\",\n \"description\": \"Flat Rate Padded Envelope\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"large_envelope_or_flat\",\n \"name\": \"Large Envelope or Flat\",\n \"description\": \"Large envelope or flat. Has one dimension that is between 11 1/2\\\" and 15\\\" long, 6 1/18\\\" and 12\\\" high, or 1/4\\\" and 3/4\\\" thick.\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"large_flat_rate_box\",\n \"name\": \"Large Flat Rate Box\",\n \"description\": \"Large Flat Rate Box\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"large_package\",\n \"name\": \"Large Package (any side > 12\\\")\",\n \"description\": \"Large package. Longest side plus the distance around the thickest part is over 84\\\" and less than or equal to 108\\\".\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"letter\",\n \"name\": \"Letter\",\n \"description\": \"Letter\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"medium_flat_rate_box\",\n \"name\": \"Medium Flat Rate Box\",\n \"description\": \"USPS flat rate box. A special 11\\\" x 8 1/2\\\" x 5 1/2\\\" or 14\\\" x 3.5\\\" x 12\\\" USPS box that clearly indicates \\\"Flat Rate Box\\\"\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"package\",\n \"name\": \"Package\",\n \"description\": \"Package. Longest side plus the distance around the thickest part is less than or equal to 84\\\"\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"regional_rate_box_a\",\n \"name\": \"Regional Rate Box A\",\n \"description\": \"Regional Rate Box A\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"regional_rate_box_b\",\n \"name\": \"Regional Rate Box B\",\n \"description\": \"Regional Rate Box B\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"small_flat_rate_box\",\n \"name\": \"Small Flat Rate Box\",\n \"description\": \"Small Flat Rate Box\"\n },\n {\n \"package_id\": null,\n \"package_code\": \"thick_envelope\",\n \"name\": \"Thick Envelope\",\n \"description\": \"Thick envelope. Envelopes or flats greater than 3/4\\\" at the thickest point.\"\n }\n ]\n}"
}
]
}
