Rest API Search Query By Custom Fields - Module

Hello All,

I’m using Rest Request ‘get_entry_list’

with this array

    $entryArgs = array(
    'session' => $session_id,
    'module_name' => $module,
    'query' => $query,
    'order_by' => '',
    'offset' => 0,
    'select_fields' => array('id','name'),
    'link_name_to_fields_array' => array(
        array(
            'name' => 'contacts',
            'value' => array(
                'first_name',
                'last_name',
            ),
        ),
    ),
    'max_results' => 10,
    'deleted' => 0,
);

I have created a custom field in Accounts module with the name “business registration no”
And trying to use it as
accounts.business_registration_no = ‘22383833’
It always shows no record found. But there is a record in accounts module with this registration no.


And if i use it as
accounts.name = ‘Abc’
then it gives me results.

Why not working with custom fields ?

Please help.

Hello,

Can you try ?

accounts_cstm.business_registration_no_c = ‘22383833’

Because custom fields are stored in custom tables, and a table named is postfix with _cstm.

1 Like

It works :blush::blush::blush::blush:.

Thank you so much for your quick response.