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

@dmiller I request your expertise on this topic.

dmiller
Former Employee

Alas, I must defer to our developers.


Diane Miller

del
Contributor III

You might could consider disabling the Allow Empty Query Result option and enabling an error view which would capture the pass-through data in the event that no results are returned. Then follow up with a Union snap and mapping as needed.

Something like this:
image

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