Wappler to perform mass updates and geocode

I have a MS SQL database table of addresses that I would like to forward geocode (around 1,000)
My server model is Classic ASP or .Net

@Hyperbytes kindly provided a very useful php routine to perform a mass update of Lon/Lat fields in this thread wappler-general/google-maps-geocoding/3206/5

I just wondered if there was a way of using server to connect to query the address table and loop through and update using API connect with https://opencagedata.com/demo to set the lon/lat fields in the table?

If this is possible, a brief step process would be hugely appreciated.

Thanks