A2Z + Expo Harvester Data Pull/Query

Below is an overview of the integration we offer through Cadmium EventTech Integration Services to pull basic company information from A2Z into the Expo Harvester. This integration does not pull in product information.

PREREQUISITE

Expo Harvester must be contracted in conjunction with this integration.

IMPORTANT NOTE

The third-party system is the source of truth. Exhibitors CANNOT log into the Expo Harvester to submit additional information or complete tasks.

Description

Exhibiting companies and their booth assignments are pulled into the Expo Harvester. The default frequency of the data pull is daily but can be customized to hourly closer to the event.

Considerations

The integration is simply a pull of basic company data and does not support product information. See field mapping below.
We do not support pulling in booth staff or users associated with an exhibiting company. This type of integration is not meant for users to log into or for data to be added/changed in Expo Harvester. A2Z would remain the source of truth for exhibitor data.
If a client offers booth sharing / pavilions (multiple exhibitors associated with the same booth), we need to discuss the data structure in advance to ensure we can meet the client's expectations.
- If there are co-exhibitors and/or additional listings that need to show in the mobile app, we will need to establish a cutoff date for the pull, because a product specialist will have to manually create hidden booths for those companies to show in the mobile app. If we continue pulling data, all that work will be overwritten.
Once the integration is complete, it is the client's responsibility to audit the list and ensure all companies are being pulled in that they expect to see.
We encourage you to periodically do a spot check of count on our side versus A2Z, leading up to the event, to ensure everything seems to be pulling correctly.
There is no way to integrate a floor plan but we can manually map one in Expo Harvester. Booth assignments will automatically be updated when a pull is made from A2Z; however, all changes to the floor plan itself (cutting and merging booths, etc.) will need to be updated manually in Expo Harvester by the client.

Required Credentials

EventID
SSO Encryption Token
Key
UserName
Password
InstallName

IMPORTANT NOTE

If your password ever changes (this is on the client-level in A2Z), you must notify us so we can update our code. The pull will stop working if we are using the wrong password.

Field Mapping

The following fields will be pulled over if data exists:

A2Z Field	Expo Harvester Field	Notes
CompanyID	ExhibitorExternalID	Required
ExhibitingAs	ExhibitorName	Required
ExhibitingAs	ExhibitorNameToDisplay
ExhibitingAs	ExhibitorNameSort
ExhibitingAs	ExhibitorNameShort
PrintProfile	ExhibitorDescriptionLong
ProductCategories	ExhibitorKeywords
ProductSubCategories	ExhibitorKeywords
MembershipType	ExhibitorExternalStatus	1 = Yes, 0 = No
WebsiteURL	ExhibitorWebsite
Email	ExhibitorEmail
Address1	ExhibitorAddress1
Address2	ExhibitorAddress2
City	ExhibitorCity
State	ExhibitorState
Country	ExhibitorCountry
Zip	ExhibitorZip
Fax	ExhibitorFax
Phone	ExhibitorTelephone
HARDCODED	BoothStatus	Set as "Rented" unless CompanyName = Hold
BoothNumber	BoothNumber
BoothDimension	BoothSize
BoothSize	BoothSqFt
BoothExhibitorID	BoothExhibitorID
CompanyLogo	ExhibitorLogo

Disclaimer

For this integration, Cadmium does the development to connect to the third-party system. It is the Customer's responsibility to verify development needs and associated costs with the third-party to allow Cadmium to connect to their system. The required credentials Cadmium needs from the third-party to develop the integration are noted above.

Last modified Jun 18, 2024