How can we get all the deleted records since a given Timeframe?
Hello Cho Zan,
You need to create entry point and fire select query there and get the deleted record.
Query Like : select <fields_name> from <table_name> where deleted=1 and <set time frame field>
Can you please suggest how to do it via API Call?
Please specify which API you would prefer SOAP or REST, and what version. This will be dictated by the version of Sugar you are on.
I am looking a for a way using REST V10 APIs where I want to get the list of DELETED contacts and leads from a specific prospect list. Can you please suggest me an API way here?
Hi Nilesh Shah,
To my knowledge the API only returns records that are not deleted as per the default functionality when using Sugar as a User, as when you do stuff like getting data here it does API calls just like you are trying to do. Because of this I think you would need to make a custom API endpoint to handle this, with the below being a link to a developer blog that shows a working example of this.
SugarCRM Cookbook – Adding a REST endpoint « Sugar Developer Blog – SugarCRM
Alternatively if you are on the Enterprise or Ultimate version of Sugar then you can create an Advanced Report which allows database queries to be performed (SELECT queries only) with these results being able to be exported to CSV.
I hope this helps.
Retrieving data ...