Update Row Data By ID Column
curl --request POST \
--url https://cloudlab.scispot.io/labsheets/update-rows-by-id \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"labsheet": "Sample Manager",
"rows": [
{
"ID": "SMPL000001",
"Sample Name": "Sample 1",
"Sample #": 1,
"Sample Type": "DNA",
"Sample Status": "Completed",
"Sample Quantity": 0.002,
"Sample Units": "mg",
"Test Results": "",
"Test Run Sample": ""
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
labsheet: 'Sample Manager',
rows: [
{
ID: 'SMPL000001',
'Sample Name': 'Sample 1',
'Sample #': 1,
'Sample Type': 'DNA',
'Sample Status': 'Completed',
'Sample Quantity': 0.002,
'Sample Units': 'mg',
'Test Results': '',
'Test Run Sample': ''
}
]
})
};
fetch('https://cloudlab.scispot.io/labsheets/update-rows-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/update-rows-by-id"
payload = {
"labsheet": "Sample Manager",
"rows": [
{
"ID": "SMPL000001",
"Sample Name": "Sample 1",
"Sample #": 1,
"Sample Type": "DNA",
"Sample Status": "Completed",
"Sample Quantity": 0.002,
"Sample Units": "mg",
"Test Results": "",
"Test Run Sample": ""
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)[
{
"ID": "SMPL000001",
"updatedRows": [
{
"uuid": "<uuid>",
"success": "true"
}
]
}
]{
"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
Update Row Data By ID Column
Update individual row values by matching indexes with an “ID” or “ID_BARCODE” column in a labsheet. A column with type “ID” or “ID_BARCODE” must be included in the labsheet to use this endpoint.
Note that row uuids used in other endpoints are entirely different than their “ID” and “ID_BARCODE” column values. Uuids are randomly generated unlike values in the “ID” column or “ID_BARCODE” column.
POST
https://cloudlab.scispot.io
/
labsheets
/
update-rows-by-id
Update Row Data By ID Column
curl --request POST \
--url https://cloudlab.scispot.io/labsheets/update-rows-by-id \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"labsheet": "Sample Manager",
"rows": [
{
"ID": "SMPL000001",
"Sample Name": "Sample 1",
"Sample #": 1,
"Sample Type": "DNA",
"Sample Status": "Completed",
"Sample Quantity": 0.002,
"Sample Units": "mg",
"Test Results": "",
"Test Run Sample": ""
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
labsheet: 'Sample Manager',
rows: [
{
ID: 'SMPL000001',
'Sample Name': 'Sample 1',
'Sample #': 1,
'Sample Type': 'DNA',
'Sample Status': 'Completed',
'Sample Quantity': 0.002,
'Sample Units': 'mg',
'Test Results': '',
'Test Run Sample': ''
}
]
})
};
fetch('https://cloudlab.scispot.io/labsheets/update-rows-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/update-rows-by-id"
payload = {
"labsheet": "Sample Manager",
"rows": [
{
"ID": "SMPL000001",
"Sample Name": "Sample 1",
"Sample #": 1,
"Sample Type": "DNA",
"Sample Status": "Completed",
"Sample Quantity": 0.002,
"Sample Units": "mg",
"Test Results": "",
"Test Run Sample": ""
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)[
{
"ID": "SMPL000001",
"updatedRows": [
{
"uuid": "<uuid>",
"success": "true"
}
]
}
]{
"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"
}⌘I
