Aside from missing windows and JSON functions in MySQL 5.6 there are security flaws to consider. This is pretty sad that we are still stuck on MySQL version 5.6.37-82.2-82.2. While I realize that Magic ETL is all that there are still a lot of people who find the MySQL dataflows to be their preference. So I drop my token in…
I have built a custom Python script to pull any table or report from Quickbooks and dump to a CSV file. I then use Domo Workbench to push the CSV file to Domo. Let me know if you are interested.
FYI I use Domo workbench to upload the CSV due to having to leave code on clients machines. I don't want anyone getting a hold of our API key which would be in the Python code. Hence the marriage between Python extracting the data from Quickbooks and Domo Workbench pushing the CSV to Domo works well. It is a balance…