# Fetch Orders by Date Range — Selling Partner API (SP-API)

> Retrieves a list of orders based on a specified date range, buyer email, or order ID. See the documentation

- Key: `amazon_selling_partner-fetch-orders-by-date-range`
- Type: Action (Read-only)
- Version: 0.0.4
- App: Selling Partner API (SP-API) (`amazon_selling_partner`) — https://pipedream.com/apps/amazon-selling-partner.md
- This page (HTML): https://pipedream.com/apps/amazon-selling-partner/actions/fetch-orders-by-date-range
- Hints: read-only · open-world
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/amazon_selling_partner/actions/fetch-orders-by-date-range/fetch-orders-by-date-range.mjs

## Description

Retrieves a list of orders based on a specified date range, buyer email, or order ID. [See the documentation](https://developer-docs.amazon.com/sp-api/reference/getorders)

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `marketplaceId` | `string` | Yes | The Amazon Marketplace ID Options are loaded from the connected account. |
| `createdAfter` | `string` | Yes | Fetch orders created after this ISO date. |
| `createdBefore` | `string` | No | Fetch orders created before this ISO date. |
| `buyerEmail` | `string` | No | The email address of a buyer |
| `amazonOrderId` | `string` | No | An order identifier that is specified by the seller. Used to select only the orders that match the order identifier. If SellerOrderId is specified, then FulfillmentChannels, OrderStatuses, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and BuyerEmail cannot be specified. Options are loaded from the connected account. |

## Run it

**MCP**

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "amazon_selling_partner",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// listTools() hands your model this tool's input schema, so it can
// fill the arguments itself:
const result = await mcp.callTool({
  name: "amazon_selling_partner-fetch-orders-by-date-range",
  arguments: {
    marketplaceId: "Marketplace ID",
    createdAfter: "Created After",
  },
})
```

**TypeScript**

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "amazon_selling_partner-fetch-orders-by-date-range",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    amazon_selling_partner: { authProvisionId: "apn_xxxxxxx" },
    marketplaceId: "Marketplace ID",
    createdAfter: "Created After",
  },
})

console.log(result)
```

**cURL**

```bash
curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
  -H "Content-Type: application/json" \
  -H "X-PD-Environment: production" \
  -H "Authorization: Bearer {access_token}" \
  -d '{
    "external_user_id": "{external_user_id}",
    "id": "amazon_selling_partner-fetch-orders-by-date-range",
    "configured_props": {
      "amazon_selling_partner": { "authProvisionId": "apn_xxxxxxx" },
      "marketplaceId": "Marketplace ID",
      "createdAfter": "Created After"
    }
  }'
```

---

- App: https://pipedream.com/apps/amazon-selling-partner.md · All apps: https://pipedream.com/apps