How to store data from integration response

Question

My input will be emailaddress in eachline

"values": [
{
"id": "d7971ace-7ca5-ec11-8132-0050569773df",
"emailAddress": "testing.test@test.com"
},
{
"id": "50363345-b494-ec11-8131-0050569773df",
"emailAddress": "test2.test@test.com"
}

This will be the response of my integration.

I want to store the entered emailaddresses in new table as seperate rows and the IDs from response should get mapped to those emailaddress in DB .

How can I achieve it

Stefan Helzle · Answer

You create a record type and add the fields you need. Use a foreach to iterate on the values from your JSON and map the fields to a record using the record type constructor. Then use a write records node to persist it.