ADITUS/Exhibitors/Import

Import

Exhibitor import

Use these endpoints to import exhibitors for a specific event via an Excel file or JSON data.
The import process is asynchronous.

  1. Start an import task.
    Use 'POST Import Exhibitors by Excel' or 'POST Import Exhibitors by JSON'.

  2. Poll the task status until it is complete.
    Use 'GET Import Task Status'.

  3. Retrieve the final result with detailed success/error information.
    Use 'GET Import Task Result'.

Data Structure Definition

This API describes the data objects used for importing exhibitor-related information into the system.

All objects defined here can be used for both file-based imports (e.g., CSV or XLSX) and payload-based imports (JSON).

StartFragment

Exhibitor Object

Describes an exhibitor to be imported.

Fields

FieldTypeRequiredDescription
Exhibitor_ExternalIdstringUnique identifier of the exhibitor in the source system
Exhibitor_Name1stringName of the exhibitor
Exhibitor_Name2, Exhibitor_Name3, Exhibitor_Name4stringExtended name information
Exhibitor_LineOfBusinessstringIndustry or line of business
Exhibitor_CountryLookupstringTwo-letter ISO country code
Exhibitor_SpokenLanguagestringTwo-letter ISO language code
Exhibitor_Info1Exhibitor_Info32stringCustom text fields for exhibitor-specific information
Exhibitor_ExternalId2, Exhibitor_ExternalId3integerCustom external numeric identifiers

Fairevent Appearance Object

Describes a specific trade fair appearance of an exhibitor.

Each appearance is linked to the event context of the import and requires a valid Exhibitor_ExternalId.

Fields

FieldTypeRequiredDescription
FaireventAppearance_ExternalIdstringUnique identifier of the appearance in the source system
FaireventAppearance_HallstringHall of the event
FaireventAppearance_FloorstringFloor of the event
FaireventAppearance_BoothstringBooth number
FaireventAppearance_AreanumberBooth size in m²
FaireventAppearance_CancelledOnstringCancellation date (format: "dd.MM.yyyy HH:mm:ss" or "dd.MM.yyyy")
FaireventAppearance_CancelledReasonstringCancellation reason
FaireventAppearance_Info1FaireventAppearance_Info30stringCustom text fields
FaireventAppearance_ExternalId2, FaireventAppearance_ExternalId3integerCustom numeric identifiers
FaireventAppearance_EntryStatusstring or integerControls ticket access rights:
AllOperationsAllowed / 0 – Both exhibitor and visitor passes allowed
ExhibitorTicketsBlocked / 1 – Exhibitor passes blocked
VisitorTicketsBlocked / 2 – Visitor passes blocked
ExhibitorVisitorTicketsBlocked / 3 – Both blocked
Empty – No validation performed

Contact Data

All contact imports require the field Exhibitor_ExternalId to assign contacts to the correct exhibitor.

a) Email Contacts

Describes a business email address of the exhibitor.

FieldTypeRequiredDescription
EMailstringEmail address in one of the following formats:
mail@aditus.de
mail@aditus.de (Display)
'Display'
'Display'mail@aditus.de
'Display' mail@aditus.de

{email} represents a valid email address.
{display} may include letters, digits, and spaces.


b) Phone Contacts

Describes a business phone number.

FieldTypeRequiredDescription
PhonestringBusiness phone number

c) Generic Contact Data

Describes any contact data type (e.g., fax, secondary email, etc.).

FieldTypeRequiredDescription
Contact_ExternalIdstringUnique contact identifier in the source system
Contact_ValuestringContact value (e.g., email or phone)
Contact_ContactNameLookupstringContact name (default: "eMailBusiness")
Contact_ContactTypeLookupstringContact type (default: "EMail")
Contact_Info1Contact_Info10stringCustom text fields
Contact_IsMainContactbooleanIndicates if the contact is the main contact
Contact_ExternalId2, Contact_ExternalId3integerCustom numeric identifiers

Address Data

Describes address data associated with the exhibitor.

To import multiple addresses, the exhibitor entry must be repeated with distinct address data.

FieldTypeRequiredDescription
Address_ExternalIdstringUnique identifier of the address in the source system
Address_Street, Address_Street2, Address_Street3stringStreet and additional lines
Address_StreetNumberstringStreet number
Address_Line1Address_Line3stringAddress lines
Address_CitystringCity
Address_StateOrProvincestringState or province
Address_CountystringCounty or region
Address_CountryLookupstringTwo-letter ISO country code
Address_PostalCodestringPostal code
Address_PostOfficeBoxstringPO Box
Address_AddressTypeLookupstringAddress type (default: "Business Address")
Address_IsMainAddressbooleanMarks the main address
Address_Info1Address_Info10stringCustom text fields
Address_ExternalId2, Address_ExternalId3integerCustom numeric identifiers

Ticket Quotas

Optional ticket quotas may be defined using the format:

TicketQuota{XXX}
TicketQuota{XXX}ShortCode

Where {XXX} is a sequential integer (1 ≤ {XXX} ≤ n).

Short codes apply to 1:n ticket models and are mandatory if such an article is referenced.

If quotas for a given appearance already exist, they will be updated or extended — reductions are not performed.
FaireventAppearance_ExternalId is mandatory to assign ticket quotas.


User Accounts

If configured, user accounts can be automatically created for imported exhibitors.

A valid email address (EMail) is mandatory.

If FaireventAppearance_ExternalId is provided, the user receives access to that event appearance.

Imported users automatically receive the roles "BaseRole" and "Exhibitor".

FieldTypeRequiredDescription
User_FirstNamestringFirst name
User_LastNamestringLast name
User_DeeplinkTokenstringExternal identifier for ESC DeepLink (unique per user)
User_Info1User_Info10stringCustom text fields

If configured, activation emails will be sent after import for all newly created accounts.

Endpoints#endpoints