PicklistUpsert

Updates an existing set of picklists or inserts a new set of picklists.

Usage

Use the PicklistUpsert method to insert a set of picklists or update an existing set of picklists for an object.

The object is specified with the <ObjectName> element of apdata:PicklistSet.

The apdata:PicklistSet argument contains the following elements containing picklist data for each picklist:

• Name. The system name of the picklist field (required). When performing an insert operation, this name is used as the display name. You can use the FieldManagementRead method to obtain the system name of the picklist field.

• WebSvcTag. The Web Services v2.0 integration tag name for the picklist field. This element is read-only and is ignored in upsert operations.

• OrderAllLanguages. Whether the values in the picklist field are to be ordered alphabetically for all languages. Valid values are Y (the picklist values are to be ordered alphabetically for all languages) or N (the picklist values are to be ordered according to the values specified by <Order>).

• ListOfPicklistValues. The values for the picklist as contained in child elements of <PickListValue>:

  • ValueId. An identifier assigned to the picklist value. This element maps to the Id field in the Edit Picklist window for the picklist field in the UI. It is the language-independent name for the picklist value.

  • Disabled. Whether the picklist value is disabled.

  • ListOfValueTranslations. The picklist values in the languages activated for your company, contained in child elements of <ValueTranslation>:

    • LanguageCode. The three-letter language code for the language.

    • Value. The picklist value in the language identified by the language code.

    • Order. The order number of the picklist value according to the language identified by the language code.

      Note: <Order> is a required value. If <OrderAllLanguages> specifies Y (the picklist values are to be ordered alphabetically for all languages), then the value in <Order> is ignored. If <OrderAllLanguages> specifies N or is not specified, then the picklist values are ordered according to the values specified in <Order>.

    • Description. The description of the picklist value in the language identified by the language code.

See Oracle Migration Tool On Demand Guide for reference tables about the following:

• Mappings of three-letter language codes to languages.

• Mappings of object names to the display names for the objects in the Oracle CRM On Demand user interface.

Arguments

The following table describes the arguments taken by the PicklistUpsert method.

Table Arguments Taken by the Picklist Upsert Method

Name	Description	Required	Default	I/O
apData:PicklistSet	The picklist data to be inserted or updated.	Yes	Not applicable	Input
Status	The status of the call.	Not applicable	Not applicable	Output

Return Value of the Call

The status is returned.