I would like to help develop a web app in Bubble.io. I am familiar with Bubble however I am not familiar with API calls and storing this data in a database. This app is not developed and would be starting from scratch. Here is the use case summary I am trying to build:
1) There would be a login screen where the user could either sign up or log in. The user type would be set to "client" (as opposed to admin which would be used later).
2) The user would authenticate their account with Quickbooks Online (QBO) from [login to view URL]
3) Upon initiation in Bubble, monthly account balances would be pulled from QBO. For example, the user may specify 1/31/2021 - 5/31/2022. From that date range, all account information would be stored in a [login to view URL] database from QBO for each month-end in that range. Any prior account information for this company during that date range would be overwritten.
4) On a nightly basis, there would be API calls to pull in the number of invoices, amount of invoices, number of expenses, amount of expenses, cash balances, and revenue.
That is it for now. There are possibly multiple other steps to this program such as building out additional calls and building out the user login/permissions part of the app as well.
I am fine with using an OAuth program like Pathfix if that makes things easier.
I am open to other ideas to achieve this. The idea is this information would then be used to generate dashboards and reports.
I am an accountant so use cases are not my thing. If I am missing any information, please feel free to reach out. In your reply, please let me know what type of experience you have with projects like this.