Create a project and add HTTP listener to call the API

Drag and Drop bulk insert connector

Create a DB connection

Add the insert query as below

Set input parameter as

Now add a transformation

Here metadata for the output will be pre-populated and can see it accept the Array of the input object, here we are mapping data for two countries.

Run the application using – http://localhost:8081/insert

And now we can see the data added in Target table –


Sample application –

Leave a Comment