SQL Server
SQL Server
Walmart v3 Acknowledge Orders
See more Walmart v3 Examples
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.
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
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
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'
DECLARE @resp int
EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @http, 'HttpNoBody', @success OUT, 'POST', 'https://api-gateway.walmart.com/v3/orders/{purchaseOrderId}/acknowledge', @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Response status code: ' + @iTmp0
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
-- 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 @resp
EXEC @hr = sp_OADestroy @sbResponseBody
END
GO