Validation Options

[IAmVigneswaran]

@arjunprakash027 Similarly to csv2notion. Let's implement Validation Options.

validation options:

--mandatory-column COLUMN
CSV column that cannot be empty (use multiple times for multiple columns)

--fail-on-relation-duplicates
fail if any linked DBs in relation columns have duplicate entries; otherwise, first entry in alphabetical order will be treated as unique when looking up relations

--fail-on-duplicates
fail if Airtable or CSV has duplicates in key column, useful when sanitizing before merge to avoid ambiguous mapping

--fail-on-duplicate-csv-columns
fail if CSV has duplicate columns; otherwise last column will be used

--fail-on-conversion-error
fail if any column type conversion error occurs; otherwise errors will be replaced with empty strings

--fail-on-missing-columns
fail if columns are present in CSV but not in Airtable; otherwise those columns will be ignored

Thank you.

[arjunprakash027]

added fail-on-duplicate-csv-columns!