People Data Labs / Search companies with SQL or a query

People Data Labs tool people-data-labs-company-search-get on looot: input fields, $0.28 per result, output shape, and code to run it with curl, JavaScript or Python.

Structured search over People Data Labs’ company index, not free text. Send exactly one of sql (a WHERE clause) or query (an Elasticsearch query as JSON); size sets how many records. Returns data, full company records. Priced per record returned.

Tool id: people-data-labs-company-search-get
Provider: People Data Labs
Job: Find companies matching a filter (company.search)
Price: $0.28 per result. A call that fails at the provider costs $0.

Inputs

Name	Type	Required	Description
`from`	integer	no	An offset value for pagination, 0 to 9999. Pagination can go up to 10,000 records per query; use the response’s total field to see how many records exist for this query.
`pretty`	boolean	no	Whether the output should have human-readable indentation.
`query`	string	no	An Elasticsearch (v7.7) query object, as a JSON string. Provide either this or sql, not plain text. See PDL’s Elasticsearch mapping reference for the full field list.
`scroll_token`	string	no	An offset key for paginating between batches. Each search response returns a scroll_token that fetches the next `size` records.
`size`	integer	no	The number of matched records to return, between 1 and 100 at PDL, capped at 3 here per this seed’s request-size limit.
`sql`	string	no	A SQL query of the format: SELECT * FROM company WHERE XXX, where XXX is a standard SQL boolean query involving PDL’s company fields. Any column selection or LIMIT keyword is ignored by PDL. Provide either this or query, not plain text.
`titlecase`	boolean	no	Setting titlecase to true will titlecase any records returned.

Output

Shape of the run’s result, checked against 1 real answer:

{ data: { id, sic: { sic_code, major_group, industry_group, industry_sector }[], name, size, tags: string[], type, naics: { sector, naics_code, sub_sector, industry_group, naics_industry, national_industry }[], ticker, founded, summary, website, headline, industry, location: { geo, name, metro, region, country, locality, continent, postal_code, address_line_2, street_address }, profiles: string[], industry_v2, linkedin_id, twitter_url, display_name, facebook_url, linkedin_url, mic_exchange, linkedin_slug, employee_count, funding_stages: string[], dataset_version, alternative_names: string[], l... ...

The shape is cut here. Signed in, looot inspect people-data-labs-company-search-get prints all of it.

Run it

Every call needs your API token in LOOOT_TOKEN; Sign in shows how to get one. Each run also needs a new idempotency key, so a retry never pays twice. With wait: 30 the answer comes back inline when the run ends within 30 seconds. Otherwise you get the running run back: poll GET /v1/runs/<runId>.

Example input with placeholder values:

curl -X POST "https://api.looot.ai/v1/runs" \
  -H "Authorization: Bearer $LOOOT_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{"endpointId":"people-data-labs-company-search-get","input":{"scroll_token":"<scroll_token>"},"wait":30}'

const response = await fetch("https://api.looot.ai/v1/runs", {
  method: "POST",
  headers: {
    Authorization: `Bearer ${process.env.LOOOT_TOKEN}`,
    "Content-Type": "application/json",
    "Idempotency-Key": crypto.randomUUID(),
  },
  body: JSON.stringify({
    endpointId: "people-data-labs-company-search-get",
    input: {
      scroll_token: "<scroll_token>",
    },
    wait: 30,
  }),
});
const run = await response.json();
console.log(run.status, run.result);

import os
import uuid

import requests

response = requests.post(
    "https://api.looot.ai/v1/runs",
    headers={
        "Authorization": f"Bearer {os.environ['LOOOT_TOKEN']}",
        "Idempotency-Key": str(uuid.uuid4()),
    },
    json={
        "endpointId": "people-data-labs-company-search-get",
        "input": {
            "scroll_token": "<scroll_token>",
        },
        "wait": 30,
    },
    timeout=90,
)
run = response.json()
print(run["status"], run.get("result"))

To let looot pick among every provider of this job instead, send job:company.search as endpointId; see the job page.