create custom form with selections/options populated from an SQL table or API?

Is it possible to create custom form with selections/options populated from an SQL table? Or is it possible to create a custom form with selections/options pulled from an external API? (e.g. Choose a city - and the options presented come from and SQL table or API call)  -- Update: I'm testing using the new custom form "external" option to connect to an API with the data that will populate the pull-down menu.  Here's a link about how to do it:  https://experienceleague.adobe.com/docs/workfront/using/administration-and-setup/customize/custom-forms/form-designer/design-a-form/external-lookup-examples.html?lang=en