New Relic Lens actions

This page provides a reference for New Relic Lens actions available in the workflow automation actions catalog. These actions let you run ANSI SQL queries against data sources connected through New Relic Lens directly from a workflow step.

Prerequisites

Before using New Relic Lens actions in workflow automation, ensure you have:

• A New Relic account with appropriate permissions.
• One or more data sources connected in New Relic Lens.
• The necessary permissions for the New Relic Lens service.

Query Lens

The action identifier is newrelic.lens.query.

Runs an ANSI SQL query against connected data sources through New Relic Lens.

steps:
  - name: queryLens
    type: action
    action: newrelic.lens.query
    version: 1
    inputs:
      accountIds: [12345]
      query: >
        SELECT appName,appId, count(*) as count FROM telemetry.Transaction
        GROUP BY appName, appId LIMIT 1
      selectors:
        - name: resultsAsString
          expression: '.results | tostring'

{
  "success": true,
  "results": [
    {
      "appName": "workflow-service (production.us-exit-speed)",
      "appId": 2882375598,
      "count": 52688
    }
  ]
}