How to use Action Flow to convert a CSV file to XLSX?

Hi Wojciech, 

I think the best is to get the data and pass it in a form of parameters for ML script (I think AR Sailfin App was having working examples of triggering ML python scripts with AF done differently than that in documentation - you could ask Celonis support and share general approach if there’s a big difference :)), transforming JSON into Dataframe in ML and then into excel file. However I’m not sure how to attach excel file from ML workbench to Outlook module, so theoretical way to achieve this would be:

Step 1) Run Notebook using only AF (you can also try to mix signals but I wouldn’t advice on that, documentation below):
Step 2) Convert Json into Dataframe (example provided)
Step 3) Convert Dataframe into excel (example provided_
Step 4) Convert excel into binary? (IO/BytesIO + Openpyxl?)
Step 5) Run AF sending email attaching binary? (documentation below + passing binary excel file as a parameter/input for AF)

Documentation Triggering ML script with AF: Trigger Machine Learning ScriptDocumentation - passing parameters: Forward Parameters to Machine Learning ScriptDocumentation - triggering AF from ML workbench: Trigger an Action Flow from ML WorkbenchDocumentation swagger for ML workbench API endpoints: https://[teamname].[realm].celonis.cloud/machine-learning/swagger-ui/index.html#/Small example for turning JSON into Excel file (of course need to instal openpyxl):

import json
import pandas as pd
import openpyxl

json_string = '''
{
    "name": "Charlie",
    "age": 35,
    "address": {
        "street": "123 Main St",
        "city": "Munich"
    },
    "hobbies": "reading"
}
'''

data = json.loads(json_string)
df = pd.DataFrame([data], index=[0]) 
print(df)

# Export DataFrame to Excel
df.to_excel('output.xlsx', index=False)

Output:

Small example for DECODING binary to excel. I know it’s not the same but process should be fully reversable, so I would check if there’s no function for that.

Documentation for API ML workbench endpoints:

Hope that helped! :)

Best Regards,

Mateusz Dudek

Hi ​@wojciech.brol, 

Next to the proper data transformation solution that ​@mateusz.dudek14 suggests, you can check the Celonis Action Flow blueprint for inspiration purposes: https://docs.celonis.com/en/send-excel-file-via-mail.html

Hi, ​@mateusz.dudek14 , ​@janpeter.van.d ,
I wanted to thank you for your help in solving the problem. I’ve learned a lot thanks to your advice.

Action Flow generates Excel files, but I encountered difficulties with the ML Workbench API Endpoint—I can't directly retrieve the contents of the file. The only accessible data is the content within a given Notebook ID, but the API does not allow downloading the actual Excel file.

I tried to work around this issue using the download URL, but instead of getting the Excel file, I receive an HTML file that redirects to the actual download. Unfortunately, this solution does not work as expected. It seems we’ll have to wait for Celonis to introduce the appropriate endpoint ;)