We are building an accounting ERP software.
If you’ve used Quickbooks, you should know that there are companies, and each company has advanced reports, and charts/graphs.
Quickbooks API provides strange JSON that can’t be used for GET API requests to broadcast data from Quickbooks.
Example: Intuit Developer
So, with this ugly Quickbooks JSON, we build a parser in backend workflows that reads JSON and creates a new row in a special DB table for each metric for each month. Therefore, there are thousands of API events triggering per single company connection.
Now we faced an issue that the app becomes too busy with just a single user who tries to connect 2-4 companies simultaneously. It’s disgusting since it’s just a single user, it’s just an app for internal usage.
Data retrieval per company takes up to 5 minutes.
How to deal with this QB JSON? Has anybody used Quickbooks to show its data in Bubble?