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
(Chilkat2-Python) Amazon SP-API Get Specific OrderSee more Amazon SP-API ExamplesGet a specific Amazon Seller order. For more information, see https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#getorders
import sys import chilkat2 # This example requires the Chilkat API to have been previously unlocked. # See Global Unlock Sample for sample code. # Gets information for this 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" authAws = chilkat2.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 jsonLwaToken = chilkat2.JsonObject() success = jsonLwaToken.LoadFile("qa_data/tokens/sp_api_lwa_token.json") if (success == False): print("Failed to load LWA access token.") sys.exit() # Must use the non-sandbox domain for getting the RDT. rest = chilkat2.Rest() success = rest.Connect("sellingpartnerapi-eu.amazon.com",443,True,True) if (success == False): print(rest.LastErrorText) sys.exit() success = rest.SetAuthAws(authAws) # Add the x-amz-access-token request header. lwa_token = jsonLwaToken.StringOf("access_token") rest.ClearAllHeaders() 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}", # "dataElements": ["buyerInfo", "shippingAddress"] # } # ] # } sbPath = chilkat2.StringBuilder() sbPath.Append("/orders/v0/orders/") sbPath.Append(orderId) jsonRc = chilkat2.JsonObject() jsonRc.UpdateString("restrictedResources[0].method","GET") jsonRc.UpdateString("restrictedResources[0].path",sbPath.GetAsString()) jsonRc.UpdateString("restrictedResources[0].dataElements[0]","buyerInfo") jsonRc.UpdateString("restrictedResources[0].dataElements[1]","shippingAddress") sbRequest = chilkat2.StringBuilder() jsonRc.EmitSb(sbRequest) sbResponse = chilkat2.StringBuilder() uri = "/tokens/2021-03-01/restrictedDataToken" success = rest.FullRequestSb("POST",uri,sbRequest,sbResponse) if (success == False): print(rest.LastErrorText) sys.exit() # Examine the response status. statusCode = rest.ResponseStatusCode if (statusCode != 200): print("Response status code: " + str(statusCode)) print("Response status text: " + rest.ResponseStatusText) print("Response body: ") print(sbResponse.GetAsString()) print("Failed.") sys.exit() # Get the restricted data token. jsonResp = chilkat2.JsonObject() jsonResp.LoadSb(sbResponse) restrictedDataToken = jsonResp.StringOf("restrictedDataToken") print("Restricted Data Token: " + restrictedDataToken) # ------------------------------------------------------------------------------------------------------------ # ------------------------------------------------------------------------------------------------------------ # 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.) rest.Disconnect(100) success = rest.Connect("sandbox.sellingpartnerapi-eu.amazon.com",443,True,True) if (success == False): print(rest.LastErrorText) sys.exit() success = rest.SetAuthAws(authAws) rest.ClearAllHeaders() rest.AddHeader("x-amz-access-token",restrictedDataToken) rest.ClearAllQueryParams() rest.AddQueryParam("MarketplaceIds","ATVPDKIKX0DER") rest.ClearAllPathParams() rest.AddPathParam("{orderId}",orderId) uri = "/orders/v0/orders/{orderId}" success = rest.FullRequestNoBodySb("GET",uri,sbResponse) if (success == False): print(rest.LastErrorText) sys.exit() # Examine the response status. statusCode = rest.ResponseStatusCode if (statusCode != 200): print("Response status text: " + rest.ResponseStatusText) print("Response body: ") print(sbResponse.GetAsString()) print("Failed.") sys.exit() print(sbResponse.GetAsString()) # If successful, gets a JSON response such as the following: # { # "payload": { # "AmazonOrderId": "902-1845936-5435065", # "PurchaseDate": "1970-01-19T03:58:30Z", # "LastUpdateDate": "1970-01-19T03:58:32Z", # "OrderStatus": "Unshipped", # "FulfillmentChannel": "MFN", # "SalesChannel": "Amazon.com", # "ShipServiceLevel": "Std US D2D Dom", # "OrderTotal": { # "CurrencyCode": "USD", # "Amount": "11.01" # }, # "NumberOfItemsShipped": 0, # "NumberOfItemsUnshipped": 1, # "PaymentMethod": "Other", # "PaymentMethodDetails": [ # "Standard" # ], # "IsReplacementOrder": false, # "MarketplaceId": "ATVPDKIKX0DER", # "ShipmentServiceLevelCategory": "Standard", # "OrderType": "StandardOrder", # "EarliestShipDate": "1970-01-19T03:59:27Z", # "LatestShipDate": "1970-01-19T04:05:13Z", # "EarliestDeliveryDate": "1970-01-19T04:06:39Z", # "LatestDeliveryDate": "1970-01-19T04:15:17Z", # "IsBusinessOrder": false, # "IsPrime": false, # "IsGlobalExpressEnabled": false, # "IsPremiumOrder": false, # "IsSoldByAB": false, # "IsIBA": false, # "DefaultShipFromLocationAddress": { # "Name": "MFNIntegrationTestMerchant", # "AddressLine1": "2201 WESTLAKE AVE", # "City": "SEATTLE", # "StateOrRegion": "WA", # "PostalCode": "98121-2778", # "CountryCode": "US", # "Phone": "+1 480-386-0930 ext. 73824", # "AddressType": "Commercial" # }, # "FulfillmentInstruction": { # "FulfillmentSupplySourceId": "sampleSupplySourceId" # }, # "IsISPU": false, # "IsAccessPointOrder": false, # "AutomatedShippingSettings": { # "HasAutomatedShippingSettings": false # }, # "EasyShipShipmentStatus": "PendingPickUp", # "ElectronicInvoiceStatus": "NotRequired" # } # } # Use this online tool to generate parsing code from sample JSON: # Generate Parsing Code from JSON json = chilkat2.JsonObject() json.LoadSb(sbResponse) AmazonOrderId = json.StringOf("payload.AmazonOrderId") PurchaseDate = json.StringOf("payload.PurchaseDate") LastUpdateDate = json.StringOf("payload.LastUpdateDate") OrderStatus = json.StringOf("payload.OrderStatus") FulfillmentChannel = json.StringOf("payload.FulfillmentChannel") SalesChannel = json.StringOf("payload.SalesChannel") ShipServiceLevel = json.StringOf("payload.ShipServiceLevel") CurrencyCode = json.StringOf("payload.OrderTotal.CurrencyCode") Amount = json.StringOf("payload.OrderTotal.Amount") NumberOfItemsShipped = json.IntOf("payload.NumberOfItemsShipped") NumberOfItemsUnshipped = json.IntOf("payload.NumberOfItemsUnshipped") PaymentMethod = json.StringOf("payload.PaymentMethod") IsReplacementOrder = json.BoolOf("payload.IsReplacementOrder") MarketplaceId = json.StringOf("payload.MarketplaceId") ShipmentServiceLevelCategory = json.StringOf("payload.ShipmentServiceLevelCategory") OrderType = json.StringOf("payload.OrderType") EarliestShipDate = json.StringOf("payload.EarliestShipDate") LatestShipDate = json.StringOf("payload.LatestShipDate") EarliestDeliveryDate = json.StringOf("payload.EarliestDeliveryDate") LatestDeliveryDate = json.StringOf("payload.LatestDeliveryDate") IsBusinessOrder = json.BoolOf("payload.IsBusinessOrder") IsPrime = json.BoolOf("payload.IsPrime") IsGlobalExpressEnabled = json.BoolOf("payload.IsGlobalExpressEnabled") IsPremiumOrder = json.BoolOf("payload.IsPremiumOrder") IsSoldByAB = json.BoolOf("payload.IsSoldByAB") IsIBA = json.BoolOf("payload.IsIBA") Name = json.StringOf("payload.DefaultShipFromLocationAddress.Name") AddressLine1 = json.StringOf("payload.DefaultShipFromLocationAddress.AddressLine1") City = json.StringOf("payload.DefaultShipFromLocationAddress.City") StateOrRegion = json.StringOf("payload.DefaultShipFromLocationAddress.StateOrRegion") PostalCode = json.StringOf("payload.DefaultShipFromLocationAddress.PostalCode") CountryCode = json.StringOf("payload.DefaultShipFromLocationAddress.CountryCode") Phone = json.StringOf("payload.DefaultShipFromLocationAddress.Phone") AddressType = json.StringOf("payload.DefaultShipFromLocationAddress.AddressType") FulfillmentSupplySourceId = json.StringOf("payload.FulfillmentInstruction.FulfillmentSupplySourceId") IsISPU = json.BoolOf("payload.IsISPU") IsAccessPointOrder = json.BoolOf("payload.IsAccessPointOrder") HasAutomatedShippingSettings = json.BoolOf("payload.AutomatedShippingSettings.HasAutomatedShippingSettings") EasyShipShipmentStatus = json.StringOf("payload.EasyShipShipmentStatus") ElectronicInvoiceStatus = json.StringOf("payload.ElectronicInvoiceStatus") i = 0 count_i = json.SizeOfArray("payload.PaymentMethodDetails") while i < count_i : json.I = i strVal = json.StringOf("payload.PaymentMethodDetails[i]") i = i + 1 print("Success!") |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.