How do I POST the result of a Export ZOQL into my own database?

[heberbrandao]

Hey guys,

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?

[Viktor]

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

[bolaurent · Accepted 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