create custom field in sugarcrm database and get that value using REST

Aravinth,

Since this field was created directly in the database, it is possible that there are missing components that are required by Sugar.  When a field is created via Studio, a vardef file is created on the file system, along with the field being created in the [module]_cstm table and fields_meta_data table within the database.

If you create the field via Studio, the REST call should return results.

For reference, here is a link to developer guide that walks you through manually creating a field.

You can also review this document on creating fields in Studio.

Hope this helps,

Lori

Thank you so much for your reply. I just created the field directly in database(is that good or not).For accessing this value in REST call, modified the cache/module/module-name/vardefs solved the issue.

How to update the custom field (created using studio) using REST api.

Aravinth,

I am not sure if this page will help, but thought I would pass it along.  The page contains several examples of creating and updating records using REST.

Kind Regards,

Lori Arce

Thanks for you reply. Reference page doesn't have any samples like that but i am able to update the custom field using REST.

Thanks.

Hi Aravinth..

Try this

$get_entry_parameters = array(

     'session' => $session_id,

     'module_name' => "Users",

     'id' => "XXXX",

     'select_fields' => array(

          'my_custom_field_c',

     ),

    );

    $get_entry_result = call("get_entry", $get_entry_parameters, $url);

    $pre_msg = $get_entry_result->entry_list[0]->name_value_list->my_custom_field_c->value;

my_custom_field_c

Hi Mehul Bhandari

Thanks for your reply, already find solution in sugarcrm rest api example.

How does one make such changes like this if running a cloud service?

We updated a field to include some more choices/options but when trying to create records via rest, the custom options are not inserted. Only the pre-existing options work with the REST client...