Get Companies
Retrieve a paginated list of companies. By default, only basic company data is returned with relationship IDs. Use the ‘include’ parameter to get detailed relationship data.
Complex Usage Example
Advanced Company Filtering with Full Context
This example demonstrates advanced filtering with multiple parameters, relationship inclusion, business entity filtering, sorting, and pagination for retrieving companies:- Include relationships: Retrieve complete data for people, workspaces, contact information, and documents
- Filter by workspace: Limit to companies in a specific workspace
- Search by name: Find companies with “TechCorp” in their name
- Filter by business entity: Only show German GmbH companies
- Registration filtering: Filter by tax ID and registration numbers
- Geographic filtering: Limit to companies in Germany
- Contact filtering: Find companies with specific email or phone
- Media filtering: Only show companies with logos
- Date range filtering: Limit to companies created/updated in specific periods
- Sorting: Order by creation date (newest first)
- Pagination: Get 25 results per page with cursor-based pagination
Filtering & sorting on related objects
Filter and sort on a related (included) object by nesting into the relationship — the same relationships you pass toinclude.
- To-one relations nest directly:
{ "issuer": { "name": { "_eq": "Acme" } } }, and sort by a dot-path:"orderBy": { "field": "issuer.name", "direction": "asc" }. - To-many relations must be quantified with
_some,_every, or_none:{ "items": { "_some": { "quantity": { "_gt": 1 } } } }. They are not directly sortable (a to-many sort needs an aggregate proxy). - Composite
composite_*columns are virtual — filter and sort on their underlying source fields, not on the composite.
include) and how to filter or sort on each:
| Relationship | Cardinality | Filter on a field | Sort by a field |
|---|---|---|---|
workspace | to-one (workspace) | { "workspace": { "name": { "_eq": … } } } | "field": "workspace.name" ✅ |
source_workspace_connector | to-one (workspace_connector) | { "source_workspace_connector": { "name": { "_eq": … } } } | "field": "source_workspace_connector.name" ✅ |
relations | to-many (company_relation) | { "relations": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
people | to-many (company_person) | { "people": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
social_links | to-many (company_web_link) | { "social_links": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
locations | to-many (company_location) | { "locations": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
emails | to-many (company_email) | { "emails": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
phones | to-many (company_phone) | { "phones": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
categories | to-many (company_category) | { "categories": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
media | to-many (company_media) | { "media": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
company_financial | to-one (company_financial) | { "company_financial": { "field_name": { "_eq": … } } } | "field": "company_financial.field_name" ✅ |
company_workspace_connectors | to-many (company_workspace_connector) | { "company_workspace_connectors": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
field_name with any field of the related object. See its object-reference page for the full field list.
Filter by a to-one relation (and sort by it):
Headers
Bearer token for authentication
Query Parameters
Include detailed relationship data in the response. Comma-separated values supported.
workspace, company, people, documents, created_by, medias, web_links, emails, phones, categories, locations, people, parents, subsidiaries Filter companies created on or after this date
Filter companies created on or before this date
Filter companies updated on or after this date
Filter companies updated on or before this date
Filter companies by creator ID(s)
Filter companies by workspace ID(s)
Filter companies by external workspace ID(s)
Filter companies by email address(es)
Filter companies by phone number(s)
Filter companies by parent registration number(s)
Filter companies by associated document ID(s)
Filter companies by parent company ID(s)
Filter companies by parent company tax ID value(s)
Filter companies by parent company registration value(s)
Filter companies by primary domain URL(s)
Sort companies by field. Use - prefix for descending order.
created_at, -created_at, updated_at, -updated_at, issue_date, -issue_date, due_date, -due_date