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)
how are you identifying the workbooks not used?
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?