Airtable connector fail to import

user049190
user049190 ⚪️
in Connectors

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

 

Tagged:

Comments

  • GrantSmith
    GrantSmith Indiana 🥷

    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 Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories