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
Mimics "is blank" behavior within platform segmentation UI. Below is a list of what
text: empty string OR no value exists
Mimics "is not blank" behavior within platform segmentation UI. Below is a list of what
text: value exists AND not empty string