Skip to main content

Text to Action: Shape Data with Plain English or Python in eZintegrations

Quick Intro: Words or Code, You Choose

Data can be messy—messy with emails, APIs, WebSocket streams, or database rows, all needing tweaks to fit right. eZintegrations’ Text to Operations makes it simple: type plain English to describe changes, or write Python code for control. No need to juggle complex scripts; the tool turns your instructions into working Python, built on the old Python operation but now smarter. It’s like telling a helper what to do, and they nail it every time.

Easy Setup: Get Going Fast

Jump into eZintegrations’ interface to start.

  1. Add the ToolOperation: In your Integration Bridge, place Text to Operations where data needs work—work, after source, before target.

  2. Write or Say: Enter a plain sentence (like “Make last names uppercase”) or paste Python code. Enable “Forward Code” to pass the generated code forward.

The system uses “pycode_data” (your input) and “Responsedata” (your output list) automatically. You just focus on the task.

Core Feature: Simple Instructions, Big Results

Text to Operations turns your words into Python or runs your code directly, handling data with ease.

Real Test Example:
Input data from an API:

{
  "bizdata_dataset_response": {
    "data": [
      {
        "id": 1,
        "email": "george.bluth@reqres.in",
        "first_name": "George",
        "last_name": "Bluth",
        "avatar": "https://reqres.in/img/faces/1-image.jpg"
      }
    ]
  }
}

Instruction:
“

From the source data, convert the last_name key to uppercase.”

What Happens:

  • Words to Code: It reads “last_name” and builds Python.
  • Generated Code: 
    Responsedata = []
for user in pycode_data['bizdata_dataset_response']['data']:
    user['last_name'] = user['last_name'].upper()
    Responsedata.append(user)
  • Output: 
    [
  {
    "id": 1,
    "email": "george.bluth@reqres.in",
    "first_name": "George",
    "last_name": "BLUTH",
    "avatar": "https://reqres.in/img/faces/1-image.jpg",
    "python_code": "Responsedata = []\nfor user in pycode_data['bizdata_dataset_response']['data']:\n    user['last_name'] = user['last_name'].upper()\n    Responsedata.append(user)"
  }
]
  • How It Works: One field for instructions or code, preview to check, and done. For more, try “Create new keys from attributes and drop the old ones.”

Another Example:
Input:

[
  {
    "attributeid": 212077,
    "attributename": "item_no",
    "attributevalue": "999898",
    "attribute_groupid": 24315,
    "attribute_groupname": "Default",
    "Isvariant": "false"
  },
  {
    "attributeid": 212078,
    "attributename": "Product Name",
    "attributevalue": "Product ABC",
    "attribute_groupid": 24315,
    "attribute_groupname": "Default",
    "Isvariant": "false"
  }
]

Instruction:
“

For each item, create a new key from 'attributename', set its value to 'attributevalue', and remove both keys.”

Generated Code:

Responsedata = []
for item in pycode_data:
    new_item = item.copy()
    new_key = new_item.pop('attributename', None)
    new_value = new_item.pop('attributevalue', None)
    if new_key and new_value:
        new_item[new_key] = new_value
    Responsedata.append(new_item)

Output:

[
  {
    "attributeid": 212077,
    "item_no": "999898",
    "attribute_groupid": 24315,
    "attribute_groupname": "Default",
    "Isvariant": "false"
  },
  {
    "attributeid": 212078,
    "Product Name": "Product ABC",
    "attribute_groupid": 24315,
    "attribute_groupname": "Default",
    "Isvariant": "false"
  }
]

It handles case changes, new fields, or restructuring—restructuring all from words or code.

Why

The ItWin: Shines:Fast Powerand in Simplicity
Flexible

Schedule runs (like every Monday at 2 PM with cron 0 14 * * 1), track progress with live logs, and scale without limits. Text to Operations streamlines data tasks: plain English or Python code delivers precise results to any system. It cuts effort, reduces bugs, and speeds up your workflows. Why write complex scripts when a sentence works? Get started with eZintegrations and make data handling a breeze.

Launch your data flow at eZintegrations—eZintegrations, where words or code make it happen.

Back to top