Skip to main content
Version: Streamsheets 2.4

INFLUX.SELECT

star This is a Streamsheets Enterprise feature.

Performs a SELECT query on your Influx database. You can use the Function Wizard for this function.

Syntax

=INFLUX.SELECT(Producer, JSON [, Target, XValue, Instant, Timeout])

Arguments

NameDescription
ProducerProducer to use for querying. The database name is configured in the affiliated Connector.
JSONDefines a query using a JSON cell range, which contains all clauses to build the SELECT query.
TargetOptional. INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
XValueOptional. Name of the value which should be used for the x-axis if result is visualized by a chart. Defaults to "time".
InstantOptional. If set to true the select query is immediately performed. Note: use with care, since this can overload InfluxDB very quickly. Default is false.
TimeoutOptional. Defines Timeout to perform query.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=INFLUX.SELECT(|Producer, JSON(A1:B2), D1:F20)TRUEAssuming passed JSON looks like { select: '*', from: 'measures' } this will return all values currently stored in measurement "measures" and writes them to cell range D1:F20.
info

Designed for Influx version 1.x.