Create a table users
POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables
{{baseurl}}/v2/schemas/keyspaces/userskeyspace/tables
{
name
: users
,
columnDefinitions
:
[
{
name
: firstname
,
typeDefinition
: text
},
{
name
: lastname
,
typeDefinition
: text
},
{
name
: favorite color
,
typeDefinition
: text
}
],
primaryKey
:
{
partitionKey
: [firstname
],
clusteringKey
: [lastname
]
},
tableOptions
:
{
defaultTimeToLive
: 0,
clusteringExpression
:
[{ column
: lastname
, order
: ASC
}]
}
}
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
pretty | string | format results |
Request Body
{"name"=>"{{rtable}}", "columnDefinitions"=>[{"name"=>"firstname", "typeDefinition"=>"text"}, {"name"=>"lastname", "typeDefinition"=>"text"}, {"name"=>"favorite_color", "typeDefinition"=>"text"}], "primaryKey"=>{"partitionKey"=>["firstname"], "clusteringKey"=>["lastname"]}, "tableOptions"=>{"defaultTimeToLive"=>0, "clusteringExpression"=>[{"column"=>"lastname", "order"=>"ASC"}]}}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
X-Cassandra-Token | string | (Required) The token returned from the authorization endpoint. Use this token in each request to the database. | |
Content-Type | string |
RESPONSES
status: Created
{"name":"users"}