Script running CREO and Windchill, what's the best way?
So I have a slight issue. I need to script a repeatable process which utlizes both CREO and Windchill.
The case is - sometimes we got a request to download certain file from company database, and then convert it to specified format, then e-mail back to a requestor. It's a deadly repeatable process, which I thought could be easily automated.
I wanted to maintain a following chain of actions:
1) Mail request gots to Outlook, it runs a rule which opens a script.
2) Script opens Creo, logs into appropriate database.
3) It opens Windchill Cabinets, searches appropriate drawing number with data extracted from mail.
4) With use of appropriate rules (without checkout, latest or as stored state) it downloads appropriate drw to workspace, opens it. Then runs a mapkey converter.
5) After all it runs sorting script, which puts converted file in appropriate cloud drive, and sends mail back to user.
While steps 1,,2,5 are relatively easy and doable with powershell, python or VBA, I have giant problems with actually coming up with some kind of shell which puts it all together AND searching the Windchill database.
Could you guys maybe advise me with the way or tool I could maintain the process with? Would the Jlink be enough?

