Endpoints that return collections of resources must limit the number of records returned in a given response. The query parameter
limit can be used to alter the number of records returned. A typical endpoint will return 20 records by default and will allow a maximum of 100 records to be returned. The query parameter
offset can be used to offset the result set. These query parameters can be combined to recover all records in a collection through a series of requests by incrementing the
offset by the value of
limit with each request.
limit: The number of results to display in each page (default = 20; max = 100).
offset: The starting point for the result set of a page. This is a zero-based index. For example, if there are 39 total records and the
limitis the default of 20, use
offset=20to get the second page of results.
The total number of results in a collection can be found in the
meta.total property of the response.
orders parameter is available to apply multiple sorting criteria to a request. The parameter is set as an array where the key is the field to sort by and the value is the direction of sort, either
DESC. In the example below the results are first sorted by the schema's label and then sorted by the schema creation timestamp.
Please note that in order to sort records by specific field on that record you will have to define what field you want to order by using the field ID. For example, if you have a record
stripe_order that has a field with an ID of
amount you would use the following format to order results by that field.
filters: All filters will be grouped with AND conditions.
Filtering record root level properties
Filtering Custom Object fields
Filtering Custom Object relationships
- The  section can be omitted in which case the filter will use the default eq operator
|Less than or equal|
|Greater than or equal|
|Contains (accepts |
|Mimics "is blank" behavior within platform segmentation UI. Below is a list of what |
text: empty string OR no value exists
text area: empty string OR no value exists
drop-down: no options present
multi-select: no options present
date: no value exists
date-time: no value exists
number: no value exists
currency: no value exists (for amount)
|Mimics "is not blank" behavior within platform segmentation UI. Below is a list of what |
text: value exists AND not empty string
text area: value exists AND not empty string
drop-down: some sort of option present
multi-select: some sort of option present
date: some sort of non-null value
date-time: some sort of non-null value
number: some sort of non-null value
currency: some sort of non-null value (for amount)