Transactions

The Transactions file contains information about transactions associated with members.

Delta export. Each daily file contains transactions registered or updated during that day. Upsert on transactionId and keep the row with the latest updatedAt.

File: analytics/Transactions/transactions_YYYY_MM_DD.csv Primary key: transactionId

A sample file is provided below:

transactions_all_until_2025_09_16.csv

43KB

Open

Available Data:

Column	Type	Can be empty	Description
transactionId	uuid	No	Unique transaction ID
memberId	uuid	Yes	Assigned member ID
channelId	uuid	Yes	Channel ID
memberData	json object	No	Member identification data
items	json array	No	Transaction items
tenantId	uuid	No	Tenant ID
header	json object	No	Transaction header
assignedToMemberAt	datetime	Yes	Member assignment date
matched	boolean	Empty = false	Whether matched
grossValue	decimal	No	Total gross value
currency	string	Yes	Currency
pointsEarned	decimal	No	Units earned
unitsDeducted	decimal	No	Units deducted
channelName	string	Yes	Channel name
createdAt	datetime	No	Registration date
updatedAt	datetime	No	Date last updated