Classic ASP / Cognite API v1 / Retrieve rows
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.
' {
' "id": 1844083276579324,
' "start": 0,
' "end": -14940119,
' "limit": 100,
' "cursor": "laborum",
' "columns": [
' "voluptate esse dolor",
' "ex"
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.UpdateInt("id",123)
success = json.UpdateInt("start",0)
success = json.UpdateInt("end",-14940119)
success = json.UpdateInt("limit",100)
success = json.UpdateString("cursor","laborum")
success = json.UpdateString("columns[0]","voluptate esse dolor")
success = json.UpdateString("columns[1]","ex")
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}}/sequences/data/list","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 '{
"id": 1844083276579324,
"start": 0,
"end": -14940119,
"limit": 100,
"cursor": "laborum",
"columns": [
"voluptate esse dolor",
"ex"
]
}'
https://domain.com/api/v1/projects/{{project}}/sequences/data/list
Postman Collection Item JSON
{
"id": "getSequenceData",
"name": "Retrieve rows",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"sequences",
"data",
"list"
],
"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": "Processes data requests, and returns the result. NB - This operation uses a dynamic limit on the number of rows returned based on the number and type of columns, use the provided cursor to paginate and retrieve all data.",
"body": {
"mode": "raw",
"raw": "{\n \"id\": 1844083276579324,\n \"start\": 0,\n \"end\": -14940119,\n \"limit\": 100,\n \"cursor\": \"laborum\",\n \"columns\": [\n \"voluptate esse dolor\",\n \"ex\"\n ]\n}"
}
}
}
