Skip to content

vokurka/keboola-zuora-ex

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Documentation

To use Zuora AQuA Extractor you just need to create the component in your KBC project and set the configuration correctly.

Here is an example of configuration:

{
  "bucket": "in.c-ex-zuora-main",

  "username": "<your_username>",
  "#password": "<your_password>",

  "start_date": "-1 month",
  "end_date": "today",

  "queries": {
    "report1": "select AccountNumber from account where CreatedDate >= {start_date} and CreatedDate <= {end_date}",
    "report2": "select AccountNumber from account where CreatedDate >= {start_date} and CreatedDate <= {end_date}"
  }
}
  • bucket - destination bucket for downloaded data
  • username - username of account you are using to access Zuora
  • password - password of account you are using to access Zuora
  • start_date - placeholder for use in queries so you do not have to type the date again in every query
  • end_date - placeholder for use in queries so you do not have to type the date again in every query
  • queries - a list of queries and their names - the resulting data table in KBC will have the same name as query here

Warning: Zuora AQuA is implemented in stateless mode. So you have to have in mind order of the queries. For more informations look here.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages