Skip to main content

Hello,

I'm a new to the AirTable API and trying to automate adding records with data from another API.  I have this function:

	async function updateCrewRecords(data: CrewDetailsType[]) {

		const crewBase = new Airtable({ apiKey: AT_API_KEY }).base('appxxx')

		const table = cewBase('tblxxx')



		const records = data.map((crew) => ({

			fields: {

				CrewID: crew.CrewID,

				CompanyID: crew.CompanyID,

				IsActive: crew.IsActive,

				Position: crew.Position,

			},

		}))



		try {

			// const response = await table.create(records, { typecast: true })

			const response = await table.update(records, {

				typecast: true,

				performUpsert: true,

				fieldsToMergeOn: ['CrewID'],

			})

		} catch (e: any) {

			const errorMsg = `updateCrewRecords(): ${e.message}`

			console.log(e.statusCode, errorMsg)

			// throw error(e.statusCode, e.message)

		}

	}

 The commented out table.create(records) works as expected, but the upsert doesn't.  The error I'm getting is:

422 updateCrewRecords(): Invalid request: parameter validation failed. Check your request data. 

I can't find any way to get any more specific information on what is going wrong.

Any help would be much appreciated!
Thanks,
Adam.

<grr> finally ask for help and then figure it out. 🙄

This works. 😮‍💨

const response = await table.update(records, {

	typecast: true,

	performUpsert: {

		fieldsToMergeOn: :'CrewID'],

	},

})

Reply


Terms & Conditions