(SQL Server) Walmart v3 Acknowledge Orders

Allows a DSV to acknowledge an order, including all order lines, preferably within four hours of receipt of the order.

The response to a successful call contains the acknowledged order. As a good practice, acknowledge your orders to avoid underselling.

Note: This example requires Chilkat v9.5.0.85 or greater.

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

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'

    -- Note: A problem is was fixed after the Chilkat v9.5.0.84 release.  The "Content-Length: 0" header is required for the POST.
    -- Chilkat v9.5.0.84 did not automatically include it for QuickRequest called with the POST verb.
    DECLARE @resp int
    EXEC sp_OAMethod @http, 'QuickRequest', @resp OUT, 'POST', 'https://api-gateway.walmart.com/v3/orders/{purchaseOrderId}/acknowledge'
    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
        RETURN
      END


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

    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
    EXEC @hr = sp_OADestroy @resp

    -- A sample JSON response:

    -- {
    --   "order": {
    --     "purchaseOrderId": "1581564396843",
    --     "customerOrderId": "3001859598500",
    --     "customerEmailId": "D5AFD31C627A45F3A93041FD557F94C4@relay.walmart.com",
    --     "orderDate": 1517252660000,
    --     "buyerId": "43538435-de77-44c7-b606-ad9a8ff1d8f8",
    --     "mart": "Walmart.com",
    --     "isGuest": false,
    --     "shippingInfo": {
    --       "phone": "2566519197",
    --       "estimatedDeliveryDate": 1518454800000,
    --       "estimatedShipDate": 1518109200000,
    --       "methodCode": "Standard",
    --       "postalAddress": {
    --         "name": "whitney feathers",
    --         "address1": "4100 Cloverdale Dr NW",
    --         "address2": null,
    --         "city": "Huntsville",
    --         "state": "AL",
    --         "postalCode": "35805",
    --         "country": "USA",
    --         "addressType": "RESIDENTIAL"
    --       }
    --     },
    --     "orderLines": {
    --       "orderLine": [
    --         {
    --           "lineNumber": "1",
    --           "item": {
    --             "productName": "High-Quality 8 x 10 Prints",
    --             "sku": "8x10{IS",
    --             "imageUrl": "https://i5.walmartimages.com/asr/7924b94b-49fa-4050-8e62-2364d07d0068_1.6ef0f115abba4f27b7c5e785c2bac517.jpeg",
    --             "weight": {
    --               "value": "0.438",
    --               "unit": "Pounds"
    --             }
    --           },
    --           "charges": {
    --             "charge": [
    --               {
    --                 "chargeType": "PRODUCT",
    --                 "chargeName": "ItemPrice",
    --                 "chargeAmount": {
    --                   "currency": "USD",
    --                   "amount": 1.79
    --                 },
    --                 "tax": {
    --                   "taxName": "Tax1",
    --                   "taxAmount": {
    --                     "currency": "USD",
    --                     "amount": 0.15
    --                   }
    --                 }
    --               },
    --               {
    --                 "chargeType": "SHIPPING",
    --                 "chargeName": "Shipping",
    --                 "chargeAmount": {
    --                   "currency": "USD",
    --                   "amount": 1.75
    --                 },
    --                 "tax": null
    --               }
    --             ]
    --           },
    --           "orderLineQuantity": {
    --             "unitOfMeasurement": "EACH",
    --             "amount": "1"
    --           },
    --           "statusDate": 1542069814000,
    --           "orderLineStatuses": {
    --             "orderLineStatus": [
    --               {
    --                 "status": "Shipped",
    --                 "statusQuantity": {
    --                   "unitOfMeasurement": "EACH",
    --                   "amount": "1"
    --                 },
    --                 "cancellationReason": null,
    --                 "trackingInfo": {
    --                   "shipDateTime": 1540845015000,
    --                   "carrierName": {
    --                     "otherCarrier": null,
    --                     "carrier": "UPS"
    --                   },
    --                   "methodCode": "Standard",
    --                   "carrierMethodCode": null,
    --                   "trackingNumber": "3445435443441221",
    --                   "trackingURL": "http://www.fedex.com"
    --                 }
    --               }
    --             ]
    --           },
    --           "refund": {
    --             "refundId": null,
    --             "refundComments": null,
    --             "refundCharges": {
    --               "refundCharge": [
    --                 {
    --                   "refundReason": "Quality -> Missing Parts / Instructions",
    --                   "charge": {
    --                     "chargeType": "PRODUCT",
    --                     "chargeName": "Quality -> Missing Parts / Instructions",
    --                     "chargeAmount": {
    --                       "currency": "USD",
    --                       "amount": -0.01
    --                     },
    --                     "tax": null
    --                   }
    --                 }
    --               ]
    --             }
    --           },
    --           "originalCarrierMethod": "22",
    --           "referenceLineId": "123456",
    --           "fulfillment": {
    --             "fulfillmentOption": "S2H",
    --             "shipMethod": "STANDARD",
    --             "storeId": null,
    --             "pickUpDateTime": 1518120000000,
    --             "pickUpBy": null
    --           }
    --         }
    --       ]
    --     }
    --   }
    -- 

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @sbResponseBody


END
GO