Assigning A Custom Field Picklist Value Via API

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:
  1. {\"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:
  1. {\"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:
  1.  ("UDF_CHAR16", xxx701) // using picklist id
  2. ("UDF_CHAR16", "xxx701")
  3.  ("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






                        Zoho Marketing Automation
                                • 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


                                Manage your brands on social media



                                        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

                                                                • CRM Community Learning Series

                                                                  CRM Community Learning Series


                                                                • Tips

                                                                  Tips

                                                                • Functions

                                                                  Functions

                                                                • Meetups

                                                                  Meetups

                                                                • Kbase

                                                                  Kbase

                                                                • Resources

                                                                  Resources

                                                                • Digest

                                                                  Digest

                                                                • CRM Marketplace

                                                                  CRM Marketplace

                                                                • MVP Corner

                                                                  MVP Corner

                                                                • Word of the Day

                                                                  Word of the Day


                                                                      Design. Discuss. Deliver.

                                                                      Create visually engaging stories with Zoho Show.

                                                                      Get Started Now