Skip to main content
Version: Streamsheets 2.5

INFLUX.SHOW

star This is a premium feature.

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

Syntax

=INFLUX.SHOW(Producer, Type, Target, [, Measurement, Timeout])

Arguments

NameDescription
ProducerProducer to use for querying. The database name is configured in the affiliated Connector.
TypeDefines what to show. Must be one of following constants "Continuous Queries", "Measurements", "Series", "Retention Policies".
TargetINBOX(), 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.
MeasurementOptional. Only applies to type "Series". A fully qualified name of the measurement to show its series of.
TimeoutOptional. Defines Timeout to perform query.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=INFLUX.SHOW(|Producers, "Retention Policies", D1:D10)TRUEShows all existing retention policies.
info

Designed for Influx version 1.x.