Back to Collection Items
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = Server.CreateObject("Chilkat.Http")
' Use this online tool to generate code from sample JSON: Generate Code to Create JSON
' The following JSON is sent in the request body.
' {
' "query": "sin",
' "convertToString": true,
' "limit": 14015535,
' "sourceLimit": -32489793,
' "inferSchemaLimit": 97832
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.UpdateString("query","sin")
success = json.UpdateBool("convertToString",1)
success = json.UpdateInt("limit",14015535)
success = json.UpdateInt("sourceLimit",-32489793)
success = json.UpdateInt("inferSchemaLimit",97832)
http.SetRequestHeader "content-type","application/json"
http.SetRequestHeader "api-key","{{api-key}}"
' resp is a Chilkat.HttpResponse
Set resp = http.PostJson3("https://domain.com/api/v1/projects/{{project}}/transformations/query/run","application/json",json)
If (http.LastMethodSuccess = 0) Then
Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
Response.End
End If
Response.Write "<pre>" & Server.HTMLEncode( resp.StatusCode) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( resp.BodyStr) & "</pre>"
%>
</body>
</html>
Curl Command
curl -X POST
-H "api-key: {{api-key}}"
-H "content-type: application/json"
-d '{
"query": "sin",
"convertToString": true,
"limit": 14015535,
"sourceLimit": -32489793,
"inferSchemaLimit": 97832
}'
https://domain.com/api/v1/projects/{{project}}/transformations/query/run
Postman Collection Item JSON
{
"id": "runPreview",
"name": "Run query",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"transformations",
"query",
"run"
],
"query": [
],
"variable": [
]
},
"method": "POST",
"header": [
{
"key": "api-key",
"value": "{{api-key}}",
"description": "An admin can create API keys in the Cognite console."
},
{
"key": "content-type",
"value": "application/json"
}
],
"description": "Preview a SQL query.",
"body": {
"mode": "raw",
"raw": "{\n \"query\": \"sin\",\n \"convertToString\": true,\n \"limit\": 14015535,\n \"sourceLimit\": -32489793,\n \"inferSchemaLimit\": 97832\n}"
}
}
}
