People Data Labs: Company Search

Search companies with structured filters or SQL, such as industry, size and location.

Tool ID: peopledatalabs_company_search

Run this action

Use the TypeScript SDK for one call. Use ctx.tools.execute(...) inside a Play for durable calls, scheduled calls, or CSV processing.

import { Deepline } from 'deepline';

const deepline = await Deepline.connect();
const result = await deepline.tools.execute(
  'peopledatalabs_company_search',
  {
    "query": {},
    "sql": "SELECT * FROM company WHERE location_country=\"united states\" AND website IS NOT NULL",
    "size": 123
  },
);

console.log(result.toolResponse.raw);

CLI

deepline tools execute peopledatalabs_company_search --input '{
  "query": {},
  "sql": "SELECT * FROM company WHERE location_country=\"united states\" AND website IS NOT NULL",
  "size": 123
}' --json

Example response

The SDK returns this shape at result.toolResponse.raw. The example values illustrate the response.

{
  "data": {
    "data": [
      {}
    ],
    "total": 123,
    "scroll_token": "example"
  }
}

Use deepline describe peopledatalabs_company_search --json for the latest machine-readable contract.

Input reference

People Data Labs company search input.

Name	Type	Required	Default	Details
`payload.query`	`record`	No	—	Elasticsearch-style query. Use this OR `sql`, not both. If you are unsure about field names, prefer `sql` with known fields.
`payload.sql`	`string`	No	—	SQL must be in the form `SELECT * FROM company WHERE ...`. Use single quotes for string literals. You must use valid PDL field names and nested subfields (e.g., `location.country`, not `location`). Only `SELECT ` is supported — column selection is not. DO NOT include a `LIMIT` clause. PDL rejects any SQL with `LIMIT` as HTTP 400 (`LIMIT is not supported inside of a SQL query`). Use the `size` input parameter (1–100) to control how many records come back. Example: SELECT FROM company WHERE See the live schema for the complete constraint.
`payload.size`	`integer`	No	—	Number of records to return (1-100).
`payload.scroll_token`	`string`	No	—	Token for retrieving the next page of results.
`payload.titlecase`	`boolean`	No	—	Normalize output text casing.
`payload.data_include`	`string`	No	—	Avoid using data_include unless you want partial fields only.
`payload.pretty`	`boolean`	No	—	Pretty-print response JSON.

Output reference

People Data Labs company search result.

Name	Type	Required	Default	Details
`result.data`	`object`	Yes	—	Provider response payload.
`result.data.data`	`array`	No	—	—
`result.data.total`	`number`	No	—	—
`result.data.scroll_token`	`string \| null`	No	—	—
`result.data.warnings`	`array`	No	—	—
`result.data.error`	`string`	No	—	—
`result.data.status`	`number`	No	—	—
`result.meta`	`record`	No	—	Additional response metadata (status, paging).

Deepline cost

Pricing model: per_result (per result).
Estimated Deepline credits: 1.19 per pricing unit.

​Run this action

​CLI

​Example response

​Input reference

​Output reference

​Deepline cost

​Related documentation

Run this action

CLI

Example response

Input reference

Output reference

Deepline cost

Related documentation