Currently our UCCX is integrated with SQL database and its successfully fetching customer details based on the input entered during the call.
However, our database team is not willing to expose database. They are asking for an API to connect to this SQL server without directly exposing. Could you please shed some light from where i can get the API.
The API method would have UCCX be the client and the database server be the...well, server. Therefore, they need to provide you with an API access method and documentation on which methods are allowed, and what message bodies are required, etc. You would just end up using a combination of steps in your scripts, such as: Make REST Call, Create JSON/XML Document, Get JSON/XML Document Data.
Sometimes there is a certificate requirement, if say for example the transport is HTTPS, then UCCX will need to be able to trust that other server. In which case, you'll need to upload that cert/chain to the UCCX OS Administration web page under tomcat-trust.