Shotgun as a live data source for Excel/PowerBI/etc

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”
i.e.
https://mysite.shotgunstudio.com/page/1234
to
https://mysite.shotgunstudio.com/reports/csv/1234

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.

9 Likes

Hey Stephen,

Good to hear from you! This is something that never moved beyond the prototype stage, so isn’t quite so full-featured as you’ve seen.

Be sure to share your idea with the product team via the roadmap site. More details are in this thread:

4 Likes

Submitted the feature request to the Roadmap page. Fingers-crossed!

1 Like