C# and REST API: Uploading Multiple Records to Airtable

Other Questions Airtable
1

I’m learning about APIs and JSON. I’ve managed to upload a single record to Airtable using their API, but now I need to post multiple rows at once. Here’s what I’ve done so far:

public static async Task UploadRecord()
{
    using (var client = new HttpClient())
    {
        var request = new HttpRequestMessage(HttpMethod.Post, "https://api.airtable.com/v0/MYAPPID/MyTable");
        request.Headers.Add("Authorization", "Bearer MYAPIKEY");
        request.Content = new StringContent("{\"records\": [{\"fields\": {\"Column1\": \"Value1\"}}]}");
        request.Content.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json");

        await client.SendAsync(request);
    }
}

I’ve also created a model for the data structure:

public class AirtableModel
{
    public class DataFields
    {
        public string Column1 { get; set; }
    }

    public class Entry
    {
        public DataFields fields { get; set; }
    }

    public class DataSet
    {
        public List<Entry> records { get; set; }
    }
}

How can I use this model to send multiple records from a DataGridView or list? I’m stuck on how to properly format the data for the API request. Any help would be great!

2

I’ve been in your shoes, Noah. When I first started working with the Airtable API, I struggled with bulk uploads too. Here’s a tip that saved me hours:

Instead of creating a new HttpClient for each request, consider using a static HttpClient. It’s more efficient and helps avoid socket exhaustion.

For your multiple record upload, you could create a method like this:

private static readonly HttpClient client = new HttpClient();

public static async Task UploadMultipleRecords(List<AirtableModel.Entry> entries)
{
    var dataset = new AirtableModel.DataSet { records = entries };
    var json = JsonConvert.SerializeObject(dataset);

    var request = new HttpRequestMessage(HttpMethod.Post, "https://api.airtable.com/v0/MYAPPID/MyTable");
    request.Headers.Add("Authorization", "Bearer MYAPIKEY");
    request.Content = new StringContent(json, Encoding.UTF8, "application/json");

    var response = await client.SendAsync(request);
    response.EnsureSuccessStatusCode();
}

This approach has worked wonders for me when dealing with large datasets. Just remember to properly dispose of the HttpClient when your application shuts down.

3

I’ve implemented a similar solution in my projects. Here’s what you can do:

Create a List<AirtableModel.Entry> and populate it with your data. Then, instantiate an AirtableModel.DataSet with this list.

You can then serialize this DataSet to JSON and use it in your HTTP request. Here’s a modified version of your UploadRecord method:

public static async Task UploadMultipleRecords(List<AirtableModel.Entry> entries)
{
var dataset = new AirtableModel.DataSet { records = entries };
var json = JsonConvert.SerializeObject(dataset);

using (var client = new HttpClient())
{
    var request = new HttpRequestMessage(HttpMethod.Post, "https://api.airtable.com/v0/MYAPPID/MyTable");
    request.Headers.Add("Authorization", "Bearer MYAPIKEY");
    request.Content = new StringContent(json);
    request.Content.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json");

    await client.SendAsync(request);
}

}

This should handle multiple records efficiently. Remember to handle any exceptions that might occur during the API call.

4

hey noah, i’ve dealt with this before. u can serialize ur DataSet object to JSON using Newtonsoft.Json:

var dataset = new AirtableModel.DataSet { records = yourListOfEntries };
var json = JsonConvert.SerializeObject(dataset);

then use that json string in ur StringContent. should work for multiple records. good luck!