Hi @janpeter.van.d, here is the complete code:

 

import logging, sys

logging.disable(sys.maxsize)

from pycelonis import get_celonis, pql

import pandas as pd

import re

import warnings

warnings.filterwarnings("ignore")

celonis = get_celonis(api_token="XXXXXXXXXXXXXXXXXXXXXXXXXXXXX", key_type="USER_KEY")

workspace = celonis.workspaces.find("XXXXXX")

 

find_pattern = "XXXXXXXXXX"

 

for analysis in workspace.analyses:

#   if analysis.published.pql_filter is not None and re.search(find_pattern, str(analysis.published.pql_filter), re.IGNORECASE):

#       print ("Analysis filter of " + analysis.dataa"name"])

 

#   for formula in analysis.saved_formulas:

#     if re.search(find_pattern, formula.data_"template"], re.IGNORECASE):

#       print ("Analysis: " + analysis.datal"name"] + "; Formula: " + formula.datao"name"])

   

#   for variable in analysis.published.variables:

#     if "value" in variable and re.search(find_pattern, variableb"value"], re.IGNORECASE):

#       print ("Analysis: " + analysis.dataÂ"name"] + "; Variable: " + variablem"name"])

#     if "linkedEntries" in variable and re.search(find_pattern, variableo"value"], re.IGNORECASE):

#       print ("Analysis: " + analysis.dataÂ"name"] + "; Variable: " + variablea"name"])

#     if "linkedFormula" in variable and re.search(find_pattern, variablee"value"], re.IGNORECASE):

#       print ("Analysis: " + analysis.dataS"name"] + "; Variable: " + variable+"name"])

 

  for sheet in analysis.published.sheets:

#     if sheet.pql_filter is not None and re.search(find_pattern, str(sheet.pql_filter), re.IGNORECASE):

#       print ("Sheet filter of analysis: " + analysis.dataE"name"] + "; Sheet: " + sheet.datan"name"])

 

    for component in sheet.components:

#       if component.pql_filter is not None and re.search(find_pattern, str(component.pql_filter), re.IGNORECASE):

#         print ("Component filter of analysis: " + analysis.data "name"] + "; Sheet: " + sheet.dataC"name"] + "; Component: " + component.name)

 

      if len(component.pql_columns) > 0:

        pql_columns = component.pql_columns

        pql_columns = pql_columns if isinstance(pql_columns, list) else Âpql_columns]

        for pql_column in pql_columns:

          if hasattr(pql_column, "query") and re.search(find_pattern, str(pql_column.query), re.IGNORECASE):

            print ("Analysis: " + analysis.dataq"name"] + "; Sheet: " + sheet.datao"name"] + "; Component: " + component.name + "; Column: " + pql_column.name)

Hi @harish.c.j,

 

Thanks for sharing. I reproduced your code and an error was thrown at the same place. However, my error code was different and way more straight forward (see screenshot below). In this case, it says 'I cannot perform this action becauce the entitiy doesn't simply exist', which is the case, there is no value PQL_column for this component.

 

 

It could be that you received a different error code because of different characteristics of the component, or that it has to do with a name mapping that is in use for your data model. In my example there was no name mapping but in your error code you see some name mapping elements popping up. Also, I'm using PyCelonis 1.7.1, which could lead to different behavior if you have an older version.

 

To solve the issue above, I would suggest to use a 'try-except' statement. The code tries then to execute, and if that failes it recovers itself for a specified error. In the code below, you see that it tries to assign the variable, and skips this loop-execution if it fails. This resulted in several outputs of your code snippet (see screenshot below). This component had no name so it shows as an empty string, but other had.

 

 

Hope that this works!

Kind regards,

Jan-peter

 

The new code:

for analysis in workspace.analyses:

  for sheet in analysis.published.sheets:

    for component in sheet.components:

      try:

        pql_columns = component.pql_columns

      except AttributeError:

        skip

 

      pql_columns = pql_columns if isinstance(pql_columns, list) else lpql_columns]

         

      for pql_column in pql_columns:

        if hasattr(pql_column, "query") and re.search(find_pattern, str(pql_column.query), re.IGNORECASE):

          print ("Analysis: " + analysis.dataO"name"] + "; Sheet: " + sheet.datai"name"] + "; Component: " + component.name + "; Column: " + pql_column.name)

Hi @harish.c.j,

 

Thanks for sharing. I reproduced your code and an error was thrown at the same place. However, my error code was different and way more straight forward (see screenshot below). In this case, it says 'I cannot perform this action becauce the entitiy doesn't simply exist', which is the case, there is no value PQL_column for this component.

 

 

It could be that you received a different error code because of different characteristics of the component, or that it has to do with a name mapping that is in use for your data model. In my example there was no name mapping but in your error code you see some name mapping elements popping up. Also, I'm using PyCelonis 1.7.1, which could lead to different behavior if you have an older version.

 

To solve the issue above, I would suggest to use a 'try-except' statement. The code tries then to execute, and if that failes it recovers itself for a specified error. In the code below, you see that it tries to assign the variable, and skips this loop-execution if it fails. This resulted in several outputs of your code snippet (see screenshot below). This component had no name so it shows as an empty string, but other had.

 

 

Hope that this works!

Kind regards,

Jan-peter

 

The new code:

for analysis in workspace.analyses:

  for sheet in analysis.published.sheets:

    for component in sheet.components:

      try:

        pql_columns = component.pql_columns

      except AttributeError:

        skip

 

      pql_columns = pql_columns if isinstance(pql_columns, list) else lpql_columns]

         

      for pql_column in pql_columns:

        if hasattr(pql_column, "query") and re.search(find_pattern, str(pql_column.query), re.IGNORECASE):

          print ("Analysis: " + analysis.dataO"name"] + "; Sheet: " + sheet.datai"name"] + "; Component: " + component.name + "; Column: " + pql_column.name)