user_external_id of API-inserted transaction remains in database after deletion
complete
Din from Lunch Money
The user_external_id of a transaction inserted using the API and then deleted in the UI will remain in the database. Retrying to insert the transaction via the API will fail due to incorrect handling of duplicate user_external_ids with the following error: "Key (user_external_id, asset_id, account_id)=(1234567891234567891, 12345, 12345) already exists."
Log In
J
JP Shipherd
complete
This is fixed as of Dec 20, 2024. It will be possible to insert a new transaction with an asset_id/external_id that matches a transaction that was deleted on or after that date.
Users who deleted transactions with external_ids prior to this date can email support@lunchmoney.app to request a manual fix.