Write data to Quickbooks Tables

Question

Does anyone have experience writing a data set to append to the Quickbooks InvoiceLine table? Currently, it is being done in Access but I am now cleaning/blending the data in Alteryx so would like to write back using Alteryx as well. I am using CData ODBC to pull the data in an it can write using XML but I cannot figure out how to execute the write function from Alteryx. Thanks!!

atcodedog05 · Answer

Interesting! Something new to explore 🤓 Thanks for the share @mceleavey

mceleavey · Answer

Hi @Hayden_McHan ,

You will need to develop an API connector for Quickbooks.

There has been some work done on this previously, check this ARTICLE to get you started.

If you would like someone to develop a personalised API connection for you feel free to DM me.

M.