Happy Business Starts Here

Valued Scholar

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

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?

Tags (1)
2 REPLIES 2
Support SME

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 √

Master

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

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