Resources
| Data Source Type: | REST/URL data source |
| Authentication: |
Eloqua Username and Password Basic HTTP Authentication |
| Sample Query: | https//Your-Base-URL/API/rest/1.0/assets/emails |
| API Documentation: | Oracle Eloqua API Documentation |
Note: This guide assumes that you already have an active Eloqua account.
Prerequisite: Find your Eloqua base URL
Your Eloqua base URL is a key element in getting data from your Eloqua account. You can can find your base URL in your Eloqua account in the address bar at the top of the page:
Keep your base URL handy for setting up your connection with Eloqua.
In Klipfolio: Start the data source creation process
To create a data source using Eloqua, go to the Connector Gallery page in Klipfolio and select Eloqua. If you don't see Eloqua in the list, select REST/URL.
Pick a data request
Get data faster with the example data requests. They are fully editable if you want to customize your request. If you choose to go custom, we highly recommend that you use Eloqua API documentation to help you get started with editing your query.
For this article, let's choose the Emails data request.
- On the Choose a pre-built or custom connection page, click Emails.
Edit your query URL
Your query URL is https://<Your-Base-URL>/API/rest/1.0/assets/emails
First, replace <Your-Base-URL> with the base URL that you found in your Eloqua account.
Once you have completed your query:
- Select Authentication (OAuth, 2-Step, X-WSSE, or Basic).
- Under Type, select Basic HTTP Authentication.
- At Username, enter your company name and username in the following format: "yourcompany\username" (for example, "acmeconsulting\johnsmith")
- At Password, enter your Eloqua password for the username above.
- Select Get data.
- Ensure this is the data you’re looking for and, optionally, select the checkbox to Model your data. Learn more about modelling your data source here.
- Click Continue.
- Name, choose refresh settings, and, optionally, share your data source.
- Click Save.