Cookie preferences

Choose whether to allow optional cookies. You can change this anytime in Cookie settings.

Always active

Required for security and core site functionality.

Helps us understand how people find and use the site.

Privacy Policy.
NEON DEER DATA LABS Search documentation...

neondeerdata.com
View as Markdown (opens in a new tab)

Query rows

Query rows with filters and select the fields to return.

Request

POST /v1/lookup-tables/{table_id}/rows/query

Finds a table's rows that match every condition you send, one page at a time.

Requires lookup_tables:read. The connection also needs access to the relevant tables, objects, or workflows.

MCP action: query_lookup_rows. Its argument names match the fields below; an HTTP header is passed using its argument name in MCP.

Parameters

Name Send in Required Type or allowed values Notes
table_id path Yes string
filter JSON body No object A condition is {"field": , "eq": } or {"field": , "in": [, ...]}. Use {"and": [...]} to require every condition, or {"or": [...]} to require any of them. eq null matches an empty cell.
filter.field Within the JSON value Within this object string Alternative 1.
filter.eq Within the JSON value Within this object string or number or boolean or object or null Alternative 1. Alternative 1.
filter.eq.objectId Within the JSON value Within this object string (uuid) Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.eq.recordId Within the JSON value Within this object string (uuid) Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.in Within the JSON value Within this object array of string or number or boolean or object Alternative 1. Alternative 2.
filter.in[].objectId Within the JSON value Within this object string (uuid) Alternative 1. Alternative 2. Alternative 4.
filter.in[].recordId Within the JSON value Within this object string (uuid) Alternative 1. Alternative 2. Alternative 4.
filter.and Within the JSON value Within this object array of object Alternative 2. Alternative 1.
filter.and[].field Within the JSON value Within this object string Alternative 2. Alternative 1. Alternative 1.
filter.and[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 1. Alternative 1. Alternative 1.
filter.and[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.and[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.and[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 1. Alternative 1. Alternative 2.
filter.and[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 1. Alternative 2. Alternative 4.
filter.and[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 1. Alternative 2. Alternative 4.
filter.and[].and Within the JSON value Within this object array of object Alternative 2. Alternative 1. Alternative 2. Alternative 1.
filter.and[].and[].field Within the JSON value Within this object string Alternative 2. Alternative 1. Alternative 2. Alternative 1.
filter.and[].and[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 1.
filter.and[].and[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.and[].and[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.and[].and[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 2.
filter.and[].and[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.and[].and[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.and[].or Within the JSON value Within this object array of object Alternative 2. Alternative 1. Alternative 2. Alternative 2.
filter.and[].or[].field Within the JSON value Within this object string Alternative 2. Alternative 1. Alternative 2. Alternative 2.
filter.and[].or[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 1.
filter.and[].or[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 4.
filter.and[].or[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 4.
filter.and[].or[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 2.
filter.and[].or[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 2. Alternative 4.
filter.and[].or[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 1. Alternative 2. Alternative 2. Alternative 2. Alternative 4.
filter.or Within the JSON value Within this object array of object Alternative 2. Alternative 2.
filter.or[].field Within the JSON value Within this object string Alternative 2. Alternative 2. Alternative 1.
filter.or[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 2. Alternative 1. Alternative 1.
filter.or[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.or[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.or[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 2. Alternative 1. Alternative 2.
filter.or[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.or[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.or[].and Within the JSON value Within this object array of object Alternative 2. Alternative 2. Alternative 2. Alternative 1.
filter.or[].and[].field Within the JSON value Within this object string Alternative 2. Alternative 2. Alternative 2. Alternative 1.
filter.or[].and[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 1.
filter.or[].and[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.or[].and[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 1. Alternative 4.
filter.or[].and[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 2.
filter.or[].and[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.or[].and[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 2. Alternative 4.
filter.or[].or Within the JSON value Within this object array of object Alternative 2. Alternative 2. Alternative 2. Alternative 2.
filter.or[].or[].field Within the JSON value Within this object string Alternative 2. Alternative 2. Alternative 2. Alternative 2.
filter.or[].or[].eq Within the JSON value Within this object string or number or boolean or object or null Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 1.
filter.or[].or[].eq.objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 4.
filter.or[].or[].eq.recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 1. Alternative 1. Alternative 4.
filter.or[].or[].in Within the JSON value Within this object array of string or number or boolean or object Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 2.
filter.or[].or[].in[].objectId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 4.
filter.or[].or[].in[].recordId Within the JSON value Within this object string (uuid) Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 2. Alternative 4.
fields JSON body No array of string
limit JSON body No integer
cursor JSON body No string
segment JSON body No integer
total_segments JSON body No integer

Response

HTTP status Result
200 A page of matching rows, in id order.

Required fields are required within their containing object. Notes identify fields that apply only to a particular response alternative.

Response field Type Required in object Notes
data array of object Yes
data[].id string (uuid) Yes
data[].object "lookup_row" Yes
data[].values object Yes
data[].version integer Yes
data[].roster_verified_at string (date-time) No
pagination object Yes
pagination.next_cursor string or null Yes

Errors

HTTP status Meaning
400 One of: invalid_request, invalid_filter, invalid_value, invalid_cursor, credential_in_url.
401 One of: missing_credential, invalid_credential, credential_expired, credential_revoked.
402 One of: payment_overdue.
403 One of: plan_required, not_available, insufficient_scope, operation_not_allowed, field_not_writable, plan_capacity_exceeded.
404 One of: resource_not_found.
409 One of: table_filling, table_fill_failed, lookup_key_required, key_conflict, version_conflict, table_busy, table_capacity_exceeded, idempotency_conflict.
413 One of: request_too_large.
422 One of: batch_rejected.
423 One of: organization_reopening.
428 One of: customer_agreement_required.
429 One of: rate_limited.
503 One of: service_unavailable.

See errors and recovery and safe retries before repeating a write.

The public OpenAPI document lists generally available API families. Alpha operations may not appear in that document; their request and response fields are listed on this page. Use the API Playground to inspect a real response with your connection's access.

Copy section link

Select and copy this link to share the section.