Value Lists with REST API

Value Lists with REST API

SaveToDB 10 allows configuring REST API services in a database as shown in Getting Data Using REST API and Saving Data Using REST API.

In short, the configuration looks like this:

IDTABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_OBJECTUPDATE_OBJECTDELETE_OBJECT
 ZohoCRMContactsHTTPhttps://www.zohoapis.com/crm/v2/ContactsPOST {$url}

{"data":[{@json_row_values}]}
PUT {$url}/{id}

{"data":[{@json_row_values}]}
DELETE {$url}/{id}

The configured ZohoCRM.Contacts object has the same configuration features as other native database objects.

So, developers can configure value lists using the xls.handlers table.

Moreover, you can mix fixed values, values from a database, and values from the underlying data service.

Here is a sample:

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMEEVENT_NAMEHANDLER_SCHEMAHANDLER_NAMEHANDLER_TYPEHANDLER_CODE
 ZohoCRMContactsSalutationValidationListVALUES-None-,Mr.,Mrs.,Dr.,Prof.
 ZohoCRMContactsLead_SourceValidationListZohoCRMxl_list_lead_sourcesVIEW
 ZohoCRMContactsAccount_NameValidationListZohoCRMxl_list_account_namesHTTP<HTTP request>

Where the HTTP request looks like

https://www.zohoapis.com/crm/v2/Accounts?fields=Account_Name

Creating such configurations can be time-consuming.

We recommend loading service metadata using the SELECT queries described in the HTTP Commands topic.

Doing this way, you can select the required columns only in the right order to copy data easily.