API Reference
Log In
API Reference

search a table

get
https://{databaseId}-{region}.apps.astra.datastax.com/api/rest/v2/keyspaces//
Path Params
string
required

UUID of your database from the Astra URL.
For example, d341f349-e5db-46d2-9c90-bb9ebaa6f0fc.

string
required

Cloud region where your database lives.
For example, us-east-1

string
required

keyspace name

string
required

table name

Query Params
boolean

format results

where
object

URL escaped JSON query using the following keys:
| Key | Operation |
|-|-|
| $lt | Less Than |
| $lte | Less Than Or Equal To |
| $gt | Greater Than |
| $gte | Greater Than Or Equal To |
| $ne | Not Equal To |
| $in | Contained In |
| $exists | A value is set for the key |
| $select | This matches a value for a key in the result of a different query |
| $dontSelect | Requires that a key’s value not match a value for a key in the result of a different query |
| $all | Contains all of the given values |
| $regex | Requires that a key’s value match a regular expression |
| $text | Performs a full text search on indexed fields |

string

URL escaped, comma delimited list of keys to include

int32

restrict the number of returned items (max 100)

string

move the cursor to a particular result

sort
object

keys to sort by

boolean

unwrap results

Headers
uuid
required

Unique identifier (UUID) for the request. Use any valid UUID.

string
required

The token returned from the authorization endpoint. Use this token in each request to the database.

Responses

Updated over 5 years ago

Language
URL
Response 
Click Try It! to start a request and see the response here! Or choose an example:
application/json
Updated over 5 years ago