Bulk-import historical transactions for Wayfair tracking

POST

/v1/portability/transactions/backfill

• Production
• Local development

Allows a customer migrating from another tax-API provider to import their last 12–24 months of transactions so the Wayfair-threshold tracker has accurate rolling totals from day one. Up to 10,000 rows per call; chunk larger imports client-side.

Parameters

Header Parameters

X-API-Key

Any of:

string

string

null

null

Request Body ^required

BackfillRequest

Wrapper for a batch of historical transactions. Max 10,000 rows per call.

object

rows

Rows

Historical transactions to import. Up to 10,000 rows per call; chunk larger imports client-side.

Array<object>

<= 10000 items

BackfillRow

A single historical transaction for nexus-threshold tracking.

object

state

required

State

Two-letter USPS code for the destination state of the transaction.

string

>= 2 characters <= 2 characters /^[A-Za-z]{2}$/

order_total

required

Order Total

Gross order total in USD (pre-tax). Used for economic-nexus threshold math.

number

tax_collected

Tax Collected

Tax actually collected on the order in USD. Reported back in the Wayfair-tracker summary so you can see collected-vs-due.

number

0

tx_at

required

Tx At

Transaction timestamp. Accepts YYYY-MM-DD (date-only, interpreted as midnight UTC) or full RFC 3339 (with offset).

string

/^\d{4}-\d{2}-\d{2}(T\d{2}:\d{2}(:\d{2})?(Z|[+\-]\d{2}:\d{2})?)?$/

Responses

200

Rows accepted. Returns inserted-count plus updated rolling totals.

Response Post Transactions Backfill V1 Portability Transactions Backfill Post

object

key

additional properties

any

400

Body validation failed — see detail for specifics.

401

Missing or invalid API key.

422

Validation Error

HTTPValidationError

object

detail

Detail

Array<object>

ValidationError

object

loc

required

Location

Array

msg

required

Message

string

type

required

Error Type

string

input

Input

ctx

Context

object