Issues with using @ser to resolve invalid CSV column names

I’ve got some data in a .csv that utilizes column names with invalid chars (whitespaces in names, parentheses, slashes, etc.) that basically can’t be directly turned into fields in a canonical. To work around this, I’ve been creating valid field names for each column and utilizing the @ser annotation to link them back, as advised in: https://community.c3.ai/t/field-name-restrictions/1454 and https://community.c3.ai/t/data-integration-how-can-canonical-types-handle-whitespaces-in-csv-column-names/443/9.

@ser(name="Column 1 Name")
Column1Name: string 

Upon provisioning, I get the same issue as https://community.c3.ai/t/invalid-value-path-building-id-at-9-for-type-canonicalxyz/1968 [Invalid Value Path … ], except using @ser hasn’t fixed it.

Any ideas why? Running locally on server version 7.9.6.59.

1 Like