Servicenow Get Records

Retrieves multiple records from a specified ServiceNow table with optional filtering and pagination. Use this action to query and fetch records from any ServiceNow table (e.g., incident, sys_user, problem). Supports filtering via sysparm_query, field selection, pagination, and d…

मूल्य

मुफ़्त Action

एकीकृत भुगतान

अभी समर्थित नहीं

• table_namestring

  आवश्यक
  The name of the table from which to retrieve the record.
• sysparm_viewstring
  UI view for which to render the data. Determines the fields returned in the response.
• sysparm_limitinteger
  Maximum number of records to return. For requests that exceed this number of records, use the sysparm_offset parameter to paginate record retrieval. This limit is applied before ACL evaluation. If no records return, including records you have access to, rearrange the record orde…
• sysparm_querystring
  Encoded query used to filter the result set. Syntax: <col_name><operator><value>. All parameters are case-sensitive. Operators: = (exact match), != (not equal), ^ (AND), ^OR (OR), LIKE (contains string), STARTSWITH, ENDSWITH (string fields only). Multiple conditions: <col_name><…
• sysparm_fieldsstring
  Comma-separated list of fields to return in the response. Invalid fields are ignored.
• sysparm_offsetinteger
  Starting record index for which to begin retrieving records. Use this value to paginate record retrieval. This functionality enables the retrieval of all records, regardless of the number of records, in small manageable chunks. For example, the first time you call this endpoint,…
• name_value_pairsstring
  DEPRECATED: This parameter does not work in the ServiceNow Table API and will be ignored. Use 'sysparm_query' instead for filtering records. Example: sysparm_query='active=true^priority=1' for multiple conditions.
• sysparm_no_countboolean
  Flag that indicates whether to execute a select count(*) query on the table to return the number of rows in the associated table.
• sysparm_display_valuestring
  Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that…
• sysparm_query_categorystring
  Name of the category to use for queries.
• sysparm_query_no_domainboolean
  Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: false (Exclude the record if it is in a domain that the currently logged in user is not configured to access), true (Include the record even if…
• sysparm_exclude_reference_linkboolean
  Flag that indicates whether to exclude Table API links for reference fields.

• data

  आवश्यक
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  आवश्यक
  Whether or not the action execution was successful or not

अभी कोई सत्यापित संबंधित उपयोग मामला लिंक नहीं है।