How to get "hierarchyEntityLongId" (List id which appears if you copy-paste list format to excel)

Hi all,

 

Excel is very handy for "mass" analysis/amendments of line items. However, for List formatted line items I get List ID (instead of name) in "Format" column. It happens both when you copy-paste or export blueprint for all line items. It is very annoying to manually map these IDs to list names. Screenshots are below.

 

Is there any way I can retreive these List IDs and their names?

 

Thanks,

Hayk

 

SCR1.PNG

 

SCR2.PNG

Tagged:

Best Answers

  • Hi Aleph,

    That's not quite as straightforward, but I managed it with the following snippet.

     

     

    window.anaplan.data.ModelContentCache._modelInfo.modulesLabelPage.entityLongIds[0].forEach(function(e,i) {console.log(e + ' ' + window.anaplan.data.ModelContentCache._modelInfo.modulesLabelPage.entityIds[0][i]);window.anaplan.data.ModelContentCache.getLineItemsLabelPage(e).entityLongIds[0].forEach(function(le,li) {console.log(le + ' ' + window.anaplan.data.ModelContentCache.getLineItemsLabelPage(e).entityIds[0][li]);})})

     

    You can see some sample output below. Each line item is below its parent module - the modules all have entity long Ids that begin with 102. Line Items will start at 200 and go higher.

     

     

    Screen Shot 2019-01-14 at 17.15.08.png

Answers

  • That's awesome!!

     

    Thanks a lot for this tip.

     

    Regards,

    Hayk

  • Hi

    The other more "low tech" method is to sert up a module with a line item representing each list. Format the line item as the list in question.  When you copy out the blueprint, you will ge the line item (i.e. list name) and the GUID

     

    2018-05-23_09-31-51.png

     

    2018-05-23_09-32-14.png

     

     

     

     

    Hope this helps

    David

  • Hi,

     

    Thanks for your advice. That is how I've been doing it previously.

    But console is less time consuming if you have many lists to set.

     

    Regards,

    Hayk

  • Hello Greg,

     

     The ids for the line item subsets can also be queried as you say. But as the line items are not part of the standard info and label pages, is there a way to fetch the complete list of line item entity ids in a similar way as above?

  • Thank you Greg, that works!