Managing databases from the API
Getting database information
Getting all of the databases in a workspace
To list all of the databases in a specific workspace:
The response contains an array of database objects. For each database, the database object contains the following fields:
Where:
id
The UUID of the database.
name
The name of the database.
created_at
The date and time when the database was created.
updated_at
The date and time the database configuration was most recently updated.
last_generated
The date and time that the database data was most recently generated.
data_url
The URL to download the most recently generated data. Until the data is generated, this is null.
workspace
The identifier and name of the workspace that the database belongs to.
Getting details for a specific database
To get the details for a specific database by name:
Creating and managing database configuration
Creating or updating a database
To create a database or update an existing database:
The request body is a database object with the database configuration.
The response contains a database object with the new or updated database configuration.
Deleting a database
To delete a database:
Returns an empty response body with a 200 status code.
Adding static data to a table
In Fabricate, instead of generating the data for a table, you can provide static data in the form of a .csv file. For more information, go to Attaching static data to a table.
From the API, to update the .csv file content:
This method expects a multipart/form-data request body with a file parameter that contains the contents of the .csv file to use for the table data.
The response contains an empty response body with a 200 code.
Last updated