Files
Introduction
There are plans to implement a calendar view for FME Flow schedules, but we are still working on improving this functionality before we release it. In the meantime, Philippe Blackburn Gravel from the City of Repentigny has developed a workspace that creates an Excel Spreadsheet where you can see all of the schedules on FME Flow, as well as shows you open time in the schedule where you could potentially plan downtime for upgrades or add CPU intensive workspaces. This method will also continue to be useful once we release our schedule viewer, as you can share the Excel spreadsheet with whoever may need to find a time slot.
Overview
This workspace utilizes the FME Flow REST API to retrieve the schedules and, based on how the schedule was set up, then either the time or the CRON expression is extracted. After some attribute manipulation, the data is output to Microsoft Excel.
To run the attached workspace, you will need to create an API token in FME Flow that has access to Schedules. By default, token expiration is set to the end of the day, so change the expiration date to a day that suits you. Ensure to enable Access to Schedules in the permissions and also open the dropdown to expand the list of schedules and press 'Select All' to ensure the token has Full Access to each schedule.
Once the API token has been created, open the workspace in FME Workbench, then run the workspace with Prompt. In the prompt, enter your FME Flow URL and the token. Then browse to a location to save the Excel spreadsheet.
Run the workspace, then view the output in Microsoft Excel.
Output
The Time worksheet lists the name of the schedule, how often the schedule reoccurs, the time it starts, and if it is enabled.
The Week worksheet provides an overview of the week which shows where there would be gaps in the schedules. The FME Flow instance shown in this demo isn’t very busy, but if we were planning downtime for an upgrade, then it looks like the most optimal time would either be a Tuesday or Wednesday, as the schedules on those days are disabled, or over the weekend.
Additional Resources
Tutorial: Getting Started with the FME Flow REST API
Tutorial: Getting Started with Microsoft Excel
Webinar: How to Connect to Any REST API with No-Code