API update of custom field with type 'Linked to Database'

Question

Does anyone know if it's possible set the value of a folder / project custom field that is linked to a database using the API?

I have attempted using both the 'display value' of the database record and the actual record ID (looked up using the DataHub API) and in both cases the API returns the following error:

{"errorDescription":"Parameter 'customFields' value is invalid","error":"invalid_parameter"}

Thanks in advance 😊

Rohan V · Answer

Hey @Zak Pring, welcome to the Community! 🙌

Thanks for taking the time to share this answer. It will definitely be helpful to other community members! 😁

Zak Pring · Answer

I can answer the question myself now (thanks to a Wrike support request!).

It turns out the value needs to be the record ID (as expected), but specified as a string array e.g.

{    
  "customFields": [        
    { "id": "IEAEUFOFJUAJCARN", "value": "[\"RE1987042\"]" }    
  ]
}

Hopefully useful to others with the same issue 👍️