star This is a Streamsheets Premium feature.

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


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


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. Defines a cell range to show the query result. Might not be necessary if result is visualized by a chart.
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 successful.


=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.

Designed for Influx version 1.x.