Airtable API Patch Request Fails in ADF

Jon Carlisle 91 Reputation points
2023-01-27T22:23:38.65+00:00

I'm trying to update data in Airtable using Rest API in ADF. I get an error. I'm trying to execute a PATCH. Here's my mapping.

User's image

Example request from Airtable API documentation:
User's image

Why is this not working?

Error Message:
Response: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}},Source=Microsoft.DataTransfer.ClientLibrary,'

Thank you!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,241 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.