Airtable: Import Records

script

// set values from your account
let baseId = "appOSVpC6cay6jFbX"
let tableName = "Debug"

// create Airtable value
let at = new Airtable()
let content = `# Imported Records, Table: ${tableName}

`

// request list of records in the table
let results = at.listRecords(baseId, tableName)
if (results) { // we got values!
	let records = results["records"] // array of records
	// loop over records array
	for (const record of records) {
		// get fields from record
		// loop over them and make a line
		let fields = record["fields"]
		let vals = []
		let keys = Object.keys(fields).sort()
		for (const fieldName of keys) {
			vals.push(fields[fieldName])
		}
		content += vals.join(", ")
		content += "\n"
	}
	// create a new draft with the results
	let d = new Draft()
	d.content = content
	d.update()
	editor.load(d)
	app.setClipboard(JSON.stringify(records))
}
else { // something when wrong, log error
	console.log(at.lastError)
	context.fail()
}