Skip to main content

AI

Ask questions and discuss using AI copilots, annotations, and machine learning tools for smarter automation and data insights.

  • 86 Topics
  • 301 Replies
86 Topics
C
Level 3
christoph.schus12Level 3
posted in AI
Hello all,

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill? Best regards Christoph

22
G
Level 8
R
Level 4
rahul.bhat13Level 4
asked in AI
Add_Table_From_Pool deprecated in 2.x?

Hi, Im trying to add a table from Datapool to datamodel and i found this function, add_table_from_pool in the release notes of 1.5 Now when i try its not present. Is this deprecated? If so, are there any alternatives? Please let me know. Now the error:

20
R
Level 4
S
Level 2
sameer.hardiLevel 2
asked in AI
Getting pool versions using python

Hello All, I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool) Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)> Is there any way i could get the data pool versions?

70
G
Level 8
Z
Level 3
z.bLevel 3
posted in AI
Hi Team,

Hi Team, Can you please help me with the code to extract Knowledge Mode Record information using Py Celonis. I checked the PyCelonis documentation but was not able to get the same. Thank You in advance. Regards, JB

11
matt.witty13
Level 5
S
Level 3
siddhesh.naik11Level 3
posted in AI
Can anyone help me with the code for creating CLI profile?

Can anyone help me with the code for creating CLI profile?

25
G
Level 8
A
Level 2
anurag.jha13Level 2
asked in AI
API Request to using PyCelonis.

Hi, I am trying to send API Request using the api_request() function but i am getting this RetryError. Can anyone please explain how to tackle this error.

10
R
Level 4
R
Level 3
rahul.bhat11Level 3
asked in AI
Connection to pycelonis after 2.0 upgrade

Hi, I am trying to connect to pycelonis from my local system to IBC . It was possible with all the required values when it was 1.7.4 But after the upgrade to 2.0 , we are getting a getaddrinfo error Is anyone else facing such an issue? If so, What needs to be done. Let me know Thanks

210
R
Level 3
C
Level 3
christoph.schus12Level 3
asked in AI
Load Data Model & table

Hello all, How can I output the data model with a python command in the pycelonis package? in pycelonis 2.0.0 this was done with the functions pool = celonis.pools.find('my_datapool') dm = pool.datamodels.find('my_datamodel') In pycelonis 2.0.1 this doesn't seem to work anymore. I get the data pool via: pool = celonis.data_integration.get_data_pool(celonis_pool_id) but how do I get the data models and the tables they contain? Many greetings Christoph

60
G
Level 8
M
Level 3
maryam.tahmoLevel 3
asked in AI
Is it possible to visualize the ML code in EMS

Hello all, I want to know if is it possible to visualize the output of PyCelonis in EMS. For example, if I have any diagram in Python, I can show it in the EMS environment? Thanks

20
S
Level 2
R
Level 3
rahul.bhat11Level 3
asked in AI
Does upgrading a workbench app in Machine learning upgrades all apps?

Hi All, I want to upgrade a single workbench app in Machine learning. I do not want to disturb any other app present in the the workbench. Is it possible to do it? Please provide any documentation if present.

10
R
Level 3
M
Level 2
marco.valliLevel 2
posted in AI
I'm getting an error when trying to add a table to a data model

I'm getting an error when trying to add a table to a data model The main problem is: it was working last week and, when I tried to re-run today, I got the following error: HTTPStatusError: Client error '400 Bad Request' for url I dont know what could be triggering it, specially because it was working before and I didn't

52
M
Level 2
C
Level 2
christian.huppeLevel 2
posted in AI
Migration script for instances

Migration script for instances Is there a pre-build python script to move data pools, spaces and analyses from one celonis instance to another? BR, Christian

71
.
Level 5
M
Level 2
max.schulLevel 2
asked in AI
Datamodel access via PyCelonis 2.0.0

I have a question regarding PyCelonis 2.0.0. It looks like any means to access data (from a datamodel) and use it with a data frame were removed from the package. Is my assumption correct? If so, how would you implement something like an "invoice duplication" app with Python in the ML Workbench if it is impossible to get the data? Thanks

10
M
Level 3
R
Level 3
rahul.bhat11Level 3
asked in AI
Hi All,Is there any way to access the data and display it from the tables from the datapool in the Machine learning module and later do some queries and push it back into the datamodel?

There is a method to push data into the datamodel, but i could not find any that can access it. Please let me know if anymore details are needed. Thank you

60
M
Level 3
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Hi all,is it possible to execute/run an existing data integration schedule via python?

It is already possible to execute data jobs and data models. But I have not found anything for schedules in PyCelonis Docs. The reason I want to do this is to distinguish between an automatic execution via DI/Python schedule or a true manual one with a "real" user behind. If I execute a data job via Python, it will be shown as "Manual Execution" in the logs. Best regards Irfan

70
irfan.suria12
Level 4
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Which API/objects can I use to create Action Flow modules via Python?

I have a huge table in an analysis that I want to rebuild with a query data module in Action Flows. Obviously, this would require a lot of copy&paste as there is no feature yet to automatically create a query data module from an OLAP table, similar to the feature that exists for creating an Action Engine skill based on an OLAP table. Now, I want to leverage the MLWB for it. With analysis.drafts.components("table").pql_columns I was already able to get all the column names and their respective pql-queries. How can I transfer them to the action flows?

10
irfan.suria12
Level 4
S
Level 3
saravanan.gopalLevel 3
asked in AI
Hello All,I am working on python code to get the last updated date for tables across multiple Data Models. I am facing an issue while passing the Variable to Filter.Please share your expert opinion ont this topic.RegardsSaravanan.G

20
janpeter.van.d
Level 8
S
Level 3
saravanan.gopalLevel 3
asked in AI
Hello All,I am trying to get details of table from data model directly using Pyhton. Where I need to retrieve the few columns for the last 7 days based on a date column (example: ERDAT &gt; TODAY() -7 ).

Tried using PQLFilter but could not achieve this.

00
S
Level 3
F
Level 1
florian.mansfLevel 1
asked in AI
How can I get the connections from the process explorer/process graph via Python?

I have found two ways to get the activities via python. But I need the connections betweens them. I can check for all activities wether they have a connection to each other but with the complexity of O(n²) thats very inefficient and costs a lot of time for complex processes with many activities. Is there a more efficient way to get the connections?

10
T
Level 1
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Which permissions does an application key need in order to access the objects in Studio (Views, analyses, etc.)?

I have given my App Key the following permissions: Space permissions: Use all packages Package permissions: Use package Analysis permissions: Use Data Pool permissions (of the analysis): Use all data models celonis.spaces.find("Space123") works nicely, but then space.pockages will return an empty list. Consequently, space.packages.find("Analysis123") would not work. Which permissions do I miss? Cheers

40
D
Level 1
.
Level 2
.1460138Level 2
asked in AI
Getting below error while creating RCA using Machine Learning workbenchAttributeError: 'NoneType' object has no attribute 'source_name'Please help us reslove this error

from pycelonis import get_celonis from pycelonis.root_cause_analysis import root_cause_analysis celonis = get_celonis() dm = celonis.datamodels.find('c4cb1efc-fa6a-4704-bc51-b3b365c5e796') kpis = {'late_payment': """ CASE WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')=0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), TODAY()) > 0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), TODAY()) <= 60 THEN NULL WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')>0 AND DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Create Purchase Order Item'), PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" = 'Clear Invoice')) > 30 THEN 1 WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN",

10
G
Level 8
J
Level 3
jaikishan.pandy11Level 3
asked in AI
How to find the data directory and the shared selection URL for Machine Learning Workbench? We need it in order to push our model result back into Celonis. Also please help me to resolve the attached errorThank you!

00
S
Level 1
J
Level 3
jaikishan.pandy11Level 3
asked in AI
Getting Error while running the get_data_frame in analysis

Please find below attached error snap

00
T
Level 1
R
Level 4
raman.silot14Level 4
asked in AI
Unable to upload ipynb file

getting this error

20
G
Level 8
E
Level 4
e.nLevel 4
posted in AI
I get the following error when setting up DegitalTwin in Simulation.

I get the following error when setting up DegitalTwin in Simulation. What kind of time format should I use so that Celonis can read it correctly? ​ Error Message​ Timestamps are rounded at the Eventday. This could cause problems to the Digital Twin Extraction, please check your Data Model and include the hours and minutes in the Timestamp columns of the data model.

11
.
Level 5

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025