Article Details
Id:22162
Product:finPOWER Connect
Type:NEW
Version:6.00.01
Opened:02/04/2025
Closed:17/07/2025
Released:18/08/2025
Job: J035435

Sample Scripts; Australian BSB Import; Prompt to import the BSB list

The "Script_AustralianBsbImport.xml" Script provided with finPOWER in the "Sample Scripts" folder will now prompt for a file path to save the APCAL file to. Another prompt to import the downloaded BSB list into finPOWER is also displayed.

Additionally, if in test mode it will prompt to save the downloaded json to a file so that it can be re-used if necessary.

To accommodate these changes, the Script Type has been changed to "General (User Interface)".

When the Script is imported into finPOWER, the following constants need to be added using the "Add Constants" button on the Script, Constants page:

  • APIKey: AusPayNet API Key (String).
    • To obtain an API Key, signup at https://auspaynet-bicbsb-api-prod.developer.azure-api.net . You will then need to subscribe to the BSBQuery, this is free for 5 calls/minute up to a maximum of 100 calls/week.
  • ClearExisting: Clear existing Bank Branches? (Boolean)
    • If true, all existing Bank Branches will be deleted.
  • JsonFilePath: Optional. File path to previously downloaded json text file from the API. (String)
    • If specified, the API will not be called and this file will be used instead.
  • UpdateExisting: Update existing Bank Branches? (Boolean)
    • If true, existing Bank Branches will be updated.

The following Script has been updated:

  • Script_AustralianBsbImport.xml
    • Version: 1.01 (17/07/2025)

Please note that due to strain on the AUSPayNet API when doing a full retrieval of data, it has been requested that the Script be run between 4AM and 8AM AEST when possible.