Transactions Function
Updated over a week ago


Fetch transactions from your Bkper book Gives you all the transactions according to the query provided:

BKPER_TRANSACTIONS(bookId, cache, query, properties, ids)

Sample usage

=BKPER_TRANSACTIONS("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, "acc:'Bank Account' after:01/2019", TRUE, FALSE)

Explaining the syntax:

  • bookId: string - The universal Book Id.

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

  • query: string - The query.

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

  • ids: TRUE or FALSE - True to include transaction ids.

Did this answer your question?