yes. All you have to do is have your script send the data like today's date and check it againsts your web portal its http call and you should get a yes holiday or no or similar response.
Based on that you can continue you ICM script accordingly.
Please rate helpful posts.
You can set up a DB lookup to a DB that gets updated via the web. Or an app gateway. Basically, there's a lot of different ways to do what you're trying to accomplish.
As David said, there are two ways:
1. The built-in DBLookup node which can run a simple query against a MS SQL database. Quite easy to set up. The data will be in a SQL database and YOU would have to build an out-of-band system (a Web service) to alter the database. ICM would know nothing of this process - ICM only reads the DB.
The DBLookup node can be in an Admin Script that runs once a day (say at 1am) and sets a global variable that the routing script looks at.
2. Integrate an Application Gateway. This is a very serious integration that costs money and you need a development contract with Cisco to get the specifications (GED).
You can adopt 1 in two phases. Phase 1 is to build in the DBLookup, where the information is in the database but the only way to change it is with a SQL update. Phase 2 is to add the Web service.
The return on this is extremely low and to be frank, makes little sense to me.
What is the business driver here?
the purpose of this web portal is to allow non technical persons to change the times where the call center agents are praying. (prayer time is variant)
now once the times are set in the web portal how can you access the "hours" variables in icm, in which table they reside?