# 422 error - Api data to Airtable

**URL:** <https://community.parabola.io/t/422-error-api-data-to-airtable/1400>\
**Category:** Ask a question\
**Tags:** Using-APIs\
**Created:** [December 15, 2020, 3:40pm UTC](https://community.parabola.io/t/422-error-api-data-to-airtable/1400 "2020-12-15T15:40:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hannah](https://avatars.discourse-cdn.com/v4/letter/h/f04885/32.png) [@Hannah](https://community.parabola.io/u/Hannah)\
**Post date:** [December 15, 2020, 3:40pm UTC](https://community.parabola.io/t/422-error-api-data-to-airtable/1400/1 "2020-12-15T15:40:49Z")

</div>

Hi, I’m wondering if anyone can help? I am completely new to this and not sure what I am doing wrong.  
I am trying to complete a workflow that sends data from an API to Airtable, but I am getting this error:

{  
“error”: {  
“message”: “You must provide an array of up to 10 record objects, each with an “id” ID field and a “fields” object for cell values.”,  
“type”: “INVALID\_RECORDS”  
}  
}

Here is the body:  
{  
“records”: [  
{  
“id”: “{jobkey}”,

```
  "fields": {
    "Company Name": "{company}",
    "id": "{jobkey}",
    "Location": "{formattedLocation}",
    "Application URL": "{url}",
    "description": "{description}",
    "Published date": "{date}",
    "Job Title": "{jobtitle}",
    "Image": "{logo}"
     }
}

```

]  
}`

When looking at ‘view sent request’ it all looks like the data is pulling through.

Many Thanks!

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [December 15, 2020, 9:33pm UTC](https://community.parabola.io/t/422-error-api-data-to-airtable/1400/2 "2020-12-15T21:33:32Z")

</div>

Hey @Hannah,

Welcome to the community! Starting with your JSON `Request Body`, it looks like the `jobkey` column is being passed as a record id. The record id is a unique value provided by Airtable that’s linked to every row in your base.

To get those values, use a [Pull from Airtable](https://parabola.io/integration/airtable) step. You’ll notice a new column called `id`. We’ll need to use those values and merge them into your API call.

 ![pull-airtable](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/1c2a1640dc78bb39d509d693c672f17e536a8d23.png)

To link your record ids into your Send to an API step, you’ll want to combine your [Pull from an API](https://parabola.io/integration/api#pull-from-an-api) step with your Pull from Airtable step. You’ll want to keep rows that match on a shared column like `jobkey` from each step.

 ![airtable-flow](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/7/7276af60597f1e72bb5d4f6c6f975fb46601bf25.png)

You’ll then want to format your JSON using the new `id` column.

```auto
{
	"records": [{
		"id": "{id}",

		"fields": {
			"Company Name": "{company}",
			"id": "{jobkey}",
			"Location": "{formattedLocation}",
			"Application URL": "{url}",
			"description": "{description}",
			"Published date": "{date}",
			"Job Title": "{jobtitle}",
			"Image": "{logo}"
		}
	}]
}

```

Let us know if that helps!