It would be very useful to have Shotgun pages available as live data sources for programs like Excel/PowerBI to read directly, rather than using manual “Export All to CSV (Excel)”.
This is partially possible through the unsupported feature of renaming a page URL from “page” to “reports/csv”
The resulting URL can be used as a Web Data Source in Excel/PowerBI. Yay!
BUT the resulting data does not include any linked fields (e.g. for a list of Tasks, the Status of the Link entity) unlike using “Export All to CSV (Excel)” on a page.
Overall, this feature request is for a supported way to use Shotgun as a Live Data Source in other software packages.