Data Table Actions

https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Below are the various requests that can be performed against the Data Table resource, as well as the expected parameters and the potential responses.

Add Column

Adds a new column to this data table

Method And Url

POST https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/column

Authentication

A valid API access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Organization, all.User, dataTable.*, or dataTable.addColumn.

Request Path Components

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97
DATA_TABLE_ID	ID associated with the data table	575ed78e7ae143cd83dc4aab

Request Headers

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Request Body

The body of the request should be serialized JSON that validates against the Data Table Column schema. For example, the following would be a valid body for this request:

{
  "name": "myColumn3",
  "dataType": "string",
  "constraint": "optional",
  "defaultValue": "aDefault"
}

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X POST \
    -d '{"name":"myColumn3","dataType":"string","constraint":"optional","defaultValue":"aDefault"}' \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/column

Successful Responses

Code	Type	Description
200	Data Table	Updated data table information

Error Responses

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if data table was not found

Delete

Deletes a data table

Method And Url

DELETE https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Authentication

A valid API access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Organization, all.User, dataTable.*, or dataTable.delete.

Request Path Components

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97
DATA_TABLE_ID	ID associated with the data table	575ed78e7ae143cd83dc4aab

Request Headers

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X DELETE \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Successful Responses

Code	Type	Description
200	Success	If data table was successfully deleted

Error Responses

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if data table was not found

Get

Retrieves information on a data table

Method And Url

GET https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Authentication

A valid API access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Application.cli, all.Application.read, all.Organization, all.Organization.read, all.User, all.User.cli, all.User.read, dataTable.*, or dataTable.get.

Request Path Components

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97
DATA_TABLE_ID	ID associated with the data table	575ed78e7ae143cd83dc4aab

Request Headers

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X GET \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Successful Responses

Code	Type	Description
200	Data Table	Data table information

Error Responses

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if data table was not found

Patch

Updates information about a data table

Method And Url

PATCH https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Authentication

A valid API access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Organization, all.User, dataTable.*, or dataTable.patch.

Request Path Components

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97
DATA_TABLE_ID	ID associated with the data table	575ed78e7ae143cd83dc4aab

Request Headers

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Request Body

The body of the request should be serialized JSON that validates against the Data Table Patch schema. For example, the following would be a valid body for this request:

{
  "name": "My Updated Data Table"
}

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X PATCH \
    -d '{"name":"My Updated Data Table"}' \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID

Successful Responses

Code	Type	Description
200	Data Table	Updated data table information

Error Responses

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if data table was not found

Remove Column

Removes a column from this data table

Method And Url

DELETE https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/column

Authentication

A valid API access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Organization, all.User, dataTable.*, or dataTable.removeColumn.

Request Path Components

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97
DATA_TABLE_ID	ID associated with the data table	575ed78e7ae143cd83dc4aab

Request Query Parameters

Name	Required	Description	Default	Example
columnName	Y	Name of the column to remove		columnName=myColumnName

Request Headers

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X DELETE \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/column?columnName=myColumnName

Successful Responses

Code	Type	Description
200	Data Table	Updated data table information

Error Responses

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if data table was not found

Schemas

Data Table

Schema for a single Data Table

Data Table Schema

▶
root:{} 3 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
properties:{} 8 keys
▶
id:{} 2 keys
▶
dataTableId:{} 2 keys
▶
applicationId:{} 2 keys
▶
creationDate:{} 2 keys
▶
lastUpdated:{} 2 keys
▶
name:{} 3 keys
▶
description:{} 2 keys
▶
columns:{} 3 keys

Data Table Example

▶
root:{} 7 keys
id:"596e6ce831761df4231708f1"
dataTableId:"596e6ce831761df4231708f1"
applicationId:"575ec8687ae143cd83dc4a97"
creationDate:"2016-06-13T04:00:00.000Z"
lastUpdated:"2016-06-13T04:00:00.000Z"
name:"My Data Table"
▶
columns:[] 2 items

Data Table Column

Schema for a single Data Table Column

Data Table Column Schema

▶
root:{} 5 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
properties:{} 4 keys
▶
name:{} 2 keys
▶
dataType:{} 2 keys
▶
constraint:{} 2 keys
▶
defaultValue:{} 1 key
▶
required:[] 3 items
additionalProperties:false

Data Table Column Example

▶
root:{} 4 keys
name:"myColumn3"
dataType:"string"
constraint:"optional"
defaultValue:"aDefault"

Data Table Patch

Schema for the body of a Data Table modification request

Data Table Patch Schema

▶
root:{} 4 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
properties:{} 2 keys
▶
name:{} 3 keys
▶
description:{} 2 keys
additionalProperties:false

Data Table Patch Example

▶
root:{} 1 key
name:"My Updated Data Table"

Error

Schema for errors returned by the API

Error Schema

▶
root:{} 3 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
properties:{} 2 keys
▶
type:{} 1 key
▶
message:{} 1 key

Error Example

▶
root:{} 2 keys
type:"NotFound"
message:"Application was not found"

Success

Schema for reporting a successful operation

Success Schema

▶
root:{} 3 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
properties:{} 1 key
▶
success:{} 2 keys

Success Example

▶
root:{} 1 key
success:true