Python FAQs

Get answers to frequently asked questions about Python.

What can I do with the Python connector in Workato?

The Python connector allows you to write and execute custom Python code as part of a recipe. You can use this connector to develop web applications, data pipelines, and machine learning projects.

What are common uses for the Python connector?

Common uses for the Python connector include:

• Data transformation (such as date formats)
• File format conversion (for example, CSV to JSON)
• Data set chunking to prevent API timeouts

Refer to Use cases for more ways to use Python.

Which version of Python does the Workato Python connector use?

The Python connector in Workato runs Python 3.9 or later.

What libraries are supported by the Workato Python connector?

The Python connector supports all standard libraries included in Python 3.9 or later. The Python connector also supports the following libraries:

• bcrypt
• lxml
• msoffcrypto
• NumPy
• openpyxl
• pandas
• Pytz
• requests
• xlrd

LIMITED LIBRARY SUPPORT

The Python connector does not support user-provided libraries or libraries not listed in the preceding list.

Are there any limitations to using the Python connector in Workato?

Yes, you should consider the following limitations when using the Python connector:

• The Python connector limits script size to 1MB.
• The Python connector provisions 256MB of total memory overhead for each Python action.
• Actions time out after 90 seconds.
• Limit CSV file sizes to 20MB when using them with the Pandas library, due to its temporary storage requirements.
• Limit Excel file sizes to 5MB when using them with the Pandas library, as Pandas requires additional temporary storage and decompresses standard Excel compressed data.

What actions are supported by the Python connector in Workato?

The primary action supported by the Python connector is Execute Python code. This allows you to run custom Python scripts within a recipe.

Do I need to perform any setup configuration to use the Python connector in Workato?

No specific setup configuration is required for the Python connector. You can search for and select Python in the Apps tab to start using it.