Airtable connector fail to import

Reply
Highlighted
White Belt

Airtable connector fail to import

Hi all,

 

Does anyone have experience with the Airtable connector in Domo? For example, is there a limitation of total columns? I am having problem importing a view (1135 columns, let's call it view A) from Airtable, but I was able to import another view from the same table (458 columns, view B).  I checked there is no emoji in view A and the app ID, table name, view name are correct. I can't figure out why this is not working. The error message is simply 'Failed to execute import successfully.'

 

Any help is appreciated. 

 

- Teresa

 

Tags (1)
Highlighted
Major Red Belt

Hi @user049190 

Yes there is a limitation to the number of columns supported when importing AirTable data. I think it was around 500 columns. You also need to be careful of nested cells as it will expand every possible value to a new column in attempt to flatten the data which will cause your number of columns to expand greatly.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.