Run Query

Run a LINQ query.

External Documentation

To learn more, visit the Devo documentation.

Basic Parameters

Parameter	Description
From	The start date.
Query	This is the query that you want to run, expressed in LINQ. <br/>To find the query's LINQ script in the Devo app, open the query in the `Data search` area, then choose `Query code editor` from the toolbar.<br/>
Query ID	This is the ID of the query that you want to run. <br/>To find the query ID, open the query in the `Data search` area, then open the search window menu and select `Current query → Get ID`.<br/>
Query Identifier	Select a method for running the query.
Query Priority	Set the query priority.
To	The end date.

Advanced Parameters

Parameter	Description
Limit	Maximum number of elements returned in the response.
Offset	Position of the first element in the returned list. You will retrieve a subset of records starting with the offset value.
Progress Info	Select if you want to get progress info about the requested query.

Example Output

{
    "query": "from demo.ecommerce.data select *",
    "from": 1519645036,
    "to": 1519645136,
    "mode": {
        "type": "json"
    },
    "destination": {
        "type": "hdfs",
        "params": {
            "param1": "value1",
            "param1": "value2"
        }
    }
}

Workflow Library Example

Run Query with Devo and Send Results Via Email

Preview this Workflow on desktop