GET Export SQL

Response Content-Type:  text/html

The html format writes a complete HTML document to the HTTP response body. The query SQL is written within the HTML document. This response is the default response unless .json is appended to the URL or the endpoint is requested with the application/json Accept header.

Response Content-Type:  application/json

The json format writes JSON to the HTTP response body containing both the query SQL and query parameters if applicable.

The JSON response is returned if .json is appended to the URL or the endpoint is requested with the application/json Accept header.

JSON responses without error have this structure:

{
    "query":{
        "sql":string
        // The parameters property is an array of values to be substituted
        // at the respective positions of "?" characters in the Prepared
        // JDBC query. 
        ,"parameters":[object]
    }
}

{
    "query": {
        "sql": "select t1.id, t1.name from table_name t1 where 1=1 and t1.last_updated > ?"
        ,"parameters":["2015-09-29T00:00:00.000Z"]
    }
}