JupiterOne Query icon

JupiterOne Query

Run J1QL queries against your JupiterOne account

JupiterOne Query

AI-generated

Overview

This node executes J1QL (JupiterOne Query Language) queries against a JupiterOne account to retrieve data. It is useful for users who want to programmatically query their JupiterOne data, such as assets, relationships, or security findings, with a flexible query language. The node automatically handles pagination and limits the number of results returned, making it practical for extracting large datasets in manageable chunks.

Use Case Examples

  1. Querying all JupiterOne accounts with a limit of 50 results.
  2. Running a custom J1QL query to find specific assets or relationships in the JupiterOne environment.

Properties

Name Meaning
J1QL Query The J1QL query string to execute. The node automatically appends a LIMIT clause if not present.
Limit Maximum number of results to return from the query. Must be between 1 and 10000.

Output

JSON

  • results - Array of query results returned by the J1QL query, limited by the specified limit.
  • limit - The maximum number of results requested.
  • baseQuery - The original J1QL query string without any LIMIT clause.

Dependencies

  • Requires JupiterOne API credentials including account ID and access token for authentication.

Troubleshooting

  • Error if the limit exceeds 10,000 results, as the node enforces a maximum limit of 10,000.
  • Timeout error if the query takes longer than 5 minutes to complete.
  • GraphQL errors returned by JupiterOne are logged and thrown as node errors.
  • If no deferred result URL is returned, the node throws an error indicating an invalid response from JupiterOne.

Discussion