Get table
servicenow_get_tableRetrieve records from a ServiceNow table using filters, field selection, and pagination. Use parameters like table name and query to fetch specific data.
Instructions
Get records from the specified table based on provided parameters.
:param table: The name of the table. :type table: str :param name_value_pairs: Dictionary of name-value pairs for filtering records. :type name_value_pairs: str :param sysparm_display_value: Display values for reference fields ('True', 'False', or 'all'). :type sysparm_display_value: str :param sysparm_exclude_reference_link: Exclude reference links in the response. :type sysparm_exclude_reference_link: bool :param sysparm_fields: Comma-separated list of field names to include in the response. :type sysparm_fields: str :param sysparm_limit: Maximum number of records to return. :type sysparm_limit: int :param sysparm_no_count: Do not include the total number of records in the response. :type sysparm_no_count: bool :param sysparm_offset: Number of records to skip before starting the retrieval. :type sysparm_offset: int :param sysparm_query: Encoded query string for filtering records. :type sysparm_query: str :param sysparm_query_category: Category to which the query belongs. :type sysparm_query_category: str :param sysparm_query_no_domain: Exclude records based on domain separation. :type sysparm_query_no_domain: bool :param sysparm_suppress_pagination_header: Suppress pagination headers in the response. :type sysparm_suppress_pagination_header: bool :param sysparm_view: Display style ('desktop', 'mobile', or 'both'). :type sysparm_view: str
:return: Response containing list of parsed Pydantic models with information about the retrieved records. :rtype: Response
:raises MissingParameterError: If table is not provided. :raises ParameterError: If input parameters are invalid.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| table | No | ||
| sysparm_view | No | ||
| sysparm_limit | No | ||
| sysparm_query | No | ||
| api_parameters | No | ||
| sysparm_fields | No | ||
| sysparm_offset | No | ||
| name_value_pairs | No | ||
| sysparm_no_count | No | ||
| table_record_sys_id | No | ||
| sysparm_display_value | No | ||
| sysparm_query_category | No | ||
| sysparm_query_no_domain | No | ||
| sysparm_exclude_reference_link | No | ||
| sysparm_suppress_pagination_header | No |