[Adobe Analytics API] Specifying report date format. | Community
Skip to main content
G
goncalolopes
November 15, 2021
Solved

[Adobe Analytics API] Specifying report date format.

  • November 15, 2021
  • 2 replies
  • 2449 views

Hello,

Is it possible to specify the format of the date values in the JSON report built using the Adobe Analytics API?

For example, currently date comes in format Month Day, Year. Is it possible to get the date in an ISO 8601 format (Year-Month-Day)?

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by David_Jerome

Gotcha!

 

Just had a look back at my scripts (using Python) and I did a work around.

 

AdobeAPIdate = today - timedelta(days = 1)

#CREATE THE ADOBE API DATES WITH ADOBE NAMING LOGIC (E.G. 00 for Jan)
adjust = 1
while adjust < 31:
if ((str(AdobeAPIdate))[5:7]) == '01':
monthshift = '00'
elif ((str(AdobeAPIdate))[5:7]) == '02':
monthshift = '01'
elif ((str(AdobeAPIdate))[5:7]) == '03':
monthshift = '02'
elif ((str(AdobeAPIdate))[5:7]) == '04':
monthshift = '03'
elif ((str(AdobeAPIdate))[5:7]) == '05':
monthshift = '04'
elif ((str(AdobeAPIdate))[5:7]) == '06':
monthshift = '05'
elif ((str(AdobeAPIdate))[5:7]) == '07':
monthshift = '06'
elif ((str(AdobeAPIdate))[5:7]) == '08':
monthshift = '07'
elif ((str(AdobeAPIdate))[5:7]) == '09':
monthshift = '08'
elif ((str(AdobeAPIdate))[5:7]) == '10':
monthshift = '09'
elif ((str(AdobeAPIdate))[5:7]) == '11':
monthshift = '10'
elif ((str(AdobeAPIdate))[5:7]) == '12':
monthshift = '11'
AdobeCustomDates.append((str(1))+((str(AdobeAPIdate))[2:4])+monthshift+((str(AdobeAPIdate))[8:11]))
adjust += 1
AdobeAPIdate = today - timedelta(days = adjust)

 

Then I used "AdobeAPIdate" as the date for output to SQL / google sheets.

 

 

2 replies

David_Jerome
David_Jerome
Level 6
November 15, 2021

Yes you can.

 

Here is bit of the code I use...

 


body = {
'rsid': 'yourrsid',
'globalFilters': [
{
'type': 'dateRange',
'dateRange': '2021-03-01T00:00:00.000/2021-03-05T00:00:00.000'
}
],
'metricContainer': {
'metrics': [
{
'columnId': 'metrics/event1:::0'..............

    G
    goncalolopesAuthor
    November 15, 2021

    I meant on the resulting JSON report.
    When using the dimension 'variables/daterangeday', the date values come in the format 'Month Day, Year', for example:

    ... "value":"Dec 31, 2017", ...

    What I'm looking for here would be so these dates come in ISO 8601 format:

    ... "value":"2017-12-31", ...​
    David_Jerome
    David_JeromeAccepted solution
    Level 6
    November 15, 2021

    Gotcha!

     

    Just had a look back at my scripts (using Python) and I did a work around.

     

    AdobeAPIdate = today - timedelta(days = 1)

    #CREATE THE ADOBE API DATES WITH ADOBE NAMING LOGIC (E.G. 00 for Jan)
    adjust = 1
    while adjust < 31:
    if ((str(AdobeAPIdate))[5:7]) == '01':
    monthshift = '00'
    elif ((str(AdobeAPIdate))[5:7]) == '02':
    monthshift = '01'
    elif ((str(AdobeAPIdate))[5:7]) == '03':
    monthshift = '02'
    elif ((str(AdobeAPIdate))[5:7]) == '04':
    monthshift = '03'
    elif ((str(AdobeAPIdate))[5:7]) == '05':
    monthshift = '04'
    elif ((str(AdobeAPIdate))[5:7]) == '06':
    monthshift = '05'
    elif ((str(AdobeAPIdate))[5:7]) == '07':
    monthshift = '06'
    elif ((str(AdobeAPIdate))[5:7]) == '08':
    monthshift = '07'
    elif ((str(AdobeAPIdate))[5:7]) == '09':
    monthshift = '08'
    elif ((str(AdobeAPIdate))[5:7]) == '10':
    monthshift = '09'
    elif ((str(AdobeAPIdate))[5:7]) == '11':
    monthshift = '10'
    elif ((str(AdobeAPIdate))[5:7]) == '12':
    monthshift = '11'
    AdobeCustomDates.append((str(1))+((str(AdobeAPIdate))[2:4])+monthshift+((str(AdobeAPIdate))[8:11]))
    adjust += 1
    AdobeAPIdate = today - timedelta(days = adjust)

     

    Then I used "AdobeAPIdate" as the date for output to SQL / google sheets.

     

     

    I
    Adobe Employee
    isinhaAdobe Employee
    Adobe Employee
    November 15, 2021

    @goncalolopes - this has some examples of Analytics API 2.0:

    https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/reporting-guide.md

    G
    goncalolopesAuthor
    November 15, 2021

    Is there a section that references defining the date format in the report? Please see my reply above for an example.

    Terms & ConditionsAccessibility statement

    Loading footer...