The getRecords operation retrieves a one or more records from a ServiceNow table. You must pass in the table name of the record you want to retrieve to use this operation.
This operation will return a result that is an array with one or more records in it.
You must configure at least one ServiceNow Instance to use this operation.
Inputs
Input Name | Input Code | Required | Description |
|---|---|---|---|
ServiceNow Instance Code | FDSN_INSTANCE_CODE | Yes | The instance Code of the ServiceNow Instance created under Topology that you will connect to. The URL, PORT, USERNAME, and PASSWORD are taken from the instance. |
Request Media Type | FDR_REQUEST_MEDIA_TYPE | Yes | Choose to return the data in JSON or XML format. If you select JSON, then use JSONPATH notation in the path expression inputs (See https://github.com/json-path/JsonPath) If you select XML, then use XPATH notation in the path expression inputs. |
Table Name | FDSN_TABLE_NAME | Yes | The ServiceNow Table that you want to retrieve records from (e.g. change_request) |
Query String | FDR_QUERY_STRING | No | Use the query string to filter and sort the results from ServiceNow. It may be helpful to use the Rest Explorer feature of ServiceNow to generate the query strings. |
Fail workflow if http response code over 200 | FDSN_FAIL_IF_HTTP_CODE_OVER_200 | No | If true, any http code over 200 will fail the step and the workflow. |
Path Expression 1 | FDSN_PATH_EXPRESSION_1 | No | Use XPATH or JSONPATH notation to return part of the response back to the workflow as |
Path Expression 2 | FDSN_PATH_EXPRESSION_2 | No | Use XPATH or JSONPATH notation to return part of the response back to the workflow as |
Path Expression 3 | FDSN_PATH_EXPRESSION_3 | No | Use XPATH or JSONPATH notation to return part of the response back to the workflow as |
Path Expression 4 | FDSN_PATH_EXPRESSION_4 | No | Use XPATH or JSONPATH notation to return part of the response back to the workflow as |
Path Expression 5 | FDSN_PATH_EXPRESSION_5 | No | Use XPATH or JSONPATH notation to return part of the response back to the workflow as |
Outputs
Output Name | Required | Description |
|---|---|---|
FDR_RESPONSE_CODE | Returns the integer HTTP response code such as 200, 400, 500. | |
FDR_RESPONSE_STRING | Returns the complete JSON or XML response from the ServiceNow instance. | |
FDSN_OUTPUT_1 | Returns the value returned by | |
FDSN_OUTPUT_2 | Returns the value returned by | |
FDSN_OUTPUT_3 | Returns the value returned by | |
FDSN_OUTPUT_4 | Returns the value returned by | |
FDSN_OUTPUT_5 | Returns the value returned by |
Artifacts
This operation doesn’t consume or produce any artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the Target.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Example
