The most easier way to make your firebird SQL query with bubble. Steps for making query:
- Put one Repeating Group and set the Data source for "Get data from an external API".
- In API Provider, set "Firebird - query".
- in serverName, put your server address, for example, if your connection string in IBExpert is firebird.yourdomain.com:/firebird/database.gdb, your serverName will be firebird.yourdomain.com
- In databaseFile put your database file address, for exemplo, if your connection string in IBExpert is firebird.yourdomain.com:/firebird/database.gdb, your databaseFile will be firebird.yourdomain.com
- in userName put your Firebird user name, for examplo sysdba.
- in password, put your Firebird password, for examplo, masterkey
in SQLQuery, put our firebird SQL Query, for example, select first, second, third from tablename where filters order by index