# Import data

Source: https://developer.avalara.com/products/returns/integration-guides/managed-returns-emea/wej7772481021922/

Guide: Avalara Managed Returns API (EMEA)

# Import data

Import VAT transaction data and monitor the processing and validation status.

Use the `vatUploadData` mutation to import VAT transaction data by uploading an Excel file (base64) for one or more VAT return periods.

**View request:**

```
mutation VatUploadData($input: UploadDataInput!) {
  vatUploadData(input: $input) {
    id
    errors {
      message
      extensions {
        type
        code
        status
      }
    }
  }
}
```

**Variables example:**

```
{
  "input": {
    "fileName": "ava-apr-2026.xlsx",
    "fileContent": "",
    "dataSource": "PartnerPortal"
  }
}
```

Note

-   Uploads an Excel file (AvaTemplate) with transaction-level VAT data for one or more Return periods
-   The upload is associated with the target Company and is processed asynchronously
-   The returned id is the `dataTraceId` used to poll upload status
-   Validation and transformation of rows occur on the server; failed rows and counts are available through the status API

## Check import status

Use this query to check the validation and processing status of previously imported data.

**View request:**

```
query VatUploadDataStatus($dataTraceId: String!) {
  vatUploadDataStatus(dataTraceId: $dataTraceId) {
    id
    status
    currentStep
    steps
    description
    vatValidationSummary {
      totalTransactions
      passed
      failed
    }
  }
}
```

**View response:**

```
{
  "data": {
    "vatUploadDataStatus": {
      "id": "...",
      "status": "Complete",
      "currentStep": 5,
      "steps": 5,
      "description": "...",
      "vatValidationSummary": {
        "totalTransactions": 4,
        "passed": 2,
        "failed": 2
      }
    }
  }
}
```