Import Wise Transactions
import_wise_transactionsDestructive
Import Wise transaction-history CSV rows into e-arveldaja with a dry run by default; execute to create bank transactions, separate fees, and avoid double-counting transfers.
Instructions
Import Wise transaction-history CSV rows. Direct-call contract: DRY RUN by default; execute=true creates rows; each created bank row carries the API type of its true direction (incoming IN → type D, outgoing OUT → type C) and source_direction records that same flow; fees are separate outgoing (type C) transactions; inter-account transfers avoid double-counting confirmed counterpart journals.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date_to | No | Only import transactions up to this date (YYYY-MM-DD) | |
| execute | No | Actually create transactions (default false = dry run) | |
| file_ref | No | Opaque Accounting Inbox Wise CSV reference. Provide exactly one of file_path or file_ref. | |
| date_from | No | Only import transactions from this date (YYYY-MM-DD) | |
| file_path | No | Absolute path/base64 Wise CSV input. Provide exactly one of file_path or file_ref. | |
| plan_handle | No | Execution-plan handle returned by the reviewed dry run. Required for execute=true in addition to approved_command_digest; the digest alone cannot execute. | |
| skip_jar_transfers | No | Skip Jar (savings pot) transfers — internal movements within Wise (default true) | |
| not_own_transfer_ids | No | Owner-confirmed only: exact transfer Wise IDs that are payments to or from a third party, not own transfers: imported as ordinary unconfirmed rows without an ownership review. Must not overlap confirm_own_transfer_ids; a row whose own-account evidence says otherwise is held (not_own_transfer_conflicts_evidence). | |
| counterpart_overrides | No | Owner-confirmed only: { wise_id, dimension_id } picking the own bank account a transfer row goes to or from when its own-account evidence points to several (wise_transfer_counterpart_conflict). The pick must be one of the evidenced accounts, else the row stays held; an entry that decides nothing is reported (unused_counterpart_override). | |
| accounts_dimensions_id | Yes | Bank account dimension ID for the Wise account in e-arveldaja. Must be the dimension of a configured bank account; otherwise refused with wise_dimension_not_bank_account before any write. | |
| approved_command_digest | No | Exact lowercase SHA-256 command digest returned by the reviewed dry run. Required for execute=true when mutations are planned. | |
| fee_account_relation_id | No | Deprecated alias for fee_account_dimensions_id. | |
| confirm_own_transfer_ids | No | Exact Wise IDs explicitly approved as own transfers. TRANSFER-* and BANK_DETAILS_PAYMENT_RETURN-* prefixes are hints only; a hinted row whose other party is provably not an own account is imported as an ordinary unconfirmed payment (transfers_treated_as_payments). | |
| journalized_transfer_ids | No | Exact { wise_id, journal_id } pairs the operator has checked: the labelled inter-account journal already books that Wise transfer (resolves a wise_transfer_journal_ambiguous review). Each mapping is validated; a rejected one is reported and the row resolves as if unmapped (it may still be skipped as already journalized, or held for review). | |
| fee_account_dimensions_id | No | Account dimension ID for the Wise fee expense account. | |
| acknowledged_journal_holds | No | Owner-confirmed only: { wise_id, journal_ids } stating those journals do NOT book that held Wise transfer. Releases the row (imported and confirmed normally; an exact-label double-booking hold stays recorded as booked by its labelled journal) only when journal_ids lists every required_acknowledgement_ids journal of its review; never for counterpart, identity or untagged-row holds. | |
| inter_account_dimension_id | No | Other bank account dimension ID for inter-account transfers. Auto-detected if only one other bank account exists. Per row, own-account evidence on another bank decides first and this id is the fallback; a row whose counterpart cannot be determined or whose evidence contradicts this id is held (not imported), the other rows are planned. |