Forum Discussion

Max's avatar
Max
New Contributor II
2 years ago

Set default value if stored procedure doesnt return anything

Hello, I have a pipeline were im running a stored procedure in SQL to insert and update records. On update, If no records are found, the stored procedure snap doesn't display anything in the result ...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
2 years ago
Copy Link

Hi Max,

Because $AuditID is a field coming from the SP result, and will not be present when there's no data coming from the SP, I suggest you use the .hasPath() function. Your expression will look something like:

$.hasPath('AuditID')

The result is true/false based on the response of the SQL snap. 

Hope this helps.

Regards,

Bojan