Back to catalog

People Data Labs · Enrichment

People Data Labs / Search people with SQL or a query

Structured search over People Data Labs' person 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 person records. Priced per record returned.

Private Gateway connection

Data below comes from the configured private Gateway. Provider activation remains governed by its evidence and policy gates.

unverifiedRequest shape unavailableUnverified
Published API evidence
Public metadata only. Response bodies, credentials, and internal review notes are never displayed.

No verification date is claimed. No response capture is claimed.

Request parameters

  • data_include query · optional

    A comma-separated string of fields the response should include. Begin the string with - to exclude those fields instead. Use data_include="" to exclude all data. Example: "full_name,emails.address"

  • dataset query · optional

    The dataset category to return records from. Can be multiple comma-separated categories, or 'all'.

  • pretty query · optional

    Whether the output should have human-readable indentation.

  • query query · optional

    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. Example: "{\"query\": {\"term\": {\"job_company_name\": \"people data labs\"}}}"

  • scroll_token query · optional

    An offset key for paginating between batches. Each search response returns a scroll_token that fetches the next `size` records. Example: "104$14.278746"

  • size query · optional

    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 query · optional

    A SQL query of the format: SELECT * FROM person WHERE XXX, where XXX is a standard SQL boolean query involving PDL's person fields. Provide either this or query, not plain text. Example: "SELECT * FROM person WHERE job_company_name='people data labs'"

  • titlecase query · optional

    Setting titlecase to true will titlecase any records returned.

Sign in to run this operation, inspect live eligibility, and see governed execution and audit evidence. Sign in.

People Data Labs / Search people with SQL or a query · looot