Tutorial: create some random rows with python inside SeaTable

Here is a very short tutorial how to generate some rows with a Python-Script.
Here is how it looks like:


The script is simple:

  • The first part is the authentication against the current base.
  • I create a loop that is executed ten times.
  • Every time I define row data to create two new rows
  • I append the two new rows
  • The loop goes on until 10 runs were completed.

In this way, you can generate a lot of dummy data in a very short time.
Please be aware that the column structure has to be created first. The columns are not generated on the fly.

And here is the code:

from seatable_api import Base, context
import random

# context.server_url
server_url = 'https://seatable-demo.de' 
api_token = context.api_token
base = Base(api_token, server_url)

# execute batch append multiple times
for i in range(10):

  # define the data for two new rows
  rows_data = [
      'Name': "I am new Row",
      'single': "new",
      'random': random.randint(0,100000000),
      'rating': random.randint(0,5)
      'Name': "I am second new row",
      'single': "more than new",
      'random': random.randint(0,100000000),
      'rating': random.randint(0,5)

  # append the two rows
  base.batch_append_rows(context.current_table, rows_data)