Forum Academy Marketplace Showcase Pricing Features

Has anyone integrated Quickbooks data to Bubble?

Need help APIs
#1

Hey there.

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

Screenshot 2022-05-09 at 18.34.15
Screenshot 2022-05-09 at 18.34.15958×1060 106 KB

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?

#2

Hey @vovahumnytskiy

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 :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

I post daily about no-code and Bubble on Twitter Follow Support Dept on Twitter

#3

Hello, @josh24.

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.

#4

Yikes!

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 :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

I post daily about no-code and Bubble on Twitter Follow Support Dept on Twitter