Policy Automation for B2C Service

Get Involved. Join the Conversation.


    Pedro Viglione
    Dynamic Drop Downs from excel in OPA
    Topic posted July 12, 2018 by Pedro ViglioneGreen Ribbon: 100+ Points 
    97 Views, 2 Comments
    Dynamic Drop Downs from excel in OPA

    Hello, I have solved an issue and I what to share it with all of you.

    I had two Drop Downs depending one from the other, and it was hard to manage them from multi-level XML list of values, so y decided to manage them from Excel.

    The first Drop Down was easy to map from excel, just use "Use values from rules" functionality, but when I mapped  for the second Drop Down, it bringed me all the values of the column, (I was looking only the values that had reference withe the first Drop Down)
    The solution it was to create an entity defined by the excel and then create a reference (one to one) to select only one instance, after that, I copy the value from the selected instance to a global attribute.

    Here is a project with the solution.

    I hope that it will be useful