Axiom Docs

POST

datasets

_apl?format=tabular

cURL

curl --request POST \
  --url 'https://api.axiom.co/v1/datasets/_apl?format=tabular' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "apl": "[\"dataset-name\"] | limit 10",
  "startTime": "string",
  "endTime": "string"
}
'

{
  "format": "tabular",
  "status": {
    "elapsedTime": 260650,
    "minCursor": "0d8q6stroluyo-07c3957e7400015c-0000c875",
    "maxCursor": "0d8q6stroluyo-07c3957e7400015c-0000c877",
    "blocksExamined": 4,
    "blocksCached": 0,
    "blocksMatched": 0,
    "rowsExamined": 197604,
    "rowsMatched": 197604,
    "numGroups": 0,
    "isPartial": false,
    "cacheStatus": 1,
    "minBlockTime": "2025-03-26T12:03:14Z",
    "maxBlockTime": "2025-03-26T12:12:42Z"
  },
  "tables": [
    {
      "name": "0",
      "sources": [
        {
          "name": "dataset-name"
        }
      ],
      "fields": [
        {
          "name": "_sysTime",
          "type": "datetime"
        },
        {
          "name": "_time",
          "type": "datetime"
        },
        {
          "name": "content_type",
          "type": "string"
        },
        {
          "name": "geo.city",
          "type": "string"
        },
        {
          "name": "geo.country",
          "type": "string"
        },
        {
          "name": "id",
          "type": "string"
        },
        {
          "name": "is_tls",
          "type": "boolean"
        },
        {
          "name": "message",
          "type": "string"
        },
        {
          "name": "method",
          "type": "string"
        },
        {
          "name": "req_duration_ms",
          "type": "float"
        },
        {
          "name": "resp_body_size_bytes",
          "type": "integer"
        },
        {
          "name": "resp_header_size_bytes",
          "type": "integer"
        },
        {
          "name": "server_datacenter",
          "type": "string"
        },
        {
          "name": "status",
          "type": "string"
        },
        {
          "name": "uri",
          "type": "string"
        },
        {
          "name": "user_agent",
          "type": "string"
        },
        {
          "name": "is_ok_2    ",
          "type": "boolean"
        },
        {
          "name": "city_str_len",
          "type": "integer"
        }
      ],
      "order": [
        {
          "field": "_time",
          "desc": true
        }
      ],
      "groups": [],
      "range": {
        "field": "_time",
        "start": "1970-01-01T00:00:00Z",
        "end": "2025-03-26T12:12:43Z"
      },
      "columns": [
        [
          "2025-03-26T12:12:42.68112905Z",
          "2025-03-26T12:12:42.68112905Z",
          "2025-03-26T12:12:42.68112905Z"
        ],
        [
          "2025-03-26T12:12:42Z",
          "2025-03-26T12:12:42Z",
          "2025-03-26T12:12:42Z"
        ],
        [
          "text/html",
          "text/plain-charset=utf-8",
          "image/jpeg"
        ],
        [
          "Ojinaga",
          "Humboldt",
          "Nevers"
        ],
        [
          "Mexico",
          "United States",
          "France"
        ],
        [
          "8af366cf-6f25-42e6-bbb4-d860ab535a60",
          "032e7f68-b0ab-47c0-a24a-35af566359e5",
          "4d2c7baa-ff28-4b1f-9db9-8e6c0ed5a9c9"
        ],
        [
          false,
          false,
          true
        ],
        [
          "QCD permutations were not solvable in linear time, expected compressed time",
          "QCD permutations were not solvable in linear time, expected compressed time",
          "Expected a new layer of particle physics but got a Higgs Boson"
        ],
        [
          "GET",
          "GET",
          "GET"
        ],
        [
          1.396373193863436,
          0.16252390534308514,
          0.4093416175186162
        ],
        [
          3448,
          2533,
          1906
        ],
        [
          84,
          31,
          29
        ],
        [
          "DCA",
          "GRU",
          "FRA"
        ],
        [
          "201",
          "200",
          "200"
        ],
        [
          "/api/v1/buy/commit/id/go",
          "/api/v1/textdata/cnfigs",
          "/api/v1/bank/warn"
        ],
        [
          "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; AS; rv:11.0) like Gecko",
          "Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/535.24 (KHTML, like Gecko) Chrome/19.0.1055.1 Safari/535.24",
          "Mozilla/5.0 (Windows; U; MSIE 9.0; WIndows NT 9.0; en-US))"
        ],
        [
          true,
          true,
          true
        ],
        [
          7,
          8,
          6
        ]
      ]
    }
  ],
  "datasetNames": [
    "dataset-name"
  ],
  "fieldsMetaMap": {
    "dataset-name": [
      {
        "name": "status",
        "type": "",
        "unit": "",
        "hidden": false,
        "description": "HTTP status code"
      },
      {
        "name": "resp_header_size_bytes",
        "type": "integer",
        "unit": "none",
        "hidden": false,
        "description": ""
      },
      {
        "name": "geo.city",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": "the city"
      },
      {
        "name": "resp_body_size_bytes",
        "type": "integer",
        "unit": "decbytes",
        "hidden": false,
        "description": ""
      },
      {
        "name": "content_type",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": ""
      },
      {
        "name": "geo.country",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": ""
      },
      {
        "name": "req_duration_ms",
        "type": "float",
        "unit": "ms",
        "hidden": false,
        "description": "Request duration"
      }
    ]
  }
}

Authorizations

Authorization

string

header

required

The access token received from the authorization server in the OAuth 2.0 flow.

Query Parameters

format

enum<string>

required

Available options:

legacy,

tabular

nocache

boolean

default:false

saveAsKind

string

dataset_name

string

When saveAsKind is true, this parameter indicates the name of the associated dataset.

Body

application/json

apl

string

required

APL query to execute. For more information, see Introduction to APL.

cursor

string

endTime

string

includeCursor

boolean

queryOptions

object

Show child attributes

queryOptions.against

string

queryOptions.againstStart

string

queryOptions.againstTimestamp

string

queryOptions.aggChartOpts

string

queryOptions.caseSensitive

string

queryOptions.containsTimeFilter

string

queryOptions.datasets

string

queryOptions.displayNull

string

queryOptions.editorContent

string

queryOptions.endColumn

string

queryOptions.endLineNumber

string

queryOptions.endTime

string

queryOptions.integrationsFilter

string

queryOptions.openIntervals

string

queryOptions.quickRange

string

queryOptions.resolution

string

queryOptions.shownColumns

string

queryOptions.startColumn

string

queryOptions.startLineNumber

string

queryOptions.startTime

string

queryOptions.timeSeriesVariant

string

queryOptions.timeSeriesView

string

startTime

string

start and end time for the query, these must be specified as RFC3339 strings or using relative time expressions (e.g. now-1h, now-1d, now-1w, etc)

variables

object

Variables is an optional set of additional variables that are inserted into the APL

Show child attributes

variables.{key}

object

Response

Successful APL result

datasetNames

string[]

required

format

string

required

Format specifies the result set format. Either "legacy" (default) or "tabular".

status

object

required

Show child attributes

status.blocksExamined

integer<uint64>

required

status.cacheStatus

integer<uint8>

required

status.elapsedTime

integer<int64>

required

status.isPartial

boolean

required

status.maxBlockTime

string<date-time>

required

status.minBlockTime

string<date-time>

required

status.numGroups

integer<uint32>

required

status.rowsExamined

integer<uint64>

required

status.rowsMatched

integer<uint64>

required

status.continuationToken

string

status.isEstimate

boolean

status.maxCursor

string

Row id of the newest row, as seen server side. May be higher than what the results include if the server scanned more data than included in the results. Can be used to efficiently resume time-sorted non-aggregating queries (ie filtering only).

status.messages

object[]

Show child attributes

status.messages.count

integer<int64>

required

status.messages.msg

string

required

status.messages.priority

string

required

status.messages.code

string

status.minCursor

string

Row id of the oldest row, as seen server side. May be lower than what the results include if the server scanned more data than included in the results. Can be used to efficiently resume time-sorted non-aggregating queries (ie filtering only).

buckets

object

Show child attributes

buckets.series

object[]

Show child attributes

buckets.series.endTime

string<date-time>

required

buckets.series.startTime

string<date-time>

required

buckets.series.groups

object[]

Show child attributes

buckets.series.groups.group

object

required

Show child attributes

buckets.series.groups.group.{key}

object

buckets.series.groups.id

integer<uint64>

required

buckets.series.groups.aggregations

object[]

Show child attributes

buckets.series.groups.aggregations.op

string

required

buckets.series.groups.aggregations.value

object

required

buckets.series.groups.aggregations.data

object

buckets.totals

object[]

Show child attributes

buckets.totals.group

object

required

Show child attributes

buckets.totals.group.{key}

object

buckets.totals.id

integer<uint64>

required

buckets.totals.aggregations

object[]

Show child attributes

buckets.totals.aggregations.op

string

required

buckets.totals.aggregations.value

object

required

buckets.totals.aggregations.data

object

fieldsMetaMap

object

FieldsMetaMap contains the unit information (if we have it) for each field in the given dataset entry

Show child attributes

fieldsMetaMap.{key}

object[]

Show child attributes

fieldsMetaMap.{key}.hidden

boolean

required

fieldsMetaMap.{key}.name

string

required

fieldsMetaMap.{key}.type

string

required

fieldsMetaMap.{key}.unit

string

required

fieldsMetaMap.{key}.description

string

matches

object[]

Matches hold the matching events of a filter query in the "legacy" result format

Show child attributes

matches._rowId

string

required

matches._sysTime

string<date-time>

required

matches._time

string<date-time>

required

matches.data

object

required

Show child attributes

matches.data.{key}

object

request

object

Show child attributes

request.endTime

string

required

request.resolution

string

required

The time resolution of the query’s graph, in seconds. Valid values are the query’s time range /100 at maximum and /1000 at minimum or "auto".

request.startTime

string

required

start and end time for the query, these must be specified as RFC3339 strings or using relative time expressions (e.g. now-1h, now-1d, now-1w, etc)

request.aggregations

object[]

Show child attributes

request.aggregations.field

string

required

request.aggregations.op

enum<string>

required

Available options:

count,

distinct,

sum,

avg,

min,

max,

topk,

percentiles,

histogram,

stdev,

variance,

argmin,

argmax,

makeset,

rate,

makelist

request.aggregations.alias

string

request.aggregations.argument

object

request.continuationToken

string

request.cursor

string

request.fieldsMeta

object[]

FieldsMeta contains the unit information (if we have it) for each field

Show child attributes

request.fieldsMeta.hidden

boolean

required

request.fieldsMeta.name

string

required

request.fieldsMeta.type

string

required

request.fieldsMeta.unit

string

required

request.fieldsMeta.description

string

request.filter

object

Show child attributes

request.filter.field

string

required

request.filter.op

enum<string>

required

We also support '==', but we’re not exporting that to swagger, because it can’t deal with it add >, >=, <, <= to that list, it breaks codegen.

Available options:

and,

or,

not,

eq,

!=,

ne,

exists,

not-exists,

gt,

gte,

lt,

lte,

starts-with,

not-starts-with,

ends-with,

not-ends-with,

contains,

not-contains,

regexp,

not-regexp

request.filter.caseSensitive

boolean

Supported for these filters: starts-with, not-starts-with, ends-with, not-ends-with, contains, not-contains, eq, ne.

request.filter.children

string[]

Supported for these filters: and, or, not.

request.filter.value

object

request.groupBy

string[]

request.includeCursor

boolean

request.limit

integer<uint32>

request.order

object[]

Show child attributes

request.order.desc

boolean

required

request.order.field

string

required

request.project

object[]

Show child attributes

request.project.field

string

required

request.project.alias

string

request.virtualFields

object[]

Show child attributes

request.virtualFields.alias

string

required

request.virtualFields.expr

string

required

tables

Table defines the schema for query results in the "tabular" result format. · object[]

Tables hold the result tables in the "tabular" result format

Show child attributes

tables.fields

FieldInfo captures information about a field used in the tabular result format. See Table. · object[]

required

Fields contain information about the fields included in these results. The order of the fields match up with the order of the data in Columns.

Show child attributes

tables.fields.name

string

required

tables.fields.type

string

required

tables.fields.agg

object

AggInfo captures information about an aggregation

Show child attributes

tables.fields.agg.name

string

required

Name is the system name of the aggregation, which is the string form of aggregation.Type. If the aggregation is aliased, the alias is stored in the parent FieldInfo

tables.fields.agg.args

object[]

Args specifies any non-field arguments for the aggregation. Fx. [10] for topk(players, 10).

tables.fields.agg.fields

string[]

Fields specifies the names of the fields this aggregation is computed on. Fx ["players"] for topk(players, 10)

tables.groups

GroupInfo captures information about a grouping clause in the tabular result format. See Table. · object[]

required

Groups specifies which grouping operations has been performed on the results.

Show child attributes

tables.groups.name

string

tables.name

string

required

Name is the name assigned to this table. Defaults to "0". The name "_totals" is reserved for system use.

tables.order

object[]

required

Order echoes the ordering clauses that was used to sort the results.

Show child attributes

tables.order.desc

boolean

required

tables.order.field

string

required

tables.sources

SourceInfo specifies the provenance of a results Table. · object[]

required

Sources contain the names of the datasets that contributed data to these results.

Show child attributes

tables.sources.name

string

required

tables.buckets

BucketInfo captures information about how a grouped query is sorted into buckets. · object

The standard mode of operation is to create buckets on the _time column,

Show child attributes

tables.buckets.field

string

required

Field specifies the field used to create buckets on. Normally this would be _time.

tables.buckets.size

object

required

An integer or float representing the fixed bucket size. When the bucket field is _time this value is in nanoseconds.

tables.columns

object[][]

Columns contain a series of arrays with the raw result data. The columns here line up with the fields in the Fields array.

tables.range

RangeInfo specifies the window a query was restricted to. · object

Show child attributes

tables.range.end

string<date-time>

required

End is the ending time the query is limited by. Queries are restricted to the interval [start,end).

tables.range.field

string

required

Field specifies the field name on which the query range was restricted. Normally _time

tables.range.start

string<date-time>

required

Start is the starting time the query is limited by. Queries are restricted to the interval [start,end).

Run query (legacy)Query (Legacy)

⌘I

cURL

curl --request POST \
  --url 'https://api.axiom.co/v1/datasets/_apl?format=tabular' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "apl": "[\"dataset-name\"] | limit 10",
  "startTime": "string",
  "endTime": "string"
}
'

{
  "format": "tabular",
  "status": {
    "elapsedTime": 260650,
    "minCursor": "0d8q6stroluyo-07c3957e7400015c-0000c875",
    "maxCursor": "0d8q6stroluyo-07c3957e7400015c-0000c877",
    "blocksExamined": 4,
    "blocksCached": 0,
    "blocksMatched": 0,
    "rowsExamined": 197604,
    "rowsMatched": 197604,
    "numGroups": 0,
    "isPartial": false,
    "cacheStatus": 1,
    "minBlockTime": "2025-03-26T12:03:14Z",
    "maxBlockTime": "2025-03-26T12:12:42Z"
  },
  "tables": [
    {
      "name": "0",
      "sources": [
        {
          "name": "dataset-name"
        }
      ],
      "fields": [
        {
          "name": "_sysTime",
          "type": "datetime"
        },
        {
          "name": "_time",
          "type": "datetime"
        },
        {
          "name": "content_type",
          "type": "string"
        },
        {
          "name": "geo.city",
          "type": "string"
        },
        {
          "name": "geo.country",
          "type": "string"
        },
        {
          "name": "id",
          "type": "string"
        },
        {
          "name": "is_tls",
          "type": "boolean"
        },
        {
          "name": "message",
          "type": "string"
        },
        {
          "name": "method",
          "type": "string"
        },
        {
          "name": "req_duration_ms",
          "type": "float"
        },
        {
          "name": "resp_body_size_bytes",
          "type": "integer"
        },
        {
          "name": "resp_header_size_bytes",
          "type": "integer"
        },
        {
          "name": "server_datacenter",
          "type": "string"
        },
        {
          "name": "status",
          "type": "string"
        },
        {
          "name": "uri",
          "type": "string"
        },
        {
          "name": "user_agent",
          "type": "string"
        },
        {
          "name": "is_ok_2    ",
          "type": "boolean"
        },
        {
          "name": "city_str_len",
          "type": "integer"
        }
      ],
      "order": [
        {
          "field": "_time",
          "desc": true
        }
      ],
      "groups": [],
      "range": {
        "field": "_time",
        "start": "1970-01-01T00:00:00Z",
        "end": "2025-03-26T12:12:43Z"
      },
      "columns": [
        [
          "2025-03-26T12:12:42.68112905Z",
          "2025-03-26T12:12:42.68112905Z",
          "2025-03-26T12:12:42.68112905Z"
        ],
        [
          "2025-03-26T12:12:42Z",
          "2025-03-26T12:12:42Z",
          "2025-03-26T12:12:42Z"
        ],
        [
          "text/html",
          "text/plain-charset=utf-8",
          "image/jpeg"
        ],
        [
          "Ojinaga",
          "Humboldt",
          "Nevers"
        ],
        [
          "Mexico",
          "United States",
          "France"
        ],
        [
          "8af366cf-6f25-42e6-bbb4-d860ab535a60",
          "032e7f68-b0ab-47c0-a24a-35af566359e5",
          "4d2c7baa-ff28-4b1f-9db9-8e6c0ed5a9c9"
        ],
        [
          false,
          false,
          true
        ],
        [
          "QCD permutations were not solvable in linear time, expected compressed time",
          "QCD permutations were not solvable in linear time, expected compressed time",
          "Expected a new layer of particle physics but got a Higgs Boson"
        ],
        [
          "GET",
          "GET",
          "GET"
        ],
        [
          1.396373193863436,
          0.16252390534308514,
          0.4093416175186162
        ],
        [
          3448,
          2533,
          1906
        ],
        [
          84,
          31,
          29
        ],
        [
          "DCA",
          "GRU",
          "FRA"
        ],
        [
          "201",
          "200",
          "200"
        ],
        [
          "/api/v1/buy/commit/id/go",
          "/api/v1/textdata/cnfigs",
          "/api/v1/bank/warn"
        ],
        [
          "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; AS; rv:11.0) like Gecko",
          "Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/535.24 (KHTML, like Gecko) Chrome/19.0.1055.1 Safari/535.24",
          "Mozilla/5.0 (Windows; U; MSIE 9.0; WIndows NT 9.0; en-US))"
        ],
        [
          true,
          true,
          true
        ],
        [
          7,
          8,
          6
        ]
      ]
    }
  ],
  "datasetNames": [
    "dataset-name"
  ],
  "fieldsMetaMap": {
    "dataset-name": [
      {
        "name": "status",
        "type": "",
        "unit": "",
        "hidden": false,
        "description": "HTTP status code"
      },
      {
        "name": "resp_header_size_bytes",
        "type": "integer",
        "unit": "none",
        "hidden": false,
        "description": ""
      },
      {
        "name": "geo.city",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": "the city"
      },
      {
        "name": "resp_body_size_bytes",
        "type": "integer",
        "unit": "decbytes",
        "hidden": false,
        "description": ""
      },
      {
        "name": "content_type",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": ""
      },
      {
        "name": "geo.country",
        "type": "string",
        "unit": "",
        "hidden": false,
        "description": ""
      },
      {
        "name": "req_duration_ms",
        "type": "float",
        "unit": "ms",
        "hidden": false,
        "description": "Request duration"
      }
    ]
  }
}

Get started

Annotation endpoints

API token endpoints

Dataset endpoints

Edge endpoints

Map field endpoints

Monitor endpoints

Notifier endpoints

Organization endpoints

Role-Based Access Control endpoints

Saved queries endpoints

User endpoints

Views endpoints

Virtual fields endpoints

Run query

Authorizations

Query Parameters

Body

Response