Get Row Data By ID Column
curl --request GET \
--url https://cloudlab.scispot.io/labsheets/fetch-row-by-id \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://cloudlab.scispot.io/labsheets/fetch-row-by-id', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://cloudlab.scispot.io/labsheets/fetch-row-by-id"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text){
"headers": [
"uuid",
"Sample ID",
"Sample Name",
"Sample",
"Sample Type",
"Sample Status",
"Sample Quantity",
"Sample Units",
"Test Results",
"Test Run Sample"
],
"rows": [
[
"<uuid>",
"SMPL000001",
"Sample 1",
1,
"DNA",
"Pending",
0.001,
"mg",
null,
null
]
],
"success": true
}{
"success": false,
"message": "Invalid Authentication Token"
}{
"success": false,
"message": "Missing Authentication Token"
}{
"success": false,
"message": "Validation error"
}{
"success": false,
"message": "Operation failed"
}Labsheets (LIMS) API
Get Row Data By ID Column
Uses a value of cell in an ID or ID_BARCODE type column to retrieve the row. By default value in “id” key maps to the value for ID type column. To find rows by ID_BARCODE type (automated IDs) column instead, “idType” key has to be set to “ID_BARCODE” in the payload.
GET
https://cloudlab.scispot.io
/
labsheets
/
fetch-row-by-id
Get Row Data By ID Column
curl --request GET \
--url https://cloudlab.scispot.io/labsheets/fetch-row-by-id \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://cloudlab.scispot.io/labsheets/fetch-row-by-id', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://cloudlab.scispot.io/labsheets/fetch-row-by-id"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text){
"headers": [
"uuid",
"Sample ID",
"Sample Name",
"Sample",
"Sample Type",
"Sample Status",
"Sample Quantity",
"Sample Units",
"Test Results",
"Test Run Sample"
],
"rows": [
[
"<uuid>",
"SMPL000001",
"Sample 1",
1,
"DNA",
"Pending",
0.001,
"mg",
null,
null
]
],
"success": true
}{
"success": false,
"message": "Invalid Authentication Token"
}{
"success": false,
"message": "Missing Authentication Token"
}{
"success": false,
"message": "Validation error"
}{
"success": false,
"message": "Operation failed"
}Authorizations
Personal access token from Scispot Account → Personal Tokens
Query Parameters
The name of the selected labsheet
Example:
"Sample Manager"
Value in the ID or ID_BARCODE column of the row to be fetched
Example:
"SMPL000001"
(Optional) The type of the ID column to be fetched. Possible values: "ID" or "ID_BARCODE" (defaults to "ID" if not provided)
Example:
"ID_BARCODE"
⌘I
