DataSource Stored Procedure MSSQL


What would be the best approach to execute a stored procedure to upsert x amount of records from a table.

I can't use bulk upsert because my INSERT statement depends on an ID that I get inside the stored procedure.


Hey @iwgarcia! I'm curious if something like this might work. Have you considered passing {{ JSON.stringify(yourData) }} to your stored procedure and then unpacking it? How many records are you looking to insert at once and are any of the fields particularly long?