Skip to main content
Accounts Function
Updated over 11 months ago

BKPER_ACCOUNTS

Fetch the (Chart of) Accounts from your Bkper book. Gives you a listing of accounts and groups from your Bkper book:


​=BKPER_ACCOUNTS(bookId, cache, groups, properties)
​

Sample usage

=BKPER_ACCOUNTS("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, TRUE, FALSE)

Explaining the syntax:

  • bookId: string - The universal Book Id.

  • cache: number - Cache-control. Increase to clean cache and force fetch update.

  • groups: TRUE or FALSE - True to include account groups.

  • properties: TRUE or FALSE - True to include custom account properties.
    ​

Did this answer your question?