Trying to pull two dimension in a single API call

Question

I am new to Adobe Analytics API. I am trying to create a pipeline to extract data from adobe API.

I have two dimension which I need to pull , For example :

evar1 and evar2 in a single API call. I was reading through the documentation but was not able to progress through it.

My request body looks something like this : I am trying to bring in evar1 along with evar2 in this single API call.

body = {
'rsid': 'rsid',
'globalFilters': [{
'type': 'dateRange',
'dateRange': '2023-07-01T00:00:00/2023-07-16T23:59:59.999'
},
{
'type': 'segment',
'segmentId': 'sgid'
}],
'metricContainer': {
'metrics': [
{'id': 'metrics/occurrences'},
]}
,
'dimension': 'variables/evar1',
'settings': {
'dimensionSort': 'asc',
'limit':'100000'
}
}

AritraBh · Accepted Answer

Can you share what you are doing? If you are trying to pull multiple dimensions you can only do so as a Breakdown... not a flat table.

I.e.
metric X

eVar1 - value 1 ###

eVar2 - value 1 ##

eVar2 - value 2 ##

eVar1 - value 2 ###

eVar2 - value 1 ##

eVar2 - value 2 ##

If you need a flat table, you should consider using the Data Warehouse exports.

eVar 1 - Value 1 | eVar 2 - Value 1 | ###

eVar 1 - Value 1 | eVar 2 - Value 2 | ###

eVar 1 - Value 2 | eVar 2 - Value 1 | ###

eVar 1 - Value 2 | eVar 2 - Value 2 | ###

how would I create a body for data warehouse exports? As in if I am writing my code in python , is there a way to connect to the data warehouse and fetch data ?

Jennifer_Dungan · Answer

A little known fact is that Workspace is built using API 2.0; and you can actually get the API calls that are used right from the Workspace.

First, you need to enable debug mode:

This will add a new Icon to your tables:

When you click on the icon, you will get the option for the Sparkline or the Table, choose the table:

Now, you will be presented with Timestamps.. more complex tables may use multiple API calls:

When you click on each time, a new page will open showing you the API used in multiple formats including JSON and Curl, etc.

This might be a better starting point than trying to write the API from scratch.

Sign up

Login with SSO

Login to the community

Login with SSO