HI All,
i am using the service now input tool to connect directly to SN tables to fetch data in alteryx workflows. However, one of the tables contains over 20M records and i need to figure out a way to filter the records before the input tool fetches all the records.
In the input tool there is an option for customer query but i am struggling with understanding the correct syntax.
Select * from task_sla where task = "e7962b741b6b89d4d68a0d0cf94bcb20";
i tried using this query where i want to pull records for the particular task id. however it is not working.
if anyone can help in figuring out the right query to filter the data i would be very helpful.
Thank You
SR
I sincerely hope you have figured this out, but for those who are also searching for the answer to this, I spent most of this afternoon trying a ridiculous number of variations. May I point out that the Information text does NOT really help:
Alteryx ServiceNow Input Tool Custom Query Information
I tried so many variations with "sysparm_query=" at the beginning, which apparently you should NOT do. I tried the display value, as the Information text shows, with and without double-quotes, to no avail. I tried the sys_id value with and without quotes. I finally got the expected results from this:
Alteryx ServiceNow Input Tool Custom Query Correct Format
Hope this helps someone else from struggling!