Hello!
We just released updates to the API that allow filtering which records are returned using a formula, limiting which fields are returned, and sorting on multiple fields.
You can read more on our blog or in the API documentation.
That usually happens if the folder where npm installs global packages isn’t on your PATH. You can see the path of the folder by running: npm config ls -l | grep prefix
On my machine, running macOS I see the following output:
prefix = "/Users/kasra/.n...
You can see the underlying field IDs using this script:
for (const table of base.tables) {
output.text(table.name);
output.table(table.fields)
}
You can substitute the IDs for the names in the API, e.g. record.getCellValue(fieldId)
