Below approach does not require an API
You can use Data Import and Export option.
Step1: Configure the file path from SFTP server and schedule the import on the recurring basis. (You can flag the contacts with Y/N value in separate field to identify in eloqua contact database. Create & Map to the contact field called "External Activity record")
Step2: Install the cloud app "External Activity"
Create a segment to fetch the records those who have "External Activity record=Y'.
Create a campaign canvas - > Add the segment + External Activity App -> Configure the app step
Schedule the campaign and activate.
If this is on a campaign, then a contact can only run through it once. What if a contact is a member of multiple external activities? This app doesn't run in the program canvas.
Also, where do you map the campaign ID, external activity, asset date, asset name, and asset type fields? You would need to configure that in the app and create a new segment and campaign for each possibility. The asset type, activity, and name are static within the app configuration on the canvas.
In the multiple occurrence case, Segment can be configured and route the contacts from the Program canvas to the campaign canvas. (Allow contacts to enter multiple times)
Yes, i agree. The app needs to be configured with the necessary external activity details. Configure the app based on the segment setup. More than 3 app step needs to configured based on the number of external activity type.
Thank you both. I do have 2 concerns when we do this, 1. How can we track if there is an issue 2. How can do deduplicate meaning, same member could be in 3 different external activities at the same list upload?