Get CSV/Excel column headers for mapping

POST/api/v1/transactions/bulk-upload/headers

Return the column headers, sample rows, and a suggested mapping for a previously uploaded CSV/Excel file. Use this before preview to let the user map their file's columns to DayZero fields (date, amount, description).

Operation ID: get_bulk_upload_headers_api_v1_transactions_bulk_upload_headers_post·View as markdown·OpenAPI slice

Authentication

Bearer token authentication. Pass your DayZero API token in the Authorization header and the target business UUID in x-business-id.

Request body

Schema: BulkUploadHeadersRequest

s3_keystringrequired: S3 key of the CSV/Excel file to read headers from

Responses

201Successful Response

Schema: SuccessEnvelope_BulkUploadHeadersResponse_

successboolean
messagestring
codestring
dataBulkUploadHeadersResponse

400Bad Request - Invalid input

401Unauthorized - Authentication required

403Forbidden - Insufficient permissions

422Validation Error

Schema: HTTPValidationError

detailarray · ValidationErrorValidationError

5 fields

locarray · string | integerrequired
msgstringrequired
typestringrequired
inputobject
ctxobject

Code samples

POST/api/v1/transactions/bulk-upload/headers

bash

curl -X POST 'https://api.ondayzero.com/api/v1/transactions/bulk-upload/headers' \
  -H 'Authorization: Bearer dz_your_token' \
  -H 'x-business-id: YOUR_BUSINESS_ID' \
  -H 'Content-Type: application/json' \
  -d '{
  "s3_key": "string"
}'