[Cotlet](https://cotlet.dev/index.md) · [Integrations](https://cotlet.dev/integrations.md) · [How it works](https://cotlet.dev/how-it-works.md) · [Use cases](https://cotlet.dev/use-cases.md) · [Security](https://cotlet.dev/security.md) · [For developers](https://cotlet.dev/for-developers.md) · [For automation agencies](https://cotlet.dev/for-agencies.md) · [Blog](https://cotlet.dev/blog.md) · [API docs](https://cotlet.dev/docs.md) · [Help center](https://cotlet.dev/help.md) · [Changelog](https://cotlet.dev/changelog.md) · [Contact](https://cotlet.dev/contact.md) · [Pricing](https://cotlet.dev/pricing.md) · [Sign up](https://cotlet.dev/signup)

# Run saved query

> Runs a saved query and returns its rows. Inputs, cURL, Python and Node.js examples and an example response.

Source: https://cotlet.dev/docs/api/peoplehr/run_query

Docs sections: [Get started](https://cotlet.dev/docs.md) · [REST API](https://cotlet.dev/docs/api.md) · [MCP](https://cotlet.dev/docs/mcp.md) · [SDKs & CLI](https://cotlet.dev/docs/sdks.md) · [Integrations](https://cotlet.dev/docs/integrations.md)

Runs a saved query and returns its rows.

PeopleHR API: https://cotlet.dev/docs/api/peoplehr.md

`GET https://cotlet.dev/api/v1/peoplehr/queries/run`

Access: read.

Returns the columns of the query and its rows as PeopleHR shows them, the same data the Export to CSV button gives. Dates keep the format PeopleHR uses in the result. It reads only and changes nothing.

## Parameters

| Name | Type | Required | Description |
|---|---|---|---|
| `name` | string | yes | Exact name from list_queries. |
| `cursor` | string | no | Next page cursor from the previous call. |

## Request

**cURL**

```bash
curl "https://cotlet.dev/api/v1/peoplehr/queries/run?name=Jane+Doe" \
  -H "Authorization: Bearer $COTLET_API_KEY"
```

**Python**

```python
result = client.call("peoplehr", "run_query", {"name":"Jane Doe"})
```

**Node.js**

```js
const result = await cotlet.call('peoplehr', 'run_query', {"name":"Jane Doe"});
```

**CLI**

```bash
cotlet call peoplehr run_query --data '{"name":"Jane Doe"}'
```

## Example response

```json
{
  "name": "Probation ending soon",
  "columns": [
    "Employee",
    "Probation End Date",
    "Probation Status"
  ],
  "rows": [
    [
      "Ana Lopez",
      "2027-02-16",
      "In probation"
    ],
    [
      "Jake Ortiz",
      "2026-12-04",
      "In probation"
    ]
  ],
  "next_cursor": null
}
```

Previous: [List saved queries](https://cotlet.dev/docs/api/peoplehr/list_queries.md)
Next: [Approve holiday request](https://cotlet.dev/docs/api/peoplehr/approve_holiday_request.md)

---

Give your AI agents your signed-in browser.

**Product:** [Integrations](https://cotlet.dev/integrations.md) · [Use cases](https://cotlet.dev/use-cases.md) · [How it works](https://cotlet.dev/how-it-works.md) · [Pricing](https://cotlet.dev/pricing.md) · [Security](https://cotlet.dev/security.md)

**Resources:** [Blog](https://cotlet.dev/blog.md) · [API docs](https://cotlet.dev/docs.md) · [Help center](https://cotlet.dev/help.md) · [Changelog](https://cotlet.dev/changelog.md) · [GitHub](https://github.com/cotletdev/cotlet)

**Solutions:** [For developers](https://cotlet.dev/for-developers.md) · [For automation agencies](https://cotlet.dev/for-agencies.md)

**Company:** [About](https://cotlet.dev/about.md) · [AI info: company facts](https://cotlet.dev/ai-info.md) · [Contact](https://cotlet.dev/contact.md)

**Legal:** [Terms of service](https://cotlet.dev/terms) · [Privacy policy](https://cotlet.dev/privacy) · [Refund policy](https://cotlet.dev/refunds) · [Acceptable use](https://cotlet.dev/acceptable-use) · [Cookie policy](https://cotlet.dev/cookies) · [DPA](https://cotlet.dev/dpa) · [Subprocessors](https://cotlet.dev/subprocessors)

**Elsewhere:** [Status page](https://status.cotlet.dev) · [Cotlet on GitHub](https://github.com/cotletdev) · [Cotlet on X](https://x.com/cotletdev) · [Cotlet on LinkedIn](https://www.linkedin.com/company/cotletdev) · [Cotlet on Product Hunt](https://www.producthunt.com/products/cotlet) · [Cotlet on Crunchbase](https://www.crunchbase.com/organization/cotlet) · [Cotlet on SaaSHub](https://www.saashub.com/cotlet)

Cotlet is an independent service. It is not affiliated with, endorsed by or sponsored by any of the products listed on this site. Product names are trademarks of their respective owners.

## For AI agents: sign your user up

Is your user asking you to sign them up for Cotlet? You can do it for them, no account or key needed.

1. Read the fields and their allowed values: GET https://cotlet.dev/api/v1/access-requests
2. Ask the user for each value: email, apps, what you will do with them. If they leave the password to you, generate a strong one and show it to them.
3. Show the user what you will send, then POST it as JSON to https://cotlet.dev/api/v1/access-requests.

One call creates the account and sends the access request; we email the user when access is granted.