How to insert data into an SQL Database table

Learn how to insert data into an SQL Database table using the Azion API.

View as Markdown

If you’ve already created a database, you can use Azion SQL Database to insert new data into it through the Azion API.

Adding data into a table

Run the following POST request in your terminal, replacing [TOKEN VALUE] with your personal token and {id_database} with the ID of the table you want to insert data into:

curl --location 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \
--header 'Authorization: Token [TOKEN VALUE]' \
--header 'Content-Type: application/json' \
--data {
"statements": [
"INSERT INTO users VALUES (1, '\''item 1'\'');",
"INSERT INTO users VALUES (2, '\''item 2'\'');",
"INSERT INTO users VALUES (3, '\''item 3'\'');"
]
}

You should receive the following response:

{
"state": "executed",
"data": [
{
"results": {
"columns": [],
"rows": []
}
},
{
"results": {
"columns": [],
"rows": []
}
},
{
"results": {
"columns": [],
"rows": []
}
}
]
}