BKPER_GROUPS
Fetch the Groups from your Bkper book. Gives you a listing of groups (with parent groups, child groups and number of accounts) from your Bkper book:
β=BKPER_GROUPS(bookId, cache, properties)
β
Sample usage
=BKPER_GROUPS("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, TRUE)
Explaining the syntax:
bookId: string - The universal Book Id.
cache: number - Cache-control. Increase to clean cache and force fetch update.
properties: TRUE or FALSE - True to include custom group properties.
β