Solved

How do I use ArcESB to retrieve data from restful API using a webhook, then take that data and import it into SQL Server Management Studio?

  • 5 July 2024
  • 1 reply
  • 26 views

Badge

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.   

icon

Best answer by Rohit 8 July 2024, 08:14

View original

1 reply

Userlevel 1

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: https://cdn.cdata.com/help/AZK/mft/REST.html

XML Map: https://cdn.cdata.com/help/AZK/mft/XML-Map.html

SQL Server: https://cdn.cdata.com/help/AZK/mft/SQL-Server.html

Reply