QFind anything/

Upload CSV

Bulk upload incoming transactions via CSV file against a CSV data source connection. Returns syncLogId, dataSourceConnectionId, total, successful, failed, created, and errors.

Parameters

file(file)required

CSV file (multipart/form-data). Max 10MB.

dataSourceConnectionId(string)required

ID of the CSV data source connection (from POST /data-sources with source csv). Query parameter or multipart form field.

delimiter(string)

CSV delimiter. Query parameter.

POST/incoming-transactions/upload

curl -X POST "http://localhost:8000/api/v1/incoming-transactions/upload?dataSourceConnectionId=$CSV_CONNECTION_ID" \
  -H "X-Api-Key: $API_KEY" \
  -H "X-Tenant-Id: $TENANT_ID" \
  -H "X-Environment: production" \
  -F "file=@transactions.csv"

Response(201)

{
  "syncLogId": "089fafeb-bfb2-491a-9fb3-718118e808be",
  "dataSourceConnectionId": "089fafeb-bfb2-491a-9fb3-718118e808bf",
  "total": 10,
  "successful": 8,
  "failed": 2,
  "created": [
    {
      "id": "tran_inc_acme_abc123",
      "row": 2
    },
    {
      "id": "tran_inc_acme_def456",
      "row": 3
    }
  ],
  "errors": [
    {
      "row": 5,
      "error": "Invalid amount"
    },
    {
      "row": 8,
      "error": "Missing required field: merchant"
    }
  ]
}