I am trying to set up the Startup python script to be able to run a process which taps into Smartsheets API and converts it to an excel, which I then separately read into FME and runs through an FME process. I'd like to have the python code run every time before running through the data processing workflow I set up.
I have added my python script, set the interpreter to 3.10 and have installed modules into the Documents\\FME\\Plugins\\Python folder using command prompt : C:\\Program Files\\FME>fmeworkbench.exe python -m pip install pandas --target C:\\Users\\vberg2\\Documents\\FME\\Plugins\\Python . It ran and successfully installed pandas, along with a few other modules I installed after. I am however getting this error when I try to run the FME workspace: Python Exception <ModuleNotFoundError>: No module named 'pandas._libs.interval'. When I look into the folder directory, that file is there.
Am I missing a step, or did I install pandas incorrectly?
Thanks for the help!