Hello,
I am trying to write data from an API to an existing table in SQL server. My table structure contains few columns that are auto generated such as row_id (auto incremental). Is there anyway I can use INSERT statement in any node so that I can map the columns of the table that I have created and the ones that are in the database?
Something like this:
Table in Kinme:
Column1 Column2
abc xyz
ccc ddd
Database table:
row_id Column1 Column2
1 abc xyz
2 ccc ddd
Thank you.