As Solution Architect / Model builder, I would like to be able to create a "connection" in CloudWorks Anaplan using a webservice managed by Anaplan which automatically updates in the backend a file that contains the periodically updated CurrentTimestamp in UTC (something like "2021-02-01T14:10:45").
I will know this will be solved if I can build an "integration" in CloudWorks and schedule it every hour to update a cell with the CurrentTimestamp in my Anaplan model.
This will finally solve the lacking of a function in Anaplan which returns the Current Date or Current Timestamp, without involving any other third-party applications.
Currently, the workaround to have in Anaplan the Current Date / CurrentTimestamp is to create an external scheduled task that updates a cell in system module from an Anaplan model with this information. To build this, it is needed an external on-premise machine (or other thrid-party integration REST API tool) from which it is triggered this scheduled task action.
If Anaplan would make available this CurrentTimestamp file automatically updated and to give access to this file using CloudWorks, it will not be necessary to involve any other third-party tools in order to build this workaround.
It is acceptable also that this CurrentTimestamp to be not every second updated....but only every 30mins/1hour. However, it will give enough information for 99.99999% of the cases where CurrentTimestamp is needed in Anaplan.
Currently, the only service available in CloudWorks is "Amazon S3" and to have a file updated with the CurrentTimestamp in "Amazon S3" it is needed other third-party tools...this is why, in my opinion, will be needed that Anaplan to create some Anaplan proprietary Webservice and give access to everyone in order to make this work.
What do you think?
Alex