How to export REST API call to raw JSON / XML using ODBC Driver – ZappySys Help Center

By default ZappySys ODBC Driver for XML / JSON /CSV produces data in rows and columns by parsing your response. However sometimes you have need to export response as raw document without parsing. If you want to save rest api response as raw document then perform following steps.

Go to ODBC DSN UI and setup your criteria to query API source (e.g. set URL, Authentication)
Now go to query tab and enter following query and click Preview data button. As you may notice 3 properties we have overridden to produce Raw document.
```
SELECT * FROM $
WITH( 
  EnableRawOutputMode='True'
 ,IncludeParentColumns='False'
 ,Filter= ' ' --blank filter 
)
```
When you execute query you may see just one column as below. Right-Click in Grid cell and copy. Now you may paste this to some new local file and save it.

If you don't want to set Raw data option in Query then use below UI setting on Input / Output Tab.

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com

https://zappysys.com/support/