cURL
curl --request POST \ --url https://cloud.cdata.com/api/batch \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --data ' { "query": "<string>", "defaultCatalog": "<string>", "defaultSchema": "<string>", "parameters": [ {} ], "timeout": 150 } '
{ "results": [ { "affectedRows": 123, "schema": [ { "catalogName": "<string>", "columnLabel": "<string>", "columnName": "<string>", "dataType": 1, "dataTypeName": "<string>", "length": 123, "nullable": true, "ordinal": 123, "precision": 123, "scale": 123, "schemaName": "<string>", "tableName": "<string>" } ], "rows": [ [ "<unknown>" ] ] } ], "error": { "code": 0, "message": "<string>" } }
The batch operation allows you to execute batch INSERTs, UPDATEs, and DELETEs against your data sources using a single request.
JWT token authentication. Include the token in the Authorization header as 'Bearer '.
The SQL query to execute. Must be a valid SQL query.
1
Show child attributes
1 <= x <= 300
OK
Was this page helpful?