Skip to main content

Run Query

Run a LINQ query.

External Documentation

To learn more, visit the Devo documentation.

Basic Parameters

ParameterDescription
FromThe start date.
QueryThis is the query that you want to run, expressed in LINQ.
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.
Query IDThis is the ID of the query that you want to run.
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.
Query IdentifierSelect a method for running the query.
Query PrioritySet the query priority.
ToThe end date.

Advanced Parameters

ParameterDescription
LimitMaximum number of elements returned in the response.
OffsetPosition of the first element in the returned list. You will retrieve a subset of records starting with the offset value.
Progress InfoSelect 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

Workflow LibraryPreview this Workflow on desktop