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.