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?
I’m actually a CPA turned Bubble developer, so I’m quite familiar with accounting data structures, but I can’t say I’ve used the Quickbooks API previously.
My honest truth on their product as an accountant is that it leaves a lot to be desired, so I wouldn’t be surprised if their API performance is poor.
However, the more likely situation is that there could be something happening in your workflow that’s causing everything to work way harder than it needs to.
Are you confident that your workflows are optimised? Alarm bells ring for me when you say there are thousands of API events triggering per single company connection.
Josh @ Support Dept
Helping no-code founders get unstuck fast save hours, & ship faster with an expert on-demand
Unfortunately, thousands of actions that is what we have to deal with, because of Quickbooks API. It is as optimized as it can be. Just imagine an enormously large JSON coming from Quickbooks where they don’t have a format like “value_name”:“value”, and also everything is placed randomly, so you don’t know what number is related to certain metric.
The bad news is I’m really not sure that there will be an opportunity to speed this up if you’re not able to rationalize how you use the Quickbooks API.
Thousands of API calls take time to complete.
Josh @ Support Dept
Helping no-code founders get unstuck fast save hours, & ship faster with an expert on-demand
It sounds like an interesting workaround and no reason why it wouldn’t work. The critical thing will be transforming the data into a format in Tableau that makes it easy to call from Bubble. So make sure you plan your database carefully in Bubble before transforming the data in Tableau.
Josh @ Support Dept
Helping no-code founders get unstuck fast save hours, & ship faster with an expert on-demand
Hey @josh24 , is there any other app you would recommend besides Quickbooks that I use along with Bubble?
I’m currently working on a ERP for a single company and was planning on integrating Quickbooks.
I need to send customer info from Bubble to Quickbooks (or similar) and create invoices within the accounting software so that invoices, payments, and AR are all handled by the accounting software and just use Webhooks to update the Bubble app.
save hours, & ship faster with an expert 
on-demand