> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/amazon-seller-central/integration-specifications/orders-api.md).

# Orders API

{% hint style="warning" %}
**Only 2 years of history is available through the Amazon Orders API**

If an order is more than 2 years older than the day you begin to load history, we will not be able to retrieve that data because it is not made available through the API ([source](https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#overview)).
{% endhint %}

## Integration Overview

The Daasity Amazon Seller Central integrations utilize the Selling Partner API (SP-API) which is a REST-based API that helps Amazon selling partners programmatically access their data on orders, shipments, payments, and more.

## Integration Availability

This integration is available for:

* Enterprise
* Growth

## API Endpoints

The Daasity Amazon Seller Central - Orders API extractor is built based on this [Amazon Seller Central API documentation](https://developer-docs.amazon.com/sp-api/docs/what-is-the-selling-partner-api). The following endpoints are used by Daasity to replicate data from Amazon Seller Central:

* [Orders API](https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference)

## Entity Relationship Diagram (ERD)

[Click here to view the ERD for the Daasity Amazon Seller Central - Orders API integration](https://lucid.app/documents/embedded/56562bef-d714-4b60-b311-8a45871fa77e) illustrating the different tables and keys to join across tables.

## Amazon Seller Central Schema

The Orders API will generate files in one of three formats (CSV, XML, and JSON). A report might vary slightly for each Seller Central account and thus Daasity will dynamically create the table based on the file extracted from Amazon. Thus each table will be a direct mapping from the file output to the table with no transformation.

* [ASC Orders](#asc-orders)

### **ASC Orders**

* Endpoint: [Orders](https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#getorders)
* Update Method: UPSERT
* Table Name: \
  \[`AMAZON_SELLER_CENTRAL.ASC_ORDERS`]

{% hint style="info" %}
**Limitations:**

* Daasity's default request is hourly.
* Amazon data is updated daily.
  {% endhint %}