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
DATATABLEID
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:
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
DATATABLEID
ID associated with the data table
575ed78e7ae143cd83dc4aab
Request Headers
Name
Required
Description
Default
Authorization
Y
The token for authenticating the request, prepended with Bearer
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
DATATABLEID
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
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
DATATABLEID
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:
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
DATATABLEID
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