How to use the Sugar API to retrieve data from a user table

Question

I want to get records just like mysql query using REST API for Sugar CRM.

I found a method to get forms for custom modules, as shown below. Get a list of entries from the SugarCRM module using the REST API: http://scriptbaker.com/get-list-of-records-from-sugarcrm-module-using-api/

My problem is that I do not have a module with a table in which I am trying to get records. Is there any way.

Answer 1

It is not possible to retrieve data from a table that is not really a module. The table does not exist in SugarCRM models and configurations, so the API cannot access it.

You can create a separate file to retrieve data from a table using the dbSugarCRM object.

If you give me more detailed information, I can prepare such a file for you.