Selling Partner API (SP-API) ACTION
Fetch Orders by Date Range
Retrieves a list of orders based on a specified date range, buyer email, or order ID. See the documentation
- Action
- Read only
- OAuth
- SDK
- MCP
IMPLEMENTATION
Call this tool
Connect a user's Selling Partner API (SP-API) account once, then configure and run Fetch Orders by Date Range from your backend or agent.
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 -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"
}
}'// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
new URL("https://remote.mcp.pipedream.net/v3"),
{
requestInit: {
headers: {
Authorization: `Bearer ${accessToken}`,
"x-pd-project-id": "{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",
},
})SCHEMA
Inputs
Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.
| Property | Type | Description |
|---|---|---|
marketplaceId Marketplace ID | string | The Amazon Marketplace ID Required Dynamic |
createdAfter Created After | string | Fetch orders created after this ISO date. Required |
createdBefore Created Before | string | Fetch orders created before this ISO date. Optional |
buyerEmail Buyer Email | string | The email address of a buyer Optional |
amazonOrderId Seller Order ID | string | 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. Optional Dynamic |
REFERENCE
Tool details
Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.
- Registry key
- amazon_selling_partner-fetch-orders-by-date-range
- Version
- 0.0.4
- App
- Selling Partner API (SP-API)
- Authentication
- OAuth
- Read-only
- Yes
- Destructive
- No
- Open world
- Yes
- Source
- View on GitHub ↗