AI

Hi all, I want to pulling data from a knowledge model through the following code ... space = celonis.apps.get_spaces().find('Default')package = space.get_packages().find('Knowledge Model Test')knowledge_model = package.get_knowledge_model('999-automation-rate-bw-download')content = knowledge_model.get_content() But I get the error "PyCelonisPermissionError: You don't have permission to perform 'GET' ", even I have set all possible permissions (for "Space" / "Package / "Analysis").Any ideas which permissions are missing. Unfortunately the article below does not help me here. Thanks in advance,Best,Jonas 

Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0): After identifying the required space, package , analysis and sheet, I specify the required table:olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title") ... and query the table:olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()olap_query_HistoricPOs Some columns are read correctly:(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')and others are not. These get a hash and a brace like this:(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"') This incorrect naming is kept in the subsequently created dataframe:df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model) and leads to an empty df in the further notebook:df_references = {}df_references['historic_POs']= df_his

Hi there,I would like to pull an OLAP table component out one analysis sheet into the ML bench If I try this way by ID it works:components = sheet.componentscomponent = components.find_by_id('Component_ID_Here') But I would like to import the table by name as the component ID might change.So I tried this but it does not work.:components = sheet.componentscomponent = components.find('Table_Title_Here') Hope you can give me a hint. Best,Conny

Hi All,I wanted to share an issue with you guys regarding the ML app we had in our server in which the app was automatically changing it's python package versions despite of whatever desired versions of python packages we install. Then we figured out that if the ML app had a file named virtual environments and in it's metadata if the versions are already set , no matter what ever desired versions of python packages we install it automatically changes it's version to the one mentioned in the metadata of that virtual environment. The reason for this is that the workbenches where virtual environments were used usually become corrupted and inaccessible. Files will not be recoverable if a workbench is corrupted.  The only way of resolving this issue is creating a new ML app and backing up the files in the current workbench (Excluding the virtual environments) and restoring them to a new workbench. This will ensure your data is protected from possible corruption. For more inf

Hi Team,I am trying to create a table in a specific data job before which i have done some calculations using pandas and i want to perform SQL using that table in the datajob.But the tutorial gives the datapool create tables and i am not able to access it in Datajob i need.Is there any way to do this?When i force the data_source_id while creating the table in data pool, it gives an error saying it cannot find that table and source id.Please let me know if there is a way.Thank you

Hi Team,I am trying to retrieve the data received from the data connection in a table to machine learning workbench to do some manipulations and write it to another table in datapool.Is it possible?I have tried so far . data_pool = c.data_integration.get_data_pools().find(<pool name>)a=data_pool.get_job(<job id>)b=data_pool.get_table(data_source_id=<sourceid> name=<table name>) But from here i am unable to get the function get_data_frame. Is there any other way?Please let me know.Thank you

Hi all,has anyone had problems when triggering a Jupyter Notebook from an Action Flow? I cannot even trigger the template provided in the educational page. It is puzzling because the POST requests succeeds with code 200 - so I assume that all required fields are correctly filled - yet the Notebook is not executed, it does not produce any output. I have tried to move the Notebook across folders and apps, to no avail. Anyone else had the same problem? Attached is the POST output (maybe the problem is that the ML notebook is QUEUED? but how would I solve it anyways?).

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 regardsChristoph 

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.5Now when i try its not present. Is this deprecated?If so, are there any alternatives?Please let me know. Now the error: 

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? 

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

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

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. 

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.4But after the upgrade to 2.0 , we are getting a getaddrinfo errorIs anyone else facing such an issue?If so, What needs to be done.Let me knowThanks

Hello all, How can I output the data model with a python command in the pycelonis package? in pycelonis 2.0.0this was done with the functionspool = 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 greetingsChristoph

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

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. 

I'm getting an error when trying to add a table to a data modelThe 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  

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

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

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 

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 regardsIrfan

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?