github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-05-05 22:52:20 -05:00
Code Issues 1.5k Packages Projects Releases 54 Wiki Activity

[GH-ISSUE #133] Actual api nodejs client (@actual-app/api) unable to create accounts #7055

New Issue
Closed
opened 2026-04-10 16:43:12 -05:00 by GiteaMirror · 6 comments
GiteaMirror commented 2026-04-10 16:43:12 -05:00
Owner
Copy Link

Originally created by @jhonderson on GitHub (Jul 20, 2022).
Original GitHub issue: https://github.com/actualbudget/actual/issues/133

I am trying to create an script to import accounts and transactions using SimpleFIN API and Actual NodeJS client, but I am getting this error:

...
Loading fresh spreadsheet
Importing Accounts...
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name
(node:87511) UnhandledPromiseRejectionWarning: TypeError: connection.getNumClients is not a function
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49402:22)
(Use `node --trace-warnings ...` to show where the warning was created)
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 2)
(node:87511) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'transaction' of null
    at Module.transaction (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45837:6)
    at Module.transaction (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54383:77)
    at applyMessagesForImport (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61290:50)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61316:12
    at run (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64536:29)
    at sequenceState.queue.push.resolve.resolve (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64549:16)
    at new Promise (<anonymous>)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64548:14
    at _sendMessages (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61484:11)
    at batchMessages (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61529:11)
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 6)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 9)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 12)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 15)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 18)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 21)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 24)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null
    at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41)
    at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82)
    at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10)
    at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71
    at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12)
    at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26)
    at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 26)
(node:87511) UnhandledPromiseRejectionWarning: TypeError: connection.getNumClients is not a function
    at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49402:22)
(node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 27)

The call to actual.getAccounts() works fine, but not createAccount.

I am using @actual-app/api-4.1.0.

Originally created by @jhonderson on GitHub (Jul 20, 2022). Original GitHub issue: https://github.com/actualbudget/actual/issues/133 I am trying to create an script to import accounts and transactions using SimpleFIN API and Actual NodeJS client, but I am getting this error: ``` ... Loading fresh spreadsheet Importing Accounts... error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name error SELECT * FROM accounts WHERE offbudget = ? ORDER BY sort_order, name (node:87511) UnhandledPromiseRejectionWarning: TypeError: connection.getNumClients is not a function at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49402:22) (Use `node --trace-warnings ...` to show where the warning was created) (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 2) (node:87511) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'transaction' of null at Module.transaction (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45837:6) at Module.transaction (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54383:77) at applyMessagesForImport (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61290:50) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61316:12 at run (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64536:29) at sequenceState.queue.push.resolve.resolve (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64549:16) at new Promise (<anonymous>) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64548:14 at _sendMessages (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61484:11) at batchMessages (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:61529:11) (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 6) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 9) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 12) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 15) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 18) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 21) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 24) (node:87511) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'prepare' of null at Module.runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:45806:41) at runQuery (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54349:82) at all (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54392:10) at Module.insertAccount (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:54764:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56312:71 at withUndo (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:64016:12) at Object.account-create (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:56311:65) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49780:36 at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49399:26) at /Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:58515:10 (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 26) (node:87511) UnhandledPromiseRejectionWarning: TypeError: connection.getNumClients is not a function at Object.undoDisabled (/Users/jhondiaz/development/import-simplefin/node_modules/@actual-app/api/app/bundle.api.js:49402:22) (node:87511) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 27) ``` The call to actual.getAccounts() works fine, but not createAccount. I am using @actual-app/api-4.1.0.
GiteaMirror added the bug label 2026-04-10 16:43:12 -05:00
GiteaMirror commented 2026-04-10 16:43:14 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Nov 24, 2022):

🚧🚨 This issue is being marked as stale due to 90 days of inactivity. 🚧🚨

<!-- gh-comment-id:1325855062 --> @github-actions[bot] commented on GitHub (Nov 24, 2022): 🚧🚨 This issue is being marked as stale due to 90 days of inactivity. 🚧🚨
GiteaMirror commented 2026-04-10 16:43:15 -05:00
Author
Owner
Copy Link

@tjfinlinson commented on GitHub (Dec 30, 2022):

@jhonderson , I'm interested in getting Simple Fin to work, but I honestly don't have much dev experience. There is a Draft PR for setting up a Nordigen sync for European banks, and work was also started on Plaid integration, I wonder if those would be helpful places.

The Plaid app can be found in https://github.com/actualbudget/actual/tree/master/packages/desktop-client/src

Nordigen PRs
https://github.com/actualbudget/actual/pull/209
https://github.com/actualbudget/actual-server/pull/74

<!-- gh-comment-id:1367704340 --> @tjfinlinson commented on GitHub (Dec 30, 2022): @jhonderson , I'm interested in getting Simple Fin to work, but I honestly don't have much dev experience. There is a Draft PR for setting up a Nordigen sync for European banks, and work was also started on Plaid integration, I wonder if those would be helpful places. The Plaid app can be found in https://github.com/actualbudget/actual/tree/master/packages/desktop-client/src Nordigen PRs https://github.com/actualbudget/actual/pull/209 https://github.com/actualbudget/actual-server/pull/74
GiteaMirror commented 2026-04-10 16:43:16 -05:00
Author
Owner
Copy Link

@MatissJanis commented on GitHub (Jan 29, 2023):

👋 There have been some significant changes in how we bundle the API. Your issue might have been fixed with those.

Could you please check if this is still a problem for you?

Thanks

<!-- gh-comment-id:1407750421 --> @MatissJanis commented on GitHub (Jan 29, 2023): 👋 There have been some significant changes in how we bundle the API. Your issue _might_ have been fixed with those. Could you please check if this is still a problem for you? Thanks
GiteaMirror commented 2026-04-10 16:43:17 -05:00
Author
Owner
Copy Link

@JamesHenry commented on GitHub (Jan 31, 2023):

@MatissJanis the last time I tried with a brand new copy of actual a couple of weeks ago I couldn't get even the most basic API usage to work: https://github.com/actualbudget/docs/issues/52#issuecomment-1382752551

Has this now been fixed/is there any working example you can point me towards?

I had a break from Actual for a while but I had built my entire system around programmatic usage so that I could externalise the categorization logic on my side and decouple it from Actual. I would love to return to this.

Any help would be greatly appreciated 🙏

<!-- gh-comment-id:1410914244 --> @JamesHenry commented on GitHub (Jan 31, 2023): @MatissJanis the last time I tried with a brand new copy of actual a couple of weeks ago I couldn't get even the most basic API usage to work: https://github.com/actualbudget/docs/issues/52#issuecomment-1382752551 Has this now been fixed/is there any working example you can point me towards? I had a break from Actual for a while but I had built my entire system around programmatic usage so that I could externalise the categorization logic on my side and decouple it from Actual. I would love to return to this. Any help would be greatly appreciated 🙏
GiteaMirror commented 2026-04-10 16:43:19 -05:00
Author
Owner
Copy Link

@j-f1 commented on GitHub (Jan 31, 2023):

I have a PR awaiting final approval from James that I would like to ship soon (https://github.com/actualbudget/actual/pull/464). With those changes, you should be able to get the API working — let me know if you have any issues with that branch!

<!-- gh-comment-id:1410926541 --> @j-f1 commented on GitHub (Jan 31, 2023): I have a PR awaiting final approval from James that I would like to ship soon (https://github.com/actualbudget/actual/pull/464). With those changes, you should be able to get the API working — let me know if you have any issues with that branch!
GiteaMirror commented 2026-04-10 16:43:19 -05:00
Author
Owner
Copy Link

@j-f1 commented on GitHub (Feb 27, 2023):

I believe version 5 of the API package has improved things, but let me know if you’re still having issues after you upgrade and we can reopen.

<!-- gh-comment-id:1446571350 --> @j-f1 commented on GitHub (Feb 27, 2023): I believe version 5 of the API package has improved things, but let me know if you’re still having issues after you upgrade and we can reopen.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#7055
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?