Populate dropdown with response from server connect

Hi all,

I’m creating an admin page which has an App Connect call to a Server Connect DB query and returns data correctly, which I can see in the Chrome debug tools.

The data returned is a set of name-value pairs which are to be populated into a dropdown box, eg:

[
   { id: 1, name: "London"},
   { id: 2, name: "New York"}
]

But how do I get those values into a select (bootstrap 4 theme) so they’re visible to the end user?

I can the select actions to set the value, but not to populate all the options.

Any help is much appreciated!

Regards,
Andy