Axibase Time Series Database

Series: insert CSV

Description

Inserts series values for the specified entity and series tags in CSV format.

The CSV header must consist of a date or time column followed by at least one numeric metric column.

The records are inserted for the same entity and series tags.

Request

Method Path Content-Type Header
POST /api/v1/series/csv/{entity}?[&{tag-name}={tag-value}] text/csv

Parameters

Name In Description
entity path [Required] Entity name.
tag query tag=value parameter pairs.

Payload

  • Payload is plain text in CSV format containing a header line and data rows.
  • The last line in the file must end with a line feed.
  • The header must begin with a time or date column, followed by at least one metric column containing numeric values.
  • Entity and Metric names containing space characters are normalized by replacing the space character with an underscore.
  • Time must be specified using Unix time in milliseconds if the time column is used or ISO format if the date column is used.
  • Separator must be comma.
  • If possible, sort submitted samples by time in ascending order.

Unix Time Format

time,metric-1,metric-2,...,metric-N
1423139581000,5.0,2.1,...,10.4
1423139592016,5.0,2.1,...,10.4

ISO Format

date,metric-1,metric-2,...,metric-N
2016-05-16T00:14:36.000Z,5.0,2.1,...,10.4
2016-05-16T00:14:45.012Z,5.0,2.1,...,10.4

Response

Fields

None.

Errors

  • Empty first row if no rows are found.
  • CSV must have at least 2 columns if header contains less than 2 columns.
  • No data if the number of data rows is 0.

Example

Request

URI

POST /api/v1/series/csv/nurswgvml007

Payload

time,cpu_user,cpu_system,waitio
1423139581000,12.4,1.4,0
1423139592016,16.0,4.2,0

curl

curl https://atsd_hostname:8443/api/v1/series/csv/nurswgvml007 \
 -k --user {username}:{password} \
 --header "Content-Type: text/csv" \
 --data-binary $'date,lx.cpu_busy\n2016-05-21T00:00:00Z,12.45\n2016-05-21T00:00:15Z,10.8\n'

--data-binary $ is used to prevent curl from dropping line feed characters.

curl https://atsd_hostname:8443/api/v1/series/csv/nurswgvml007 \
 -k --user {username}:{password} \
 --header "Content-Type: text/csv" \
 --data-binary @file.csv

Response

None.

Java Example

Additional Examples

← delete →