List exports

GET 
/exports

List exports.

Authorization Action:

exporter:exports:list

Request

Query Parameters

ids string[]
status string[]

Possible values: [notProcessed, inProgress, failed, done, expired]

type string

Possible values: [recurring, oneTime]

tagLabels string[]
tagLabelValues string[]
from date-time
to date-time
page number
Possible values: >= 0
Default value: 0
pageSize number
Possible values: >= 0
Default value: 1000
sort string
Possible values: Value must match regular expression sortingStringRegex
Default value: createdAt:desc

Responses

200

application/json

Schema

Schema

results object[]required
Array [
format objectrequired
filenamestring
extensionstringrequired
Possible values: [csv, xlsx, pdf]
columns object[]
Define how exported data fields are mapped to the output file
Array [
idstringrequired
Column id.
When exporting resource items it must be formatted as: <type>.<attribute>.
labelstringrequired
Column label
]
timezonestring
Target timezone: all data field will be remapped to this timezone
Default value: utc
templatestring
Possible values: [tabular, expanded]
Default value: tabular
csvDelimiterstring
typestringrequired
Possible values: [recurring, oneTime]
items object[]required
Array [
params objectrequired
oneOf
MessageExportItemParamsDto
target objectrequired
valuestringrequired
Identifier of the resource the be exported: typically a URN. It is possible to export multiple resources by providing a comma separated list of values.
labelstring
Label that will replace the target value. If multiple values are provided, you can can pass a comma separated list of labels. The number of labels must match the number of values.
channelIdstringrequired
Example: 0115c85d-ef3e-4de9-9732-d0c5c4f2c482
subtopicstringrequired
Subtopic from which to retrieve data for export
Example: events.data
fromnumber
Unix timestamp: number of seconds since 1970 UTC
tonumber
Unix timestamp: number of seconds since 1970 UTC
periodstring
ISO8601 Duration: https://en.wikipedia.org/wiki/ISO_8601#Durations
Possible values: Value must match regular expression durationRegExp
Example: P1Y6M4DT12H30M5S
decimation object
dsobjectrequired
Decimation granularity. Only supports positive integer.
Example: 15m
dsfstringrequired
Aggregation algotithm
Possible values: [avg, max, min, sum, stddev, variance]
transformstring
Possible values: [delta]
outputFormatstringrequired
Determines how exported data will be formatted in the output file. Check the following link for more info: https://en.wikipedia.org/wiki/Wide_and_narrow_data
In the long format exported variables are spread across multiple rows. In the wide format exported variables are spread across multiple columns, and each row represents a different timestamp.
If wide format is selected, request.colums must be provided.
Possible values: [long, wide]
Default value: long
ResourceExportItemParamsDto
typestringrequired
Resource type (e.g. installations, devices, customers, etc.)
idsstring[]
IDs of the resources to be exported
includestring
Associated resources to be included. For example, if a resource installation has an association to a device resource, by settings include=devices you create export the installations data together with their associated devices.
sortstring
filterobject
page object
limitnumber
Possible values: >= 0
offsetnumber
Possible values: >= 0
ReportItemParamsDto
templateobjectrequired
Template object in JSON format
Example: { schemas: [{ text0: { type: "text", position: { x: 0, y: 0 }, width: 10, height: 10 } }], basePdf: { width: 297, height: 210, padding: [10, 10, 10, 10] } }
elements object[]required
Array [
templateFieldIdstringrequired
ID of template key associated to the report element
Example: text0
typestringrequired
Possible values: [text, chart, table]
sources object[]required
Defines the parameters needed to retrieve the data that will be used to fill the template element. Typically, sources has 1 element. However, if you want a chart with multiple plots, you can specify multiple source elements.
Array [
params objectrequired
The parameters associated to the service request
oneOf
MessageExportItemParamsDto
target objectrequired
valuestringrequired
Identifier of the resource the be exported: typically a URN. It is possible to export multiple resources by providing a comma separated list of values.
labelstring
Label that will replace the target value. If multiple values are provided, you can can pass a comma separated list of labels. The number of labels must match the number of values.
channelIdstringrequired
Example: 0115c85d-ef3e-4de9-9732-d0c5c4f2c482
subtopicstringrequired
Subtopic from which to retrieve data for export
Example: events.data
fromnumber
Unix timestamp: number of seconds since 1970 UTC
tonumber
Unix timestamp: number of seconds since 1970 UTC
periodstring
ISO8601 Duration: https://en.wikipedia.org/wiki/ISO_8601#Durations
Possible values: Value must match regular expression durationRegExp
Example: P1Y6M4DT12H30M5S
decimation object
dsobjectrequired
Decimation granularity. Only supports positive integer.
Example: 15m
dsfstringrequired
Aggregation algotithm
Possible values: [avg, max, min, sum, stddev, variance]
transformstring
Possible values: [delta]
outputFormatstringrequired
Determines how exported data will be formatted in the output file. Check the following link for more info: https://en.wikipedia.org/wiki/Wide_and_narrow_data
In the long format exported variables are spread across multiple rows. In the wide format exported variables are spread across multiple columns, and each row represents a different timestamp.
If wide format is selected, request.colums must be provided.
Possible values: [long, wide]
Default value: long
ResourceExportItemParamsDto
typestringrequired
Resource type (e.g. installations, devices, customers, etc.)
idsstring[]
IDs of the resources to be exported
includestring
Associated resources to be included. For example, if a resource installation has an association to a device resource, by settings include=devices you create export the installations data together with their associated devices.
sortstring
filterobject
page object
limitnumber
Possible values: >= 0
offsetnumber
Possible values: >= 0
servicestringrequired
The service from which to fetch the data
Possible values: [messages, resources]
postProc object[]
The post-processing function(s) to apply to the retrieved data
Array [
fnstringrequired
Possible values: [max, min, add, cumSum, mult, avg]
keystringrequired
Defines the key of the object whose value will be processed by the function
paramsobject
Function parameters. Not all processing functions require additional parameters.
Example: For `add` or `mult`: {k: 1}", "For `avg`: {k: 1.5, decimals: 3}
]
]
formats object[]required
Defines the formatting parameters of the template element. For example, for elements of type Chart: the chart type, the chart color, etc. If multiple sources elements have been specified, you must define a formats element for each source. So, it must be: len(formats) == len(sources).
Array [
text object
The formatting parameters for elements of type "Text"
keystringrequired
Defines the key of the object whose value will be displayed in the report
Example: value
unitKeystring
Defines the key of the object whose value will be displayed as unit of measurement
Example: unit
chart object
The formatting parameters for elements of type "Chart"
typestringrequired
Possible values: [bar, line]
xAxis objectrequired
X axis chart parameters
keystringrequired
Defines the key of the object whose value will be plotted in the X axis
options objectrequired
typestringrequired
Possible values: [string, datetime]
formatstring
Formatting string. If X axis represents time, this will be used to format the date.
yAxis objectrequired
Y axis chart parameters
keystringrequired
Defines the key of the object whose value will be plotted in the Y axis
labelstring
Chart label
colorstring
Hexadecimal color string
canvas object
widthnumberrequired
heightnumberrequired
table object
The formatting parameters for elements of type "Table"
columns object[]required
Array [
idstringrequired
Column id.
When exporting resource items it must be formatted as: <type>.<attribute>.
labelstringrequired
Column label
]
]
]
filenamestring
Name of the output file (without extension)
]
periodicitystring
ISO8601 Duration: https://en.wikipedia.org/wiki/ISO_8601#Durations
Possible values: Value must match regular expression durationRegExp
Example: P1Y6M4DT12H30M5S
periodStartnumber
Period start expressed in Unix timestamp. If not specified, the creation date of the request will be used.
notification object
messages object[]required
Notification messages. For each notification, there must be exactly two notification messages with the two different policies (onSuccess, onFailure)
Array [
targetstring
Notification target: can be an email address, a phone number or a telegram account. If not specified, the notification target is set to the user that created the rule.
policystringrequired
The notification policy: whether it is associated with a success event (export delivered), or a failure event (export failed)
Possible values: [onSuccess, onFailure]
mediumstringrequired
Possible values: [email, telegram, slack, discord]
titlestringrequired
textstringrequired
]
tags object[]
Array [
labelstringrequired
labelValuestringrequired
metadataobject
Other custom properties associated to the tag
]
idstringrequired
createdAtstring<date-time>required
updatedAtstring<date-time>required
deletedAtstring<date-time>required
]
totalnumberrequired

Example (auto)

{
  "results": [
    {
      "format": {
        "filename": "string",
        "extension": "csv",
        "columns": [
          {
            "id": "string",
            "label": "string"
          }
        ],
        "timezone": "utc",
        "template": "tabular",
        "csvDelimiter": "string"
      },
      "type": "recurring",
      "items": [
        {
          "params": {
            "target": {
              "value": "string",
              "label": "string"
            },
            "channelId": "0115c85d-ef3e-4de9-9732-d0c5c4f2c482",
            "subtopic": "events.data",
            "from": 0,
            "to": 0,
            "period": "P1Y6M4DT12H30M5S",
            "decimation": {
              "ds": "15m",
              "dsf": "avg"
            },
            "transform": "delta",
            "outputFormat": "long"
          },
          "filename": "string"
        }
      ],
      "periodicity": "P1Y6M4DT12H30M5S",
      "periodStart": 0,
      "notification": {
        "messages": [
          {
            "target": "string",
            "policy": "onSuccess",
            "medium": "email",
            "title": "string",
            "text": "string"
          }
        ]
      },
      "tags": [
        {
          "label": "string",
          "labelValue": "string",
          "metadata": {}
        }
      ],
      "id": "string",
      "createdAt": "2024-07-29T15:51:28.071Z",
      "updatedAt": "2024-07-29T15:51:28.071Z",
      "deletedAt": "2024-07-29T15:51:28.071Z"
    }
  ],
  "total": 0
}

400

Missing user identity id

• csharp
• curl
• dart
• go
• http
• java
• javascript
• kotlin
• c
• nodejs
• objective-c
• ocaml
• php
• powershell
• python
• r
• ruby
• rust
• shell
• swift

• HTTPCLIENT
• RESTSHARP

var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Get, "https://connhex.com/exports");
request.Headers.Add("Accept", "application/json");
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

Request Collapse all

Parameters

ids — query

status — query

notProcessedinProgressfaileddoneexpired

type — query

---recurringoneTime

tagLabels — query

tagLabelValues — query

from — query

to — query

page — query

pageSize — query

sort — query