Cloud Actions

EOL: SentryOne Test reached its end of life date on June 15, 2022. See the Solarwinds End of Life Policy for more information.

Cloud actions are responsible for gathering data by connecting to Salesforce or other sites that provide a REST API. Each action can fulfill a unique roll within a test: 

  • Prepare tests by ensuring the expected results are up to date. 
  • Clean-up an environment before or after a test execution. 

Execute REST Query (grid)

IconDescription
SentryOne Test Execute Rest Query(grid)The Execute Rest Grid action performs HTTP Requests that parses and stores the response (table) values into a resource grid.
FunctionDescription
Rest ConnectionThe cloud connection that's created in the test group level or test level asset.
Endpoint URLThe web address that accepts the web request. Endpoints can use the following actions:
  • Get - Retrieves information from the endpoint.
  • Post - A request that the endpoint perform "something" with the provided information.

Settings Tab

SentryOne Test Execute Rest Query Grid Settings

FunctionDescription
Results FormatSelects whether the results return in Json or Xml format.
Content TypeThe information needed to send in the header. For example, application\json, application\javascript, application\xml, etc.
Root Json PathJson can return results that have several root objects. Each object contains corresponding data. Identifying the root only returns the results for that root.

Example: 

{
"data":
{
"id" : "1",
"data1column": "test1"
}
"data2":
{
"data2key": "1",
"data2column:" "test2"
}
}

Note:  Setting the root Json path to data only returns the results id and data1column. Setting the root Json path to data2 only returns data2key and data2column results.

Timeout (s)Sets the amount of time in seconds the request should fail if there is no response from the web service.
Number of retiresSets the number of attempts to connect before the execution fails and reports an error.
Resource keyIdentifies the tile's name if it needs to be called in the Execution Track, Assert, or Teardown steps of the test.
Grid Column(s)The user defined column names, token paths, and data types for each column. Using the Json example above, you can add two columns with the data root Json path.

Example
Column NameToken PathData Type
IDidSystem.Int64
NameOfTestdata1columnSystem.String
Column Names are user-defined. The token path must be exactly the same as the path it's pointing to in the returned Json data. (Notice id and data1column paths identified in the Json example above.)

Headers Tab

SentryOne Test Execute Rest Query Grid Headers

FunctionDescription
Headers TabHeaders are information about the type of data returned.

Add and remove headers by selecting the corresponding buttons. Once a header is added, select in its corresponding name and value fields to configure them.

Cursor / Paging Settings

SentryOne Test Execute Rest Query Grid Cursor Paging Settings

FunctionDescription
Token PathIdentifies the child token that's used.
Is Return Value URLSelect this option if the Token Path is a URL.
Query String ParameterIdentifies the (optional) parameters needed to complete the Json request.
Cursor Finished ValueThe value needed to identify the output data is complete.

Test Results Tab

SentryOne Test Execute Rest Query Grid Test Results

Select Test to see the results returned based on the configuration in the previous tabs.

Execute REST Query (scalar)

IconDescription
SentryOne Test Execute Rest Query ScalarThe Execute Rest Query (Scalar) action performs HTTP Requests that parses and stores the response value into a resource grid.
FuncitonDescription
Rest ConnectionThe cloud connection that's created in the test group level or test level asset.
Endpoint URLThe web address that accepts the web request. Endpoints can use the following actions:
  • Get - Retrieves information from the endpoint.
  • Post - A request that the endpoint perform something with the provided information.

Settings Tab

SentryOne Test Execute Rest Query Scalar Settings

FunctionDescription
Results FormatSelects whether results are returned in Json or Xml format.
Content TypeThe information needed to be sent in the header. For example, application\json, application\javascript, application\xml, etc.
Root Json PathJson can return results that have numerous root objects with corresponding data for each root. Identifying the root only returns the results for that root.

Example:
{
"data":
{
"id" : "1",
"data1column": "test1"
}
"data2":
{
"data2key": "1",
"data2column:" "test2"
}
}

Note:  Setting the root Json path to data only returns the results id and data1column.
Timeout (s)Sets the time (in seconds) the request action should take place before it's a failure.
Number of retiresSets the number of attempts to connect before the execution fails and reports an error.
Resource keyIdentifies the tile's name if it needs to be called in the Execution Track, Assert, or Teardown steps of the test.
Grid Column(s)The user defined column names, token paths, and data types for each column. Using the Json example above, you can add two columns with the data root Json path.

Example:
Column NameToken PathData Type
IDidSystem.Int64
NameOfTestdata1columnSystem.String
Note:  Column Name can be user-defined, however, the token path must be exactly the same as the path it's pointing to in the returned Json data (notice id and data1column paths identified in the Json example above.)  

Headers Tab

SentryOne Test Execute Rest Query Scalar Headers

FunctionDescription
Headers Tab

Headers are information about the type of data returned.

Add and remove headers by selecting the corresponding buttons. Once a header is added, select in its corresponding name and value fields to configure them.

Test Results Tab

SentryOne Test Execute Rest Query Scalar Test Results

FunctionDescription
Scalar ValueYou can add your own data to populate the column only when testing your configuration.

Select Test to see the results returned based on your configuration in the previous tabs.

Execute Salesforce Query Grid

IconDescription
SentryOne Test Execute Saleforce Query GridThe Execute Salesforce Query Grid action executes a query to gather a data grid from Salesforce.

Execute Salesforce Query Grid Editor

SentryOne Test Execute Salesforce Query Grid Properties

FunctionDescription
Batch SizeSets the amount of records retrieved from Salesforce per trip. The max records in a batch is 2000.
Connection assetThe connection asset contains the connection string to the Salesforce source.
Low memory modeSelecting this option stores the results on disk instead of on memory. This option is recommended for large result sets.
Include deletedChecking this option includes deleted records in the result set.
Query assetThe asset that contains the query you want to execute.
Resource keyThe name given to the results that's stored in the Test Resources.

Execute Salesforce Query Scalar

IconDescription
SentryOne Test Execute Salesforce Qurey ScalarThe Execute Salesforce Query Scalar action executes a query that gathers a single value from Salesforce.

Execute Salesforce Query Grid Editor

SentryOne Test Execute Salesforce Query Scalar Properties

FunctionDescription
Connection asset
The connection asset contains the connection string to the Salesforce source.
Expected type
Defines the expected datatype that's returned.
Query asset
The asset that contains the query you want to execute.
Resource key
The name given to the results that's stored in the Test Resources.

Load File From Cloud Provider

IconDescription
SentryOne Test Load File from Cloud Provider iconLoads a file from a selected Cloud asset connection.

SentryOne Test Load File from Cloud Provider Element Editor

FunctionDescription
Connection AssetThe connection asset you wish to connect to.
SourceThe source of the connection.
Match PatternThe pattern used to specify multiple files.
File NameThe file name you wish to use for the connection.

Load Grid From Cloud Provider

IconDescription
SentryOne Test Load Grid from Cloud Provider iconLoads a grid file from a selected Cloud asset connection.

Settings Tab

SentryOne Test Load Grid from Cloud Provider Element Editor

FunctionDescription
Resource KeyThe resource key for the cloud connection.
Connection AssetThe asset you wish to connect to.
SourceThe source of the connection.
Match PatternThe pattern used to specify multiple files.

File Format

SentryOne Test Load Grid from Cloud Provider Element Editor File Format tab

FunctionDescription
FormatThe file format for the connection.
DelimiterSelect the delimiter for the file.
Quote
Lines to SkipSelect lines you wish to skip.
Lines to ScanSelect the lines you wish the action to scan.
Detect FormatsSelect this button to detect the format within the grid file.

Preview

SentryOne Test Load Grid from Cloud Provider Element Editor Preview