v1
latestOpenAPI 3.0.32026-07-132612241.2 MBThis view has multiple renderer classes available: json and xlsx. In order to export the data as an excel file, just set query argument format to xlsx.When downloading xlsx format, use Accept header application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; version=...
The user can request what fields and in what order will be rendered using query argument fields. This is a comma separated list of field names used in the API. Available fields are visible in the example. Also metafields can be added to the response. For this just add them as fields, using structure metafields__{metafield.namespace}:{metafield.key}.
When exporting to excel, the column names may be changed based on account metafield names or pre-defined field name and width mapping.
Changes in version 2.2.1:
- field names have been updated to reflect the Task fields schema and filters.
- Invalid fields in fields request will return a ValidationError.
- Account filter is required.
- AccountRole display name is annotated to user objects.
- 'task_event_notes' is dropped.
- 'contact_phone' and 'contact_email' is replaced with 'contact_phones' and 'contact_emails'.
Query parameters
comma separated value
address__apartment_number
address__apartment_number__icontains
address__apartment_number__in
address__apartment_number__iregex
address__apartment_number__istartswith
address__apartment_number__search
address__city
address__city__icontains
address__city__in
address__city__iregex
address__city__istartswith
address__city__search
address__country
address__country__icontains
address__country__in
address__country__iregex
address__country__istartswith
address__country__search
address__country_code
address__country_code__icontains
address__country_code__in
address__country_code__iregex
address__country_code__istartswith
address__country_code__search
address__formatted_address
address__formatted_address__icontains
address__formatted_address__in
address__formatted_address__iregex
address__formatted_address__istartswith
address__formatted_address__search
address__google_place_id
address__google_place_id__icontains
address__google_place_id__in
address__google_place_id__iregex
address__google_place_id__istartswith
address__google_place_id__search
address__house_number
address__house_number__icontains
address__house_number__in
address__house_number__iregex
address__house_number__istartswith
address__house_number__search
address__point_of_interest
address__point_of_interest__icontains
address__point_of_interest__in
address__point_of_interest__iregex
address__point_of_interest__istartswith
address__point_of_interest__search
address__postal_code
address__postal_code__icontains
address__postal_code__in
address__postal_code__iregex
address__postal_code__istartswith
address__postal_code__search
address__raw_address
address__raw_address__icontains
address__raw_address__in
address__raw_address__iregex
address__raw_address__istartswith
address__raw_address__search
address__state
address__state__icontains
address__state__in
address__state__iregex
address__state__istartswith
address__state__search
address__street
address__street__icontains
address__street__in
address__street__iregex
address__street__istartswith
address__street__search
Django ORM lookups can be used. Metafield is_searchable must be True.
address_id
address_id__in
address_id__isnull
assignee__email
assignee__email__icontains
assignee__email__iregex
assignee__email__isnull
assignee__email__istartswith
assignee__email__search
assignee__first_name
assignee__first_name__icontains
assignee__first_name__iregex
assignee__first_name__isnull
assignee__first_name__istartswith
assignee__first_name__search
comma separated value
assignee__last_name
assignee__last_name__icontains
assignee__last_name__iregex
assignee__last_name__isnull
assignee__last_name__istartswith
assignee__last_name__search
assignee__phone
assignee__phone__icontains
assignee__phone__iregex
assignee__phone__isnull
assignee__phone__istartswith
assignee__phone__search
assignee_id
assignee_id__in
assignee_id__isnull
assignee_proximity
assignee_proximity__in
Filter the returned list where all target array values contained in filter values. Comma separated values supported
Filter the returned list where filter_value in field values. Comma separated values supported
Filter the returned list where the array is null
Filter the returned list where at least one filter value in target array. Comma separated values supported
category
category__in
contact__company__icontains
contact__company__in
contact__company__iregex
contact__company__istartswith
contact__company__search
contact__email
contact__email__icontains
contact__email__in
contact__email__iregex
contact__email__istartswith
contact__email__search
Filter the returned list where all target array values contained in filter values. Comma separated emails supported
Filter the returned list where filter_value in field values. Comma separated emails supported
Filter the returned list where the array is null
Filter the returned list where at least one filter value in target array. Comma separated emails supported
contact__name
contact__name__icontains
contact__name__in
contact__name__iregex
contact__name__istartswith
contact__name__search
contact__notes
contact__notes__icontains
contact__notes__in
contact__notes__iregex
contact__notes__istartswith
contact__notes__search
contact__phone
contact__phone__icontains
contact__phone__in
contact__phone__iregex
contact__phone__istartswith
contact__phone__search
Filter the returned list where all target array values contained in filter values. Comma separated values supported
Filter the returned list where filter_value in field values. Comma separated values supported
Filter the returned list where the array is null
Filter the returned list where at least one filter value in target array. Comma separated values supported
Django ORM lookups can be used. Metafield is_searchable must be True.
contact_id
contact_id__in
contact_id__isnull
created_by
created_by__in
created_by__isnull
description
description__icontains
description__iregex
description__istartswith
description__search
duration
duration__gt
duration__gte
duration__lt
duration__lte
external_id
external_id__icontains
external_id__in
external_id__iregex
external_id__isnull
external_id__istartswith
external_id__search
Select fields to be exported. Selected fields will be returned in the requested order. The value should be a comma separated value. When not used, all the fields in the serializer except metafields will be returned
Selects response method. xlsx returns Excel file
id
id__in
is_optimal
is_optimal__isnull
metadata__accepted_distance
metadata__accepted_distance__gt
metadata__accepted_distance__gte
metadata__accepted_distance__lt
metadata__accepted_distance__lte
metadata__accepted_duration
metadata__accepted_duration__gt
metadata__accepted_duration__gte
metadata__accepted_duration__lt
metadata__accepted_duration__lte
metadata__active_distance
metadata__active_distance__gt
metadata__active_distance__gte
metadata__active_distance__lt
metadata__active_distance__lte
metadata__active_duration
metadata__active_duration__gt
metadata__active_duration__gte
metadata__active_duration__lt
metadata__active_duration__lte
metadata__assigned_distance
metadata__assigned_distance__gt
metadata__assigned_distance__gte
metadata__assigned_distance__lt
metadata__assigned_distance__lte
metadata__assigned_duration
metadata__assigned_duration__gt
metadata__assigned_duration__gte
metadata__assigned_duration__lt
metadata__assigned_duration__lte
metadata__cancelled_distance
metadata__cancelled_distance__gt
metadata__cancelled_distance__gte
metadata__cancelled_distance__lt
metadata__cancelled_distance__lte
metadata__cancelled_duration
metadata__cancelled_duration__gt
metadata__cancelled_duration__gte
metadata__cancelled_duration__lt
metadata__cancelled_duration__lte
metadata__completed_distance
metadata__completed_distance__gt
metadata__completed_distance__gte
metadata__completed_distance__lt
metadata__completed_distance__lte
metadata__completed_duration
metadata__completed_duration__gt
metadata__completed_duration__gte
metadata__completed_duration__lt
metadata__completed_duration__lte
metadata__documents_count
metadata__documents_count__gt
metadata__documents_count__gte
metadata__documents_count__lt
metadata__documents_count__lte
metadata__events_count
metadata__events_count__gt
metadata__events_count__gte
metadata__events_count__lt
metadata__events_count__lte
metadata__failed_distance
metadata__failed_distance__gt
metadata__failed_distance__gte
metadata__failed_distance__lt
metadata__failed_distance__lte
metadata__failed_duration
metadata__failed_duration__gt
metadata__failed_duration__gte
metadata__failed_duration__lt
metadata__failed_duration__lte
metadata__forms_completed_count
metadata__forms_completed_count__gt
metadata__forms_completed_count__gte
metadata__forms_completed_count__lt
metadata__forms_completed_count__lte
metadata__forms_count
metadata__forms_count__gt
metadata__forms_count__gte
metadata__forms_count__lt
metadata__forms_count__lte
metadata__signatures_count
metadata__signatures_count__gt
metadata__signatures_count__gte
metadata__signatures_count__lt
metadata__signatures_count__lte
metadata__task_event_notes_count
metadata__task_event_notes_count__gt
metadata__task_event_notes_count__gte
metadata__task_event_notes_count__lt
metadata__task_event_notes_count__lte
metadata__transit_distance
metadata__transit_distance__gt
metadata__transit_distance__gte
metadata__transit_distance__lt
metadata__transit_distance__lte
metadata__transit_duration
metadata__transit_duration__gt
metadata__transit_duration__gte
metadata__transit_duration__lt
metadata__transit_duration__lte
metadata__unassigned_distance
metadata__unassigned_distance__gt
metadata__unassigned_distance__gte
metadata__unassigned_distance__lt
metadata__unassigned_distance__lte
metadata__unassigned_duration
metadata__unassigned_duration__gt
metadata__unassigned_duration__gte
metadata__unassigned_duration__lt
metadata__unassigned_duration__lte
Django ORM lookups can be used. Metafield is_searchable must be True.
order__auto_assign
order__created_by
order__created_by__in
order__created_by__isnull
order__external_id
order__external_id__icontains
order__external_id__in
order__external_id__iregex
order__external_id__isnull
order__external_id__istartswith
order__external_id__search
comma separated value
Django ORM lookups can be used. Metafield is_searchable must be True.
Filter the returned list where all target array values contained in filter values. Comma separated values supported
Filter the returned list where all filter_values are present. Comma separated values supported
Filter the returned list where at least one filter value in target array. Comma separated values supported
Filter the returned list where all target array values contained in filter values. Comma separated values supported
Filter the returned list where all filter_values are present. Comma separated values supported
Filter the returned list where at least one filter value in target array. Comma separated values supported
order__reference
order__reference__icontains
order__reference__in
order__reference__iregex
order__reference__istartswith
order__reference__search
order_id
order_id__in
order_id__isnull
orderer__id
orderer__id__in
orderer__id__isnull
comma separated value
orderer__name
orderer__name__icontains
orderer_id
orderer_id__in
orderer_id__isnull
Which field to use when ordering the results.
owner_id
owner_id__in
owner_id__isnull
A page number within the paginated result set.
Number of results to return per page.
Filter the returned list where all target array values contained in filter values. Comma separated UUID values supported
Filter the returned list where filter_value in field values. Comma separated UUID values supported
Filter the returned list where the array is null
Filter the returned list where at least one filter value in target array. Comma separated UUID values supported
priority
priority__gt
priority__gte
priority__in
priority__lt
priority__lte
comma separated value
receiver_id
receiver_id__in
receiver_id__isnull
reference
reference__icontains
reference__in
reference__iregex
reference__istartswith
reference__search
comma separated value
route_id
route_id__in
route_id__isnull
A search term.
Filter the returned list where all target array values contained in filter values. Comma separated integer values supported
Filter the returned list where filter_value in field values. Comma separated integer values supported
Filter the returned list where the array is null
Filter the returned list where at least one filter value in target array. Comma separated integer values supported
state
comma separated value
unassignee_id
unassignee_id__in
unassignee_id__isnull
Ensures that the last updated data is not immediately available in order to allow the latest changes to finish taking effect. If used, the updated_at upper bound is limited to 2 seconds ago. This prevents the out-of-order appearance of records. Availabe since API version 2.4.13. For older versions, this filter is forced True if updated_at__gt or updated_at__gteis used.