Fetch List of Labsheet Rows
curl --request GET \
--url https://cloudlab.scispot.io/labsheets/fetch-list-rows \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://cloudlab.scispot.io/labsheets/fetch-list-rows', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://cloudlab.scispot.io/labsheets/fetch-list-rows"
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,
[
"<uuid>",
"SMPL000002",
"Sample 2",
2,
"DNA",
"Pending",
0.002,
"mg",
null,
null
]
]
],
"total": 2,
"success": "true"
}{
"success": false,
"message": "Bad request"
}{
"success": false,
"message": "Invalid Authentication Token"
}{
"success": false,
"message": "Missing Authentication Token"
}{
"success": false,
"message": "Not found"
}{
"success": false,
"message": "Validation error"
}{
"success": false,
"message": "Operation failed"
}Labsheets (LIMS) API
Fetch List of Labsheet Rows
Pagination constraints: pageSize must be at most 1000, and page multiplied by pageSize must be less than 50000. Violations return HTTP 400 with a plain string message.
GET
https://cloudlab.scispot.io
/
labsheets
/
fetch-list-rows
Fetch List of Labsheet Rows
curl --request GET \
--url https://cloudlab.scispot.io/labsheets/fetch-list-rows \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://cloudlab.scispot.io/labsheets/fetch-list-rows', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://cloudlab.scispot.io/labsheets/fetch-list-rows"
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,
[
"<uuid>",
"SMPL000002",
"Sample 2",
2,
"DNA",
"Pending",
0.002,
"mg",
null,
null
]
]
],
"total": 2,
"success": "true"
}{
"success": false,
"message": "Bad request"
}{
"success": false,
"message": "Invalid Authentication Token"
}{
"success": false,
"message": "Missing Authentication Token"
}{
"success": false,
"message": "Not found"
}{
"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"
Number of rows to be fetched (defaults to 5 if not specified)
Example:
10
The page number of rows to be fetched indexed from 1, where a page is a set of rows of size pageSize. (setting pageSize as "10" and page as "2"will fetch rows 11-20) (defaults to 1 if not specified)
Example:
1
(Optional) Whether to filter out archived or unarchived rows. Possible values: "archived", "unarchived", "any" (defaults to "any" if not provided)
Example:
"any"
⌘I
