Replicating API v1.4 call

[jantzen_belliston-Adobe]

Hi,

So we make an API v1.4 request to obtain data with multiple dimensions(elements) and metrics (including calculated metrics).

{"reportDescription":{
   "reportSuiteID":"myRSID",
   "dateFrom":$Yesterday,
   "dateTo":$Yesterday,
   "dateGranularity":"Day",
   "elements":[
      {"top":100,
      "id":"product",
      "classification":"dimension1"},
     {"top":100,
      "id":"product",
      "classification":"dimension2"},
     {"top":100,
      "id":"product",
      "classification":"dimension3"},
    {"top":100,
      "id":"dimension4"}
   ],
   "metrics":[
      {"decimals":0,
      "id":"event1"},
      {"decimals":0,
      "id":"event2"},
      {"decimals":0,
      "id":"event3"},
      {"decimals":0,
      "id":"calcMetric1"},
      {"decimals":0,
      "id":"event4"}
    ],
    "segments": [
      {"id": "segment1"}]}}

This is working with API v1.4, but we have to migrate this in the near future since v1.4 is not going to be supported down the road.

We are thinking of 

1. Data warehouse: which however doesn't support calculated metrics apparently

2. API v2.0: which allows only one dimension at a time

Would like to hear some opinions on which tool to use and being pointed to some resources. 

Thanks in advance.

[jantzen_belliston-Adobe]

Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?

[#3]

Hi @Roxie423 ,

You can also try using the Ad Hoc Analysis as it will allow you to breakdown one dimension line item with another & can see 50,000 line items. Though Adobe has already decided to deprecate Ad Hoc. But, before we are going to deprecate this feature we will be giving an option to the users to view up to 50,000 line items in Analysis Workspace.

Regards,

Abhinav