Retrieves a list of ServiceNow records based on specified filters.
To use this procedure, make sure your agent has learned the Servicenow Book (BDK).
Syntax
retrieve some records from servicenow [whose condition]
Retrieves a list of ServiceNow records based on the specified filters. It can optionally filter based on a given condition.
Base Syntax
retrieve some records from servicenow
What does it do? This is the base syntax for the procedure.
Where does it go? This phrase should be written on a new line.
Is it required? ✅ Yes — This part of the phrase is required.
Does it require input data? ⛔ No — This phrase does not require input data.
Filter Condition Syntax
whose [condition]
What does it do? This is an optional clause used to specify a condition for filtering.
Where does it go? If used, this clause immediately follows the retrieve some records from servicenow phrase on the same line.
Is it required? 🌟 No — This clause is optional in the syntax.
Does it require input data? ✅ Yes — This clause requires a condition (a filter expression) to be specified.
the table name is
What does it do? Specifies the table name from which to retrieve records.
Where does it go? This phrase should be indented beneath retrieve some records from servicenow
Is it required? ✅ Yes — This phrase is required in the syntax.
Does it require input data? ✅ Yes — This phrase requires a text value to be specified as the table name.
Example: the table name is "incident"
the limit is
What does it do? Specifies the limit of objects to be returned.
Where does it go? This phrase should be indented below retrieve some records from servicenow
Is it required? 🌟 No — This phrase is optional in the syntax.
Does it require input data? ✅ Yes — This phrase requires a text value to be specified.
Example: the limit is "10"
Examples
1. Retrieve all incidents from the 'incident' table
retrieve some records from servicenow
the table name is "incident"
2. Retrieve all incidents from the 'incident' table whose number is 'INC0010001'
retrieve some records from servicenow whose number is "INC0010001"
the table name is "incident"
3. Retrieve all incidents from the 'incident' table whose created date is after '2022-01-01'
the date is "2024-02-25T12:30:00Z"
get the date as a datetime
use the above as the target
retrieve some records from servicenow whose "sys_created_on" is greater than the target
the table name is "incident"
4. Retrieve 5 incidents from the 'incident' table
retrieve some records from servicenow
the table name is "incident"
the limit is "5"