Microsoft recently announced very powerful Azure SQL Database External REST Endpoint Integration — an ability to call a REST endpoint natively from Azure SQL Database.
We decided to check this new feature with Genesys Cloud API. To get list of queues from the API and insert into SQL table:
/api/v2/routing/queues
Main requirement is deploy Genesys Cloud proxy application to the Azure with implemented security based on header API key:
https://genesys-noralogix.azurewebsites.net
Under Azure SQL run SQL:
Genesys Cloud queues will be inserted into SQL table