Insert LineItem in an Opportunity with Apex

Question

I am trying to add an OpportunityLineItem to an Opportunity and having some challenge with PricebookEntry.

Here is my Apex function:

public static void saveRecord(List recList3){

List<PricebookEntry> pbes = [SELECT Id, PriceBook2Id, Product2Id, Product2.Id, Product2.Name FROM PriceBookEntry WHERE Product2Id IN: recList3 AND PriceBook2.isActive=true LIMIT 1];

    for(Integer y = 0, aValue = recList3.size(); y < aValue; y++){
        OpportunityLineItem oli = recList3[y];
        oli.PriceBookEntryId = pbes.Id;
    }
   
    insert recList3;
}

My Apex function receives a List of OpportunityLineItems Object like this:

[{"Name":"ProductXYZ","OpportunityId":"0068A000009sx4UQAQ","Product2Id":"01t6g000000R2L4AAK","Quantity":"1","UnitPrice":"1"}]

What I need is to go through my OpportunityLineItems List, do a SOQL to find the PricebookEntryId that matches the Product2Id and add it to recList3.

I have 2 errors: -Invalid bind expression type of OpportunityLineItem does not match domain of foreign key -Variable does not exist: Id

Thanks for helping me

Answer 1

You are correct, before you can add OpportunityLineItems, you need to assign a value to Opportunity.Pricebook2Id. The Salesforce UX does this all for you behind the scenes when you add Opportunity products (because the dialog prompts you for the Pricebook)

But, if you are doing this in Apex, then you have to do the steps manually, 1x1

Opportunity o = new Opportunity(Name = 'xx',
                                Stagename = 'ss',
                                CloseDate = Date.today(),
                                Pricebook2Id = thePricebook2Id
                               );
 insert o;

 OpportunityLineItem oli = new OpportunityLineItem(
                                  OpportunityId = o.Id,
                                  Quantity = qty,
                                  PricebookEntryId = thePricebookEntryId
                                 );
 insert oli;

where thePricebookEntryId is the ID of the junction record (PricebookEntry) that links the PriceBook2 corresponding to the Opportunity's Pricebook2Id and the Product2 (for the SKU of the OpportunityLineItem)