Once you built your own Custom API Connector, you are ready to use it!
Use it in an SSIS package or in an ODBC application:
Using a Custom API Connector with SSIS or ODBC
Building a Custom API Connector
Create and use your own custom REST API ODBC driver or SSIS connector
Documentation