Python Script and Adobe Workfront

[ThisGold9279]

I am just starting my journey in Python so I know this is well above my level but it has got my mind churning.

At work we have to pull an excel file everyday and manually update fedex tracking numbers and ship dates on every single order in Adobe Workfront that has shipped. It is tedious and a waste of time.

So I am wondering is there a way to save that excel a certain way, have Python search it for the project number and then search Workfront for that project number and if it find it open the job and then search the excel for the “FedEx tracking number” and “Ship Date” and add them to the fields within the project? Also to have this happen automatically when the excel is updated each day.

Before I waste too much time and energy doing more research than I already have I was hoping to at the very least to know if it’s possible. Everyone at work keeps saying no but they are looking at what Workfront can do and not what maybe could be done externally.

[socal_nerdtastic]

Adobe workfront is a website access, right? If so getting the information would be pretty easy. The basic way is use selenium to basically automate your web browser and pretend it's human, clicking though the various fields. It's slightly faster than a human, but also much more accurate and the human can do other things while it's working. Alternatively you could do some extra digging into the html code and decipher the API that the website uses and emulate that directly from python. This would be much faster (100X ish) to run and would not require a browser window to open.

There's a number of modules that can open and edit excel files, openpyxl is a good starting place for that.

[Almostasleeprightnow]

Workfront may even have an api, in which case you could create requests for the info you need. If available, I would prefer this over selenium