|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(Classic ASP) Amazon SP-API Get Order ItemsSee more Amazon SP-API ExamplesReturns detailed order item information for the order that you specify. For more information, see https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#get-ordersv0ordersorderidorderitems
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' This example requires the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. ' Gets detailed order item information for a specified order ID ' The order ID is something like "902-1845936-5435065" and it is the AmazonOrderId returned in the JSON when getting the list of orders. For example: ' { ' "payload": { ' "CreatedBefore": "1.569521782042E9", ' "Orders": [ ' { ' "AmazonOrderId": "902-1845936-5435065", ' "PurchaseDate": "1970-01-19T03:58:30Z", ' ... ' However, when using the sandbox, instead use the explicit keyword TEST_CASE_200 orderId = "TEST_CASE_200" ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.AuthAws") set authAws = Server.CreateObject("Chilkat.AuthAws") authAws.AccessKey = "AWS_ACCESS_KEY" authAws.SecretKey = "AWS_SECRET_KEY" authAws.ServiceName = "execute-api" ' Use the region that is correct for your needs. authAws.Region = "eu-west-1" ' First get a restricted data token for the given order ID. ' This requires an LWA access token which cannot be more than 1 hour old. ' See Fetch SP-API LWA Access Token ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jsonLwaToken = Server.CreateObject("Chilkat.JsonObject") success = jsonLwaToken.LoadFile("qa_data/tokens/sp_api_lwa_token.json") If (success = 0) Then Response.Write "<pre>" & Server.HTMLEncode( "Failed to load LWA access token.") & "</pre>" Response.End End If ' Must use the non-sandbox domain for getting the RDT. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Rest") set rest = Server.CreateObject("Chilkat.Rest") success = rest.Connect("sellingpartnerapi-eu.amazon.com",443,1,1) If (success = 0) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If success = rest.SetAuthAws(authAws) ' Add the x-amz-access-token request header. lwa_token = jsonLwaToken.StringOf("access_token") success = rest.ClearAllHeaders() success = rest.AddHeader("x-amz-access-token",lwa_token) ' We're going to send a POST with the following JSON body: ' { ' "restrictedResources": [ ' { ' "method": "GET", ' "path": "/orders/v0/orders/{orderId}/orderItems", ' "dataElements": ["buyerInfo"] ' } ' ] ' } ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbPath = Server.CreateObject("Chilkat.StringBuilder") success = sbPath.Append("/orders/v0/orders/") success = sbPath.Append(orderId) success = sbPath.Append("/orderItems") ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jsonRc = Server.CreateObject("Chilkat.JsonObject") success = jsonRc.UpdateString("restrictedResources[0].method","GET") success = jsonRc.UpdateString("restrictedResources[0].path",sbPath.GetAsString()) success = jsonRc.UpdateString("restrictedResources[0].dataElements[0]","buyerInfo") ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbRequest = Server.CreateObject("Chilkat.StringBuilder") success = jsonRc.EmitSb(sbRequest) ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbResponse = Server.CreateObject("Chilkat.StringBuilder") uri = "/tokens/2021-03-01/restrictedDataToken" success = rest.FullRequestSb("POST",uri,sbRequest,sbResponse) If (success = 0) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' Examine the response status. statusCode = rest.ResponseStatusCode If (statusCode <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( "Response status code: " & statusCode) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response status text: " & rest.ResponseStatusText) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response body: ") & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( sbResponse.GetAsString()) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>" Response.End End If ' Get the restricted data token. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jsonResp = Server.CreateObject("Chilkat.JsonObject") success = jsonResp.LoadSb(sbResponse) restrictedDataToken = jsonResp.StringOf("restrictedDataToken") Response.Write "<pre>" & Server.HTMLEncode( "Restricted Data Token: " & restrictedDataToken) & "</pre>" ' ------------------------------------------------------------------------------------------------------------ ' ------------------------------------------------------------------------------------------------------------ ' Now that we have the RDT, we can use it to get information about the order. ' ' Yes, the SP-API is horribly tedious and painful. You must use an RDT specifically tailored to each request requiring an RDT, ' the RDT must not be over an hour old, and if you need to get a new RDT you must get it using an LWA token that itself is not ' more than an hour old. If the LWA is more than an hour old, you must get a new one. Ughhh!!!!! ' ------------------------------------------------------------------------------------------------------------ ' Disconnect from the non-sandbox domain. This example will use the sandbox. ' (The RDT was obtained using the non-sandbox domain. For some reason, the sandbox domain does not work for getting the RDT.) success = rest.Disconnect(100) success = rest.Connect("sandbox.sellingpartnerapi-eu.amazon.com",443,1,1) If (success = 0) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If success = rest.SetAuthAws(authAws) success = rest.ClearAllHeaders() success = rest.AddHeader("x-amz-access-token",restrictedDataToken) success = rest.ClearAllQueryParams() success = rest.AddQueryParam("MarketplaceIds","ATVPDKIKX0DER") success = rest.ClearAllPathParams() success = rest.AddPathParam("{orderId}",orderId) uri = "/orders/v0/orders/{orderId}/orderItems" success = rest.FullRequestNoBodySb("GET",uri,sbResponse) If (success = 0) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' Examine the response status. statusCode = rest.ResponseStatusCode If (statusCode <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( "Response status text: " & rest.ResponseStatusText) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response body: ") & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( sbResponse.GetAsString()) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>" Response.End End If ' If successful, gets a JSON response such as the following: ' { ' "payload": { ' "AmazonOrderId": "902-1845936-5435065", ' "OrderItems": [ ' { ' "ASIN": "B00551Q3CS", ' "OrderItemId": "05015851154158", ' "SellerSKU": "NABetaASINB00551Q3CS", ' "Title": "B00551Q3CS [Card Book]", ' "QuantityOrdered": 1, ' "QuantityShipped": 0, ' "ProductInfo": { ' "NumberOfItems": 1 ' }, ' "ItemPrice": { ' "CurrencyCode": "USD", ' "Amount": "10.00" ' }, ' "ItemTax": { ' "CurrencyCode": "USD", ' "Amount": "1.01" ' }, ' "PromotionDiscount": { ' "CurrencyCode": "USD", ' "Amount": "0.00" ' }, ' "IsGift": false, ' "ConditionId": "New", ' "ConditionSubtypeId": "New", ' "IsTransparency": false, ' "SerialNumberRequired": false, ' "IossNumber": "", ' "DeemedResellerCategory": "IOSS", ' "StoreChainStoreId": "ISPU_StoreId", ' "BuyerRequestedCancel": { ' "IsBuyerRequestedCancel": true, ' "BuyerCancelReason": "Found cheaper somewhere else." ' } ' } ' ] ' } ' } ' Use this online tool to generate parsing code from sample JSON: ' Generate Parsing Code from JSON ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set json = Server.CreateObject("Chilkat.JsonObject") success = json.LoadSb(sbResponse) json.EmitCompact = 0 Response.Write "<pre>" & Server.HTMLEncode( json.Emit()) & "</pre>" AmazonOrderId = json.StringOf("payload.AmazonOrderId") i = 0 count_i = json.SizeOfArray("payload.OrderItems") Do While i < count_i json.I = i ASIN = json.StringOf("payload.OrderItems[i].ASIN") OrderItemId = json.StringOf("payload.OrderItems[i].OrderItemId") SellerSKU = json.StringOf("payload.OrderItems[i].SellerSKU") Title = json.StringOf("payload.OrderItems[i].Title") QuantityOrdered = json.IntOf("payload.OrderItems[i].QuantityOrdered") QuantityShipped = json.IntOf("payload.OrderItems[i].QuantityShipped") NumberOfItems = json.IntOf("payload.OrderItems[i].ProductInfo.NumberOfItems") CurrencyCode = json.StringOf("payload.OrderItems[i].ItemPrice.CurrencyCode") Amount = json.StringOf("payload.OrderItems[i].ItemPrice.Amount") ItemTaxCurrencyCode = json.StringOf("payload.OrderItems[i].ItemTax.CurrencyCode") ItemTaxAmount = json.StringOf("payload.OrderItems[i].ItemTax.Amount") PromotionDiscountCurrencyCode = json.StringOf("payload.OrderItems[i].PromotionDiscount.CurrencyCode") PromotionDiscountAmount = json.StringOf("payload.OrderItems[i].PromotionDiscount.Amount") IsGift = json.BoolOf("payload.OrderItems[i].IsGift") ConditionId = json.StringOf("payload.OrderItems[i].ConditionId") ConditionSubtypeId = json.StringOf("payload.OrderItems[i].ConditionSubtypeId") IsTransparency = json.BoolOf("payload.OrderItems[i].IsTransparency") SerialNumberRequired = json.BoolOf("payload.OrderItems[i].SerialNumberRequired") IossNumber = json.StringOf("payload.OrderItems[i].IossNumber") DeemedResellerCategory = json.StringOf("payload.OrderItems[i].DeemedResellerCategory") StoreChainStoreId = json.StringOf("payload.OrderItems[i].StoreChainStoreId") IsBuyerRequestedCancel = json.BoolOf("payload.OrderItems[i].BuyerRequestedCancel.IsBuyerRequestedCancel") BuyerCancelReason = json.StringOf("payload.OrderItems[i].BuyerRequestedCancel.BuyerCancelReason") i = i + 1 Loop Response.Write "<pre>" & Server.HTMLEncode( "Success!") & "</pre>" %> </body> </html> |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.