SQL Server Requires Chilkat v11.0.0+
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.Chilkat SQL Server Downloads
-- 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
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- 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.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
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
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 @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @http, 'HttpJson', @success OUT, 'POST', 'https://api-gateway.walmart.com/v3/orders/{purchaseOrderId}/shipping', @json, 'application/json', @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Response status code: ' + @iTmp0
EXEC sp_OAMethod @resp, 'GetBodyJson', @success OUT, @json
-- 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
EXEC @hr = sp_OADestroy @resp
END
GO