Python: Insert data

Parameters

• json

  (Required)

  The values to insert. Pass an dict to insert a single row or an list to insert multiple rows.

• count

  (Optional)

  The property to use to get the count of rows returned.

• returning

  (Optional)

  Either 'minimal' or 'representation'. Defaults to 'representation'.

• default_to_null

  (Optional)

  Make missing fields default to `null`. Otherwise, use the default value for the column. Only applies for bulk inserts.

Examples

Create a record

response = (
    supabase.table("planets")
    .insert({"id": 1, "name": "Pluto"})
    .execute()
)

Bulk create

try:
    response = (
        supabase.table("characters")
        .insert([
            {"id": 1, "name": "Frodo"},
            {"id": 2, "name": "Sam"},
        ])
        .execute()
    )
    return response
except Exception as exception:
    return exception