Get BalanceSheet from Quickbooks Custom API call

Questions
,
1

Information on your n8n setup

  • n8n version: 1.6.0
  • Running n8n via desktop app

I want to use an HTTP request to get the Balance sheet information from the Quickbooks Online.
I have already connected the Quickbooks to my n8n workflow (and can use built in functions without problem). The Custom API call to get the Balance sheet returns an Unknown error.

I am using the GET method described in this intuit document while using an HTTP request node to request for the information.

does anyone know how to make it work ?

2

Hi @Alireza_Aminidad, welcome to the community!

Looks like your HTTP Request has an URL of https://quickbooks.api.intuit.com, but as per the documentation you have shared the path would be something like https://quickbooks.api.intuit.com/v3/company/4620816365223113490/reports/BalanceSheet (where 4620816365223113490 is your company ID, you’d need to update that value accordingly).

I tried this out using the below workflow and it seems to work fine:

Result:

image
image1920×907 101 KB

Hope this helps!

1 Like
3

Thank you so much. This solved my problem and also opened a whole new way that I can interact with QuickBooks Online

1 Like
4

Awesome, glad to hear this helps :slight_smile:

Thanks so much for confirming!

1 Like