How to reference a static list for Form option component

Question

Hello everyoneI’m trying to create a dropdown list were the list items is a list of countries (I have a list of countires in an XML and json format) and I want to load that static in /apps so I can reference it in form options (picture below) My question is: Is there anyway that I can load my defined list ? or do I need to create each node for each country (picture below)? Thanks in advance.

arunpatidar · Accepted Answer

Hi,In this case you can use datasource and return list items, you can create datasourec from json as welle.g. https://aemlab.blogspot.com/2019/07/aem-touch-ui-dropdown-from-json.html

lukasz-m · Answer

Hi @odabio, I am not sure if this is one time action or you would like to maintain your list in the future, but you can consider below solutions that should allow you to automate list creation process.

Data Importer functionality from ACS Commons - however it requires Excel file as an input - so you will need to transform your XML or JSON file into excel to use it.
https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp-tools/data-importer/index.html
You can create simple java class that will do the import job, here is a nice example of servlet that allows to import data in JSON format https://blogs.perficient.com/2021/08/16/loading-json-content-into-aem/
If you are using Groovy console you can also create groovy script that will create the list from XML or JSON - this is quite similar approach to the one described in point 2.

Sign up

Login with SSO

Login to the community

Login with SSO