API docs by Redocly

Data Pipeline service API docs (1.3.0)

Download OpenAPI specification:

REST API for BAO Data Pipeline service

Kobo Toolbox data pipelines

Get surveys for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
url
required
string
username
required
string
password
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "username": "string",
  • "password": "string"
}

Response samples

Content type
application/json
[
  • {
    }
]

Get surveys for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
url
required
string
username
required
string
password
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "username": "string",
  • "password": "string"
}

Response samples

Content type
application/json
[
  • {
    }
]

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "survey": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (AuthTokenApiSource)
survey
required
string
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "survey": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (AuthTokenApiSource)
survey
required
string
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "survey": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Test connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
url
required
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "authToken": "string"
}

Get surveys for payload

Request Body schema: application/json
required
url
required
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "authToken": "string"
}

Response samples

Content type
application/json
[
  • {
    }
]

Create many data pipelines

Request Body schema: application/json
required
Array of objects (KoboDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test connection for payload

Request Body schema: application/json
required
url
required
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "authToken": "string"
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Workflows

Get workflow

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "cronExpression": "string",
  • "steps": {
    },
  • "status": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "scheduleable": true,
  • "displayName": "string"
}

Update workflow

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
continuouslyUpdated
required
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
cronExpression
string
required
object (WorkflowSteps)
object (WorkflowStatus)
object (Access)
triggerExpression
string
displayDescription
string
scheduleable
boolean
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "cronExpression": "string",
  • "steps": {
    },
  • "status": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "scheduleable": true,
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Remove workflow

path Parameters
uid
required
string

Responses

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get workflows

query Parameters
filter
Array of strings
order
Array of strings

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create workflow

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
continuouslyUpdated
required
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
cronExpression
string
required
object (WorkflowSteps)
object (WorkflowStatus)
object (Access)
triggerExpression
string
displayDescription
string
scheduleable
boolean
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "cronExpression": "string",
  • "steps": {
    },
  • "status": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "scheduleable": true,
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Execute workflow

path Parameters
uid
required
string

Responses

Get workflows V2

query Parameters
required
object (SearchRequestDto)

Responses

Response samples

Content type
application/json
{
  • "results": [
    ],
  • "pager": {
    }
}

Views

Get view

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schema": {
    },
  • "description": "string",
  • "dataWarehouseViewName": "string",
  • "query": "string",
  • "materialized": true,
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "tags": [
    ],
  • "status": {
    },
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "tagString": "string",
  • "qualifiedDataWarehouseViewName": "string",
  • "redshiftViewName": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayName": "string"
}

Update view

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
required
object (Schema)
description
string
dataWarehouseViewName
string
query
required
string
materialized
required
boolean
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
tags
Array of strings unique
object (ViewStatus)
object (AnonymousAccess)
object (Access)
triggerExpression
string
displayDescription
string
tagString
string
qualifiedDataWarehouseViewName
string
redshiftViewName
string
Deprecated
scheduleable
boolean
continuouslyUpdated
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schema": {
    },
  • "description": "string",
  • "dataWarehouseViewName": "string",
  • "query": "string",
  • "materialized": true,
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "tags": [
    ],
  • "status": {
    },
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "tagString": "string",
  • "qualifiedDataWarehouseViewName": "string",
  • "redshiftViewName": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Remove view

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

getViews

query Parameters
filter
Array of strings
order
Array of strings

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create view

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
required
object (Schema)
description
string
dataWarehouseViewName
string
query
required
string
materialized
required
boolean
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
tags
Array of strings unique
object (ViewStatus)
object (AnonymousAccess)
object (Access)
triggerExpression
string
displayDescription
string
tagString
string
qualifiedDataWarehouseViewName
string
redshiftViewName
string
Deprecated
scheduleable
boolean
continuouslyUpdated
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schema": {
    },
  • "description": "string",
  • "dataWarehouseViewName": "string",
  • "query": "string",
  • "materialized": true,
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "tags": [
    ],
  • "status": {
    },
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "tagString": "string",
  • "qualifiedDataWarehouseViewName": "string",
  • "redshiftViewName": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Unload view

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy view

path Parameters
uid
required
string

Responses

Get structure

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Download data

path Parameters
uid
required
string

Responses

Get data preview

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Variables

Get variable

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Update variable

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
secured
required
boolean
value
required
string [ 1 .. 5000 ] characters
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Remove variable

path Parameters
uid
required
string

Responses

Get variable

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Update variable

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
secured
required
boolean
value
required
string [ 1 .. 5000 ] characters
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Remove variable

path Parameters
uid
required
string

Responses

Get variables

query Parameters
filter
Array of strings
order
Array of strings

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create variable

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
secured
required
boolean
value
required
string [ 1 .. 5000 ] characters
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Get variables

query Parameters
filter
Array of strings
order
Array of strings

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create variable

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
secured
required
boolean
value
required
string [ 1 .. 5000 ] characters
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "secured": true,
  • "value": "string",
  • "displayName": "string"
}

Settings

Get setting

path Parameters
key
required
string
Enum: "ALERT_EMAIL" "DEFAULT_ACCESS_LEVEL" "DATA_PIPELINE_ERROR_ACTION_STAGING_TABLES" "RETAIN_TEMP_FILES" "THEME"

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "client": "string",
  • "key": "ALERT_EMAIL",
  • "value": "string"
}

Update setting

path Parameters
key
required
string
Enum: "ALERT_EMAIL" "DEFAULT_ACCESS_LEVEL" "DATA_PIPELINE_ERROR_ACTION_STAGING_TABLES" "RETAIN_TEMP_FILES" "THEME"
Request Body schema: application/json
required
id
string
created
string <date-time>
lastUpdated
string <date-time>
client
required
string
key
required
string
Enum: "ALERT_EMAIL" "DEFAULT_ACCESS_LEVEL" "DATA_PIPELINE_ERROR_ACTION_STAGING_TABLES" "RETAIN_TEMP_FILES" "THEME"
value
required
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "client": "string",
  • "key": "ALERT_EMAIL",
  • "value": "string"
}

Get all settings

Responses

Response samples

Content type
application/json
{
  • "settings": {
    }
}

Create setting

Request Body schema: application/json
required
object

Responses

Request samples

Content type
application/json
{
  • "settings": {
    }
}

Schemas

Get schema

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schemaName": "string",
  • "description": "string",
  • "tags": [
    ],
  • "access": {
    },
  • "permanent": true,
  • "providerSchema": "REDSHIFT",
  • "statistics": {
    },
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update schema

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
schemaName
string
description
string
tags
Array of strings unique
object (Access)
permanent
required
boolean
providerSchema
required
string
Enum: "REDSHIFT" "POSTGRESQL" "CLICKHOUSE" "SYNAPSE" "SQL_SERVER" "NA"
object (SchemaStatistics)
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schemaName": "string",
  • "description": "string",
  • "tags": [
    ],
  • "access": {
    },
  • "permanent": true,
  • "providerSchema": "REDSHIFT",
  • "statistics": {
    },
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove schema

path Parameters
uid
required
string

Responses

Get schemas

query Parameters
filter
Array of strings
order
Array of strings

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create schema

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
schemaName
string
description
string
tags
Array of strings unique
object (Access)
permanent
required
boolean
providerSchema
required
string
Enum: "REDSHIFT" "POSTGRESQL" "CLICKHOUSE" "SYNAPSE" "SQL_SERVER" "NA"
object (SchemaStatistics)
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "schemaName": "string",
  • "description": "string",
  • "tags": [
    ],
  • "access": {
    },
  • "permanent": true,
  • "providerSchema": "REDSHIFT",
  • "statistics": {
    },
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create schema snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Remove schema snapshot

path Parameters
uid
required
string

Responses

Get views of schema

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get tables in schema

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get table in schema

path Parameters
uid
required
string
tableName
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get columns in table

path Parameters
uid
required
string
tableName
required
string

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Public datasets

Get public dataset

path Parameters
key
required
string

Responses

Response samples

Content type
application/json
{
  • "key": "string",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "name": "string",
  • "description": "string",
  • "owner": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "tags": [
    ],
  • "headerRow": true,
  • "table": {
    },
  • "tagString": "string"
}

Update public dataset

path Parameters
key
required
string
Request Body schema: application/json
required
key
string
lastUpdated
string <date-time>
name
string
description
string
owner
string
reference
string
source
string
termsOfUse
string
tags
Array of strings unique
headerRow
boolean
object (Table)
tagString
string

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "name": "string",
  • "description": "string",
  • "owner": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "tags": [
    ],
  • "headerRow": true,
  • "table": {
    },
  • "tagString": "string"
}

Remove public dataset

path Parameters
key
required
string

Responses

Get all public datasets

query Parameters
filter
Array of strings
page
integer <int32>
pageSize
integer <int32>

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create public dataset

query Parameters
key
required
string
name
required
string
description
string
owner
string
reference
string
source
string
termsOfUse
string
tags
string
Request Body schema: application/json
file
required
string <binary>

Responses

Request samples

Content type
application/json
{
  • "file": "string"
}

DHIS2 destinations

Get destination

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "viewSource": {
    },
  • "status": {
    },
  • "access": {
    },
  • "importOptions": {
    },
  • "apiTarget": {
    },
  • "apiTokenTarget": {
    },
  • "type": "DHIS2",
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayName": "string"
}

Update destination

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
required
object (View)
object (DestinationStatus)
object (Access)
object (ImportOptions)
object (UsernamePasswordApiTarget)
object (AuthTokenApiTarget)
type
string
Value: "DHIS2"
triggerExpression
string
displayDescription
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "viewSource": {
    },
  • "status": {
    },
  • "access": {
    },
  • "importOptions": {
    },
  • "apiTarget": {
    },
  • "apiTokenTarget": {
    },
  • "type": "DHIS2",
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayName": "string"
}

Remove destination

path Parameters
uid
required
string

Responses

Update destination access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get destinations

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create destination

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
required
object (View)
object (DestinationStatus)
object (Access)
object (ImportOptions)
object (UsernamePasswordApiTarget)
object (AuthTokenApiTarget)
type
string
Value: "DHIS2"
triggerExpression
string
displayDescription
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "viewSource": {
    },
  • "status": {
    },
  • "access": {
    },
  • "importOptions": {
    },
  • "apiTarget": {
    },
  • "apiTokenTarget": {
    },
  • "type": "DHIS2",
  • "triggerExpression": "string",
  • "displayDescription": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayName": "string"
}

Load data

path Parameters
uid
required
string

Responses

Copy destination

path Parameters
uid
required
string

Responses

Test connection for destination

path Parameters
uid
required
string
Request Body schema: application/json
required
url
required
string
username
string
password
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "username": "string",
  • "password": "string",
  • "authToken": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test connection for payload

Request Body schema: application/json
required
url
required
string
username
string
password
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "username": "string",
  • "password": "string",
  • "authToken": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test connection

path Parameters
uid
required
string

Responses

Test connection

path Parameters
uid
required
string

Responses

Get destination as attachment

path Parameters
uid
required
string

Responses

Data quality checks

Create data quality check

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "code": "string",
  • "description": "string",
  • "query": "string",
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "displayName": "string"
}

Update data quality check

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
object (Access)
shortName
required
string [ 0 .. 50 ] characters
Array of objects (Label)
code
required
string [ 0 .. 50 ] characters
description
string
query
required
string [ 2 .. 2147483647 ] characters
displayDescription
string
Array of objects (Label)
displayShortName
string
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "code": "string",
  • "description": "string",
  • "query": "string",
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Remove data quality check

path Parameters
uid
required
string

Responses

Update data quality check access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data quality checks

query Parameters
filter
Array of strings
order
Array of strings
required
object (PagingRequest)

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data quality check

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
object (Access)
shortName
required
string [ 0 .. 50 ] characters
Array of objects (Label)
code
required
string [ 0 .. 50 ] characters
description
string
query
required
string [ 2 .. 2147483647 ] characters
displayDescription
string
Array of objects (Label)
displayShortName
string
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "code": "string",
  • "description": "string",
  • "query": "string",
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Get data quality check result

path Parameters
uid
required
string
Request Body schema: application/json
required
Array of objects (Variable)

Responses

Request samples

Content type
application/json
{
  • "variables": [
    ]
}

Response samples

Content type
application/json
{
  • "dataQualityCheckId": "string",
  • "status": "OK",
  • "data": {
    }
}

Data quality check groups

Get data quality check group

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "description": "string",
  • "dataQualityChecks": [
    ],
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "displayName": "string"
}

Update data quality check group

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
object (Access)
shortName
required
string [ 0 .. 50 ] characters
Array of objects (Label)
description
string
Array of objects (DataQualityCheck) unique
displayDescription
string
Array of objects (Label)
displayShortName
string
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "description": "string",
  • "dataQualityChecks": [
    ],
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Remove data quality check group

path Parameters
uid
required
string

Responses

Update data quality check group access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data quality check groups

query Parameters
filter
Array of strings
order
Array of strings
required
object (PagingRequest)

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data quality check group

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
object (Access)
shortName
required
string [ 0 .. 50 ] characters
Array of objects (Label)
description
string
Array of objects (DataQualityCheck) unique
displayDescription
string
Array of objects (Label)
displayShortName
string
createdByLastUpdatedBy
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "access": {
    },
  • "shortName": "string",
  • "labels": [
    ],
  • "description": "string",
  • "dataQualityChecks": [
    ],
  • "displayDescription": "string",
  • "displayLabels": [
    ],
  • "displayShortName": "string",
  • "createdByLastUpdatedBy": "string",
  • "displayName": "string"
}

Get data quality check group result

path Parameters
uid
required
string
Request Body schema: application/json
Array of objects (Variable)

Responses

Request samples

Content type
application/json
{
  • "variables": [
    ]
}

Response samples

Content type
application/json
{
  • "name": "string",
  • "completedAt": "2019-08-24T14:15:22Z",
  • "variables": [
    ],
  • "results": [
    ]
}

Get data quality check result async

path Parameters
uid
required
string
Request Body schema: application/json
Array of objects (Variable)

Responses

Request samples

Content type
application/json
{
  • "variables": [
    ]
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Talamus data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "facilities": [
    ],
  • "startDate": "2019-08-24",
  • "endDate": "2019-08-24",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (AuthTokenApiSource)
facilities
required
Array of strings [ 1 .. 2147483647 ] items
startDate
required
string <date>
endDate
required
string <date>
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "facilities": [
    ],
  • "startDate": "2019-08-24",
  • "endDate": "2019-08-24",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (AuthTokenApiSource)
facilities
required
Array of strings [ 1 .. 2147483647 ] items
startDate
required
string <date>
endDate
required
string <date>
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "facilities": [
    ],
  • "startDate": "2019-08-24",
  • "endDate": "2019-08-24",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Test connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
url
required
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "authToken": "string"
}

Create many data pipelines

Request Body schema: application/json
required
Array of objects (TalamusDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test connection for payload

Request Body schema: application/json
required
url
required
string
authToken
string

Responses

Request samples

Content type
application/json
{
  • "url": "string",
  • "authToken": "string"
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

S3 data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "s3Source": {
    },
  • "key": "string",
  • "delimiter": "PIPE",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (S3Source)
key
required
string
delimiter
required
string
Enum: "PIPE" "COMMA" "TAB" "SEMI_COLON"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "s3Source": {
    },
  • "key": "string",
  • "delimiter": "PIPE",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (S3Source)
key
required
string
delimiter
required
string
Enum: "PIPE" "COMMA" "TAB" "SEMI_COLON"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "s3Source": {
    },
  • "key": "string",
  • "delimiter": "PIPE",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Test connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
bucket
required
string
objectKey
required
string
accessKey
string
secretKey
string

Responses

Request samples

Content type
application/json
{
  • "bucket": "string",
  • "objectKey": "string",
  • "accessKey": "string",
  • "secretKey": "string"
}

Create many data pipelines

Request Body schema: application/json
required
Array of objects (S3DataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test connection for payload

Request Body schema: application/json
required
bucket
required
string
objectKey
required
string
accessKey
string
secretKey
string

Responses

Request samples

Content type
application/json
{
  • "bucket": "string",
  • "objectKey": "string",
  • "accessKey": "string",
  • "secretKey": "string"
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Redshift data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Create many data pipelines

Request Body schema: application/json
required
Array of objects (RedshiftDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
iamRoleArn
required
string
region
required
string
Enum: "DEFAULT" "US_EAST_1" "US_EAST_2" "US_WEST_1" "US_WEST_2" "AF_SOUTH_1" "EU_CENTRAL_1" "EU_WEST_1" "EU_WEST_2" "EU_WEST_3" "EU_SOUTH_1" "EU_NORTH_1"
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "iamRoleArn": "string",
  • "region": "DEFAULT",
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Public dataset data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "key": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
key
required
string
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "key": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
key
required
string
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "key": "string",
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Create many data pipelines

Request Body schema: application/json
required
Array of objects (PublicDatasetDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Ingest all public datasets

Responses

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

PostgreSQL data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Get tables for data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Get tables for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
[
  • {
    }
]

Create many data pipelines

Request Body schema: application/json
required
Array of objects (PostgreSqlDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Parquet uploads data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "file": {
    },
  • "type": "AZURE_BLOB_STORAGE",
  • "scheduleable": true,
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
object (FileMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
scheduleable
boolean
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "file": {
    },
  • "type": "AZURE_BLOB_STORAGE",
  • "scheduleable": true,
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
object (FileMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
scheduleable
boolean
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "file": {
    },
  • "type": "AZURE_BLOB_STORAGE",
  • "scheduleable": true,
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Upload Parquet file for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
file
required
string <binary>

Responses

Request samples

Content type
application/json
{
  • "file": "string"
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Create many data pipelines

Request Body schema: application/json
required
Array of objects (ParquetUploadDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Upload Parquet file

query Parameters
name
required
string
description
string
owner
string
reference
string
source
string
termsOfUse
string
tags
string
schema
string
Request Body schema: application/json
file
required
string <binary>

Responses

Request samples

Content type
application/json
{
  • "file": "string"
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Oracle data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Create data pipeline

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Create data pipeline snapshot

path Parameters
uid
required
string
Request Body schema: application/json
required
key
string
loadData
boolean

Responses

Request samples

Content type
application/json
{
  • "key": "string",
  • "loadData": true
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Purge data files

path Parameters
uid
required
string

Responses

Load data

path Parameters
uid
required
string

Responses

Copy data pipeline

path Parameters
uid
required
string

Responses

Create many data pipelines

Request Body schema: application/json
required
Array of objects (OracleDataPipeline)

Responses

Request samples

Content type
application/json
{
  • "dataPipelines": [
    ]
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Test JDBC connection for payload

Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (JdbcSource)
sqlQuery
string
Array of objects (TableMetadata)
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
defaultPort
integer <int32>
jdbcConnectionUrl
string
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "jdbcSource": {
    },
  • "sqlQuery": "string",
  • "tables": [
    ],
  • "type": "AZURE_BLOB_STORAGE",
  • "defaultPort": 0,
  • "jdbcConnectionUrl": "string",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Response samples

Content type
application/json
{
  • "status": "OK",
  • "httpStatus": "100 CONTINUE",
  • "httpStatusCode": 0,
  • "statusCode": 0,
  • "errorCode": "OK",
  • "message": "string",
  • "messageKey": "string",
  • "devMessage": "string",
  • "data": { }
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get table structure

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get log entries

path Parameters
uid
required
string
query Parameters
taskId
string
logLevel
string
Enum: "DEBUG" "INFO" "WARN" "ERROR"
logImportance
string
Enum: "LOW" "MEDIUM" "HIGH"
order
string
Enum: "ASC" "DESC"

Responses

Response samples

Content type
application/json
[
  • {
    }
]

Get data preview

path Parameters
uid
required
string
query Parameters
table
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Test connection

path Parameters
uid
required
string

Responses

Get data download keys

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "objectKeys": [
    ]
}

Download data for key

path Parameters
uid
required
string
objectKeyId
required
string

Responses

Get distinct values for column

path Parameters
uid
required
string
column
required
string

Responses

Response samples

Content type
application/json
{
  • "schema": "string",
  • "name": "string",
  • "displayName": "string",
  • "description": "string",
  • "size": 0,
  • "sizePretty": "string",
  • "rowCount": 0,
  • "columns": [
    ],
  • "foreignKeys": [
    ],
  • "queryStartTime": "2019-08-24T14:15:22Z",
  • "queryDuration": 0,
  • "rows": [
    ],
  • "height": 0,
  • "width": 0,
  • "qualifiedTableName": "string",
  • "tableName": "string",
  • "columnCount": 0,
  • "sizeMb": 0
}

Get data pipeline as attachment

path Parameters
uid
required
string

Responses

Ona data pipelines

Get data pipeline

path Parameters
uid
required
string

Responses

Response samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "form": 0,
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Update data pipeline

path Parameters
uid
required
string
Request Body schema: application/json
required
id
string
name
required
string
created
string <date-time>
lastUpdated
string <date-time>
Array of objects (Translation) unique
client
string
createdBy
string
lastUpdatedBy
string
description
string
owner
string
url
string
reference
string
source
string
termsOfUse
string
disabled
required
boolean
runTrigger
required
string
Enum: "EVERY_15_MIN" "EVERY_30_MIN" "EVERY_HOUR" "EVERY_3_HOURS" "EVERY_DAY_0AM" "EVERY_DAY_2AM" "EVERY_NIGHT_RANDOM" "EVERY_WEEKDAY" "EVERY_SATURDAY" "EVERY_SATURDAY_NIGHT_RANDOM" "EVERY_MONTH" "EVERY_MONTH_RANDOM" "CUSTOM" "NEVER"
cronExpression
string
object (DataPipelineStatus)
tags
Array of strings unique
object (AnonymousAccess)
object (Access)
object (DataPipelineTransformation)
required
object (DataWarehouseTarget)
required
object (AuthTokenApiSource)
form
required
integer <int32>
type
string
Enum: "AZURE_BLOB_STORAGE" "BHIMA" "COMMCARE" "CSV_UPLOAD" "DHIS2" "FUNCTION" "FHIR" "GOOGLE_SHEETS" "IHRIS" "IHRIS5" "KOBO_TOOLBOX" "MSSQL" "MYSQL" "ODK" "ONA" "ORACLE" "PARQUET_UPLOAD" "POSTGRESQL" "PUBLIC_DATASET" "REDSHIFT" "S3BUCKET" "TALAMUS"
typeName
string
dataWarehouseTargetSchemaName
string
dataWarehouseTargetTableName
string
dataPipelineSourceName
string
dataDownload
boolean
typeKey
string
createdByLastUpdatedBy
string
scheduleable
boolean
continuouslyUpdated
boolean
triggerExpression
string
continuousUpdateInterval
integer <int32>
fullRefreshInterval
integer <int32>
displayDescription
string
tagString
string
displayName
string

Responses

Request samples

Content type
application/json
{
  • "id": "string",
  • "name": "string",
  • "created": "2019-08-24T14:15:22Z",
  • "lastUpdated": "2019-08-24T14:15:22Z",
  • "translations": [
    ],
  • "client": "string",
  • "createdBy": "string",
  • "lastUpdatedBy": "string",
  • "description": "string",
  • "owner": "string",
  • "url": "string",
  • "reference": "string",
  • "source": "string",
  • "termsOfUse": "string",
  • "disabled": true,
  • "runTrigger": "EVERY_15_MIN",
  • "cronExpression": "string",
  • "status": {
    },
  • "tags": [
    ],
  • "anonymousAccess": {
    },
  • "access": {
    },
  • "transformation": {
    },
  • "dataWarehouseTarget": {
    },
  • "apiSource": {
    },
  • "form": 0,
  • "type": "AZURE_BLOB_STORAGE",
  • "typeName": "string",
  • "dataWarehouseTargetSchemaName": "string",
  • "dataWarehouseTargetTableName": "string",
  • "dataPipelineSourceName": "string",
  • "dataDownload": true,
  • "typeKey": "string",
  • "createdByLastUpdatedBy": "string",
  • "scheduleable": true,
  • "continuouslyUpdated": true,
  • "triggerExpression": "string",
  • "continuousUpdateInterval": 0,
  • "fullRefreshInterval": 0,
  • "displayDescription": "string",
  • "tagString": "string",
  • "displayName": "string"
}

Remove data pipeline

path Parameters
uid
required
string

Responses

Update anonymous access

path Parameters
uid
required
string
Request Body schema: application/json
required
metadata
boolean
data
boolean

Responses

Request samples

Content type
application/json
{
  • "metadata": true,
  • "data": true
}

Update access

path Parameters
uid
required
string
Request Body schema: application/json
required
publicAccess
string
Enum: "READ" "READ_WRITE" "NONE"
required
Array of objects (AccessObject) unique
required
Array of objects (AccessObject) unique

Responses

Request samples

Content type
application/json
{
  • "publicAccess": "READ",
  • "userAccess": [
    ],
  • "userGroupAccess": [
    ]
}

Get data pipelines

Responses

Response samples

Content type
application/json
[
  • {