---
title: "Export people as CSV"
method: GET
path: "/people.csv"
tags: ["People"]
---

# Export people as CSV

`GET /people.csv`

## Request

- Base URL: `https://api.pipelinecrm.com/api/v3`
- URL: `https://api.pipelinecrm.com/api/v3/people.csv`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer and API key in header `app-key`
  - API key in query parameter `api_key` and API key in query parameter `app_key`

The same list as the JSON endpoint, as a CSV file with the columns the account's list view shows. Accepts the same `conditions` and `sort` parameters; not paginated. Requires the user's export permission.

**Filtered request example** — People at companies named Acme with lead status 2, changed in the last week (as CSV):

```
curl -g -H "Authorization: Bearer pcrm_live_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" \
  "https://api.pipelinecrm.com/api/v3/people.csv?conditions[person_company_name]=Acme&conditions[person_status][]=2&conditions[person_modified][selection]=last_7&sort=person_last_name&per_page=100"
```

## Query parameters

- `conditions` PersonConditions
  - `lead_source` integer: Returns records associated to the [Lead source](#tag/lead-sources) with this ID
  - `person_all_emails` string: Any of the person's email addresses (work, home, secondary) equals this value exactly. Several values may be given.
  - `person_bounced` 'Yes' | 'No': Returns records with the given bounced state
  - `person_city` string: Returns records that match a `LIKE` query on the city field
  - `person_company_id` union: One id, several ids as repeated `[]=` parameters, or a comma-separated list.
    - integer
    - string
    - integer[]
  - `person_company_name` string: Returns records that match a `LIKE` query on the name of the associated [Company](#tag/companies)
  - `person_converted` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_converted_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_country` string: Returns records that match a `LIKE` query on the country field
  - `person_created` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_created_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_created_by_user` integer: Returns records created by the [User](#tag/users) with this ID
  - `person_date_of_first_activity` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_days_since_last_activity` union: A numeric range filter: `[from]=1000&[to]=5000` (either bound may be omitted on most fields). Where noted, the literal strings `__NONE__` (field is empty) and `__HAS_VALUE__` (field is set) are also accepted.
    - object
      - `from` number
      - `to` number
    - '__NONE__' | '__HAS_VALUE__'
  - `person_email` string: Returns records that match a `LIKE` query on the email address field
  - `person_email2` string: Returns records that match a `LIKE` query on the other email address field
  - `person_email_in` string: Work email address is exactly one of the given values; several values may be given.
  - `person_fax` string: Returns records that match a `LIKE` query on the `fax` field
  - `person_first_name` string: Returns records that match a `LIKE` query on the `first_name` field
  - `person_full_name` string: Returns records that match a `LIKE` query on the full name (combination of `first_name` and `last_name` fields)
  - `person_home_address_1` string: Returns records that match a `LIKE` query on the home address 1 field
  - `person_home_address_2` string: Returns records that match a `LIKE` query on the home address 2 field
  - `person_home_city` string: Returns records that match a `LIKE` query on the home city field
  - `person_home_country` string: Returns records that match a `LIKE` query on the home country field
  - `person_home_email` string: Returns records that match a `LIKE` query on the home email address field
  - `person_home_phone` string: Returns records that match a `LIKE` query on the `home_phone` field
  - `person_home_state` string: Returns records that match a `LIKE` query on the home state field
  - `person_home_zip` string: Returns records that match a `LIKE` query on the home zip code field
  - `person_hours_to_first_activity` union: A numeric range filter: `[from]=1000&[to]=5000` (either bound may be omitted on most fields). Where noted, the literal strings `__NONE__` (field is empty) and `__HAS_VALUE__` (field is set) are also accepted.
    - object
      - `from` number
      - `to` number
    - '__NONE__' | '__HAS_VALUE__'
  - `person_id` integer: Returns records with this [Person](#tag/people) ID
  - `person_id_not` union: One id, several ids as repeated `[]=` parameters, or a comma-separated list.
    - integer
    - string
    - integer[]
  - `person_import_name` string: Returns records that match a `LIKE` query on the import name field
  - `person_imported_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_is_key_contact` 'Yes' | 'No': Returns records with the given key contact state
  - `person_last_emailed_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_last_name` string: Returns records that match a `LIKE` query on the `last_name` field
  - `person_linked_in_url` string: LinkedIn URL contains this text.
  - `person_mobile` string: Returns records that match a `LIKE` query on the `mobile` field
  - `person_modified` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_name` string: Returns records that match a `LIKE` query on the `first_name` or `last_name` fields
  - `person_owner` integer: Returns records owned by the [User](#tag/users) with this ID
  - `person_owner_team` integer: Returns records owned by members of the team with this ID
  - `person_phone` string: Returns records that match a `LIKE` query on the `phone` field
  - `person_phones` string: Returns records that match a `LIKE` query on the `phone`, `home_phone` or `mobile` field
  - `person_phones_contains` string: Any of the person's phone numbers contains these digits; formatting characters are ignored.
  - `person_position` string: Returns records that match a `LIKE` query on the position field
  - `person_relationship` string: Returns records that match a `LIKE` query on the relationship field
  - `person_shared_with` integer[]: Returns records shared with the [Users](#tag/users) with these ID
  - `person_simple_search` string: Returns records that match a `LIKE` query on `first_name`, `last_name`, `email` or associated [Company](#tag/companies) name
  - `person_source` union: One id, several ids as repeated `[]=` parameters, or a comma-separated list.
    - integer
    - string
    - integer[]
  - `person_state` string: Returns records whose work state starts with this value. A US state name and its two-letter code match each other (`Texas` also returns `TX`)
  - `person_status` integer: Returns records associated to the [Lead status](#tag/lead-statuses) with this ID
  - `person_summary` string: Returns records that match a `LIKE` query on the summary field
  - `person_tag_names` string[]: Returns records that match a `LIKE` query on the tag names
  - `person_tags` integer[]: Returns records associated to the [tags](#tag/predefined-contacts-tags) with these IDs
  - `person_type` 'Lead' | 'Contact': Returns records of the specified type - either `Contact` or `Lead`
  - `person_unsubscribed` 'Yes' | 'No': Returns records with the given unsubscribed state
  - `person_updated_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_viewed_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `person_website` string: Returns records that match a `LIKE` query on the website field
  - `person_work_address_1` string: Returns records that match a `LIKE` query on the work address 1 field
  - `person_work_address_2` string: Returns records that match a `LIKE` query on the work address 2 field
  - `person_work_zip` string: Work postal code starts with this text. Alias of person_zip.
  - `person_zip` string: Returns records that match a `LIKE` query on the zip code field
  - `company_address` string: Return records that have an address that exactly matches or starts with the provided string
  - `company_address2` string: Return records that have a secondary address that exactly matches or starts with the provided string
  - `company_city` string: Return records that have a city that exactly matches or starts with the provided string
  - `company_country` string: Country starts with this text (case-insensitive).
  - `company_created` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_created_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_created_by_user` integer: Return records that were created by the given user
  - `company_description` string: Return records that have a description that exactly matches or starts with the provided string
  - `company_email` string: Return records that have an email that exactly matches or starts with the provided string
  - `company_fax` string: Return records that have a fax number that exactly matches or starts with the provided string
  - `company_id` integer: The company with given company_id. Note: you can specify a comma-separated list of ids to retrieve more companies at once
  - `company_id_not` union: One id, several ids as repeated `[]=` parameters, or a comma-separated list.
    - integer
    - string
    - integer[]
  - `company_import_name` string: Return records that have an import name that exactly matches or starts with the provided string
  - `company_imported_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_is_customer` 'Yes' | 'No': Return records that are customers
  - `company_linked_in_url` string: LinkedIn URL contains this text.
  - `company_modified` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_name` string: Return records that have a name that exactly matches or starts with the provided string
  - `company_name_eq` string: Return records that have a name that exactly matches the provided string
  - `company_owner` integer: Return records that have an owner with the given ID
  - `company_owner_team` integer: Return records that have an owner in the given team
  - `company_phone` string: Return records that have a phone number that exactly matches or starts with the provided string
  - `company_phone2` string: Second phone number contains these digits; formatting characters are ignored.
  - `company_phone3` string: Third phone number contains these digits; formatting characters are ignored.
  - `company_phone4` string: Fourth phone number contains these digits; formatting characters are ignored.
  - `company_phones_contains` string: Any of the company's phone numbers contains these digits; formatting characters are ignored.
  - `company_shared_with` integer[]: Return records that have been shared with the given users
  - `company_state` string: Return records that have a state that exactly matches or starts with the provided string
  - `company_tags` integer[]: Return records that have the given tag IDs
  - `company_total_pipeline` union: A numeric range filter: `[from]=1000&[to]=5000` (either bound may be omitted on most fields). Where noted, the literal strings `__NONE__` (field is empty) and `__HAS_VALUE__` (field is set) are also accepted.
    - object
      - `from` number
      - `to` number
    - '__NONE__' | '__HAS_VALUE__'
  - `company_updated` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_updated_at` union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
    - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
    - object: An explicit range. Either bound may be omitted.
      - `from_date` string, date
      - `to_date` string, date
    - object: A relative period counted in whole units.
      - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
      - `duration` integer, required
  - `company_web` string: Return records that have a website that exactly matches or starts with the provided string
  - `company_won_value` union: A numeric range filter: `[from]=1000&[to]=5000` (either bound may be omitted on most fields). Where noted, the literal strings `__NONE__` (field is empty) and `__HAS_VALUE__` (field is set) are also accepted.
    - object
      - `from` number
      - `to` number
    - '__NONE__' | '__HAS_VALUE__'
  - `company_worked_on_by` integer: Return records that have been worked on by the given user
  - `company_zip` string: Return records that have a postal code that exactly matches or starts with the provided string
  - `customer_days_in_health` union: A numeric range filter: `[from]=1000&[to]=5000` (either bound may be omitted on most fields). Where noted, the literal strings `__NONE__` (field is empty) and `__HAS_VALUE__` (field is set) are also accepted.
    - object
      - `from` number
      - `to` number
    - '__NONE__' | '__HAS_VALUE__'
  - `customer_health_score` integer: Return records that have a customer health score that exactly matches the provided integer
  - `next_milestone_due` union: A filter on a calendar date (no time of day). Takes every form a date range filter takes: a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`. It also takes `[selection]=upcoming_anniversary&[duration]=30`, which matches dates whose month and day fall in the next 30 days of any year, such as birthdays.
    - union: A date or datetime filter. Send ONE of the forms below (see the Filtering guide): a single day `2026-01-15`; a bounded range `[from_date]=2026-01-01&[to_date]=2026-03-31` (either side optional); a relative period `[selection]=last_30` or `[selection]=this_quarter`; or a relative count `[selection]=last_x_days&[duration]=14`.
      - string: A single day (`YYYY-MM-DD`) or a relative period keyword such as `today`, `yesterday`, `this_week`, `last_week`, `next_week`, `this_month`, `last_month`, `next_month`, `this_quarter`, `last_quarter`, `next_quarter`, `this_year`, `last_year`, `year_to_date`, `last_7`, `last_30`, `last_60`, `last_90`, `next_7`, `next_30`, `next_60`, `next_90`, `last_3_months`, `next_3_months`, `last_6_months`, `next_6_months`, `last_12_months`, `next_12_months`, `past_due`, `future`.
      - object: An explicit range. Either bound may be omitted.
        - `from_date` string, date
        - `to_date` string, date
      - object: A relative period counted in whole units.
        - `selection` 'last_x_days' | 'next_x_days' | 'last_x_weeks' | 'next_x_weeks' | 'last_x_months' | 'next_x_months' | 'last_x_quarters' | 'next_x_quarters' | 'last_x_years' | 'next_x_years' | 'older_than', required
        - `duration` integer, required
    - object: Month and day within the next `duration` days, in any year (birthdays, anniversaries). `duration` 0 means today; values above 365 are treated as 365.
      - `selection` 'upcoming_anniversary', required
      - `duration` integer, required
  - `next_milestone_name` string: The customer's next milestone name contains this text.
  - `next_milestone_status` string: The customer's next milestone has this status: `not_started`, `in_progress`, `blocked` or `complete`, or the number it is stored as (0 to 3). The next milestone is the earliest one not yet complete, so `complete` normally matches nothing. `none` or `__NONE__` matches customers with no next milestone, `__HAS_VALUE__` those with one; any other value matches nothing.
- `sort` string

## Response `200`

CSV file

## Other responses

- `403`: The credentials are valid but this user may not perform the action (permissions, a read-only token, or API access switched off).

---

[API](https://skmtc.dev/pipelinecrm/apis/pipeline-crm-api.md) · [All operations](https://skmtc.dev/pipelinecrm/apis/pipeline-crm-api/llms.txt) · [OpenAPI document](https://skmtc.dev/pipelinecrm/apis/pipeline-crm-api/revisions/53ebfcc83597?raw)