I'm not sure if it would work with security permissions and what not, but you can pass a website link into Pandas' read_excel() function. I currently do that for a public excel file we use for context.
pd.read_excel(';link].xlsx', sheet_name = ';sheet name]')
I'm not sure if it would work with security permissions and what not, but you can pass a website link into Pandas' read_excel() function. I currently do that for a public excel file we use for context.
pd.read_excel(';link].xlsx', sheet_name = ';sheet name]')
Hi Matt, thanks for your reply.
Yes I know we can handle this file from Python with Pandas, my concern is related to the action flow itself.
The module "download a File" that exists for SharePoint is able to download a xlsx file. Still, after this file is downloaded I'm not sure how to send this file into a parameter inside the request in the "Make a request" module, I guess I have to transform the data of the file into JSON first.
This is how we have the action flow:
and this is how we have configured the request content:
Hi Matt, thanks for your reply.
Yes I know we can handle this file from Python with Pandas, my concern is related to the action flow itself.
The module "download a File" that exists for SharePoint is able to download a xlsx file. Still, after this file is downloaded I'm not sure how to send this file into a parameter inside the request in the "Make a request" module, I guess I have to transform the data of the file into JSON first.
This is how we have the action flow:
and this is how we have configured the request content:
Ah okay I misunderstood the question. That's a very interesting use case. I've not seen something like this before.
Hi Matt, thanks for your reply.
Yes I know we can handle this file from Python with Pandas, my concern is related to the action flow itself.
The module "download a File" that exists for SharePoint is able to download a xlsx file. Still, after this file is downloaded I'm not sure how to send this file into a parameter inside the request in the "Make a request" module, I guess I have to transform the data of the file into JSON first.
This is how we have the action flow:
and this is how we have configured the request content:
do you think there is any other alternative to send xlsx files from an action flow to a workbench? unfortunately, I couldn't find any module that allows to get data from an xlxs file and push that data to a data pool directly.
Hi Matt, thanks for your reply.
Yes I know we can handle this file from Python with Pandas, my concern is related to the action flow itself.
The module "download a File" that exists for SharePoint is able to download a xlsx file. Still, after this file is downloaded I'm not sure how to send this file into a parameter inside the request in the "Make a request" module, I guess I have to transform the data of the file into JSON first.
This is how we have the action flow:
and this is how we have configured the request content:
I'm not sure. I don't think there's a way to reference the workbench in an action flow. If there is, I'd imagine someone from the Celonis product team would be able to weigh in.
Hi Andreas,
Probably not - I was always using code in ML Workbench and found it working on daily basis reliably for about a year (With single temporary problems) - IMO way to go.
Best Regards,
Mateusz Dudek
