Can't map only one Airtable table from the database : bug?

[bastien]

I did delete and recreate my Airtable connection from scratch by providing the correct token authorisations.
I’ve rebuilt the flow several times and the problem persists.

In my database, Activepieces can’t bring up the fields in my ‘Sessions’ table and I can’t map, whereas it can bring up the fields in the other tables.

The only noticeable difference between the table that doesn’t map well and the others is that the one that doesn’t map well has more records than the others (around 1500 records).

Here’s a loom that illustrates the problem: Arc - Activepieces - 13 September 2024 | Loom

And two screenshots:

Can you help me please ?

[abuaboud]

Hi @bastien

How the session table look like? what field types used there?

@kishanprmr can you please take look next week

[bastien]

I’ve copied the table but I’ve cleared it of data because it’s confidential customer data.

Here is the emptied table: Airtable - CHRONOLOGIQUE

What’s interesting is that this same emptied table has the same problem as the filled table, Activepieces doesn’t retrieve the fields and I can’t map it.

[bastien]

@abuaboud @kishanprmr I have tried everything on my side. I am pretty sure this is a bug on Activepieces side. Airtable piece is not able to correctly read my field for some reason. It is very annoying as it is my very first flow on Activepieces and the first I need to exit Zapier

[abuaboud]

Hi @bastien

Sorry to hear that, I think there is one column is problematic or the encoding, we are over committed this week.

@kishanprmr please take look when you can

[kishanprmr]

@bastien

@bastien

Here is the emptied table: Airtable - CHRONOLOGIQUE

I just copied the same table in Airtable, and it’s loading the fields. Can you provide any additional details by testing the following custom API action and sending the response via DM? You can find your baseID in the Airtable page URL after ‘https://airtable.com/’.

[bastien]

You mean I should send you the results in a private message?

[bastien]

Please see the bug here : Arc - 17 September 2024 | Loom

[bastien]

Another one here with the Custom API action : Arc - 17 September 2024 | Loom

[bastien]

Please help me, it’s so important, this is my very first flow with Activepieces and I can’t imagine being stuck like this.

[kishanprmr]

@Bastien, I think the issue is with the specific field ‘aiText’ in the table. It has been fixed. Please recreate the Airtable step to reflect the changes

[bastien]

Indeed, it is working now. Thank you very much.