POST a Dataset as a JSON-object to a MS SQL Server 2019 stored procedure

Connecting to SQL
1

Hello,

as mentioned in the topic i have to insert multiple records with one post api call that uses a mssql stored procedure in the background, but i couldn’t find a solution or guide for this problem. The only thing that worked was to use a query parameter and pass the JSON-object as Text to the stored procedure, but the problem is that the JSON-object as text is limited by NVARCHAR(Max).
Do anyone has a solution or example code for this task?

Best Regards
Willi

2

Hi Willi,

I am not an MS SQL expert. So for my understanding what would the call to the stored procedure look like in sql syntax, that would store several records in one call? I could than look up, whether this could be realized in a REST call.

Best Regards

MrSpock