airtable 0.4.8

获取

给定一个表名，检索一个或多个记录。

at.get(table_name, table_name, record_id=None, limit=0, offset=None,
       filter_by_formula=None, view=None, max_records=0, fields=[])

其中

table_name (required) is a string representing the table name
record_id (optional) is a string, which fetches a specific item by id. If not specified, all items are fetched
limit (optional) is an integer, and it can only be specified if record_id is not present, and limits the number of items fetched (see pageSize in the AirTable documentation)
offset is a string representing the record id from which we start the offset
filter_by_formula (optional) is a string to filter the retrieving records (see filterByFormula in the AirTable documentation)
max_records (optional) is the total number of records that will be returned (see maxRecords in the AirTable documentation)
fields (optional) is a list of strings with the field names to be returned

迭代

给定一个表名，检索所有记录。

at.iterate(table_name, table_name, limit=0, offset=None,
       filter_by_formula=None, view=None, max_records=0, fields=[])

其中

table_name (required) is a string representing the table name
limit (optional) is an integer, and it can only be specified if record_id is not present, and limits the number of items fetched (see pageSize in the AirTable documentation)
offset is a string representing the record id from which we start the offset
filter_by_formula (optional) is a string to filter the retrieving records (see filterByFormula in the AirTable documentation)
max_records (optional) is the total number of records that will be returned (see maxRecords in the AirTable documentation)
fields (optional) is a list of strings with the field names to be returned

注意：这返回一个生成器，您可以使用它来遍历每条记录

# example with similar results of at.get
result = { "records": [] }
for r in self.at.iterate(self.table, fields=fields):
    result["records"].append(r)

创建

在表中创建一个新条目，并返回新创建的条目及其新ID。

at.create(table_name, data)

其中

table_name (required) is a string representing the table name
data (required) is a dictionary containing the fields and the resepective values

更新

更新表中特定条目的一些字段。未明确包含的字段将不会更新

at.update(table_name, record_id, data)

其中

table_name (required) is a string representing the table name
record_id (required) is a string representing the item to update
data (required) is a dictionary containing the fields (and the resepective values) to be updated

更新全部

类似于前面的方法，但更新所有字段，清除请求中未包含的字段。

at.update_all(table_name, record_id, data)

删除

从表中删除特定记录

at.delete(table_name, record_id)

其中

table_name (required) is a string representing the table name
record_id (required) is a string representing the item to update