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

            Zoho Pagesense Resources

              Zoho SalesIQ Resources



                    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

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now