Timestamp for when transaction was entered into the register
I've been using the API and browsing through the transactions table through Power Query, I can see the transactions id, date, amount, etc. I see that the date is the date at which you specified as enter the transaction in the register, but I cannot seem to find the column for the timestamp for when the transaction was actually entered into the register. Or that field is really missing?
Hi Jorelle Tuvillo there! We do not use timestamps within YNAB, just the transaction date. Transactions are dated, and the Transaction ID is formatted as described in : https://api.youneedabudget.com/v1#/Transactions/createTransaction
Transactions imported through File Based Import or Direct Import (not through the API) are assigned an import_id in the format: 'YNAB:[milliunit_amount]:[iso_date]:[occurrence]'. For example, a transaction dated 2015-12-30 in the amount of -$294.23 USD would have an import_id of 'YNAB:-294230:2015-12-30:1’. If a second transaction on the same account was imported and had the same date and same amount, its import_id would be 'YNAB:-294230:2015-12-30:2’. Using a consistent format will prevent duplicates through Direct Import and File Based Import.