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
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OASetProperty @http, 'BasicAuth', 1
EXEC sp_OASetProperty @http, 'Login', '<Basic Auth Username>'
EXEC sp_OASetProperty @http, 'Password', '<Basic Auth Password>'
DECLARE @queryParams int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'trackingView', 'all-checkpoints'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'levelOfDetail', 'all'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Webstore-Platform-Name', ''
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept-Language', 'eng'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Shipping-System-Platform-Name', ''
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Message-Reference', 'd0e7832e-5c98-11ea-bc55-0242ac13'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Plugin-Version', ''
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Plugin-Name', ''
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Shipping-System-Platform-Version', ''
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Message-Reference-Date', 'Wed, 21 Oct 2015 07:28:00 GMT'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Webstore-Platform-Version', ''
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://api-mock.dhl.com/mydhlapi/shipments/:shipmentTrackingNumber/tracking', @queryParams
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
RETURN
END
DECLARE @sbResponseBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.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 @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "shipments": [
-- {
-- "events": [
-- {
-- "date": "2020-06-10",
-- "time": "13:06:00",
-- "typeCode": "PU",
-- "description": "Shipment picked up",
-- "serviceArea": [
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- },
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- }
-- ],
-- "signedBy": "Mr.Grey"
-- },
-- {
-- "date": "2020-06-10",
-- "time": "13:06:00",
-- "typeCode": "PU",
-- "description": "Shipment picked up",
-- "serviceArea": [
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- },
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- }
-- ],
-- "signedBy": "Mr.Grey"
-- }
-- ],
-- "shipmentTrackingNumber": "1234567890",
-- "status": "Success",
-- "shipmentTimestamp": "2020-05-14T18:00:31",
-- "productCode": "N",
-- "description": "Shipment Description",
-- "shipperDetails": {
-- "name": "SABO SKIRT",
-- "postalAddress": {
-- "cityName": "Brno",
-- "countyName": "Moravia",
-- "postalCode": "55500",
-- "provinceCode": "CZ",
-- "countryCode": "CZ"
-- },
-- "serviceArea": [
-- {
-- "code": "ABC",
-- "description": "Alpha Beta Area",
-- "outboundSortCode": "ullamco Duis"
-- },
-- {
-- "code": "ABC",
-- "description": "Alpha Beta Area",
-- "outboundSortCode": "sunt eu"
-- }
-- ],
-- "accountNumber": "ipsum sed officia"
-- },
-- "receiverDetails": {
-- "name": "SABO SKIRT",
-- "postalAddress": {
-- "cityName": "Bratislava",
-- "countyName": "Slovakia",
-- "postalCode": "77777",
-- "provinceCode": "SK",
-- "countryCode": "SK"
-- },
-- "serviceArea": [
-- {
-- "code": "BSA",
-- "description": "BSA Area",
-- "facilityCode": "facil area",
-- "inboundSortCode": "Dui"
-- },
-- {
-- "code": "BSA",
-- "description": "BSA Area",
-- "facilityCode": "facil area",
-- "inboundSortCode": "velit"
-- }
-- ]
-- },
-- "totalWeight": 10,
-- "unitOfMeasurements": "metric",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ],
-- "numberOfPieces": 1,
-- "pieces": [
-- {
-- "events": [
-- {
-- "date": "labore sit exercitation",
-- "time": "dolore enim",
-- "typeCode": "Excepteur tempor enim paria",
-- "description": "cupidatat commodo in nostrud",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "magna Excepteur"
-- },
-- {
-- "date": "aute nulla a",
-- "time": "mollit",
-- "typeCode": "id laborum ad sit",
-- "description": "proident Ut i",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "in eu veniam"
-- }
-- ],
-- "number": 1,
-- "typeCode": "ut veniam aliqua",
-- "shipmentTrackingNumber": "velit ex ullamco",
-- "trackingNumber": "nulla dolore nisi minim ea",
-- "description": "aliqua aliquip sed in",
-- "weight": 22.5,
-- "dimensionalWeight": 22.5,
-- "actualWeight": 22.5,
-- "dimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "actualDimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "unitOfMeasurements": "est ea dolore sunt",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ]
-- },
-- {
-- "events": [
-- {
-- "date": "Ut sit exercitation et",
-- "time": "ut enim s",
-- "typeCode": "e",
-- "description": "in aliquip qui id",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "ut sit aliquip veniam"
-- },
-- {
-- "date": "ex adipisicing laborum in",
-- "time": "ut tempor aliquip occaecat",
-- "typeCode": "ad",
-- "description": "irure sed aute",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "sint laboris"
-- }
-- ],
-- "number": 1,
-- "typeCode": "amet ullamco eiusmod est in",
-- "shipmentTrackingNumber": "do magna laboris ad",
-- "trackingNumber": "dolor incididunt ad proident",
-- "description": "exercitation in dolor",
-- "weight": 22.5,
-- "dimensionalWeight": 22.5,
-- "actualWeight": 22.5,
-- "dimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "actualDimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "unitOfMeasurements": "laboris",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ]
-- }
-- ],
-- "estimatedDeliveryDate": "2020-06-12",
-- "childrenShipmentIdentificationNumbers": [
-- "1234567890",
-- "1234567890"
-- ]
-- },
-- {
-- "events": [
-- {
-- "date": "2020-06-10",
-- "time": "13:06:00",
-- "typeCode": "PU",
-- "description": "Shipment picked up",
-- "serviceArea": [
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- },
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- }
-- ],
-- "signedBy": "Mr.Grey"
-- },
-- {
-- "date": "2020-06-10",
-- "time": "13:06:00",
-- "typeCode": "PU",
-- "description": "Shipment picked up",
-- "serviceArea": [
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- },
-- {
-- "code": "BNE",
-- "description": "Brisbane-AU"
-- }
-- ],
-- "signedBy": "Mr.Grey"
-- }
-- ],
-- "shipmentTrackingNumber": "1234567890",
-- "status": "Success",
-- "shipmentTimestamp": "2020-05-14T18:00:31",
-- "productCode": "N",
-- "description": "Shipment Description",
-- "shipperDetails": {
-- "name": "SABO SKIRT",
-- "postalAddress": {
-- "cityName": "Brno",
-- "countyName": "Moravia",
-- "postalCode": "55500",
-- "provinceCode": "CZ",
-- "countryCode": "CZ"
-- },
-- "serviceArea": [
-- {
-- "code": "ABC",
-- "description": "Alpha Beta Area",
-- "outboundSortCode": "ut enim esse in incididunt"
-- },
-- {
-- "code": "ABC",
-- "description": "Alpha Beta Area",
-- "outboundSortCode": "anim pariatur adipisicing ipsum"
-- }
-- ],
-- "accountNumber": "nostrud"
-- },
-- "receiverDetails": {
-- "name": "SABO SKIRT",
-- "postalAddress": {
-- "cityName": "Bratislava",
-- "countyName": "Slovakia",
-- "postalCode": "77777",
-- "provinceCode": "SK",
-- "countryCode": "SK"
-- },
-- "serviceArea": [
-- {
-- "code": "BSA",
-- "description": "BSA Area",
-- "facilityCode": "facil area",
-- "inboundSortCode": "magna sit"
-- },
-- {
-- "code": "BSA",
-- "description": "BSA Area",
-- "facilityCode": "facil area",
-- "inboundSortCode": "ut nulla in occaecat"
-- }
-- ]
-- },
-- "totalWeight": 10,
-- "unitOfMeasurements": "metric",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ],
-- "numberOfPieces": 1,
-- "pieces": [
-- {
-- "events": [
-- {
-- "date": "enim in",
-- "time": "anim nostrud ad molli",
-- "typeCode": "dolor consectetur",
-- "description": "cillum reprehenderit incididunt es",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "cupidatat esse quis Excepteur"
-- },
-- {
-- "date": "",
-- "time": "cupidatat",
-- "typeCode": "ame",
-- "description": "dolore nulla ",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "nulla sint id sed"
-- }
-- ],
-- "number": 1,
-- "typeCode": "ea dolore dolore occaecat",
-- "shipmentTrackingNumber": "do aliqua sit",
-- "trackingNumber": "adipisicing veniam in",
-- "description": "commodo fugiat",
-- "weight": 22.5,
-- "dimensionalWeight": 22.5,
-- "actualWeight": 22.5,
-- "dimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "actualDimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "unitOfMeasurements": "do esse fugiat",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ]
-- },
-- {
-- "events": [
-- {
-- "date": "esse dolore",
-- "time": "tempor deserunt proident",
-- "typeCode": "sit do",
-- "description": "ipsum commodo sunt officia",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "irure culpa"
-- },
-- {
-- "date": "Duis amet nostrud",
-- "time": "sit eu id",
-- "typeCode": "Lorem ad",
-- "description": "amet",
-- "serviceArea": [
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- {
-- "code": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "description": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- }
-- ],
-- "signedBy": "minim occaec"
-- }
-- ],
-- "number": 1,
-- "typeCode": "dolor Duis reprehenderit",
-- "shipmentTrackingNumber": "incididunt ",
-- "trackingNumber": "cillum minim cupidatat",
-- "description": "sed voluptate",
-- "weight": 22.5,
-- "dimensionalWeight": 22.5,
-- "actualWeight": 22.5,
-- "dimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "actualDimensions": {
-- "length": 15,
-- "width": 15,
-- "height": 40
-- },
-- "unitOfMeasurements": "consequat exercitation nulla",
-- "shipperReferences": [
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- },
-- {
-- "value": "Customer reference",
-- "typeCode": "CU"
-- }
-- ]
-- }
-- ],
-- "estimatedDeliveryDate": "2020-06-12",
-- "childrenShipmentIdentificationNumbers": [
-- "1234567890",
-- "1234567890"
-- ]
-- }
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @shipmentTrackingNumber nvarchar(4000)
DECLARE @status nvarchar(4000)
DECLARE @shipmentTimestamp nvarchar(4000)
DECLARE @productCode nvarchar(4000)
DECLARE @description nvarchar(4000)
DECLARE @Name nvarchar(4000)
DECLARE @CityName nvarchar(4000)
DECLARE @CountyName nvarchar(4000)
DECLARE @PostalCode nvarchar(4000)
DECLARE @ProvinceCode nvarchar(4000)
DECLARE @CountryCode nvarchar(4000)
DECLARE @AccountNumber nvarchar(4000)
DECLARE @receiverDetailsName nvarchar(4000)
DECLARE @PostalAddressCityName nvarchar(4000)
DECLARE @PostalAddressCountyName nvarchar(4000)
DECLARE @PostalAddressPostalCode nvarchar(4000)
DECLARE @PostalAddressProvinceCode nvarchar(4000)
DECLARE @PostalAddressCountryCode nvarchar(4000)
DECLARE @totalWeight int
DECLARE @unitOfMeasurements nvarchar(4000)
DECLARE @numberOfPieces int
DECLARE @estimatedDeliveryDate nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @date nvarchar(4000)
DECLARE @time nvarchar(4000)
DECLARE @typeCode nvarchar(4000)
DECLARE @signedBy nvarchar(4000)
DECLARE @k int
DECLARE @count_k int
DECLARE @code nvarchar(4000)
DECLARE @outboundSortCode nvarchar(4000)
DECLARE @facilityCode nvarchar(4000)
DECLARE @inboundSortCode nvarchar(4000)
DECLARE @value nvarchar(4000)
DECLARE @v_number int
DECLARE @trackingNumber nvarchar(4000)
DECLARE @weight nvarchar(4000)
DECLARE @dimensionalWeight nvarchar(4000)
DECLARE @actualWeight nvarchar(4000)
DECLARE @Length int
DECLARE @Width int
DECLARE @Height int
DECLARE @actualDimensionsLength int
DECLARE @actualDimensionsWidth int
DECLARE @actualDimensionsHeight int
DECLARE @json1 int
DECLARE @i1 int
DECLARE @count_i1 int
DECLARE @Value nvarchar(4000)
DECLARE @descriptionValue nvarchar(4000)
DECLARE @strVal nvarchar(4000)
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'shipments'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @shipmentTrackingNumber OUT, 'shipments[i].shipmentTrackingNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @status OUT, 'shipments[i].status'
EXEC sp_OAMethod @jResp, 'StringOf', @shipmentTimestamp OUT, 'shipments[i].shipmentTimestamp'
EXEC sp_OAMethod @jResp, 'StringOf', @productCode OUT, 'shipments[i].productCode'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].description'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'shipments[i].shipperDetails.name'
EXEC sp_OAMethod @jResp, 'StringOf', @CityName OUT, 'shipments[i].shipperDetails.postalAddress.cityName'
EXEC sp_OAMethod @jResp, 'StringOf', @CountyName OUT, 'shipments[i].shipperDetails.postalAddress.countyName'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalCode OUT, 'shipments[i].shipperDetails.postalAddress.postalCode'
EXEC sp_OAMethod @jResp, 'StringOf', @ProvinceCode OUT, 'shipments[i].shipperDetails.postalAddress.provinceCode'
EXEC sp_OAMethod @jResp, 'StringOf', @CountryCode OUT, 'shipments[i].shipperDetails.postalAddress.countryCode'
EXEC sp_OAMethod @jResp, 'StringOf', @AccountNumber OUT, 'shipments[i].shipperDetails.accountNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @receiverDetailsName OUT, 'shipments[i].receiverDetails.name'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalAddressCityName OUT, 'shipments[i].receiverDetails.postalAddress.cityName'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalAddressCountyName OUT, 'shipments[i].receiverDetails.postalAddress.countyName'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalAddressPostalCode OUT, 'shipments[i].receiverDetails.postalAddress.postalCode'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalAddressProvinceCode OUT, 'shipments[i].receiverDetails.postalAddress.provinceCode'
EXEC sp_OAMethod @jResp, 'StringOf', @PostalAddressCountryCode OUT, 'shipments[i].receiverDetails.postalAddress.countryCode'
EXEC sp_OAMethod @jResp, 'IntOf', @totalWeight OUT, 'shipments[i].totalWeight'
EXEC sp_OAMethod @jResp, 'StringOf', @unitOfMeasurements OUT, 'shipments[i].unitOfMeasurements'
EXEC sp_OAMethod @jResp, 'IntOf', @numberOfPieces OUT, 'shipments[i].numberOfPieces'
EXEC sp_OAMethod @jResp, 'StringOf', @estimatedDeliveryDate OUT, 'shipments[i].estimatedDeliveryDate'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].events'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @date OUT, 'shipments[i].events[j].date'
EXEC sp_OAMethod @jResp, 'StringOf', @time OUT, 'shipments[i].events[j].time'
EXEC sp_OAMethod @jResp, 'StringOf', @typeCode OUT, 'shipments[i].events[j].typeCode'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].events[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @signedBy OUT, 'shipments[i].events[j].signedBy'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'shipments[i].events[j].serviceArea'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @code OUT, 'shipments[i].events[j].serviceArea[k].code'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].events[j].serviceArea[k].description'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].shipperDetails.serviceArea'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @code OUT, 'shipments[i].shipperDetails.serviceArea[j].code'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].shipperDetails.serviceArea[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @outboundSortCode OUT, 'shipments[i].shipperDetails.serviceArea[j].outboundSortCode'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].receiverDetails.serviceArea'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @code OUT, 'shipments[i].receiverDetails.serviceArea[j].code'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].receiverDetails.serviceArea[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @facilityCode OUT, 'shipments[i].receiverDetails.serviceArea[j].facilityCode'
EXEC sp_OAMethod @jResp, 'StringOf', @inboundSortCode OUT, 'shipments[i].receiverDetails.serviceArea[j].inboundSortCode'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].shipperReferences'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'shipments[i].shipperReferences[j].value'
EXEC sp_OAMethod @jResp, 'StringOf', @typeCode OUT, 'shipments[i].shipperReferences[j].typeCode'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].pieces'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @v_number OUT, 'shipments[i].pieces[j].number'
EXEC sp_OAMethod @jResp, 'StringOf', @typeCode OUT, 'shipments[i].pieces[j].typeCode'
EXEC sp_OAMethod @jResp, 'StringOf', @shipmentTrackingNumber OUT, 'shipments[i].pieces[j].shipmentTrackingNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @trackingNumber OUT, 'shipments[i].pieces[j].trackingNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].pieces[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @weight OUT, 'shipments[i].pieces[j].weight'
EXEC sp_OAMethod @jResp, 'StringOf', @dimensionalWeight OUT, 'shipments[i].pieces[j].dimensionalWeight'
EXEC sp_OAMethod @jResp, 'StringOf', @actualWeight OUT, 'shipments[i].pieces[j].actualWeight'
EXEC sp_OAMethod @jResp, 'IntOf', @Length OUT, 'shipments[i].pieces[j].dimensions.length'
EXEC sp_OAMethod @jResp, 'IntOf', @Width OUT, 'shipments[i].pieces[j].dimensions.width'
EXEC sp_OAMethod @jResp, 'IntOf', @Height OUT, 'shipments[i].pieces[j].dimensions.height'
EXEC sp_OAMethod @jResp, 'IntOf', @actualDimensionsLength OUT, 'shipments[i].pieces[j].actualDimensions.length'
EXEC sp_OAMethod @jResp, 'IntOf', @actualDimensionsWidth OUT, 'shipments[i].pieces[j].actualDimensions.width'
EXEC sp_OAMethod @jResp, 'IntOf', @actualDimensionsHeight OUT, 'shipments[i].pieces[j].actualDimensions.height'
EXEC sp_OAMethod @jResp, 'StringOf', @unitOfMeasurements OUT, 'shipments[i].pieces[j].unitOfMeasurements'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'shipments[i].pieces[j].events'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @date OUT, 'shipments[i].pieces[j].events[k].date'
EXEC sp_OAMethod @jResp, 'StringOf', @time OUT, 'shipments[i].pieces[j].events[k].time'
EXEC sp_OAMethod @jResp, 'StringOf', @typeCode OUT, 'shipments[i].pieces[j].events[k].typeCode'
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'shipments[i].pieces[j].events[k].description'
EXEC sp_OAMethod @jResp, 'StringOf', @signedBy OUT, 'shipments[i].pieces[j].events[k].signedBy'
EXEC sp_OAMethod @jResp, 'ObjectOf', @json1 OUT, 'shipments[i].pieces[j].events[k]'
SELECT @i1 = 0
EXEC sp_OAMethod @json1, 'SizeOfArray', @count_i1 OUT, 'serviceArea'
WHILE @i1 < @count_i1
BEGIN
EXEC sp_OASetProperty @json1, 'I', @i1
EXEC sp_OAMethod @json1, 'StringOf', @Value OUT, 'serviceArea[i].code.value'
EXEC sp_OAMethod @json1, 'StringOf', @descriptionValue OUT, 'serviceArea[i].description.value'
SELECT @i1 = @i1 + 1
END
EXEC @hr = sp_OADestroy @json1
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'shipments[i].pieces[j].shipperReferences'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'shipments[i].pieces[j].shipperReferences[k].value'
EXEC sp_OAMethod @jResp, 'StringOf', @typeCode OUT, 'shipments[i].pieces[j].shipperReferences[k].typeCode'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'shipments[i].childrenShipmentIdentificationNumbers'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'shipments[i].childrenShipmentIdentificationNumbers[j]'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -G -d "trackingView=all-checkpoints"
-d "levelOfDetail=all"
-u '<Basic Auth Username>:<Basic Auth Password>'
-H "Message-Reference: d0e7832e-5c98-11ea-bc55-0242ac13"
-H "Message-Reference-Date: Wed, 21 Oct 2015 07:28:00 GMT"
-H "Accept-Language: eng"
-H "Plugin-Name: "
-H "Plugin-Version: "
-H "Shipping-System-Platform-Name: "
-H "Shipping-System-Platform-Version: "
-H "Webstore-Platform-Name: "
-H "Webstore-Platform-Version: "
-H "Accept: application/json"
https://api-mock.dhl.com/mydhlapi/shipments/:shipmentTrackingNumber/tracking
Postman Collection Item JSON
{
"name": "Track a single DHL Express Shipment",
"request": {
"method": "GET",
"header": [
{
"description": "Please provide message reference\n",
"key": "Message-Reference",
"value": "d0e7832e-5c98-11ea-bc55-0242ac13"
},
{
"description": "Optional reference date in the HTTP-date format https://tools.ietf.org/html/rfc7231#section-7.1.1.2",
"key": "Message-Reference-Date",
"value": "Wed, 21 Oct 2015 07:28:00 GMT"
},
{
"key": "Accept-Language",
"value": "eng"
},
{
"description": "Please provide name of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Name",
"value": " "
},
{
"description": "Please provide version of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Version",
"value": " "
},
{
"description": "Please provide name of the shipping platform(applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the shipping platform (applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Version",
"value": " "
},
{
"description": "Please provide name of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Version",
"value": " "
},
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/shipments/:shipmentTrackingNumber/tracking?trackingView=all-checkpoints&levelOfDetail=all",
"host": [
"{{baseUrl}}"
],
"path": [
"shipments",
":shipmentTrackingNumber",
"tracking"
],
"query": [
{
"key": "trackingView",
"value": "all-checkpoints"
},
{
"key": "levelOfDetail",
"value": "all"
}
],
"variable": [
{
"key": "shipmentTrackingNumber",
"value": "dolor veniam officia non",
"description": "(Required) DHL Express shipment identification number"
}
]
},
"description": "The Tracking service retrieves tracking statuses for a single DHL Express Shipment\n"
},
"response": [
{
"name": "Shipment details found",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
},
{
"description": "Please provide message reference\n",
"key": "Message-Reference",
"value": "d0e7832e-5c98-11ea-bc55-0242ac13"
},
{
"description": "Optional reference date in the HTTP-date format https://tools.ietf.org/html/rfc7231#section-7.1.1.2",
"key": "Message-Reference-Date",
"value": "Wed, 21 Oct 2015 07:28:00 GMT"
},
{
"key": "Accept-Language",
"value": "eng"
},
{
"description": "Please provide name of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Name",
"value": " "
},
{
"description": "Please provide version of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Version",
"value": " "
},
{
"description": "Please provide name of the shipping platform(applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the shipping platform (applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Version",
"value": " "
},
{
"description": "Please provide name of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Version",
"value": " "
}
],
"url": {
"raw": "{{baseUrl}}/shipments/:shipmentTrackingNumber/tracking?trackingView=all-checkpoints&levelOfDetail=all",
"host": [
"{{baseUrl}}"
],
"path": [
"shipments",
":shipmentTrackingNumber",
"tracking"
],
"query": [
{
"key": "trackingView",
"value": "all-checkpoints"
},
{
"key": "levelOfDetail",
"value": "all"
}
],
"variable": [
{
"key": "shipmentTrackingNumber",
"value": "dolor veniam officia non",
"description": "(Required) DHL Express shipment identification number"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Invocation-Id",
"value": "sed ut mollit",
"description": "Unique identifier of the transaction"
},
{
"key": "Message-Reference",
"value": "sed ut mollit",
"description": "Message reference provided by customer as part of reqeust or automatically generated when not provided"
},
{
"key": "Content-Language",
"value": "sed ut mollit",
"description": ""
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"shipments\": [\n {\n \"events\": [\n {\n \"date\": \"2020-06-10\",\n \"time\": \"13:06:00\",\n \"typeCode\": \"PU\",\n \"description\": \"Shipment picked up\",\n \"serviceArea\": [\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n },\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n }\n ],\n \"signedBy\": \"Mr.Grey\"\n },\n {\n \"date\": \"2020-06-10\",\n \"time\": \"13:06:00\",\n \"typeCode\": \"PU\",\n \"description\": \"Shipment picked up\",\n \"serviceArea\": [\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n },\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n }\n ],\n \"signedBy\": \"Mr.Grey\"\n }\n ],\n \"shipmentTrackingNumber\": \"1234567890\",\n \"status\": \"Success\",\n \"shipmentTimestamp\": \"2020-05-14T18:00:31\",\n \"productCode\": \"N\",\n \"description\": \"Shipment Description\",\n \"shipperDetails\": {\n \"name\": \"SABO SKIRT\",\n \"postalAddress\": {\n \"cityName\": \"Brno\",\n \"countyName\": \"Moravia\",\n \"postalCode\": \"55500\",\n \"provinceCode\": \"CZ\",\n \"countryCode\": \"CZ\"\n },\n \"serviceArea\": [\n {\n \"code\": \"ABC\",\n \"description\": \"Alpha Beta Area\",\n \"outboundSortCode\": \"ullamco Duis\"\n },\n {\n \"code\": \"ABC\",\n \"description\": \"Alpha Beta Area\",\n \"outboundSortCode\": \"sunt eu\"\n }\n ],\n \"accountNumber\": \"ipsum sed officia\"\n },\n \"receiverDetails\": {\n \"name\": \"SABO SKIRT\",\n \"postalAddress\": {\n \"cityName\": \"Bratislava\",\n \"countyName\": \"Slovakia\",\n \"postalCode\": \"77777\",\n \"provinceCode\": \"SK\",\n \"countryCode\": \"SK\"\n },\n \"serviceArea\": [\n {\n \"code\": \"BSA\",\n \"description\": \"BSA Area\",\n \"facilityCode\": \"facil area\",\n \"inboundSortCode\": \"Dui\"\n },\n {\n \"code\": \"BSA\",\n \"description\": \"BSA Area\",\n \"facilityCode\": \"facil area\",\n \"inboundSortCode\": \"velit\"\n }\n ]\n },\n \"totalWeight\": 10,\n \"unitOfMeasurements\": \"metric\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ],\n \"numberOfPieces\": 1,\n \"pieces\": [\n {\n \"events\": [\n {\n \"date\": \"labore sit exercitation\",\n \"time\": \"dolore enim\",\n \"typeCode\": \"Excepteur tempor enim paria\",\n \"description\": \"cupidatat commodo in nostrud\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"magna Excepteur\"\n },\n {\n \"date\": \"aute nulla a\",\n \"time\": \"mollit\",\n \"typeCode\": \"id laborum ad sit\",\n \"description\": \"proident Ut i\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"in eu veniam\"\n }\n ],\n \"number\": 1,\n \"typeCode\": \"ut veniam aliqua\",\n \"shipmentTrackingNumber\": \"velit ex ullamco\",\n \"trackingNumber\": \"nulla dolore nisi minim ea\",\n \"description\": \"aliqua aliquip sed in\",\n \"weight\": 22.5,\n \"dimensionalWeight\": 22.5,\n \"actualWeight\": 22.5,\n \"dimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"actualDimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"unitOfMeasurements\": \"est ea dolore sunt\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ]\n },\n {\n \"events\": [\n {\n \"date\": \"Ut sit exercitation et\",\n \"time\": \"ut enim s\",\n \"typeCode\": \"e\",\n \"description\": \"in aliquip qui id\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"ut sit aliquip veniam\"\n },\n {\n \"date\": \"ex adipisicing laborum in\",\n \"time\": \"ut tempor aliquip occaecat\",\n \"typeCode\": \"ad\",\n \"description\": \"irure sed aute\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"sint laboris\"\n }\n ],\n \"number\": 1,\n \"typeCode\": \"amet ullamco eiusmod est in\",\n \"shipmentTrackingNumber\": \"do magna laboris ad\",\n \"trackingNumber\": \"dolor incididunt ad proident\",\n \"description\": \"exercitation in dolor\",\n \"weight\": 22.5,\n \"dimensionalWeight\": 22.5,\n \"actualWeight\": 22.5,\n \"dimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"actualDimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"unitOfMeasurements\": \"laboris\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ]\n }\n ],\n \"estimatedDeliveryDate\": \"2020-06-12\",\n \"childrenShipmentIdentificationNumbers\": [\n \"1234567890\",\n \"1234567890\"\n ]\n },\n {\n \"events\": [\n {\n \"date\": \"2020-06-10\",\n \"time\": \"13:06:00\",\n \"typeCode\": \"PU\",\n \"description\": \"Shipment picked up\",\n \"serviceArea\": [\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n },\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n }\n ],\n \"signedBy\": \"Mr.Grey\"\n },\n {\n \"date\": \"2020-06-10\",\n \"time\": \"13:06:00\",\n \"typeCode\": \"PU\",\n \"description\": \"Shipment picked up\",\n \"serviceArea\": [\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n },\n {\n \"code\": \"BNE\",\n \"description\": \"Brisbane-AU\"\n }\n ],\n \"signedBy\": \"Mr.Grey\"\n }\n ],\n \"shipmentTrackingNumber\": \"1234567890\",\n \"status\": \"Success\",\n \"shipmentTimestamp\": \"2020-05-14T18:00:31\",\n \"productCode\": \"N\",\n \"description\": \"Shipment Description\",\n \"shipperDetails\": {\n \"name\": \"SABO SKIRT\",\n \"postalAddress\": {\n \"cityName\": \"Brno\",\n \"countyName\": \"Moravia\",\n \"postalCode\": \"55500\",\n \"provinceCode\": \"CZ\",\n \"countryCode\": \"CZ\"\n },\n \"serviceArea\": [\n {\n \"code\": \"ABC\",\n \"description\": \"Alpha Beta Area\",\n \"outboundSortCode\": \"ut enim esse in incididunt\"\n },\n {\n \"code\": \"ABC\",\n \"description\": \"Alpha Beta Area\",\n \"outboundSortCode\": \"anim pariatur adipisicing ipsum\"\n }\n ],\n \"accountNumber\": \"nostrud\"\n },\n \"receiverDetails\": {\n \"name\": \"SABO SKIRT\",\n \"postalAddress\": {\n \"cityName\": \"Bratislava\",\n \"countyName\": \"Slovakia\",\n \"postalCode\": \"77777\",\n \"provinceCode\": \"SK\",\n \"countryCode\": \"SK\"\n },\n \"serviceArea\": [\n {\n \"code\": \"BSA\",\n \"description\": \"BSA Area\",\n \"facilityCode\": \"facil area\",\n \"inboundSortCode\": \"magna sit\"\n },\n {\n \"code\": \"BSA\",\n \"description\": \"BSA Area\",\n \"facilityCode\": \"facil area\",\n \"inboundSortCode\": \"ut nulla in occaecat\"\n }\n ]\n },\n \"totalWeight\": 10,\n \"unitOfMeasurements\": \"metric\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ],\n \"numberOfPieces\": 1,\n \"pieces\": [\n {\n \"events\": [\n {\n \"date\": \"enim in\",\n \"time\": \"anim nostrud ad molli\",\n \"typeCode\": \"dolor consectetur\",\n \"description\": \"cillum reprehenderit incididunt es\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"cupidatat esse quis Excepteur\"\n },\n {\n \"date\": \"\",\n \"time\": \"cupidatat\",\n \"typeCode\": \"ame\",\n \"description\": \"dolore nulla \",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"nulla sint id sed\"\n }\n ],\n \"number\": 1,\n \"typeCode\": \"ea dolore dolore occaecat\",\n \"shipmentTrackingNumber\": \"do aliqua sit\",\n \"trackingNumber\": \"adipisicing veniam in\",\n \"description\": \"commodo fugiat\",\n \"weight\": 22.5,\n \"dimensionalWeight\": 22.5,\n \"actualWeight\": 22.5,\n \"dimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"actualDimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"unitOfMeasurements\": \"do esse fugiat\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ]\n },\n {\n \"events\": [\n {\n \"date\": \"esse dolore\",\n \"time\": \"tempor deserunt proident\",\n \"typeCode\": \"sit do\",\n \"description\": \"ipsum commodo sunt officia\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"irure culpa\"\n },\n {\n \"date\": \"Duis amet nostrud\",\n \"time\": \"sit eu id\",\n \"typeCode\": \"Lorem ad\",\n \"description\": \"amet\",\n \"serviceArea\": [\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n {\n \"code\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"description\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n }\n ],\n \"signedBy\": \"minim occaec\"\n }\n ],\n \"number\": 1,\n \"typeCode\": \"dolor Duis reprehenderit\",\n \"shipmentTrackingNumber\": \"incididunt \",\n \"trackingNumber\": \"cillum minim cupidatat\",\n \"description\": \"sed voluptate\",\n \"weight\": 22.5,\n \"dimensionalWeight\": 22.5,\n \"actualWeight\": 22.5,\n \"dimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"actualDimensions\": {\n \"length\": 15,\n \"width\": 15,\n \"height\": 40\n },\n \"unitOfMeasurements\": \"consequat exercitation nulla\",\n \"shipperReferences\": [\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n },\n {\n \"value\": \"Customer reference\",\n \"typeCode\": \"CU\"\n }\n ]\n }\n ],\n \"estimatedDeliveryDate\": \"2020-06-12\",\n \"childrenShipmentIdentificationNumbers\": [\n \"1234567890\",\n \"1234567890\"\n ]\n }\n ]\n}"
},
{
"name": "Wrong input parameters",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
},
{
"description": "Please provide message reference\n",
"key": "Message-Reference",
"value": "d0e7832e-5c98-11ea-bc55-0242ac13"
},
{
"description": "Optional reference date in the HTTP-date format https://tools.ietf.org/html/rfc7231#section-7.1.1.2",
"key": "Message-Reference-Date",
"value": "Wed, 21 Oct 2015 07:28:00 GMT"
},
{
"key": "Accept-Language",
"value": "eng"
},
{
"description": "Please provide name of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Name",
"value": " "
},
{
"description": "Please provide version of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Version",
"value": " "
},
{
"description": "Please provide name of the shipping platform(applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the shipping platform (applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Version",
"value": " "
},
{
"description": "Please provide name of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Version",
"value": " "
}
],
"url": {
"raw": "{{baseUrl}}/shipments/:shipmentTrackingNumber/tracking?trackingView=all-checkpoints&levelOfDetail=all",
"host": [
"{{baseUrl}}"
],
"path": [
"shipments",
":shipmentTrackingNumber",
"tracking"
],
"query": [
{
"key": "trackingView",
"value": "all-checkpoints"
},
{
"key": "levelOfDetail",
"value": "all"
}
],
"variable": [
{
"key": "shipmentTrackingNumber",
"value": "dolor veniam officia non",
"description": "(Required) DHL Express shipment identification number"
}
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"instance\": \"/expressapi/shipments/1251820953/tracking?trackingView=shipment-details&levelOfDetail=shipment\",\n \"detail\": \"Parameters not having correct format: trackingView (valid parameters for trackingView are [last-checkpoint, all-checkpoints, bbx-children, advance-shipment, shipment-details-only]\",\n \"title\": \"Wrong format\",\n \"message\": \"Bad request\",\n \"status\": \"400\"\n}"
},
{
"name": "No data found",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
},
{
"description": "Please provide message reference\n",
"key": "Message-Reference",
"value": "d0e7832e-5c98-11ea-bc55-0242ac13"
},
{
"description": "Optional reference date in the HTTP-date format https://tools.ietf.org/html/rfc7231#section-7.1.1.2",
"key": "Message-Reference-Date",
"value": "Wed, 21 Oct 2015 07:28:00 GMT"
},
{
"key": "Accept-Language",
"value": "eng"
},
{
"description": "Please provide name of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Name",
"value": " "
},
{
"description": "Please provide version of the plugin (applicable to 3PV only)\n",
"key": "Plugin-Version",
"value": " "
},
{
"description": "Please provide name of the shipping platform(applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the shipping platform (applicable to 3PV only)\n",
"key": "Shipping-System-Platform-Version",
"value": " "
},
{
"description": "Please provide name of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Name",
"value": " "
},
{
"description": "Please provide version of the webstore platform (applicable to 3PV only)\n",
"key": "Webstore-Platform-Version",
"value": " "
}
],
"url": {
"raw": "{{baseUrl}}/shipments/:shipmentTrackingNumber/tracking?trackingView=all-checkpoints&levelOfDetail=all",
"host": [
"{{baseUrl}}"
],
"path": [
"shipments",
":shipmentTrackingNumber",
"tracking"
],
"query": [
{
"key": "trackingView",
"value": "all-checkpoints"
},
{
"key": "levelOfDetail",
"value": "all"
}
],
"variable": [
{
"key": "shipmentTrackingNumber",
"value": "dolor veniam officia non",
"description": "(Required) DHL Express shipment identification number"
}
]
}
},
"status": "Not Found",
"code": 404,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"instance\": \"/expressapi/shipments/1251820953/tracking?trackingView=shipment-details&levelOfDetail=shipment\",\n \"detail\": \"No data found\",\n \"title\": \"Not data found\",\n \"message\": \"Not data found\",\n \"status\": \"404\"\n}"
}
]
}
