Upload Table From Json

Inserts records from JSON into a table previously created using create_table, or creates a new table from it.

Parameters

• table_name: the name of the table created by create_table
• schema: database schema, default “public”
• if_exists: what to do if table of the same name already exists, default “fail”. available options:
  • “fail” -> creates a new table, only possible if no table of the same name exists (fails otherwise)
  • “append” -> appends records into an existing table (columns must match in order to not generate an exception)
  • “replace” -> deletes an existing table and creates a new one with the same name
  • if user inputs anything other than these three, the server will throw an exception
• body:
  • “table”: optionally specify a table object is to be added manually.
  • “data”: where the json object with the records format (list of json objects) is specified.

Returns

A TableResponse Pydantic object.