Skip to main content
GET
Every import this organisation has run, with its counts and whether it can still be undone.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

id
string
organization_id
string
entity_type
string
entity_label
string
entity_plural
string
template_id
string
parent_batch_id
string
file_id
string
file_name
string
sheet_name
string
header_row
string
status
string
write_mode
string
natural_key_field
string
total_rows
string
valid_rows
string
invalid_rows
string
will_create
string
will_update
string
committed_rows
string
failure
string
parsed_at
string
validated_at
string
committed_at
string
revert_expires_at
string
reverted_at
string
revert_summary
string
error_file_id
string
can_revert
string
created_at
string
created_by_name
string
row_version
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

can_revert
boolean<boolean>
committed_at
string<timestamp with time zone>
committed_rows
integer<integer>
created_at
string<timestamp with time zone>
created_by_name
string<character varying>
Maximum string length: 200
entity_label
string<character varying>
Maximum string length: 120
entity_plural
string<character varying>
Maximum string length: 140
entity_type
string<character varying>

Note: This is a Foreign Key to custom_field_scopes.entity.

Maximum string length: 80
error_file_id
string<uuid>
failure
string<text>
file_id
string<uuid>
file_name
string<character varying>
Maximum string length: 400
header_row
integer<integer>
id
string<uuid>

Note: This is a Primary Key.

invalid_rows
integer<integer>
natural_key_field
string<character varying>
Maximum string length: 63
organization_id
string<uuid>

Note: This is a Foreign Key to copilot_settings.organization_id.

parent_batch_id
string<uuid>

Note: This is a Foreign Key to imports.id.

parsed_at
string<timestamp with time zone>
revert_expires_at
string<timestamp with time zone>
revert_summary
string<jsonb>
reverted_at
string<timestamp with time zone>
row_version
integer<bigint>
sheet_name
string<character varying>
Maximum string length: 200
status
string<character varying>
Maximum string length: 20
template_id
string<uuid>

Note: This is a Foreign Key to import_templates.id.

total_rows
integer<integer>
valid_rows
integer<integer>
validated_at
string<timestamp with time zone>
will_create
integer<integer>
will_update
integer<integer>
write_mode
string<character varying>
Maximum string length: 20