I have a project where I need to retrieve data from a RESTful API. I have already created my request script and tested it in POSTMan. I would like to retrieve data from the RESTful API’s response, input the data into SQL Server Management Studio. My Question is what is the appropriate flow of connectors to build this? The Goal is to use a Webhook to retrieve data from the RESTful API, then be able to import that data into tables in SQL Server Management studio.
Hi,
You can use the REST connector to retrieve data from the REST API, then use the XML Map connector to map the data according to the schema, and finally use the SQL Server connector to insert the data into SQL Server tables. Your flow should look like this:
In the XML Map connector, you need to map your data according to the schema of your tables or database.
REST: CData Arc - REST Connector | Version 24.3.9159
XML Map: CData Arc - XML Map Connector Overview | Version 24.3.9159
SQL Server: CData Arc - SQL Server Connector Setup | Version 24.3.9159