Use value with itemId in breakdown report, API 2.0

[bobmcc]

I'm working on code to invoke AA API 2.0 requests to grab metrics for a breakdown report.  I have the code working according the the Reporting Guide, but the use of itemId is inconvenient.  I would like to breakdown by dimension value, not dimension itemId.  Is this possible?

Here is what I'm doing now:

Request report on dimension "variables/prop18", which in my case is "user".  The response has a row for each user, with itemId (AA internal identifier) and value (my user id).

itemId	value
83849549028	fred
937292847219	barney
4837294937	Wilma

Loop over each row, requesting report on dimension "variables/prop2", which in my case is "page",  filtered for a single row from the first result:

    "dimension": "variables/prop2",

    "metricContainer": {

         "metrics": [

             {

                 "id": "metrics/pageviews",

                 "columnId": "pageviews",

                 "filters": ["f0"]

             },

             {

                 "id": "metrics/visits",

                 "columnId": "visits",

                 "filters": ["f0"]

             }

         "metricFilters": [

             {

                 "id": "f0",

                 "type": "breakdown",

                 "dimension": "variables/prop18",

                 "itemId": "83849549028"

             }

     ]

When I get the response, each row has the itemId and value for dimension variables/prop2, plus the metrics.

Here are my questions:

1. Is there a way to setup the metricFilters based on the the value of prop18, instead of the itemId?

2. If I have to filter by itemId, is there a way to

[Gigazelle · Accepted solution]

ItemId is required, unfortunately. You can do a filter to get the Item ID, though: https://github.com/AdobeDocs/analytics-2.0-apis/blob/a7cff208f309519703fe5bc62327aaddddf7bebc/report...  

[jharrington7897]

I know this is an old thread - but is there any progress on this?  

If I have a sheet that takes an input from a user, say:
Campaign = "Email" or "affiliate"

How do I dynamically convert that term  "Email" or the term "Affiliate" into an ID that Adobes AA API can then read?

Calling the Dimensions/ endpoint is too generic and does not provide exact ids to be later added to a list for users to choose from

Should I just call a blank report once to get a list of "Values" (customer facing) and their corresponding "Ids"?

[Alina3]

I am having the same issue. Since the last solution was posted two years ago, I would like to pick it up again. Is there any news on this topic?