cancel
Showing results for 
Search instead for 
Did you mean: 

ServiceNow Query Snap - Pass through does not work for empty result

Chandan
New Contributor III

I’m trying to use the servicenow query snap to query a table.
For my use case, i may get few missing properties in a input request. I have to query servicenow and fetch these missing properties from a table if found, else just use the original request with missing properties.
I have configured the servicenow query snap by enabling “Pass Through” & “Allow Empty Query Result”.
This works fine if the record is found in servicenow table. But when the record is not found in servicenow table, the snap just returns empty object which does not have original request.
As “Pass Through” is enabled , regardless of record found or not, snap should give the original object at output but that is not happening.
Am i missing something here or is it a BUG for this snap ?
Any help will be greatly appreciated.

image

Output when the record is found : Note that it has the original key containing the original input request to servicenow query snap.

image

Output when the record is not found : It is missing the original key containing the original input request.

image

there are other alternatives too but I’m using servicenow query snap as it makes it easier to fetch the values for the reference fields which makes it perfect for my usecase.

1 ACCEPTED SOLUTION

Hello Chandan,

ServiceNow Query snap with enabled Allow Empty Query Result and in that case, if provided sys_id exists or record matched, showing the original document.

image

ServiceNow Query snap with enabled Allow Empty Query Result and in that case, if provided sys_id does not exists or record is not matched, showing the original document.
image
image

View solution in original post

6 REPLIES 6

Chandan
New Contributor III

Thank you @sreddi for a detailed solution. This worked for me but i still have suggestion if ServiceNow query snap can return intialReq if pass through is enabled and no matching record is found.  Can it be raised as an enhancement ?

Chandan
New Contributor III

Thank you @del. This was a great workaround for my usecase.