Update data
Data changes, so often it is necessary to update an entire row.
To update a row, send a PUT request to /v2/keyspaces/{keyspace_name}/{table_name}/{path}.
The {path} is comprised of the primary key values.
In this example, the partition key is firstname "Mookie" and the
clustering key is lastname "Betts";
thus, we use /Mookie/Betts as the {path} in our request.
-
cURL command (/v2)
-
Result
curl -s -L -X PUT 'https://$ASTRA_CLUSTER_ID-$ASTRA_REGION.apps.astra.datastax.com/api/rest/v2/keyspaces/users_keyspace/users/Mookie/Betts' \
-H "X-Cassandra-Token: $AUTH_TOKEN" \
-H 'Content-Type: application/json' \
-d '{
"email": "mookie.betts.new-email@email.com"
}'{"data":{"email":"mookie.betts.new-email@email.com"}}|
Updates are upserts. If the row doesn’t exist, it will be created. If it does exist, it will be updated with the new row data. |
It is also possible to update only part of a row. To partially update, send
a PATCH request to /v2/keyspaces/{keyspace_name}/{table_name}/{path}.
In this example, we realize we should not have changed the email address, and
we want to only change that one column:
-
cURL command (/v2)
-
Result
curl -s -L -X PATCH 'https://$ASTRA_CLUSTER_ID-$ASTRA_REGION.apps.astra.datastax.com/api/rest/v2/keyspaces/users_keyspace/users/Mookie/Betts' \
-H "X-Cassandra-Token: $AUTH_TOKEN" \
-H 'Content-Type: application/json' \
-d '{
"email": "mookie.betts.email@email.com"
}'{"data":{"email":"mookie.betts.email@email.com"}}