ULM: Custom Field Formatting
ULM Update
If you have jobs that are using this API to update schemas, tables, file systems, and etc. this API will still work, but it is not be as performant as the new Custom Field Values Overview. This API is recommend for modifying articles.
The value for custom field depends on the type of custom field for the Upload Logical Metadata API.
NOTE: The custom field name in the request should be its singular name.
Object Set or Reference Custom Field
Following is the format for custom fields that belong to object sets and references.
{"<custom_field_name>": [{"type":"<otype>", "key":"<key>"}]}
<otype> and <key> could be any of the following
| <otype> | Description | <key> |
|---|---|---|
| data | Represents a data source | <datasource_id> Example: {"related_ds":[{"type":"data", "key":"1"}]} |
| schema | Represents a schema | <datasource_id>.<schema_name> Example: {"related_schema":[{"type":"schema", "key":"1.emp_schema"}]} |
| table | Represents a table | <datasource_id>.<schema_name>.<table_name> Example: {"related_table":[{"type":"table", "key":"1.emp_schema.employee"}]} |
| attribute | Represents a column | <datasource_id>.<schema_name>.<table_name>.<column_name> Example:{"foreign_key":[{"type":"attribute", "key":"1.emp_schema.department.dept_id"}]} |
| article | Represents an article | <article_title> Example: {"related_article":[{"type":"article", "key":"Employee Salary Ranges"}]} |
| user | Represents a user | <email_address> Example: {"Steward":[{"type":"user", "key":"[email protected]"}]} |
| groupprofile | Represents a user group | <group_name> Example: {"Steward":[{"type":"groupprofile", "key":"test-users"}]} |
People Set Custom Field
Following is the format for people set custom field.
{"<custom_field_name>": [{"type":"<otype>", "key":"<key>"}]}
<otype> and <key> could be any of the following
| <otype> | Description | <key> |
|---|---|---|
| user | Represents a user | <email_address> Example: {"Steward":[{"type":"user", "key":"[email protected]"}]} |
| groupprofile | Represents a user group | <group_name> Example: {"Steward":[{"type":"groupprofile", "key":"test-users"}]} |
You can use the User Overview API to get their email addresses.
Picker Custom Field
Following is the format for a picker field
{"<custom_field_name>": "<picker_value>"}
<picker_value> is one of the options specified for the picker field.
For Example:
{"Salary Range": "20000"}
Multi Picker Custom Field
Following is the format for a multi picker field
{"<custom_field_name>": ["<multi_picker_value1>","<multi_picker_value2>","<multi_picker_value3>"...]}
NOTE: The value of multi picker field is a list of values, each value in the list is separated by ,.
<multi_picker_value> is one value of selected options specified for the multi picker field.
For Example:
{"Role": ["Engineer","Sales","Database Analyst"]}
Rich Text Custom Field
Following is the format for a rich text field
{"<custom_field_name>": "<rich_text_html_value>"}
<rich_text_html_value> is the value of the rich text custom field. This value can have HTML tags. Please check the HTML Sanitization guide for which HTML tags are allowed.
For Example:
{"Related External Links": "<p>Here is one:<br><a>http://myexample</a></p>"}
Date Custom Field
Following is the format for a date field
{"<custom_field_name>": "<date>"}
<date_value> is the date set for a date field. Value could be in any of standard date formats:
DD-MM-YY or
YYYY-MM-DD or
Month Day Year or
DD/MM/YYYY
Example:
{"Employee Joining Date": "May 1 2017"}
Updated 9 months ago