Assigning A Custom Field Picklist Value Via API
Hey everyone,
I have a project that has a custom layout with custom fields (shocker). I can update simple custom fields just fine, however a handful of these fields are Picklists, of which I seemingly cannot assign values to through the API. I've tried strings, longs, Zoho User Ids, Picklist_ids, none of which seem to take.
Using the GetLayoutDetails, I see information like this:
- {\"cfid\":\"xxx401\",\"is_associated\":true,\"picklist_id\":\"xxx701\",\"sequence\":21,\"value\":\"TEST VALUE\"},
Which is think is linked up to a pick list like this:
- {\"is_associated\":true,\"is_removable\":true,\"is_encrypted\":false,\"is_custom_edit\":false,\"column_name\":\"UDF_CHAR16\",\"description\":\"\",\"is_editable\":true,\"is_default_field\":false,\"is_resolution\":false,\"display_name\":\"Existing Architects\",\"is_default\":false,\"table_name\":\"ProjCustomFieldsValue\",\"is_default_unassociated\":false,\"is_mandatable\":true,\"cfid\":\"xxx401\",\"is_editform_only\":false,\"is_pii\":false,\"field_type_integer\":2,\"data_type\":\"CHAR\",\"data_type_integer\":0,\"field_type\":\"picklist\"}
And I've tried to update the value in a few ways:
- ("UDF_CHAR16", xxx701) // using picklist id
- ("UDF_CHAR16", "xxx701")
- ("UDF_CHAR16", "TEST VALUE") // using picklist value
I can't seem to find documentation about picklists and what they're expecting to get via the API, apart from them being a custom field. Picklists seem to have a cfid, picklistid, sequence, value, and is_associated fields, but I don't understand how they're associated with other values.
Same with user_picklists.
What am I missing here? Thanks,
Lee
Sticky Posts
Announcing the Zoho Projects API
Today we're excited to announce the API for Zoho Projects where any developer can extend the project management and collaboration capabilities through our APIs and can build their own customized applications for their business needs. We've tried to make the API follow the REST (Representational State Transfer) principles and generate a XML/ JSON object which allows you to access / read / write Zoho Projects data from third-party systems like Google/Yahoo gadgets, web sites, billing & invoicing systems,
Have you moved to REST API?
Dear API Users, The Documentation of our Rest API is available here . All future development will be done to this version. We are deprecating the older API today. Its documentation will no longer be available and we will also be stopping the calls to this API soon. Thanks, Prasanna
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Desk Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.