Delete multiple data

Hi,

Can anyone suggest me a solution about how do i delete multiple data using sugarcrm API?

i.e.

I have a user who have multiple licenses, I want to delete all his licenses at a time on the basis of its user id

How do I do that?

Parents

0 Francesca Shiekh 10 days ago

Good morning Rana,

In response to your direct message, I am sorry, I don't have a code snippet ready to share with you but this should help.

Your script can loop through your list of IDs and mark each one as deleted as follows:

Fetch your user's record SugarBean using the "retrieveBean" and the user's id

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.0/Data_Framework/Models/BeanFactory/

use the relationship to the licenses to get the related licenses' ids:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Data_Framework/Models/SugarBean/#Fetching_Related_Record_IDs

And delete each one using the DELETE api explained here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Integration/Web_Services/REST_API/Endpoints/modulerecord_DELETE/

In general, you can find a number of examples in curl or PHP starting here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Cookbook/Web_Services/REST_API/

If you want to do all the Deletes in a single API call try using the BULK POST for your Deletes:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Integration/Web_Services/REST_API/Endpoints/bulk_POST/index.html

I hope this gives you a good starting point.

FrancescaS
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 Francesca Shiekh 10 days ago

Good morning Rana,

In response to your direct message, I am sorry, I don't have a code snippet ready to share with you but this should help.

Your script can loop through your list of IDs and mark each one as deleted as follows:

Fetch your user's record SugarBean using the "retrieveBean" and the user's id

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.0/Data_Framework/Models/BeanFactory/

use the relationship to the licenses to get the related licenses' ids:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Data_Framework/Models/SugarBean/#Fetching_Related_Record_IDs

And delete each one using the DELETE api explained here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Integration/Web_Services/REST_API/Endpoints/modulerecord_DELETE/

In general, you can find a number of examples in curl or PHP starting here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Cookbook/Web_Services/REST_API/

If you want to do all the Deletes in a single API call try using the BULK POST for your Deletes:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.2/Integration/Web_Services/REST_API/Endpoints/bulk_POST/index.html

I hope this gives you a good starting point.

FrancescaS
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

No Data