Load dynamically load options in Select using webservice

Hi,
I have a use case where i want to load options of select from some source (web service or rest api). Data could be in xml of json format. I need option to choose appropriate fields from json data to be part of text and value of options. Is there any way to achieve this.

I saw connecter approach but works mainly with db. any other approach?

Thanks

You may try to use the “combo” excell.
Here you can find a tutorial:
docs.dhtmlx.com/doku.php?id=dhtm … cell_combo