(C#) Amazon SP-API Get Orders

See more Amazon SP-API Examples

Demonstrates Amazon SP-API Sellers API -- get orders. Returns orders created or updated during the time frame indicated by the specified parameters.

For more information, see https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#getorders

Chilkat .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// IMPORTANT:
// You'll need to make changes to use values specific to your own region and account.
// 
// Here is a list of values you'll need to change or provide:
// 
// 1) The access key. Change AWS_ACCESS_KEY to your actual access key.
// 2) The secret key. Change AWS_SECRET_KEY to your actual access key.
// 3) Your region.  Change "ew-west-1" to your region.
// 4) The domain to which you connect.  Change sandbox.sellingpartnerapi-eu.amazon.com to non-sandbox by removing the "sandbox." 
//    and change the "-eu" part of the domain to your region. See https://developer-docs.amazon.com/sp-api/docs/sp-api-endpoints
// 5) Use the restricted data token (RDT) obtained from your code that previously obtained the RDT.
// 	If you saved the RDT to a file, update the relative file path "qa_data/tokens/sp_api_rdt_token.json" to your actual file path.
// 6) Update your Marketplace ID(s), such as ATVPDKIKX0DER
// 7) If using the non-sandbox, change the CreatedAfter from "TEST_CASE_200" to an actual date, such as "2022-12-25"

Chilkat.AuthAws authAws = new 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";

Chilkat.Rest rest = new Chilkat.Rest();
bool bTls = true;
int port = 443;
bool bAutoReconnect = true;
// Make sure to use the correct domain.
// This example is using the sandbox
bool success = rest.Connect("sandbox.sellingpartnerapi-eu.amazon.com",port,bTls,bAutoReconnect);
if (success == false) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

success = rest.SetAuthAws(authAws);

// Here's the example to get the RDT access token: Get SP-API Restricted Data Token

// Load the previously obtained RDT access token.
// See Fetch SP-API RDT Access Token
Chilkat.JsonObject jsonToken = new Chilkat.JsonObject();
success = jsonToken.LoadFile("qa_data/tokens/sp_api_rdt_token.json");
if (success == false) {
    Debug.WriteLine("Failed to load RDT access token.");
    return;
}

// Add the x-amz-access-token request header.
string rdt_token = jsonToken.StringOf("restrictedDataToken");
rest.ClearAllHeaders();
rest.AddHeader("x-amz-access-token",rdt_token);

// Indicate the marketplace IDs.  Use the marketplace ID for your needs. See https://developer-docs.amazon.com/sp-api/docs/marketplace-ids
rest.ClearAllQueryParams();
// When using the sandbox, use these params literally and exactly has shown here:
rest.AddQueryParam("MarketplaceIds","ATVPDKIKX0DER");
rest.AddQueryParam("CreatedAfter","TEST_CASE_200");

Chilkat.StringBuilder sbResponse = new Chilkat.StringBuilder();
string uri = "/orders/v0/orders";
success = rest.FullRequestNoBodySb("GET",uri,sbResponse);
if (success == false) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

// Examine the response status.
int statusCode = rest.ResponseStatusCode;
if (statusCode != 200) {
    Debug.WriteLine("Response status text: " + rest.ResponseStatusText);
    Debug.WriteLine("Response body: ");
    Debug.WriteLine(sbResponse.GetAsString());
    Debug.WriteLine("Failed.");
    return;
}

Debug.WriteLine(sbResponse.GetAsString());

// If successful, gets a JSON response such as the following:

// {
//   "payload": {
//     "CreatedBefore": "1.569521782042E9",
//     "Orders": [
//       {
//         "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"
//       },
//       {
//         "AmazonOrderId": "902-8745147-1934268",
//         "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,
//         "IsAccessPointOrder": false,
//         "IsGlobalExpressEnabled": false,
//         "IsPremiumOrder": false,
//         "IsSoldByAB": false,
//         "IsIBA": false,
//         "EasyShipShipmentStatus": "PendingPickUp",
//         "ElectronicInvoiceStatus": "NotRequired"
//       }
//     ]
//   }
// }

// Use this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON

Chilkat.JsonObject json = new Chilkat.JsonObject();

json.LoadSb(sbResponse);

string AmazonOrderId;
string PurchaseDate;
string LastUpdateDate;
string OrderStatus;
string FulfillmentChannel;
string SalesChannel;
string ShipServiceLevel;
string CurrencyCode;
string Amount;
int NumberOfItemsShipped;
int NumberOfItemsUnshipped;
string PaymentMethod;
bool IsReplacementOrder;
string MarketplaceId;
string ShipmentServiceLevelCategory;
string OrderType;
string EarliestShipDate;
string LatestShipDate;
string EarliestDeliveryDate;
string LatestDeliveryDate;
bool IsBusinessOrder;
bool IsPrime;
bool IsGlobalExpressEnabled;
bool IsPremiumOrder;
bool IsSoldByAB;
bool IsIBA;
string Name;
string AddressLine1;
string City;
string StateOrRegion;
string PostalCode;
string CountryCode;
string Phone;
string AddressType;
string FulfillmentSupplySourceId;
bool IsISPU;
bool IsAccessPointOrder;
bool HasAutomatedShippingSettings;
string EasyShipShipmentStatus;
string ElectronicInvoiceStatus;
int j;
int count_j;
string strVal;

string CreatedBefore = json.StringOf("payload.CreatedBefore");
int i = 0;
int count_i = json.SizeOfArray("payload.Orders");
while (i < count_i) {
    json.I = i;
    AmazonOrderId = json.StringOf("payload.Orders[i].AmazonOrderId");
    PurchaseDate = json.StringOf("payload.Orders[i].PurchaseDate");
    LastUpdateDate = json.StringOf("payload.Orders[i].LastUpdateDate");
    OrderStatus = json.StringOf("payload.Orders[i].OrderStatus");
    FulfillmentChannel = json.StringOf("payload.Orders[i].FulfillmentChannel");
    SalesChannel = json.StringOf("payload.Orders[i].SalesChannel");
    ShipServiceLevel = json.StringOf("payload.Orders[i].ShipServiceLevel");
    CurrencyCode = json.StringOf("payload.Orders[i].OrderTotal.CurrencyCode");
    Amount = json.StringOf("payload.Orders[i].OrderTotal.Amount");
    NumberOfItemsShipped = json.IntOf("payload.Orders[i].NumberOfItemsShipped");
    NumberOfItemsUnshipped = json.IntOf("payload.Orders[i].NumberOfItemsUnshipped");
    PaymentMethod = json.StringOf("payload.Orders[i].PaymentMethod");
    IsReplacementOrder = json.BoolOf("payload.Orders[i].IsReplacementOrder");
    MarketplaceId = json.StringOf("payload.Orders[i].MarketplaceId");
    ShipmentServiceLevelCategory = json.StringOf("payload.Orders[i].ShipmentServiceLevelCategory");
    OrderType = json.StringOf("payload.Orders[i].OrderType");
    EarliestShipDate = json.StringOf("payload.Orders[i].EarliestShipDate");
    LatestShipDate = json.StringOf("payload.Orders[i].LatestShipDate");
    EarliestDeliveryDate = json.StringOf("payload.Orders[i].EarliestDeliveryDate");
    LatestDeliveryDate = json.StringOf("payload.Orders[i].LatestDeliveryDate");
    IsBusinessOrder = json.BoolOf("payload.Orders[i].IsBusinessOrder");
    IsPrime = json.BoolOf("payload.Orders[i].IsPrime");
    IsGlobalExpressEnabled = json.BoolOf("payload.Orders[i].IsGlobalExpressEnabled");
    IsPremiumOrder = json.BoolOf("payload.Orders[i].IsPremiumOrder");
    IsSoldByAB = json.BoolOf("payload.Orders[i].IsSoldByAB");
    IsIBA = json.BoolOf("payload.Orders[i].IsIBA");
    Name = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.Name");
    AddressLine1 = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.AddressLine1");
    City = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.City");
    StateOrRegion = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.StateOrRegion");
    PostalCode = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.PostalCode");
    CountryCode = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.CountryCode");
    Phone = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.Phone");
    AddressType = json.StringOf("payload.Orders[i].DefaultShipFromLocationAddress.AddressType");
    FulfillmentSupplySourceId = json.StringOf("payload.Orders[i].FulfillmentInstruction.FulfillmentSupplySourceId");
    IsISPU = json.BoolOf("payload.Orders[i].IsISPU");
    IsAccessPointOrder = json.BoolOf("payload.Orders[i].IsAccessPointOrder");
    HasAutomatedShippingSettings = json.BoolOf("payload.Orders[i].AutomatedShippingSettings.HasAutomatedShippingSettings");
    EasyShipShipmentStatus = json.StringOf("payload.Orders[i].EasyShipShipmentStatus");
    ElectronicInvoiceStatus = json.StringOf("payload.Orders[i].ElectronicInvoiceStatus");
    j = 0;
    count_j = json.SizeOfArray("payload.Orders[i].PaymentMethodDetails");
    while (j < count_j) {
        json.J = j;
        strVal = json.StringOf("payload.Orders[i].PaymentMethodDetails[j]");
        j = j + 1;
    }

    i = i + 1;
}

Debug.WriteLine("Success!");