3 Replies Latest reply on Sep 13, 2019 9:07 AM by roy at keelaro dot com

    API - Rename Multiple Campaigns

    andrepazleal

      Hi, I would like to access Eloqua API to perform a few maintenance that we have for our Eloqua Instance, today we share the instance with a whole lot of countries, we have a naming convention specific for marketing but since we share the instance, keep with a specific naming convention is hard.

       

      I need to make an modification within almost 450 campaigns with their names inside eloqua and would like to use the API for that, can someone point me a direction to that? Can I use Postman for that? Should I create a webpage to access the API, can that landing page be created inside Eloqua HTML Editor?

        • 1. Re: API - Rename Multiple Campaigns
          Lou Patrick

          Via the API, you can only update one campaign at a time. The only option to update multiple campaigns is the Import Campaigns option, which enables importing a delimited or Excel file of campaigns.

           

          To Import Campaigns: Navigate to Orchestration, then click Campaigns, click the ">>" on the top right of the screen, the select "Import Campaigns..."

          • 2. Re: API - Rename Multiple Campaigns
            andrepazleal

            Ok, but the reason to use the API is exactly that, by and external page being able to modify the campaign "name": "br_" into "name":"brLatAm" over multiple campaigns inside an shared instance where I have a huge number of campaigns without the correct prefix on the name.

            • 3. Re: API - Rename Multiple Campaigns
              roy at keelaro dot com

              HI,

               

              You need to create a simple script using PHP or your preferred language. The script process will be something like:

               

              1. Secure Login to Eloqua

              2. Search for campaigns by name or Id (depending on what you have) (API GET call)

              3. Use a REGEX if needed or a simple lookup to change the campaign name (as you know all the campaigns by name and Id that you want to change, as a one off a simple lookup list is efficient)

              4. Update the Campaign name in Eloqua (API PUT call)

               

              Note: The REST API can cycle through this. Things to be careful about with "Campaign Name" in Eloqua is that they are not unique (I'm sure you know this). When updating the Campaign name the Campaign Id must be used.

               

              You can't do this in Eloqua's landing pages. Not sure about Postman but I suspect it may not be part of their focus.

               

              I use my tool Eloqua Admin Workbench and develop the script/API calls to do these type of changes for clients.

               

              Screenshot 2019-09-13 at 09.55.02.png

               

              By the way getting a full list of Campaigns and Id is straight forward via Eloqua reporting, so you can produce a lookup list based on Id.