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 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 Operation: In your Integration Bridge, place Text to Operations where data needs 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 in the source, create a new key using the value of 'attributename', set its value to the value of 'attributevalue', and remove the 'attributename' and 'attributevalue' keys and replace it with newly created key and value.

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 all from words or code.

The Win: Fast and 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, where words or code make it happen.

Back to top