Here’s a repro case for a table with column “SingleLineText” which is of type single line text:
var Airtable = require('airtable')
var base = new Airtable({ apiKey: '<your key>' }).base('<your table id>')
base('Table 1').create({
'SingleLineText': 123
}, function (err, record) {
if (err) { console.error(err); return }
console.log('created', record.getId())
})
base('Table 1').create({
'SingleLineText': '456'
}, function (err, record) {
if (err) { console.error(err); return }
console.log('created', record.getId())
})
results in
created recc5jiGDbSGlpEsR
Class {
error: 'INVALID_VALUE_FOR_COLUMN',
message: 'Field SingleLineText cannot accept the provided value',
statusCode: 422 }
and resulting table having only one row with “456” in the SingleLineText column. i.e. the operation with 123 failed.
@openside I didn’t see typecast in the documentation, and it had been working for a few weeks already as-is, but good to know.
As said, i think it’s probably increased API strictness (not a bug) which is ok, and the original request submitted an integer, not a string value, so I’d still need to cast values to a string before adding the typecast directive.
