--- title: SideloadNode (Kapacitor TICKscript node) description: SideloadNode adds fields and tags to points based on hierarchical data from various sources. note: Auto generated by tickdoc menu: kapacitor_1_4: name: SideloadNode identifier: sideload_node weight: 250 parent: TICKscript nodes --- ### Constructor | Chaining Method | Description | |:---------|:---------| | **[sideload](#descr) ( )** | Create a node that can load data from external sources | ### Property Methods | Setters | Description | |:---|:---| | **[field](#field) ( `f` `string`, `v` `interface{}`)** | Field is the name of a field to load from the source and its default value. The type loaded must match the type of the default value. Otherwise an error is recorded and the default value is used. | | **[order](#order) ( `order` `...string`)** | Order is a list of paths that indicate the hierarchical order. The paths are relative to the source and can have template markers like `{{.tagname}}` that will be replaced with the tag value of the point. The paths are then searched in order for the keys and the first value that is found is used. This allows for values to be overridden based on a hierarchy of tags. | | **[source](#source) ( `value` `string`)** | Source for the data, currently only `file://` based sources are supported | | **[tag](#tag) ( `t` `string`, `v` `string`)** | Tag is the name of a tag to load from the source and its default value. The loaded values must be strings, otherwise an error is recorded and the default value is used. | ### Chaining Methods [Alert](/kapacitor/v1.4/nodes/sideload_node/#alert), [Barrier](/kapacitor/v1.4/nodes/sideload_node/#barrier), [Bottom](/kapacitor/v1.4/nodes/sideload_node/#bottom), [Combine](/kapacitor/v1.4/nodes/sideload_node/#combine), [Count](/kapacitor/v1.4/nodes/sideload_node/#count), [CumulativeSum](/kapacitor/v1.4/nodes/sideload_node/#cumulativesum), [Deadman](/kapacitor/v1.4/nodes/sideload_node/#deadman), [Default](/kapacitor/v1.4/nodes/sideload_node/#default), [Delete](/kapacitor/v1.4/nodes/sideload_node/#delete), [Derivative](/kapacitor/v1.4/nodes/sideload_node/#derivative), [Difference](/kapacitor/v1.4/nodes/sideload_node/#difference), [Distinct](/kapacitor/v1.4/nodes/sideload_node/#distinct), [Ec2Autoscale](/kapacitor/v1.4/nodes/sideload_node/#ec2autoscale), [Elapsed](/kapacitor/v1.4/nodes/sideload_node/#elapsed), [Eval](/kapacitor/v1.4/nodes/sideload_node/#eval), [First](/kapacitor/v1.4/nodes/sideload_node/#first), [Flatten](/kapacitor/v1.4/nodes/sideload_node/#flatten), [GroupBy](/kapacitor/v1.4/nodes/sideload_node/#groupby), [HoltWinters](/kapacitor/v1.4/nodes/sideload_node/#holtwinters), [HoltWintersWithFit](/kapacitor/v1.4/nodes/sideload_node/#holtwinterswithfit), [HttpOut](/kapacitor/v1.4/nodes/sideload_node/#httpout), [HttpPost](/kapacitor/v1.4/nodes/sideload_node/#httppost), [InfluxDBOut](/kapacitor/v1.4/nodes/sideload_node/#influxdbout), [Join](/kapacitor/v1.4/nodes/sideload_node/#join), [K8sAutoscale](/kapacitor/v1.4/nodes/sideload_node/#k8sautoscale), [KapacitorLoopback](/kapacitor/v1.4/nodes/sideload_node/#kapacitorloopback), [Last](/kapacitor/v1.4/nodes/sideload_node/#last), [Log](/kapacitor/v1.4/nodes/sideload_node/#log), [Max](/kapacitor/v1.4/nodes/sideload_node/#max), [Mean](/kapacitor/v1.4/nodes/sideload_node/#mean), [Median](/kapacitor/v1.4/nodes/sideload_node/#median), [Min](/kapacitor/v1.4/nodes/sideload_node/#min), [Mode](/kapacitor/v1.4/nodes/sideload_node/#mode), [MovingAverage](/kapacitor/v1.4/nodes/sideload_node/#movingaverage), [Percentile](/kapacitor/v1.4/nodes/sideload_node/#percentile), [Sample](/kapacitor/v1.4/nodes/sideload_node/#sample), [Shift](/kapacitor/v1.4/nodes/sideload_node/#shift), [Sideload](/kapacitor/v1.4/nodes/sideload_node/#sideload), [Spread](/kapacitor/v1.4/nodes/sideload_node/#spread), [StateCount](/kapacitor/v1.4/nodes/sideload_node/#statecount), [StateDuration](/kapacitor/v1.4/nodes/sideload_node/#stateduration), [Stats](/kapacitor/v1.4/nodes/sideload_node/#stats), [Stddev](/kapacitor/v1.4/nodes/sideload_node/#stddev), [Sum](/kapacitor/v1.4/nodes/sideload_node/#sum), [SwarmAutoscale](/kapacitor/v1.4/nodes/sideload_node/#swarmautoscale), [Top](/kapacitor/v1.4/nodes/sideload_node/#top), [Union](/kapacitor/v1.4/nodes/sideload_node/#union), [Where](/kapacitor/v1.4/nodes/sideload_node/#where), [Window](/kapacitor/v1.4/nodes/sideload_node/#window)

### Description SideloadNode adds fields and tags to points based on hierarchical data from various sources. Example: ```javascript |sideload() .source('file:///path/to/dir') .order('host/{{.host}}.yml', 'hostgroup/{{.hostgroup}}.yml') .field('cpu_threshold', 0.0) .tag('foo', 'unknown') ``` Add a field `cpu_threshold` and a tag `foo` to each point based on the value loaded from the hierarchical source. The list of templates in the `.order()` property are evaluated using the points tags. The files paths are checked then checked in order for the specified keys and the first value that is found is used. Properties ---------- Property methods modify state on the calling node. They do not add another node to the pipeline, and always return a reference to the calling node. Property methods are marked using the `.` operator. ### Field Field is the name of a field to load from the source and its default value. The type loaded must match the type of the default value. Otherwise an error is recorded and the default value is used. ```javascript sideload.field(f string, v interface{}) ``` ### Order Order is a list of paths that indicate the hierarchical order. The paths are relative to the source and can have template markers like `{{.tagname}}` that will be replaced with the tag value of the point. The paths are then searched in order for the keys and the first value that is found is used. This allows for values to be overridden based on a hierarchy of tags. ```javascript sideload.order(order ...string) ``` ### Source Source for the data, currently only `file://` based sources are supported ```javascript sideload.source(value string) ``` ### Tag Tag is the name of a tag to load from the source and its default value. The loaded values must be strings, otherwise an error is recorded and the default value is used. ```javascript sideload.tag(t string, v string) ``` Chaining Methods ---------------- Chaining methods create a new node in the pipeline as a child of the calling node. They do not modify the calling node. Chaining methods are marked using the `|` operator. ### Alert Create an alert node, which can trigger alerts. ```javascript sideload|alert() ``` Returns: [AlertNode](/kapacitor/v1.4/nodes/alert_node/) ### Barrier Create a new Barrier node that emits a BarrierMessage periodically One BarrierMessage will be emitted every period duration ```javascript sideload|barrier() ``` Returns: [BarrierNode](/kapacitor/v1.4/nodes/barrier_node/) ### Bottom Select the bottom `num` points for `field` and sort by any extra tags or fields. ```javascript sideload|bottom(num int64, field string, fieldsAndTags ...string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Combine Combine this node with itself. The data is combined on timestamp. ```javascript sideload|combine(expressions ...ast.LambdaNode) ``` Returns: [CombineNode](/kapacitor/v1.4/nodes/combine_node/) ### Count Count the number of points. ```javascript sideload|count(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### CumulativeSum Compute a cumulative sum of each point that is received. A point is emitted for every point collected. ```javascript sideload|cumulativeSum(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Deadman Helper function for creating an alert on low throughput, a.k.a. deadman's switch. - Threshold -- trigger alert if throughput drops below threshold in points/interval. - Interval -- how often to check the throughput. - Expressions -- optional list of expressions to also evaluate. Useful for time of day alerting. Example: ```javascript var data = stream |from()... // Trigger critical alert if the throughput drops below 100 points per 10s and checked every 10s. data |deadman(100.0, 10s) //Do normal processing of data data... ``` The above is equivalent to this Example: ```javascript var data = stream |from()... // Trigger critical alert if the throughput drops below 100 points per 10s and checked every 10s. data |stats(10s) .align() |derivative('emitted') .unit(10s) .nonNegative() |alert() .id('node \'stream0\' in task \'{{ .TaskName }}\'') .message('{{ .ID }} is {{ if eq .Level "OK" }}alive{{ else }}dead{{ end }}: {{ index .Fields "emitted" | printf "%0.3f" }} points/10s.') .crit(lambda: "emitted" <= 100.0) //Do normal processing of data data... ``` The `id` and `message` alert properties can be configured globally via the 'deadman' configuration section. Since the [AlertNode](/kapacitor/v1.4/nodes/alert_node/) is the last piece it can be further modified as usual. Example: ```javascript var data = stream |from()... // Trigger critical alert if the throughput drops below 100 points per 10s and checked every 10s. data |deadman(100.0, 10s) .slack() .channel('#dead_tasks') //Do normal processing of data data... ``` You can specify additional lambda expressions to further constrain when the deadman's switch is triggered. Example: ```javascript var data = stream |from()... // Trigger critical alert if the throughput drops below 100 points per 10s and checked every 10s. // Only trigger the alert if the time of day is between 8am-5pm. data |deadman(100.0, 10s, lambda: hour("time") >= 8 AND hour("time") <= 17) //Do normal processing of data data... ``` ```javascript sideload|deadman(threshold float64, interval time.Duration, expr ...ast.LambdaNode) ``` Returns: [AlertNode](/kapacitor/v1.4/nodes/alert_node/) ### Default Create a node that can set defaults for missing tags or fields. ```javascript sideload|default() ``` Returns: [DefaultNode](/kapacitor/v1.4/nodes/default_node/) ### Delete Create a node that can delete tags or fields. ```javascript sideload|delete() ``` Returns: [DeleteNode](/kapacitor/v1.4/nodes/delete_node/) ### Derivative Create a new node that computes the derivative of adjacent points. ```javascript sideload|derivative(field string) ``` Returns: [DerivativeNode](/kapacitor/v1.4/nodes/derivative_node/) ### Difference Compute the difference between points independent of elapsed time. ```javascript sideload|difference(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Distinct Produce batch of only the distinct points. ```javascript sideload|distinct(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Ec2Autoscale Create a node that can trigger autoscale events for a ec2 autoscalegroup. ```javascript sideload|ec2Autoscale() ``` Returns: [Ec2AutoscaleNode](/kapacitor/v1.4/nodes/ec2_autoscale_node/) ### Elapsed Compute the elapsed time between points ```javascript sideload|elapsed(field string, unit time.Duration) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Eval Create an eval node that will evaluate the given transformation function to each data point. A list of expressions may be provided and will be evaluated in the order they are given. The results are available to later expressions. ```javascript sideload|eval(expressions ...ast.LambdaNode) ``` Returns: [EvalNode](/kapacitor/v1.4/nodes/eval_node/) ### First Select the first point. ```javascript sideload|first(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Flatten Flatten points with similar times into a single point. ```javascript sideload|flatten() ``` Returns: [FlattenNode](/kapacitor/v1.4/nodes/flatten_node/) ### GroupBy Group the data by a set of tags. Can pass literal * to group by all dimensions. Example: ```javascript |groupBy(*) ``` ```javascript sideload|groupBy(tag ...interface{}) ``` Returns: [GroupByNode](/kapacitor/v1.4/nodes/group_by_node/) ### HoltWinters Compute the holt-winters (/{{< latest "influxdb" "v1" >}}/query_language/functions/#holt-winters) forecast of a data set. ```javascript sideload|holtWinters(field string, h int64, m int64, interval time.Duration) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### HoltWintersWithFit Compute the holt-winters (/{{< latest "influxdb" "v1" >}}/query_language/functions/#holt-winters) forecast of a data set. This method also outputs all the points used to fit the data in addition to the forecasted data. ```javascript sideload|holtWintersWithFit(field string, h int64, m int64, interval time.Duration) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### HttpOut Create an HTTP output node that caches the most recent data it has received. The cached data is available at the given endpoint. The endpoint is the relative path from the API endpoint of the running task. For example, if the task endpoint is at `/kapacitor/v1/tasks/` and endpoint is `top10`, then the data can be requested from `/kapacitor/v1/tasks//top10`. ```javascript sideload|httpOut(endpoint string) ``` Returns: [HTTPOutNode](/kapacitor/v1.4/nodes/http_out_node/) ### HttpPost Creates an HTTP Post node that POSTS received data to the provided HTTP endpoint. HttpPost expects 0 or 1 arguments. If 0 arguments are provided, you must specify an endpoint property method. ```javascript sideload|httpPost(url ...string) ``` Returns: [HTTPPostNode](/kapacitor/v1.4/nodes/http_post_node/) ### InfluxDBOut Create an influxdb output node that will store the incoming data into InfluxDB. ```javascript sideload|influxDBOut() ``` Returns: [InfluxDBOutNode](/kapacitor/v1.4/nodes/influx_d_b_out_node/) ### Join Join this node with other nodes. The data is joined on timestamp. ```javascript sideload|join(others ...Node) ``` Returns: [JoinNode](/kapacitor/v1.4/nodes/join_node/) ### K8sAutoscale Create a node that can trigger autoscale events for a kubernetes cluster. ```javascript sideload|k8sAutoscale() ``` Returns: [K8sAutoscaleNode](/kapacitor/v1.4/nodes/k8s_autoscale_node/) ### KapacitorLoopback Create an kapacitor loopback node that will send data back into Kapacitor as a stream. ```javascript sideload|kapacitorLoopback() ``` Returns: [KapacitorLoopbackNode](/kapacitor/v1.4/nodes/kapacitor_loopback_node/) ### Last Select the last point. ```javascript sideload|last(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Log Create a node that logs all data it receives. ```javascript sideload|log() ``` Returns: [LogNode](/kapacitor/v1.4/nodes/log_node/) ### Max Select the maximum point. ```javascript sideload|max(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Mean Compute the mean of the data. ```javascript sideload|mean(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Median Compute the median of the data. Note, this method is not a selector, if you want the median point use `.percentile(field, 50.0)`. ```javascript sideload|median(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Min Select the minimum point. ```javascript sideload|min(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Mode Compute the mode of the data. ```javascript sideload|mode(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### MovingAverage Compute a moving average of the last window points. No points are emitted until the window is full. ```javascript sideload|movingAverage(field string, window int64) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Percentile Select a point at the given percentile. This is a selector function, no interpolation between points is performed. ```javascript sideload|percentile(field string, percentile float64) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Sample Create a new node that samples the incoming points or batches. One point will be emitted every count or duration specified. ```javascript sideload|sample(rate interface{}) ``` Returns: [SampleNode](/kapacitor/v1.4/nodes/sample_node/) ### Shift Create a new node that shifts the incoming points or batches in time. ```javascript sideload|shift(shift time.Duration) ``` Returns: [ShiftNode](/kapacitor/v1.4/nodes/shift_node/) ### Sideload Create a node that can load data from external sources ```javascript sideload|sideload() ``` Returns: [SideloadNode](/kapacitor/v1.4/nodes/sideload_node/) ### Spread Compute the difference between `min` and `max` points. ```javascript sideload|spread(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### StateCount Create a node that tracks number of consecutive points in a given state. ```javascript sideload|stateCount(expression ast.LambdaNode) ``` Returns: [StateCountNode](/kapacitor/v1.4/nodes/state_count_node/) ### StateDuration Create a node that tracks duration in a given state. ```javascript sideload|stateDuration(expression ast.LambdaNode) ``` Returns: [StateDurationNode](/kapacitor/v1.4/nodes/state_duration_node/) ### Stats Create a new stream of data that contains the internal statistics of the node. The interval represents how often to emit the statistics based on real time. This means the interval time is independent of the times of the data points the source node is receiving. ```javascript sideload|stats(interval time.Duration) ``` Returns: [StatsNode](/kapacitor/v1.4/nodes/stats_node/) ### Stddev Compute the standard deviation. ```javascript sideload|stddev(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Sum Compute the sum of all values. ```javascript sideload|sum(field string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### SwarmAutoscale Create a node that can trigger autoscale events for a docker swarm cluster. ```javascript sideload|swarmAutoscale() ``` Returns: [SwarmAutoscaleNode](/kapacitor/v1.4/nodes/swarm_autoscale_node/) ### Top Select the top `num` points for `field` and sort by any extra tags or fields. ```javascript sideload|top(num int64, field string, fieldsAndTags ...string) ``` Returns: [InfluxQLNode](/kapacitor/v1.4/nodes/influx_q_l_node/) ### Union Perform the union of this node and all other given nodes. ```javascript sideload|union(node ...Node) ``` Returns: [UnionNode](/kapacitor/v1.4/nodes/union_node/) ### Where Create a new node that filters the data stream by a given expression. ```javascript sideload|where(expression ast.LambdaNode) ``` Returns: [WhereNode](/kapacitor/v1.4/nodes/where_node/) ### Window Create a new node that windows the stream by time. NOTE: Window can only be applied to stream edges. ```javascript sideload|window() ``` Returns: [WindowNode](/kapacitor/v1.4/nodes/window_node/)