> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omneo.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Browse Import Failures

> A `GET` to the `/imports/{importId}/failures` endpoint allows your application to list every
row this import rejected, across all of its jobs, without walking jobs and batches first.

## Filtering

<Info>
  This endpoint accepts `filter` and `sort` query parameters. See [Filtering, sorting, and search](/dev-guides/core-setup/filtering-and-sorting) for paging and for the shared `search_with`, `custom_field`, and `json_contains` filters.
</Info>

### Examples

<CodeGroup>
  ```bash Exact match theme={null}
  curl -X GET "https://api.[tenant].getomneo.com/api/v3/imports/{import}/failures?filter[external_id]={external_id}" \
    -H "Authorization: Bearer ${TOKEN}"
  ```

  ```bash Only rows with a value theme={null}
  curl -X GET "https://api.[tenant].getomneo.com/api/v3/imports/{import}/failures?filter[batch_id][nullable]=0" \
    -H "Authorization: Bearer ${TOKEN}"
  ```
</CodeGroup>

### Operators

| Operator   | Meaning                                                                                            | Example                                        |
| ---------- | -------------------------------------------------------------------------------------------------- | ---------------------------------------------- |
| `eq`       | Equal to. Applied when you give no operator.                                                       | `filter[external_id]={external_id}`            |
| `ne`       | Not equal to.                                                                                      | `filter[external_id][ne]={external_id}`        |
| `gt`       | Greater than.                                                                                      | `filter[external_id][gt]={external_id}`        |
| `gte`      | Greater than or equal to.                                                                          | `filter[external_id][gte]={external_id}`       |
| `lt`       | Less than.                                                                                         | `filter[external_id][lt]={other-external_id}`  |
| `lte`      | Less than or equal to.                                                                             | `filter[external_id][lte]={other-external_id}` |
| `in`       | Matches any value in a comma separated list.                                                       | `filter[batch_id][in]=123,456`                 |
| `not_in`   | Excludes every value in a comma separated list.                                                    | `filter[batch_id][not_in]=123,456`             |
| `nullable` | `1` returns records where the attribute is empty. Any other value returns records where it is set. | `filter[batch_id][nullable]=1`                 |

The `not_has` operator applies to related attributes, which this endpoint does not have.

### Filter attributes

| Attribute  | Attribute   | Attribute     |
| ---------- | ----------- | ------------- |
| `batch_id` | `entity_id` | `external_id` |
| `status`   |             |               |

Each attribute above is also a valid `sort` key, for example `?sort=-batch_id` for descending order.


## OpenAPI

````yaml get /v3/imports/{import}/failures
openapi: 3.1.0
info:
  title: Omneo
  version: 0.0.1
servers:
  - url: https://api.{tenant}.getomneo.com/api
    variables:
      tenant:
        default: example
security: []
paths:
  /v3/imports/{import}/failures:
    get:
      tags:
        - Import Failure
      summary: Browse Import Failures
      description: >-
        A `GET` to the `/imports/{importId}/failures` endpoint allows your
        application to list every

        row this import rejected, across all of its jobs, without walking jobs
        and batches first.
      operationId: importFailure.index
      parameters:
        - name: import
          in: path
          required: true
          description: The import ID
          schema:
            type: integer
        - name: page[size]
          in: query
          schema:
            type: string
      responses:
        '200':
          description: Array of `ImportFailure`
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: array
                    items:
                      $ref: '#/components/schemas/ImportFailure'
                required:
                  - data
        '401':
          $ref: '#/components/responses/AuthenticationException'
        '403':
          $ref: '#/components/responses/AuthorizationException'
        '404':
          $ref: '#/components/responses/ModelNotFoundException'
components:
  schemas:
    ImportFailure:
      type: object
      properties:
        id:
          type: string
        import_job_id:
          type: string
        batch_id:
          type: string
        entity_type:
          type: string
        entity_id:
          type: string
        external_id:
          type: string
        line:
          type: string
        path:
          type: string
        value:
          type: string
        message:
          type: string
        error:
          type: string
        created_at:
          type: string
      required:
        - id
        - import_job_id
        - batch_id
        - entity_type
        - entity_id
        - external_id
        - line
        - path
        - value
        - message
        - error
        - created_at
      title: ImportFailure
  responses:
    AuthenticationException:
      description: Unauthenticated
      content:
        application/json:
          schema:
            type: object
            properties:
              message:
                type: string
                description: Error overview.
            required:
              - message
    AuthorizationException:
      description: Authorization error
      content:
        application/json:
          schema:
            type: object
            properties:
              message:
                type: string
                description: Error overview.
            required:
              - message
    ModelNotFoundException:
      description: Not found
      content:
        application/json:
          schema:
            type: object
            properties:
              message:
                type: string
                description: Error overview.
            required:
              - message

````