This is a Server admin and REST API question... hopefully putting it here will be OK!
I'm looking for a way to identify all workbooks not used in the last 6 months, and then to add a tag to them identifying them as such. If they're not used when I review again in 6 months time, they're heading for the great Recycle Bin in the sky...
I know I can identify the workbooks through the "readonly" postgres metadata, but then how do I add the tag? I don't think the postgres gives you the workbook-id that "PUT /api/api-version/sites/site-id/workbooks/workbook-id/tags" requires - or is it somewhere I'm just not spotting it?
Any help would be appreciated!
(Server version 10.0.1 if it makes any difference)
For now, I'll assume that you are using historical_events which yes, you're correct only has the hist_workbook_id, and not the actual workbook id. But then if you join the hist_workbook_id to the hist_workbooks table, then you should be able to find the active workbook id. Does this help?