Search a table

get https://{databaseId}-{region}.apps.astra.datastax.com/v2/keyspaces/{keyspace-id}/{table-id}

Path Params

databaseId

string

required

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

region

string

required

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

keyspace-id

string

required

keyspace name

table-id

string

required

table name

Query Params

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 |

fields

string

URL escaped, comma delimited list of keys to include

page-size

int32

restrict the number of returned items

page-state

string

move the cursor to a particular result

sort

object

keys to sort by

raw

boolean

Defaults to false

unwrap results

Headers

X-Cassandra-Token

string

required

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

Responses

Language

URL


xxxxxxxxxx
1
curl --request GET \
2
     --url 'https://databaseid-region.apps.astra.datastax.com/v2/keyspaces/keyspace-id/table-id?where=&sort=&raw=false' \
3
     --header 'accept: application/json'

Click Try It! to start a request and see the response here! Or choose an example:

application/json

*/*

200

400Bad Request

401Unauthorized

500Internal server error