Upload files

• Upload files programmatically using our FileUpload API
• Upload files through the Portal view (coming soon)

• Generic transactions- or order files
• Adyen reports
• Checkout reports

​

Structure Overview

• Format: Only CSV files are currently supported.
• Size Limit: Maximum 5GB per file.
• Number Format: In order to prevent possible ambiguities in the numbers interpretation, we are restricting the format to only support decimal dot separators in the files that are being uploaded.
• Schema: Files must follow the same schema as defined in our Orders Report orders-report#/

​

Upload files via API - How It Works

1. Request an Upload URL Call the POST /analytics/files/upload endpoint to request a temporary, pre-signed S3 URL. This URL acts as a secure, one-time gateway to our storage. Request Body as below:
   {
     "datasetType": "ordersV1",
     "file": {
       "name": "merchant_orders_2026-01-01.csv",
       "type": "csv"
     }
   }
   
2. Upload Your File (Technical Implementation) Once you have the pre-signed URL, you can upload your data file using a standard HTTP PUT request. Using curl: For a quick implementation or testing, you can use the following curl command. We recommend using the --write-out flag during testing to verify the HTTP status code returned by the server.
   curl --request PUT \
     --upload-file '{your_file_path}' \
     '{presigned_url}' \
     --write-out "\nHTTP_STATUS:%{http_code}\n"
   
   • Note: The -write-out portion is optional but highly useful for debugging; a successful upload will return an HTTP 200.
   • Expiration: The pre-signed URL is valid for 1 hour. If the upload does not start within this window, you must request a new URL.
3. Processing & Validation After the upload is complete, our system automatically begins validation in the background. We check the file for structural integrity and header alignment.
4. Check File Status Since large files (up to 5GB) may take time to process, you can monitor the progress programmatically.
   • Endpoint: GET /analytics/files/{id}
   • Details: Retrieve the current processing status (Available, Processing, Imported, Completed, or Failed) and view import statistics once finished.
     • Available: The file has been successfully validated and is ready to be imported.
     • Processing: The system is currently validating or parsing the file.
     • Imported: The file has been successfully imported and analysed.
     • Completed: The final state of a successful process, indicating that all data has been fully processed and is now Available for reporting.
     • Failed: An error occurred during ingestion.
5. Data Integration & Visualization Once the status is marked as Complete, your data is automatically merged into our analytics engine where we further process it. Once processing is complete, your custom data will now power your dashboards, providing a unified view of your performance and reconciliation insights.