# Search and Read Records — Odoo

> Search and read records from Odoo. See the documentation

- Key: `odoo-search-read-records`
- Type: Action (Read-only)
- Version: 1.0.2
- App: Odoo (`odoo`) — https://pipedream.com/apps/odoo.md
- This page (HTML): https://pipedream.com/apps/odoo/actions/search-read-records
- Hints: read-only · open-world
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/odoo/actions/search-read-records/search-read-records.mjs

## Description

Search and read records from Odoo. [See the documentation](https://www.odoo.com/documentation/18.0/developer/reference/external_api.html#search-and-read)

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `modelName` | `string` | Yes | The technical name of the Odoo model to interact with (e.g. res.partner, helpdesk.ticket, sale.order, crm.lead). Use the List Models action to get the model name. Options are loaded from the connected account. |
| `domain` | `string` | No | Odoo search domain as JSON. Single-condition examples: phone contains 555 -> ["phone", "ilike", "555"]; email contains acme.com -> ["email", "ilike", "acme.com"]; companies only -> ["is_company", "=", true]. Use a full domain array for multiple conditions. Logical operators apply to the criteria that follow them, so use ["\|", ["id", "=", 7583], ["id", "=", 7584]] for a two-condition OR. See domain docs. |
| `fields` | `string[]` | Yes | The fields to return in the results. If not provided, all fields will be returned. Options are loaded from the connected account. |
| `limit` | `integer` | No | Maximum number of records to return. |
| `offset` | `integer` | No | Number of records to skip before returning results. |
| `order` | `string` | No | Sort order (e.g. write_date desc, name asc). |

## 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": "odoo",
      },
    },
  },
)

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: "odoo-search-read-records",
  arguments: {
    modelName: "Model Name",
    domain: "Search Domain",
  },
})
```

**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: "odoo-search-read-records",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    odoo: { authProvisionId: "apn_xxxxxxx" },
    modelName: "Model Name",
    domain: "Search Domain",
  },
})

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": "odoo-search-read-records",
    "configured_props": {
      "odoo": { "authProvisionId": "apn_xxxxxxx" },
      "modelName": "Model Name",
      "domain": "Search Domain"
    }
  }'
```

---

- App: https://pipedream.com/apps/odoo.md · All apps: https://pipedream.com/apps