Select_fields and get_entry_list syntaxs in restful

💬 General Discussion
1

Hi all,

When I try to use [get_entry_list] with [select_fields] function. I got the error message [Bad data passed in;]. Someone can help to provide the syntax to me please.

I created the custom module in suiteCRM and success to through the API to post data in the system.

Remark: The [get_entry_list] with [query] is work for me in restful.

Hyperlink : http://localhost/appname/service/v4_1/rest.php
method=get_entry_list
input_type=JSON
response_type=JSON
rest_data={“session”:“xxxxx”,“module_name”:“XYZ_in_mscode”&“select_fields”:[‘name’,‘z_curr’]}

(http://localhost/appname/service/v4_1/rest.php?method=get_entry_list&input_type=JSON&response_type=JSON&rest_data={"session":"xxxxx","module_name":"XYZ_in_mscode"&"select_fields":['name','z_curr']})

When I execute the API [select_fields and get_entry_list], the php_errror_log file will create the message.

[08-Aug-2022 10:23:58 Europe/Berlin] PHP Fatal error:  Uncaught Exception: Database failure. Please refer to suitecrm.log for details. in D:\XAMPP\htdocs\appname\include\utils.php:1892
Stack trace:
#0 D:\XAMPP\htdocs\appname\include\database\DBManager.php(353): sugar_die('Database failur...')
#1 D:\XAMPP\htdocs\appname\include\database\DBManager.php(328): DBManager->registerError('Error running c...', 'Error running c...', true)
#2 D:\XAMPP\htdocs\appname\include\database\MysqliManager.php(179): DBManager->checkError('Error running c...', true)
#3 D:\XAMPP\htdocs\appname\data\SugarBean.php(4194): MysqliManager->query(' SELECT count(*...', true, 'Error running c...')
#4 D:\XAMPP\htdocs\appname\service\v4\SugarWebServiceUtilv4.php(120): SugarBean->process_list_query(' SELECT  zdt_in...', 0, -1, 20, 'id='4d6020ba-8b...')
#5 D:\XAMPP\htdocs\appname\service\v4\SugarWebServiceImplv4.php(311): SugarWebServiceUtilv4->get_data_list(Object(ZDT_in_mscode), NULL, 'id='4d6020ba-8b...', 0, -1, -1, false, false)
#6 D:\XAMPP\htdocs\appname\service\core\REST\SugarRestJSON.php(94) in D:\XAMPP\htdocs\appname\include\utils.php on line 1892```

suiteCRM : Version 7.11.22
Platform : Win10Pro