Comment on page

SQL Operations

Select
Executes the provided SQL statement. The SELECT statement is used to query data from the database.
operation (required) - must always be sql
sql (required) - use standard SQL
Body
{
    "operation": "sql",
    "sql": "SELECT * FROM dev.dog WHERE id = 1"
}
Response: 200
[
    {
        "id": 1,
        "age": 7,
        "dog_name": "Penny",
        "weight_lbs": 38,
        "breed_id": 154,
        "owner_name": "Kyle",
        "adorable": true,
        "__createdtime__": 1611614106043,
        "__updatedtime__": 1611614119507        
    }
]
Insert
Executes the provided SQL statement. The INSERT statement is used to add one or more rows to a database table.
operation (required) - must always be sql
sql (required) - use standard SQL
Body
{
    "operation": "sql",
    "sql": "INSERT INTO dev.dog (id, dog_name) VALUE (22, 'Simon')"
}
Response: 200
{
    "message": "inserted 1 of 1 records",
    "inserted_hashes": [
        22
    ],
    "skipped_hashes": []
}
Update
Executes the provided SQL statement. The UPDATE statement is used to change the values of specified attributes in one or more rows in a database table.
operation (required) - must always be sql
sql (required) - use standard SQL
Body
{
    "operation": "sql",
    "sql": "UPDATE dev.dog SET dog_name = 'penelope' WHERE id = 1"
}
Response: 200
{
    "message": "updated 1 of 1 records",
    "update_hashes": [
        1
    ],
    "skipped_hashes": []
}
Delete
Executes the provided SQL statement. The DELETE statement is used to remove one or more rows of data from a database table.
operation (required) - must always be sql
sql (required) - use standard SQL
Body
{
    "operation": "sql",
    "sql": "DELETE FROM dev.dog WHERE id = 1"
}
Response: 200
{
    "message": "1 of 1 record successfully deleted",
    "deleted_hashes": [
        1
    ],
    "skipped_hashes": []
}

Token Authentication

Advanced JSON SQL Examples

Last modified 18d ago