Skip to main content
Question

Hi everyone, I'm trying to send a .xlsx file from sharepoint to machine learning workbench.

  • February 9, 2024
  • 6 replies
  • 25 views
andres.naran12
Level 8
Forum|alt.badge.img+10

Unfortunately, we couldn't find any documentation that explains how to send the data from a .xlsx file into a param in the HTTP module, the documentation that Celonis provides only explains how to push data for a CSV file into the datapool directly.

 

In our case, we want to send the data of the .xlsx file to Machine Learning workbench to create a table that we can send to the data pool, but we don't know how to include the data of this file into the params in the request content from the HTTP Module. Does anyone know how to do that?

    6 replies

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • February 9, 2024

    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]')

    andres.naran12
    Level 8
    Forum|alt.badge.img+10

    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:

     

    image 

    and this is how we have configured the request content:

     

    Soa

     

     

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • February 9, 2024

    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:

     

    image 

    and this is how we have configured the request content:

     

    Soa

     

     

    Ah okay I misunderstood the question. That's a very interesting use case. I've not seen something like this before.

     

    andres.naran12
    Level 8
    Forum|alt.badge.img+10

    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:

     

    image 

    and this is how we have configured the request content:

     

    Soa

     

     

    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.

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • February 12, 2024

    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:

     

    image 

    and this is how we have configured the request content:

     

    Soa

     

     

    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.

    mateusz.dudek14
    Level 11
    Forum|alt.badge.img+11

    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

    Community Code of ConductAccessibility statement