Integration configuration page

Access to the API

Developer API access (enabled at the organization level) is needed for organization members to access, connect, and configure the integrations modules on an organization’s workspace(s).

Organization admins by default have Developer API access enabled for that organization. Organization admins can also enable Developer API access for people who have an “Organizer” role within the organization. More information on managing roles within an orgnanization.

Workspace roles are not taken into consideration when it comes to having Developer API access.

Credentials

On Backstage, go to the API module, navigate to API credentials and click on Credentials. Then click and edit the value for the fields presented (for example: account, user name, password and event code). The endpoint is pre-configured.

To test the credentials, go to the next step.

Mapping

The mapping consists of "bridges" that you build between the API and Backstage, so that the data from the API is imported into the relevant Backstage fields, for example the participants' first names in the API are imported in the "fname" field in Backstage.

Each API comes with pre-set mapping. You can either manually edit the mapping, or import it from a previous event using the same API.

Import mapping from a previous event

• Go to API Data > Data Configs on a previous event and click Export XLS.
• Remove the data configs for which you do not need to import the mapping, and then save the file
• Import the XLS file in the new event in API Data > Data Configs.

Manually edit the mapping

Click on the data type. Under API Data Mappings you will see all the fields already mapped.

• Edit a field mapping: click on a field and edit the values (you need to specify at least the API field and the corresponding SpotMe field it should be mapped to).
  
  
• Create a new field mapping: Click on + under API Data Mappings (you need to specify at least the API field and the corresponding SpotMe field it should be mapped to). Don't forget to save your changes. By default, empty fields will not be imported.
  
  
• Remove a field mapping: Click on the red X on the right of the field.

Once the mapping is edited as desired, make sure to preview the corresponding data type(s) and check that there is content imported for the fields in the Synced Data tab (see details below in the Preview section).

Create metadata

For each API field that you map to a SpotMe field in the Data Configs, you need to have a corresponding metadata in Backstage, otherwise the data cannot be displayed in Backstage.

If you map API fields to SpotMe fields that do not exist yet, make sure to create the corresponding metadata (person metadata, session metadata, presenter metadata etc.) in Setup > Manage metadata. The name of the SpotMe field in the API mapping must correspond exactly to the name of the metadata.

Preview

Preview allows to check the data before actually importing it, to make sure that the expected data will be added to the event.

Go to Data Config: all pre-configured data configuration types are available here (Participants, Sessions, Sessions, etc.)

Click on Preview on one of the data configurations that will be used to download the preview file. Make sure to download the report and check the data:

• The Stats tab gives you an overview of the changes.
• The Raw API Data tab shows all the data that is included in the client's system (with all fields, including the ones that are not mapped).
• The Synced Data shows the data as it would be imported.
• Invalid (failed) shows a list of records that cannot be imported because of invalid fields or values.

If you don’t see the first three tabs, or if you see an error message, it means that something is wrong with the credentials you have received from the data provider.

Sync

After previewing the data, if there is nothing out of the ordinary, click on Sync Data for each data type you wish to sync.

After syncing, make sure to download the sync report and to check that the data has been imported correctly. The report includes one tab with the following details:

• Status of the sync (if not completed, contact support)
• fp_type
• Received: number of records that we receive from the endpoint
• Unchanged: number of records that we have already created for which there are no changes
• Updated: number of records that we have already created for which there are changes
• Deleted: number or records that are deleted from Backstage
• Invalid: number of records that are invalid

Note: You will need to sync both Participants and Sessions data before being able to preview and sync any Session registrations. We recommend that you do not sync manually more often than every hour.

Auto-sync

Please note that auto-sync should not be set up unless necessary, since it causes additional stress to our servers, and the maximum frequency is every 15 minutes.

You can enable an auto-sync on any of the data configs in the API.

1. Click on a data config, and in Auto sync frequency select the frequency you need. If nothing is selected in the dropdown list, the auto-sync will be enabled with a 60 minutes frequency by default.
   
   
2. On the data configs page, click on Auto-sync for the desired data configs.
   
   
3. You will get a confirmation popup, and the enabled Auto-sync will be highlighted in green.
   
   
4. The auto-sync will automatically stop 7 days after the end date of the event. If you need it to run longer, please contact SpotMe Support.

Please note that the scheduled jobs for the auto-sync are created on the root by default. For big events, make sure to ask SpotMe Support which server to use and have the jobs configured to that server (developer access to Backstage is required to edit scheduled jobs).

You can check when the next sync will run with the following link:

https://[node].4pax.com/api/v1/eid/[eid]/scheduler

by replacing [node] with the root of your event, for example euadmin6, and [eid] with the event id, for example f9792a1ea7e22987af3de9e44200f9f6.

Automated sync reports

If you are using an auto-sync, you may want to receive automated sync reports via email, especially to be warned about any sync error. To set up an automated sync report:

1. Click on a data config.
   
   
2.  On the right side, Email Subscribers, click on Create.
   
   
3. Enter the name of the subscribers list, the event for which you want to get an automated report (Any sync / Error occurred during sync / Never), and add the email address(es) of subscribers.
   
   
4. Make sure to add the subscribers list on each data config for which you want to get an automated report (reports are generated separately for each data config).
   
   
5. You can also create several subscribers lists, and attach them to different data configs:

Please note this functionality is available on data-api 1.1.1 and higher.