Hi,

To enhance your Odoo subscription webhook integration by including additional details such as the last invoice ID, subscription status, and current period end, you can utilize Odoo's built-in automation features.

Create a New Automated Action:

Navigate to Settings > Technical > Automation > Automated Actions.

Click on Create to define a new automated action.

Model: Select Subscription.

Trigger: Choose On Update to capture changes in subscription records.

Action To Do: Select Execute Python Code.

Python Code: Use the following script to compile the necessary subscription details:

subscription = record

last_invoice = subscription.recurring_invoice_ids.sorted('id')[-1] if subscription.recurring_invoice_ids else None

payload = {

    "subscription_id": subscription.id,

    "next_invoice_date": subscription.recurring_next_date,

    "current_period_end": getattr(subscription, 'recurring_next_date_end', None),

    "last_invoice_id": last_invoice.id if last_invoice else None,

    "last_invoice_name": last_invoice.name if last_invoice else None,

    "status": subscription.state

}

# Send the payload to your external system's webhook URL

Refer:

1. https://www.odoo.com/documentation/19.0/applications/studio/automated_actions/webhooks.html

Detailed information on setting up webhooks in Odoo

2. https://www.odoo.com/documentation/19.0/applications/studio/automated_actions.html

Automation rules — Odoo 19.0 documentation: Learn how to automate actions in Odoo, including sending data to external systems via webhooks

Hope it helps.