ContributionsMost RecentMost LikesSolutionsRe: Intermittent issue with ServiceNow Query Snap Yeah that is the last option. I'm also researching more on if this could be the issue with ServiceNow table API. Well lets see where this goes. Thank you Re: jsonpath in expression library Could you share the sample JSON and expected response ? Re: Read files for Azure "File Shares" I'm able to create the SMB string but i guess the SMB account setup is messed up. I'm using correct domain name <myazureaccountname>.file.core.windows.net What i dont understand is what should i put username and password. Is it the Active Directory credentials of my user account i should put here ? is there a way i can just connect to SMB storage using azure account name and access key ? Intermittent issue with ServiceNow Query Snap Is anyone aware of any known issue with ServiceNow query Snap ? The documentation does not show any known issue. We have used ServiceNow query snap in one of our pipeline to query records from xyz table based on input field value. Sometimes this is returning empty response even though the matching record exists in xyz table. This is a very strange behavior and is getting harder for us to replicate. Any information on this behavior will really be helpful. Re: Read files for Azure "File Shares" bojanvelevski sreddi del Requesting your expertise on this topic. Read files for Azure "File Shares" I have a new requirement to read the files stored in Azure "File Shares". I didnt have the knowledge about "File Shares" in azure and did a little research. Its a virtual drive which can be used for storing files and uses the SMB protocol to read from this storage. i have setup the file reader like this smb://{accountName}}.file.core.windows.net/{fileSharefolder}/{pathToFile} I have also tried setting up SMB account but it asks for a username and password which i dont have. I have azure account name and access key which i have used in setting SMB account. ( This could be the issue i'm not sure though ). In validation, i'm getting the following error : (actual values masked with generic name here) "error": "Error occurred while creating a mount smb://accountname.file.core.windows.net/fileshare/pathtofile" Can someone guide or assist me with setting this up ? Also it will be very helpful if you can share a sample pipeline showing SMb account setup. Re: ServiceNow Query Snap - Pass through does not work for empty result 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 ? Re: ServiceNow Query Snap - Pass through does not work for empty result Thank you del. This was a great workaround for my usecase. Re: ServiceNow Query Snap - Pass through does not work for empty result @dmiller I request your expertise on this topic. ServiceNow Query Snap - Pass through does not work for empty result 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. Output when the record is found : Note that it has the original key containing the original input request to servicenow query snap. Output when the record is not found : It is missing the original key containing the original input request. 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. Solved