Accepts .xlsx, .xls, or .csv. The first row is the header row; each
following row is one entity. Only the first sheet is read. Header names are case- and punctuation-insensitive
(Full Name, full_name, and FULLNAME all match).
| Column |
Accepted headers |
Required |
Notes |
| Full name |
Full Name, Display Name, Name |
Yes |
The only always-required column. |
| Email |
Email, Email Address, User Email |
Type 2 only |
Required when Entity Type ID is 2. |
| First name |
First Name, Firstname |
No |
Defaults to the first word of Full Name. |
| Last name |
Last Name, Lastname |
No |
Defaults to the rest of Full Name. |
| Parent entity |
Parent Entity ID, Parent Entity UUID, Parent UUID |
No |
Omitted when blank. |
| Entity type ID |
Entity Type ID, entity_type_id |
No |
Defaults to 2. Only 1 or 2 are honored. |
| Status |
Status |
No |
Defaults to ACTIVE. Accepts ACTIVE/INACTIVE or 1/0. |
| Entity ID |
Entity ID, Entity UUID, entity_id |
No |
A UUID is generated per row when blank. |
| Properties |
Properties, Properties JSON |
No |
Must be valid JSON; defaults to {}. |
Example header row: Full Name, Email, Parent Entity ID, Entity Type ID, Status, Properties