ColumnType not supported by API

Hi all

Due to our governmental funding requirements, I’m trying to migrate our current instance from the US server to the AU

I know the cross account copier doesnt work across regions, so have been trying to find a solution that doesnt require manual re-entry of data

Was heading towards what I thought might be a solution via a make.com workflow (get table data, create table, get group data, create group, get column data, create columns, get item data, create items)

However its falling over at the create columns due to errors regarding certain ColumnTypes not being supported in the api

Rather than running the job repeatedly and excluding these one by one, is there a list of current data sets which arent valid in the API?

Or is there a better way to do this? I tried export / import to excel but that would take a ridiculous amount of time and require alot of manual cleanup on every table since we use alot of sub-items and these come into Monday as main board items

Hello there @ToddQ,

What about using Workspace Templates as explained here?

Do you think it could fit your needs?

Looking forward to hearing from you :smile:

Cheers,
Matias

Funny you mention that… I actually stumbled across that as a solution yesterday and was coming back to update the question now to say it solved my problem :slight_smile:

I am glad that is the case @ToddQ !!