Run ZOQL queries through AQuA from the command line
Project description
zuora-aqua-client-cli
Run ZOQL queries through AQuA from the command line
Installation
Mac
pip3 install zuora-aqua-client-cli
The executable will be installed to /usr/local/bin/zacc
Linux
pip3 install zuora-aqua-client-cli
The executable will be installed to ~/.local/bin/zacc
Make sure ~/.local/bin/
is added to your $PATH
Configuration
Configuration should be provided by the -c /path/to/file
option.
Example config
[prod]
production = true
client_id = <client_id>
client_secret = <client_secret>
[sandbox]
production = false
client_id = <client_id>
client_secret = <client_secret>
Usage
Cheatsheet
# List fiels for resource
$ zacc describe -c ~/.config.ini -e sandbox Account
Account
AccountNumber - Account Number
AdditionalEmailAddresses - Additional Email Addresses
AllowInvoiceEdit - Allow Invoice Editing
AutoPay - Auto Pay
Balance - Account Balance
...
Related Objects
BillToContact<Contact> - Bill To
DefaultPaymentMethod<PaymentMethod> - Default Payment Method
ParentAccount<Account> - Parent Account
SoldToContact<Contact> - Sold To
# Request a bearer token, then exit
$ zacc bearer -c ~/.config.ini -e sandbox
Bearer <bearer token>
# Execute an AQuA job
$ zacc query -c ~/.config.ini -e sandbox -z "select Account.Name from Account where Account.CreatedDate > '2019-01-10'"
Account.Name
John Doe
Jane Doe
# Execute an AQuA job from a ZOQL query file
$ zacc query -c ~/.config.ini -e sandbox -z ~/query_names.zoql
Account.Name
John Doe
Jane Doe
Zacc
Usage: zacc [OPTIONS] COMMAND [ARGS]...
Options:
--help Show this message and exit.
Commands:
bearer Prints bearer than exits
describe List available fields of Zuora resource
query Run ZOQL Query
Query
Usage: zacc query [OPTIONS]
Run ZOQL Query
Options:
-c, --config-filename PATH Config file containing Zuora ouath
credentials [default: zuora_oauth.ini]
-z, --zoql PATH ZOQL file to be executed [default:
input.zoql]
-o, --output PATH Where to write the output to, default is
STDOUT
-e, --environment [prod|preprod|local]
Zuora environment to execute on [default:
local]
-m, --max-retries INTEGER Maximum retries for query
--help Show this message and exit.
Describe
Usage: zacc describe [OPTIONS] RESOURCE
List available fields of Zuora resource
Options:
-c, --config-filename PATH Config file containing Zuora ouath
credentials [default: zuora_oauth.ini]
-e, --environment [prod|preprod|local]
Zuora environment to execute on [default:
local]
--help Show this message and exit.
Bearer
Usage: zacc bearer [OPTIONS]
Prints bearer than exits
Options:
-c, --config-filename PATH Config file containing Zuora ouath
credentials [default: zuora_oauth.ini]
-e, --environment [prod|preprod|local]
Zuora environment to execute on [default:
local]
--help Show this message and exit.
Useful stuff
Has a lot of graphs on Resource relationships: https://community.zuora.com/t5/Engineering-Blog/AQUA-An-Introduction-to-Join-Processing/ba-p/13262
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for zuora-aqua-client-cli-0.1.16.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 31c1dc2672375ab14bfa7d8b0883536534d443bc5b03326f266d4bbfd68c129e |
|
MD5 | 3453c4646f938417c8384949c8490120 |
|
BLAKE2b-256 | 0b1aa7e0db5b69c2572d27bceb0aa036e76786d2a6f75326d3505d32586c9d19 |
Close
Hashes for zuora_aqua_client_cli-0.1.16-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a0b7cc2ae3634624ffb9dc1530662858374ae5267f11dfce122085174d5ae80 |
|
MD5 | 301dc056bc26910055152a7b2ebdf0d7 |
|
BLAKE2b-256 | 95febd49c9f2c73df608adb579279331dfb99cd9de1cd95ef9860de74357cdce |