Update Rows By UUID
curl --request POST \
--url https://cloudlab.scispot.io/labsheets/update-rows-by-uuid \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"labsheet": "Sample Manager",
"rows": [
{
"uuid": "<uuid>",
"Sample Status": "Completed",
"Sample Quantity": ".002"
},
{
"uuid": "<uuid>",
"Sample Status": "Invalid Input",
"Sample Quantity": ".002"
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
labsheet: 'Sample Manager',
rows: [
{uuid: '<uuid>', 'Sample Status': 'Completed', 'Sample Quantity': '.002'},
{uuid: '<uuid>', 'Sample Status': 'Invalid Input', 'Sample Quantity': '.002'}
]
})
};
fetch('https://cloudlab.scispot.io/labsheets/update-rows-by-uuid', 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-uuid"
payload = {
"labsheet": "Sample Manager",
"rows": [
{
"uuid": "<uuid>",
"Sample Status": "Completed",
"Sample Quantity": ".002"
},
{
"uuid": "<uuid>",
"Sample Status": "Invalid Input",
"Sample Quantity": ".002"
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)[
{
"uuid": "<uuid>",
"success": "true"
},
{
"uuid": "<uuid>",
"success": "false",
"message": "the option Invalid Input is invalid"
}
]{
"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 Rows By UUID
Update individual columns on one or more existing rows, identified by each row’s uuid.
Each entry in rows supplies the row uuid and the column names to change. Only the
columns you send are updated. Omitted columns keep their current values, including dates,
connections, and references. This works on labsheets that have no ID or ID_BARCODE column.
The uuid key selects the row. It is not written as a column value, including when the
labsheet has a column named uuid. Unknown column names are ignored. Use the Get Row Data
endpoint to look up row uuids. A row that fails validation is returned with success set
to false and a message, and the other rows in the request are still updated.
POST
https://cloudlab.scispot.io
/
labsheets
/
update-rows-by-uuid
Update Rows By UUID
curl --request POST \
--url https://cloudlab.scispot.io/labsheets/update-rows-by-uuid \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"labsheet": "Sample Manager",
"rows": [
{
"uuid": "<uuid>",
"Sample Status": "Completed",
"Sample Quantity": ".002"
},
{
"uuid": "<uuid>",
"Sample Status": "Invalid Input",
"Sample Quantity": ".002"
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
labsheet: 'Sample Manager',
rows: [
{uuid: '<uuid>', 'Sample Status': 'Completed', 'Sample Quantity': '.002'},
{uuid: '<uuid>', 'Sample Status': 'Invalid Input', 'Sample Quantity': '.002'}
]
})
};
fetch('https://cloudlab.scispot.io/labsheets/update-rows-by-uuid', 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-uuid"
payload = {
"labsheet": "Sample Manager",
"rows": [
{
"uuid": "<uuid>",
"Sample Status": "Completed",
"Sample Quantity": ".002"
},
{
"uuid": "<uuid>",
"Sample Status": "Invalid Input",
"Sample Quantity": ".002"
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)[
{
"uuid": "<uuid>",
"success": "true"
},
{
"uuid": "<uuid>",
"success": "false",
"message": "the option Invalid Input is invalid"
}
]{
"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
Body
application/json
⌘I
