Forum Discussion

SonkeGumede's avatar
SonkeGumede
Qrew Member
3 years ago

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:

{
  "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
------------------------------

No RepliesBe the first to reply