SQL Server Execute - Dealing With No Results

Question

Dear Snaplogic Community
I am calling an SQL Server Execute to return the field value of “CLI_SUR_NM” i.e. surname in the table based on a “$FinalIngenPolicyNo” primary key fed by a mapper. If the ID primary key is not found then how do I trap this scenario in the snaplogic snaps? What is a good way to deal with no results from an sql execute snap? If it returns no results and i map the “$CLI_SUR_NM” value I get an error.

Thank you very much!

tstack · Answer

andre.mangatal:

If the ID primary key is not found then how do I trap this scenario in the snaplogic snaps?

Do you have the “Pass Through” option checked in the Execute snaps properties?  Can you share the full configuration for the Execute snap.
Also, I wanted to mention that I don’t think you need to make the SQL Statement an expression.  I think you should be able to write the last bit as follows:
CFPOL.POL_ID = $FinalIngenPolicyNo;

The snap should substitute references like that automatically.

andre_mangatal · Answer

Hi Tim
Thanks for the reply. Yes I do have “Pass Trhough” checked as seen below in the screenshot. If it returns nothing what’s the best way to handle this? Thanks
Noted on not make the SQL Statement an expression
Thank you!

tstack · Answer

andre.mangatal:

Thanks for the reply. Yes I do have “Pass Trhough” checked as seen below in the screenshot. If it returns nothing what’s the best way to handle this? Thanks

In your first post, the screenshot shows the Execute snap not generating any preview documents.  But, you don’t have ‘Execute during preview’ checked for the snap, so it won’t running during validation/preview.  Can you select that and try again?

andre_mangatal · Answer

Hi Tim
I selected execute during preview now. And only the original passes through. I want to write logic to do processing when no rows are returned from sql server execute e.g. using the router below.
Below is the original string which is returned when the primary key is not found.

andre_mangatal · Answer

The router looks for the field value “CLI_SUR_NM” but returns an error in the router when no records are returned. What can i do to handle this zero recordsreturned?

Thanks again for your help.

Forum Discussion

SQL Server Execute - Dealing With No Results

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found