For the past weeks I have been digging into all the functionalities and differences between the ZUORA APIs.
However, so far I wasn't able to run a query Export ZOQL in order to post the results into my own database.
Has anyone succeed on doing that?
Solved! Go to Solution.
Re: How do I POST the result of a Export ZOQL into my own database?
Hi @heberbrandao the Export ZOQL is an asynchronous job, when you use it you essentially trigger a background job that will extract the data from the database into a CSV / XLS file - it will not post your results anywhere. You need to download the completed export files and use an external process / script to import the contents of the CSV output to your database.
Some more information on Export ZOQL can be found here: https://community.zuora.com/t5/API/Handling-AQuA-syntax-errors-ZOQL-vs-ZOQLEXPORT/m-p/15675#M729
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
You didn't mention what language you are using.
I've successfully used export zoql from python.
Have a look at https://github.com/bolaurent/python-cmdline-zoql (for ability to type zoql at the command line and have results either printed to terminal or sent to excel; auto detects if your query is standard zoql or export zoql).
The underlying api wrapper is at https://github.com/bolaurent/zuora_restful_python