Hello - I have a workflow where it pulls QBO report data into an excel macro. QBO nodes have all report types except for P&L. From what I understand, for P&L you have to use a HTTP Request node for a custom API. This HTTP node is much tougher to set up.
Has anyone successfully gotten QBO P&L reports to pull via n8n? I could really use some advice, thank you.
Yes it’s possible to pull QBO P&L reports through n8n using the HTTP request node but it actually requires some additional setup compared to other standard reports
Seems like a standard http request for quickbooks, what issue are you having specifically?
The issue was the output in the Process QBO Data node. I had to make some edits to the javascript and also some updates to vba in excel but i finally got it to work. PL summary tab in excel separate from Transaction List tab.
Yea I was just plugging one in and looking at the output and was thinking about how in the world to parse that out. Glad you got it going.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
