External Activities Upload list automation

You could create a script that runs on a schedule, ingests a csv, converts it to json, and uploads it to the correct activity import definition, using the bulk api. You could then upload that list through the rest api and create a contact list.

Hi Simiha,

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"

https://cloud.oracle.com/marketplace/app/AppExternalActivity

Step3:

Create a segment to fetch the records those who have "External Activity record=Y'.

Step4:

Create a campaign canvas - > Add the segment +  External Activity App -> Configure the app step

Step5:

Schedule the campaign and activate.

Thanks

Thangaraj.

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.

Hi Devon,

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.