#Python quickbooks desktop app install
# Switch singer-python version to meet singer-discover dep $ pip install singer-python=5.4.1 prompt_toolkit=1.0.14 # Build our selected catalog $ singer-discover -input catalog.json -output properties.json We’ll use the singer-discover utility we downloaded earlier for this. Tell Singer what we wantįrom here, we want to select what objects we actually want to sync. Their example config is of the following format. This will specify our OAuth credentials and some Singer specific settings. This process is already well-documented by Quickbooks, so I’ll assume you can follow that guide. Step 2: Configure the Singer tap Get the OAuth credentialsįirst off, you’re going to need Quickbooks OAuth credentials. For more info on venvs with Jupyter, check out this TowardsDataScience article. These commands may vary depending on your OS and Python version. # Install JupyterLab if you don't have it already $ pip3 install jupyterlab # Create the virtual env $ python3 -m venv ~/env/tap-quickbooks # Activate the virtual env $ source ~/env/tap-quickbooks/bin/activate # Install the dependencies $ pip install git+ git+ gluestick pandas ipykernel singer-python=5.3.1 requests=2.20.0 xmltodict=0.11.0 jsonpath-ng=1.4.3 pytz=2018.4 attrs=20.2.0 # Make our venv available to JupyterLab $ python -m ipykernel install -user -name=tap-quickbooks # Create a workspace for this $ mkdir quickbooks-integration # Enter the directory $ cd quickbooks-integration Singer taps tend to have a lot of dependency conflicts with each other - to avoid dependency hell, I highly recommend running through this example in a virtual environment. Without further ado, let’s dive in! Step 1: Setup our environment Create the virtualenv gluestick: a small open source Python package containing util functions for ETL maintained by the hotglue team.pandas: a widely used open source data analysis and manipulation tool.singer-discover: an open source utility to select streams from a Singer catalog.We’ll use the hotglue fork which uses updated dependencies. target-csv: a Singer target which converts input JSON data to CSV files.We’ll be using the hotglue fork because it has version compatibility with target-csv. tap-quickbooks: a Singer tap to extract data from Quickbooks.These samples rely on a few open source Python packages:
#Python quickbooks desktop app code
The code for these examples is available publicly on GitHub here, along with descriptions that mirror the information I’ll walk you through.
0 kommentar(er)
