Data Table Row Actions

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

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

Delete

Deletes a data table row

Method And Url

DELETE https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/rows/ROW_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, dataTableRow.*, or dataTableRow.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
ROW_ID	ID associated with the data table row	596f832b128eda5cfe765443

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/rows/ROW_ID

Successful Responses

Code	Type	Description
200	Success	If data table row was successfully deleted

Error Responses

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

Get

Retrieves the data table row

Method And Url

GET https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/rows/ROW_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.read, all.Organization, all.Organization.read, all.User, all.User.read, dataTableRow.*, or dataTableRow.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
ROW_ID	ID associated with the data table row	596f832b128eda5cfe765443

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/rows/ROW_ID

Successful Responses

Code	Type	Description
200	Data Table Row	Data table row information

Error Responses

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

Patch

Updates the data table row

Method And Url

PATCH https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/rows/ROW_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, dataTableRow.*, or dataTableRow.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
ROW_ID	ID associated with the data table row	596f832b128eda5cfe765443

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 Row Insert Update schema. For example, the following would be a valid body for this request:

{
  "myColumn1": "myValue"
}

Curl Example

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X PATCH \
    -d '{"myColumn1":"myValue"}' \
    https://api.losant.com/applications/APPLICATION_ID/data-tables/DATA_TABLE_ID/rows/ROW_ID

Successful Responses

Code	Type	Description
200	Data Table Row	Updated data table row information

Error Responses

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

Schemas

Data Table Row

Schema for a single Data Table Row

Data Table Row Schema

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

Data Table Row Example

▶
root:{} 5 keys
id:"596fbb703fc088453872e609"
creationDate:"2016-06-13T04:00:00.000Z"
lastUpdated:"2016-06-13T04:00:00.000Z"
myColumn1:"myValue"
myColumn2:5

Data Table Row Insert Update

Schema for inserting or updating a data table row

Data Table Row Insert Update Schema

▶
root:{} 4 keys
$schema:"http://json-schema.org/draft-07/schema#"
type:"object"
▶
patternProperties:{} 1 key
additionalProperties:false

Data Table Row Insert Update Example

▶
root:{} 1 key
myColumn1:"myValue"

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