Python snippets by Workato

The Python snippets by Workato connector allows you to write and execute custom Python (opens new window) code in your recipes.

Python is a popular programming language used for web applications, data pipelines, and machine learning.

Workato's Python snippets by Workato connector enables you to perform the following tasks:

• Transform data, such as converting date formats.
• Convert file formats, such as CSV to JSON.
• Process large datasets by breaking batches into smaller chunks, such as splitting 5,000 records into chunks of 500 to prevent API timeouts.

Learn more about executing Python code.

Use cases

Use Python to automate complex workflows, process data, and enhance integrations across your business applications. The Python snippets by Workato connector provides flexibility and control to generate reports, transform datasets, and script custom automations. Explore our use cases to discover how you can improve automation with Python:

• Export Workday workers to a CSV file with Python and upload the file to Google Drive.

Supported features

• Runtime version
• Libraries

Runtime version

The Python snippets by Workato connector runs on Python 3.9 or later.

Libraries

The connector supports the standard libraries included in Python 3.9 or later (opens new window) and the following additional libraries:

• bcrypt
• lxml
• msgpack
• msoffcrypto
• NumPy
• openpyxl
• pandas
• pypdf
• Pytz
• pyxlsb
• requests
• xlrd

Additional libraries aren't currently supported.

Limits

The Python snippets by Workato connector has the following limits:

Description	Limit	Notes
Memory limit for Python connector actions, including libraries, temporary memory, and inputs	256 MB	NA
Timeout for Python connector actions	90 seconds	NA
Maxium code field size (scripts) for Python connector actions	1 MB	NA
Maximum size limit for PDF files processed with the pypdf library	35 MB	NA
Maximum size limit for CSV files processed with the Pandas library	20 MB	This limit accounts for Pandas’ temporary storage requirements.
Maximum size limit for Excel files processed with the Pandas library	5 MB	Uncompressing Excel files requires additional memory.
Read request timeout for Python evaluation in actions	90 seconds	This limit applies to the following action: Invoke custom Python code action

Additionally, user-provided libraries are not supported.

Actions

The Python snippets by Workato connector supports the following action:

• Execute Python code

Connecting to Workato

The Python snippets by Workato connector doesn't require setup configuration. Search for Python in the App tab and click the icon to get started.