Insert rows

New rows can be inserted into a table by the HTTP POST command. The RaimaDB REST interface supports JSON formatted content as data for an insert operation. The row data needs to be in the format of "columnName": "columnValue". If a column has default value or allows NULL values it does not need to be specified.

Note: In some terminals, you may have to escape the quotations inside of the JSON

The URI syntax to insert a column is:

http://hostname:port/rdm/dbname/tablename

curl -X "POST" "http://localhost:21553/rdm/bicycle_db/MANUFACTURER" -i -H 'Content-Type: application/json' -d $'{ "NAME": "Trek Bicycle Corporation", "state": "WI"}'

curl -X "POST" "http://localhost:21553/rdm/bicycle_db/BICYCLE" -i -H 'Content-Type: application/json' -d $'{ "MANUFACTURER_ID": "1", "MODEL": "Domane", "TYPE": "Road"}'