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",
{
"Sample Type": "DNA"
},
{
"Sample Status": "Completed"
},
{
"Sample Quantity": 0.002
},
{
"Sample Units": "mg"
},
{
"Test Results": null
},
{
"Test Run Sample": null
}
]
}
'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',
{'Sample Type': 'DNA'},
{'Sample Status': 'Completed'},
{'Sample Quantity': 0.002},
{'Sample Units': 'mg'},
{'Test Results': null},
{'Test Run Sample': null}
]
})
};
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", { "Sample Type": "DNA" }, { "Sample Status": "Completed" }, { "Sample Quantity": 0.002 }, { "Sample Units": "mg" }, { "Test Results": None }, { "Test Run Sample": None }]
}
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",
{
"Sample Type": "DNA"
},
{
"Sample Status": "Completed"
},
{
"Sample Quantity": 0.002
},
{
"Sample Units": "mg"
},
{
"Test Results": null
},
{
"Test Run Sample": null
}
]
}
'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',
{'Sample Type': 'DNA'},
{'Sample Status': 'Completed'},
{'Sample Quantity': 0.002},
{'Sample Units': 'mg'},
{'Test Results': null},
{'Test Run Sample': null}
]
})
};
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", { "Sample Type": "DNA" }, { "Sample Status": "Completed" }, { "Sample Quantity": 0.002 }, { "Sample Units": "mg" }, { "Test Results": None }, { "Test Run Sample": None }]
}
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
