I tried to connect and extract data from IBC to my Colaboratory python environment using Pyceonis.
Normally it worked correctly with below scripts.
from pycelonis import get_celonis
login = {celonis_url: my_url, api_token: my_token}
celonis = get_celonis(**login)
analysis = celonis.analyses.find('id of my analysis)
sheet = analysis.published.sheets.find(id of my sheet)
component = sheet.components.find(id of my component)
df = component.get_data_frame()
But sometimes get_data_frame method returned exception.
Exception Traceback (most recent call last)
in ()
----> 1 df = component.get_data_frame()
2 df
2 frames
/usr/local/lib/python3.6/dist-packages/pycelonis/objects_base.py in get_data_file(self, pql_query, file_path, export_type, variables)
647
648 if r[exportStatus] != DONE:
> 649 raise Exception(f"Export failed. Status: {r} \\n\\n Query: {pql_query}")
650 else:
651 file_type = export_type.lower() if export_type != EXCEL else xlsx
Exception: Export failed. Status: {id: 08da3644-661e-419f-8a6d-b683b03a2a04, exportStatus: FAILED, created: 1571061484375, message: The provided query does not contain a valid table statement to be exported., exportType: PARQUET}
Query: [TABLE( VBAP.PSTYV|| - ||VBAP.PSTYV_TEXT AS #{VBAP.PSTYV}, VBAP.PSTYV|| - ||VBAP.PSTYV_TEXT AS #{VBAP.PSTYV}, KNA1.KUNNR AS #{KNA1.KUNNR}, COUNT_TABLE(VBAP) AS #SO Item FORMAT ,f, AVG(CALC_THROUGHPUT(ALL_OCCURRENCE[Process Start] TO ALL_OCCURRENCE[Process End], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, DAYS))) AS Throughput Time (Days) FORMAT ,f, SUM(VBAP.NETWR_CONVERTED) AS Net Value (JPY) FORMAT ,f, AVG(PU_AVG (VBAP, CASE WHEN ISNULL("_CEL_O2C_ACTIVITIES".USER_TYPE) = 1 \\r\\n THEN NULL \\r\\n WHEN ("_CEL_O2C_ACTIVITIES".USER_TYPE =
\\r\\n THEN 1.0 \\r\\n ELSE 0.0 \\r\\n END)) AS Automation Rate FORMAT .2% ) ORDER BY SUM(VBAP.NETWR_CONVERTED) DESC NOLIMIT;]I changed column name from #{VBAP.PSTYV} to simply Item category then it worked, so there is something defect in parsing column name. Could you check program ?
Best regards,
Kazuhiko
