(SQL Server) Walmart v3 Ship Order Lines

See more Walmart v3 Examples

Updates the status of order lines to Shipped and trigger the charge to the customer. The response to a successful call contains the order with the shipped line items.

For more information, see https://developer.walmart.com/api/us/mp/orders#operation/shippingUpdates

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- 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_OAMethod @http, 'SetRequestHeader', NULL, 'WM_QOS.CORRELATION_ID', 'b3261d2d-028a-4ef7-8602-633c23200af6'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'WM_SEC.ACCESS_TOKEN', 'eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'WM_SVC.NAME', 'Walmart Marketplace'

    -- Send the following in the request body:

    -- {
    --   "orderShipment": {
    --     "orderLines": {
    --       "orderLine": [
    --         {
    --           "lineNumber": "1",
    --           "intentToCancelOverride": false,
    --           "sellerOrderId": "92344",
    --           "orderLineStatuses": {
    --             "orderLineStatus": [
    --               {
    --                 "status": "Shipped",
    --                 "statusQuantity": {
    --                   "unitOfMeasurement": "EACH",
    --                   "amount": "1"
    --                 },
    --                 "trackingInfo": {
    --                   "shipDateTime": 1580821866000,
    --                   "carrierName": {
    --                     "carrier": "UPS"
    --                   },
    --                   "methodCode": "Standard",
    --                   "trackingNumber": "22344",
    --                   "trackingURL": "http://walmart/tracking/ups?&type=MP&seller_id=12345&promise_date=03/02/2020&dzip=92840&tracking_numbers=92345"
    --                 },
    --                 "returnCenterAddress": {
    --                   "name": "walmart",
    --                   "address1": "walmart store 2",
    --                   "city": "Huntsville",
    --                   "state": "AL",
    --                   "postalCode": "35805",
    --                   "country": "USA",
    --                   "dayPhone": "12344",
    --                   "emailId": "walmart@walmart.com"
    --                 }
    --               }
    --             ]
    --           }
    --         },
    --         {
    --           "lineNumber": "2",
    --           "sellerOrderId": "92344",
    --           "orderLineStatuses": {
    --             "orderLineStatus": [
    --               {
    --                 "status": "Shipped",
    --                 "statusQuantity": {
    --                   "unitOfMeasurement": "EACH",
    --                   "amount": "1"
    --                 },
    --                 "trackingInfo": {
    --                   "shipDateTime": 1580821866000,
    --                   "carrierName": {
    --                     "carrier": "FedEx"
    --                   },
    --                   "methodCode": "Express",
    --                   "trackingNumber": "22344",
    --                   "trackingURL": "http://walmart/tracking/fedEx?&type=MP&seller_id=12345&promise_date=03/02/2020&dzip=92840&tracking_numbers=92344"
    --                 },
    --                 "returnCenterAddress": {
    --                   "name": "walmart",
    --                   "address1": "walmart store 2",
    --                   "city": "Huntsville",
    --                   "state": "AL",
    --                   "postalCode": "35805",
    --                   "country": "USA",
    --                   "dayPhone": "12344",
    --                   "emailId": "walmart@walmart.com"
    --                 }
    --               }
    --             ]
    --           }
    --         }
    --       ]
    --     }
    --   }
    -- }

    DECLARE @json int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT

    DECLARE @orderLineIndex int
    SELECT @orderLineIndex = 0
    DECLARE @statusIndex int
    SELECT @statusIndex = 0
    EXEC sp_OASetProperty @json, 'I', @orderLineIndex
    EXEC sp_OASetProperty @json, 'J', @statusIndex
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].lineNumber', '1'
    EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'orderShipment.orderLines.orderLine[i].intentToCancelOverride', 0
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].sellerOrderId', '92344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].status', 'Shipped'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.unitOfMeasurement', 'EACH'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.amount', '1'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.shipDateTime', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.carrierName.carrier', 'UPS'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.methodCode', 'Standard'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingNumber', '22344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingURL', 'http://walmart/tracking/ups?&type=MP&seller_id=12345&promise_date=03/02/2020&dzip=92840&tracking_numbers=92345'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.name', 'walmart'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.address1', 'walmart store 2'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.city', 'Huntsville'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.state', 'AL'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.postalCode', '35805'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.country', 'USA'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.dayPhone', '12344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.emailId', 'walmart@walmart.com'

    SELECT @orderLineIndex = @orderLineIndex + 1
    SELECT @statusIndex = 0
    EXEC sp_OASetProperty @json, 'I', @orderLineIndex
    EXEC sp_OASetProperty @json, 'J', @statusIndex
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].lineNumber', '2'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].sellerOrderId', '92344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].status', 'Shipped'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.unitOfMeasurement', 'EACH'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.amount', '1'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.shipDateTime', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.carrierName.carrier', 'FedEx'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.methodCode', 'Express'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingNumber', '22344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingURL', 'http://walmart/tracking/fedEx?&type=MP&seller_id=12345&promise_date=03/02/2020&dzip=92840&tracking_numbers=92344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.name', 'walmart'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.address1', 'walmart store 2'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.city', 'Huntsville'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.state', 'AL'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.postalCode', '35805'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.country', 'USA'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.dayPhone', '12344'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'orderShipment.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.emailId', 'walmart@walmart.com'

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api-gateway.walmart.com/v3/orders/{purchaseOrderId}/shipping', 'application/json', @json
    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 @json
        RETURN
      END


    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    PRINT 'Response status code: ' + @iTmp0

    EXEC sp_OAMethod @resp, 'GetBodyJson', @success OUT, @json
    EXEC @hr = sp_OADestroy @resp

    -- A sample JSON response:

    -- {
    --   "order": {
    --     "purchaseOrderId": "1234567891234",
    --     "customerOrderId": "9876543212345",
    --     "sellerOrderId": "13233454564657",
    --     "customerEmailId": "customer@walmartlabs.com",
    --     "orderDate": 1478284060000,
    --     "shippingInfo": {
    --       "phone": "6501234567",
    --       "estimatedDeliveryDate": 1479798000000,
    --       "estimatedShipDate": 1478674800000,
    --       "methodCode": "Value",
    --       "postalAddress": {
    --         "name": "Jane Doe",
    --         "address1": "123 Main street",
    --         "city": "Sunnyvale",
    --         "state": "CA",
    --         "postalCode": "94086",
    --         "country": "USA",
    --         "addressType": "OFFICE"
    --       }
    --     },
    --     "orderLines": {
    --       "orderLine": [
    --         {
    --           "lineNumber": "1",
    --           "item": {
    --             "productName": "Kenmore CF-1 or 20-86883 Canister Secondary Filter Generic 2 Pack",
    --             "sku": "wei-ASSET-675gku675"
    --           },
    --           "charges": {
    --             "charge": [
    --               {
    --                 "chargeType": "PRODUCT",
    --                 "chargeName": "ItemPrice",
    --                 "chargeAmount": {
    --                   "currency": "USD",
    --                   "amount": 555
    --                 },
    --                 "tax": {
    --                   "taxName": "Tax1",
    --                   "taxAmount": {
    --                     "currency": "USD",
    --                     "amount": 48.56
    --                   }
    --                 }
    --               }
    --             ]
    --           },
    --           "orderLineQuantity": {
    --             "unitOfMeasurement": "EACH",
    --             "amount": "1"
    --           },
    --           "statusDate": 1478297929000,
    --           "orderLineStatuses": {
    --             "orderLineStatus": [
    --               {
    --                 "status": "Shipped",
    --                 "statusQuantity": {
    --                   "unitOfMeasurement": "EACH",
    --                   "amount": "1"
    --                 },
    --                 "trackingInfo": {
    --                   "shipDateTime": 1438163400000,
    --                   "carrierName": {
    --                     "carrier": "FedEx"
    --                   },
    --                   "methodCode": "Value",
    --                   "trackingNumber": "911001572321619861",
    --                   "trackingURL": "http://www.fedex.com/Tracking?action=track=english=us=x=911001572321619861"
    --                 },
    --                 "returnCenterAddress": {
    --                   "name": "ABC",
    --                   "address1": "123 Bridge street",
    --                   "city": "Huntsville",
    --                   "state": "AL",
    --                   "postalCode": "35805",
    --                   "country": "USA",
    --                   "dayPhone": "6501234567",
    --                   "emailId": "RCemailaddress@company.com"
    --                 }
    --               }
    --             ]
    --           }
    --         }
    --       ]
    --     }
    --   }
    -- }

    EXEC sp_OASetProperty @json, 'EmitCompact', 0

    PRINT 'Response JSON:'
    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    -- Insert code here to load the above JSON into the json object.

    DECLARE @lineNumber nvarchar(4000)

    DECLARE @ProductName nvarchar(4000)

    DECLARE @Sku nvarchar(4000)

    DECLARE @UnitOfMeasurement nvarchar(4000)

    DECLARE @Amount nvarchar(4000)

    DECLARE @statusDate int

    DECLARE @count_j int

    DECLARE @chargeType nvarchar(4000)

    DECLARE @chargeName nvarchar(4000)

    DECLARE @v_Currency nvarchar(4000)

    DECLARE @chargeAmountAmount int

    DECLARE @TaxName nvarchar(4000)

    DECLARE @TaxAmountCurrency nvarchar(4000)

    DECLARE @TaxAmountAmount nvarchar(4000)

    DECLARE @status nvarchar(4000)

    DECLARE @statusQuantityUnitOfMeasurement nvarchar(4000)

    DECLARE @statusQuantityAmount nvarchar(4000)

    DECLARE @ShipDateTime int

    DECLARE @Carrier nvarchar(4000)

    DECLARE @trackingInfoMethodCode nvarchar(4000)

    DECLARE @TrackingNumber nvarchar(4000)

    DECLARE @TrackingURL nvarchar(4000)

    DECLARE @returnCenterAddressName nvarchar(4000)

    DECLARE @returnCenterAddressAddress1 nvarchar(4000)

    DECLARE @returnCenterAddressCity nvarchar(4000)

    DECLARE @returnCenterAddressState nvarchar(4000)

    DECLARE @returnCenterAddressPostalCode nvarchar(4000)

    DECLARE @returnCenterAddressCountry nvarchar(4000)

    DECLARE @DayPhone nvarchar(4000)

    DECLARE @EmailId nvarchar(4000)

    DECLARE @PurchaseOrderId nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @PurchaseOrderId OUT, 'order.purchaseOrderId'
    DECLARE @CustomerOrderId nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @CustomerOrderId OUT, 'order.customerOrderId'
    DECLARE @SellerOrderId nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @SellerOrderId OUT, 'order.sellerOrderId'
    DECLARE @CustomerEmailId nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @CustomerEmailId OUT, 'order.customerEmailId'
    DECLARE @OrderDate int
    EXEC sp_OAMethod @json, 'IntOf', @OrderDate OUT, 'order.orderDate'
    DECLARE @Phone nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @Phone OUT, 'order.shippingInfo.phone'
    DECLARE @EstimatedDeliveryDate int
    EXEC sp_OAMethod @json, 'IntOf', @EstimatedDeliveryDate OUT, 'order.shippingInfo.estimatedDeliveryDate'
    DECLARE @EstimatedShipDate int
    EXEC sp_OAMethod @json, 'IntOf', @EstimatedShipDate OUT, 'order.shippingInfo.estimatedShipDate'
    DECLARE @MethodCode nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @MethodCode OUT, 'order.shippingInfo.methodCode'
    DECLARE @Name nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @Name OUT, 'order.shippingInfo.postalAddress.name'
    DECLARE @Address1 nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @Address1 OUT, 'order.shippingInfo.postalAddress.address1'
    DECLARE @City nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @City OUT, 'order.shippingInfo.postalAddress.city'
    DECLARE @State nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @State OUT, 'order.shippingInfo.postalAddress.state'
    DECLARE @PostalCode nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @PostalCode OUT, 'order.shippingInfo.postalAddress.postalCode'
    DECLARE @Country nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @Country OUT, 'order.shippingInfo.postalAddress.country'
    DECLARE @AddressType nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @AddressType OUT, 'order.shippingInfo.postalAddress.addressType'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @j int
    SELECT @j = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @json, 'SizeOfArray', @count_i OUT, 'order.orderLines.orderLine'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @json, 'I', @i
        EXEC sp_OAMethod @json, 'StringOf', @lineNumber OUT, 'order.orderLines.orderLine[i].lineNumber'
        EXEC sp_OAMethod @json, 'StringOf', @ProductName OUT, 'order.orderLines.orderLine[i].item.productName'
        EXEC sp_OAMethod @json, 'StringOf', @Sku OUT, 'order.orderLines.orderLine[i].item.sku'
        EXEC sp_OAMethod @json, 'StringOf', @UnitOfMeasurement OUT, 'order.orderLines.orderLine[i].orderLineQuantity.unitOfMeasurement'
        EXEC sp_OAMethod @json, 'StringOf', @Amount OUT, 'order.orderLines.orderLine[i].orderLineQuantity.amount'
        EXEC sp_OAMethod @json, 'IntOf', @statusDate OUT, 'order.orderLines.orderLine[i].statusDate'
        SELECT @j = 0
        EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'order.orderLines.orderLine[i].charges.charge'
        WHILE @j < @count_j
          BEGIN
            EXEC sp_OASetProperty @json, 'J', @j
            EXEC sp_OAMethod @json, 'StringOf', @chargeType OUT, 'order.orderLines.orderLine[i].charges.charge[j].chargeType'
            EXEC sp_OAMethod @json, 'StringOf', @chargeName OUT, 'order.orderLines.orderLine[i].charges.charge[j].chargeName'
            EXEC sp_OAMethod @json, 'StringOf', @v_Currency OUT, 'order.orderLines.orderLine[i].charges.charge[j].chargeAmount.currency'
            EXEC sp_OAMethod @json, 'IntOf', @chargeAmountAmount OUT, 'order.orderLines.orderLine[i].charges.charge[j].chargeAmount.amount'
            EXEC sp_OAMethod @json, 'StringOf', @TaxName OUT, 'order.orderLines.orderLine[i].charges.charge[j].tax.taxName'
            EXEC sp_OAMethod @json, 'StringOf', @TaxAmountCurrency OUT, 'order.orderLines.orderLine[i].charges.charge[j].tax.taxAmount.currency'
            EXEC sp_OAMethod @json, 'StringOf', @TaxAmountAmount OUT, 'order.orderLines.orderLine[i].charges.charge[j].tax.taxAmount.amount'
            SELECT @j = @j + 1
          END
        SELECT @j = 0
        EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus'
        WHILE @j < @count_j
          BEGIN
            EXEC sp_OASetProperty @json, 'J', @j
            EXEC sp_OAMethod @json, 'StringOf', @status OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].status'
            EXEC sp_OAMethod @json, 'StringOf', @statusQuantityUnitOfMeasurement OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.unitOfMeasurement'
            EXEC sp_OAMethod @json, 'StringOf', @statusQuantityAmount OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].statusQuantity.amount'
            EXEC sp_OAMethod @json, 'IntOf', @ShipDateTime OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.shipDateTime'
            EXEC sp_OAMethod @json, 'StringOf', @Carrier OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.carrierName.carrier'
            EXEC sp_OAMethod @json, 'StringOf', @trackingInfoMethodCode OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.methodCode'
            EXEC sp_OAMethod @json, 'StringOf', @TrackingNumber OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingNumber'
            EXEC sp_OAMethod @json, 'StringOf', @TrackingURL OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].trackingInfo.trackingURL'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressName OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.name'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressAddress1 OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.address1'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressCity OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.city'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressState OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.state'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressPostalCode OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.postalCode'
            EXEC sp_OAMethod @json, 'StringOf', @returnCenterAddressCountry OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.country'
            EXEC sp_OAMethod @json, 'StringOf', @DayPhone OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.dayPhone'
            EXEC sp_OAMethod @json, 'StringOf', @EmailId OUT, 'order.orderLines.orderLine[i].orderLineStatuses.orderLineStatus[j].returnCenterAddress.emailId'
            SELECT @j = @j + 1
          END
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @json


END
GO