update Business Opportunity table once opportunity is closed

Hi Team,

I am a beginner in Custom event and would like an example on how can I update a field inside the Business Opportunity table (source Id for example) once the opportunity is closed .

I believe I must use BUSINESS_OPPORTUNITY_API.Modify_ but not sure of the syntax/ code inside the Execute Online Sql custom event.

Thanks