Commerce Tools ACTION
Query Orders
Retrieve Orders in the Project, optionally filtered and sorted. See the documentation.
- Action
- Read only
- OAuth
- SDK
- MCP
IMPLEMENTATION
Call this tool
Connect a user's Commerce Tools account once, then configure and run Query Orders 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: "commerce_tools-query-orders",
externalUserId: "{external_user_id}", // any stable ID for this user in your system
configuredProps: {
commerce_tools: { authProvisionId: "apn_xxxxxxx" },
where: ["Where"],
sort: ["Sort"],
},
})
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": "commerce_tools-query-orders",
"configured_props": {
"commerce_tools": { "authProvisionId": "apn_xxxxxxx" },
"where": ["Where"],
"sort": ["Sort"]
}
}'// 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": "commerce_tools",
},
},
},
)
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: "commerce_tools-query-orders",
arguments: {
where: ["Where"],
sort: ["Sort"],
},
})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 |
|---|---|---|
where Where | string[] | Query Predicate(s) to filter Orders. Multiple predicates are combined with a logical AND. For example, orderState="Open". Optional |
sort Sort | string[] | Sort expression(s). For example, lastModifiedAt desc. Optional |
expand Expand | string[] | Reference Expansion paths to expand in the response. For example, customerGroup. Optional |
limit Limit | integer | The maximum number of Orders to return (max 500). Optional |
offset Offset | integer | The number of results to skip (for pagination). Optional |
withTotal With Total | boolean | Whether to calculate the total number of matching Orders. Set to false to improve performance when the total is not needed. Optional |
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
- commerce_tools-query-orders
- Version
- 0.0.1
- App
- Commerce Tools
- Authentication
- OAuth
- Read-only
- Yes
- Destructive
- No
- Open world
- Yes
- Source
- View on GitHub ↗