Excel importer drops an error if ID (string attribute) contains letters.

I have an entity, “entity1”, associated with “entity2” as many-to-many. I use excel importer to import objects to entity1. Excel importer drops an error if in the ID column I have letters. So if ID is 01, 01, 03, etc, it’s fine, but A1, A2, A3, etc. – no.  But the ID attribute of entity1 is a string. So why having letters is a problem? And how can I fix it? DO I need to use some parcing microflow?   The error is:  “The following error occurred when importing document: entity1.xlsx java.lang.IllegalArgumentException - The given member name 'entity1ID' has no corresponding member in this object of type 'Main.entity2'”.
0 answers