Upload Table From Excel

Inserts records from a type of Excel file 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
• file: Excel file to be inserted
• body: the request body if table schema columns were to be added manually, optional

Returns

A Table Pydantic object.