SonkeGumede
3 years agoQrew Member
Update lookup filed with Quickbase JSON RESTful API
Hi everyone,
I'm struggling to update a lookup field, I couldn't find any information about updating look up fields via JSON RESTful API, however, API_EditRecord works, here is my payload:
I'm struggling to update a lookup field, I couldn't find any information about updating look up fields via JSON RESTful API, however, API_EditRecord works, here is my payload:
{
"to": "tableid",
"data": [
{
"3":{
"value":12
},
"11":{
"value": 4
}
}
]
}
fid 3 is my Record ID which is equal to 12.
fid 11 is my lookup field (with Drop down list from a child table).
I'm getting this error:
{
"data": [],
"metadata": {
"createdRecordIds": [],
"lineErrors": {
"1": [
"Can not change the value of the lookup field with ID \"11\"."
]
},
"totalNumberOfRecordsProcessed": 1,
"unchangedRecordIds": [],
"updatedRecordIds": []
}
}
------------------------------
Sonke Gumede
------------------------------