Sending reports via API request

[SkinnyPigeon]

Hey folks 👋. We've had a few requests from our stakeholders about whether it would be possible to ensure our data is ready before reports are sent. Ideally, we would like to create reports with no schedule that are sent via a call to the API. This would allow us to add a task to our various data pipelines that would only trigger once the data is ready and has been tested.

The basic requirements would be:

1. New schedule option of on-demand or similar
2. New API endpoint for /api/report/{pk}/send

Is this something that has been investigated previously? I couldn't see anything in the Issues or Discussions related to it; however, I would have thought this would be a desirable feature. Potentially, I can give this a go. However, I wanted to find out first if this was something that was rejected previously or if there was another reason it was not already in place.

As always, keep up the amazing work!

[dosubot[bot]]

This feature has recently been implemented! Superset now supports on-demand/manual execution of reports via a dedicated API endpoint: /api/v1/report/{id}/execute. This endpoint allows you to trigger a report immediately through an API call, which fits your use case for integrating with data pipelines and ensuring data readiness before sending.

The implementation includes proper RBAC (role-based access control) and is also exposed in the UI as a "Trigger Now" button for manual execution. You’ll need the right permissions to use this endpoint.

If you’re looking for programmatic delivery to arbitrary endpoints, there’s also a webhook report type that lets you POST report content (CSV/PNG/PDF) to any URL.

Check your Superset version and the latest docs to confirm availability, and let me know if you need details on usage or setup!

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}    

[SkinnyPigeon]

It's not actually in production yet but looks like it's on its way