API Question : delete all line items of an opportunity with one command

Hi there,

After moving to the cloud version of Sell, our (external) quotation tool provider had to redevelop the interface used between the quotation tool and Sugar Sell. When an update of the opportunity line items by the data of the quotation is needed, each line item is 'polled' and subsequently removed. After deleting all line items (can be 100 - 200 items) , the new info is sent over and the updated line items are created.

This actual approach is quite intense on interfacing, and I wonder, does the API not offer a command for removing all line items in an opportunitye as 1 single commend ?

Does anybody have any experience in this area ?

Thanks,

Hugo

0 Harald Kuske 5 months ago

As far as I know the only way to shorten this job is to collect all ids of the LineItems from the Quote and then send a

DELETE Projects/MassUpdate

with the list of all ids like

Fullscreen1
2
3
4
5
6
7
8
{
    "massupdate_params":{
        "uid":[
            "ebf22b86-94ea-1601-4f4f-512d09173438",
            "e3b71c55-d96b-80bb-1696-512d09672398"
        ]
    }
}
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
{
    "massupdate_params":{
        "uid":[
            "ebf22b86-94ea-1601-4f4f-512d09173438",
            "e3b71c55-d96b-80bb-1696-512d09672398"
        ]
    }
}

0 Ramya Katram 5 months ago

Hi Hugo,

In addition to Harald's reply, first you can use this endpoint to get all the revenue line items of the Opportunity and after getting you can use this endpoint for mass deleting the line items related to the specific opportunity in single shot.

Thanks and Regards,

Ramya Katram

www.bhea.com
0 Hugo Geyskens 4 months ago in reply to Ramya Katram

Hi Ramya and Harald,

Sorry for the late reply, but thanks for your feedback.

I'm almost finished working in 2024 ,so i'll give it a try in 2025.

Wish you all a good new year !

Bye now

Hugo