0CodeUtil

Use the 0CodeUtil data utility toolkit for text encoding and reformatting, sentiment scoring, and multi-pattern regex work. Agents handle the transformation chores between the systems that matter.

15 actions API key available

Platform Documentation ↗ Capability data verified 2026-08-01

A batch of unstructured supplier confirmations lands in the shared mailbox

Agent runs Parse Text With Regex once per message with the named pattern set for reference, quantity, and promised date

Agent runs Convert Text Format to turn the delimited internal reference strings into readable values

Agent counts how many messages returned an empty capture for each named pattern

Agent posts the per-pattern capture rate and a sample of parsed rows to the operations channel

The operations owner approves the pattern set against the sample before the batch is written to the ERP

What This Integration Enables

0CodeUtil is built around a specific complaint: the transformation work between two systems is usually more code than the integration itself. Parse Text With Regex is the answer to it. Rather than chaining a step per field, an agent hands over one block of text and several named patterns in a single call, and gets each captured value back under its own key, along with a combined map and parallel key and value arrays. Invoice number, purchase order reference, contact email, and promised date come out of one operation on one message. Execute JavaScript Code covers the remainder: a snippet runs remotely and returns whatever its final expression evaluates to, which handles the bespoke transformation that no dedicated action will ever cover.

Around those two sit the reshaping helpers that keep the middle of a flow from becoming a script. Binary and Unicode decoding clean up strings that arrive double-escaped from an export, and Convert Text Format turns dot, pipe, or underscore separated machine strings into readable prose. Plan Date does working-day arithmetic against an explicit holiday list, and Convert Currency restates a value at the rate published on a named date. Geocoding, EXIF reading, and password-protected archive handling cover the rest. The archive actions matter for a practical reason: the vendor serves its output on links that expire after 24 hours, so this connector copies the bytes into FlowRunner file storage and returns a durable URL alongside the short-lived one. Transformation power is the point, and transformation power applied without review is exactly how a clean dataset becomes a corrupted one, which is why the gate on this page sits on the transformation itself.

Without FlowRunner

One step per field Extracting four values from a message body means four chained steps with four failure points

Silent misparses A pattern that stops matching returns nothing, and the record is written with the field blank

Deadlines counted in calendar days A five-day SLA lands on a Sunday, or on a national holiday in the customer's country

With FlowRunner

One call, several named patterns A single step returns every captured field under its own key, plus a combined map

Capture rate visible before the write A pattern that stopped matching shows up as a coverage number, not as an empty column

Deadlines counted in working days Weekends and an explicit holiday list are skipped when the target date is calculated

Use Case Scenarios

Turning free-text confirmations into rows

Supplier order confirmations arrive as prose in an email body, in a different shape from every supplier. The agent runs Parse Text With Regex over each message with the named pattern set the operations team maintains, extracting the supplier reference, the internal purchase order number, the confirmed quantity, and the promised ship date in one call. Convert Text Format cleans the delimited internal reference into something a person can read in a report. Convert Unicode To Text resolves any escape sequences that survived the supplier's mail system. Validate Email Address confirms the reply-to contact still has a domain that publishes MX records before the record names it as the escalation path.

Deadlines that land on working days

A support commitment or a delivery promise needs a real date, not a calendar date. The agent calls Plan Date with the start date, the number of days in the commitment, the weekdays to skip, and the explicit holiday list for the country the customer is in. The result is a target date that a person will actually be present for. Geocode Address and Reverse Geocode Coordinates fill in the location context around it, turning a submitted address into coordinates for routing, or a driver's GPS ping into a postal address that reads correctly on a delivery record. Convert Currency restates the order value at the rate published on the order date rather than today's, which is what an accounting restatement requires.

Handling an encrypted partner feed end to end

A partner drops a password-protected archive on SFTP every night. The agent calls Extract Secure Zip, which opens the archive and returns each file it contained. Because the vendor's extraction links expire after 24 hours, every extracted file is copied into FlowRunner file storage and returned with a durable URL, name, and byte size, so a flow that runs a reconciliation two days later still has the bytes. On the outbound side, the agent assembles the month's export, calls Create Secure Zip to password-protect it, and delivers the durable link rather than the expiring one. Read Image Metadata handles the photographic evidence in the same feed, pulling capture timestamps and GPS data out of field photographs so claims can be sorted by when and where they were taken.

Human-in-Loop Highlight

The gate here is on the transformation, not on the data. Parse Text With Regex and Execute JavaScript Code are the two most powerful actions in this connector and the two that fail most quietly. A regex that no longer matches does not raise an error; it returns an empty capture, and the record is written with a blank where the invoice number should have been. A JavaScript snippet with a changed assumption does not throw; it returns a plausible number that is wrong in the same direction across every row. Applied one message at a time, either mistake is a support ticket. Applied across a batch of nine hundred, it is a column of bad data already committed to the ERP, and nobody looks at a column that has values in it.

So when a pattern set or a snippet is new or has changed since the last run, the agent runs it against a sample first and stops. It posts to the operations channel: "New pattern set applied to 912 supplier confirmations. Coverage: supplier_ref 912 of 912, po_number 908 of 912, promised_date 641 of 912. Sample of 10 parsed rows attached. Apply to the full batch, revise the promised_date pattern, or hold?" The 641 is the finding. A person looks at the sample, recognises that one supplier changed its date format last week, and decides whether to fix the pattern or process the batch with that field left for manual entry. Nothing is written until they answer. This is the digital andon cord applied to a data transformation: the agent stops the line when its own coverage numbers disagree with what it expected, rather than filling nine hundred rows with confident blanks.

Agent processes routinely

Detects exception requiring judgment

Clear match Continues automatically

Ambiguous Routes to human via preferred channel

Human decides

Agent resumes with decision

Agent Capabilities

15 actions

Extraction and Analysis

Parse Text With Regex Runs several named regular expressions over one block of text in a single call and returns each captured value under its own key, plus a combined map and parallel key and value arrays. Used to pull invoice numbers, phone numbers, names, and email addresses out of unstructured text without chaining steps.
Analyze Sentiment Scores the emotional tone of a block of text as Positive, Negative, or Neutral and returns the compound score alongside the individual negative, neutral, and positive proportions, so a flow can route by how strongly the text leans rather than by the label alone.
Validate Email Address Checks RFC formatting and confirms the domain publishes MX records able to receive mail, returning the resolved MX hosts with priorities and separate booleans for structural and deliverability validity. Used to clean signup lists and suppress bounces before a send.
Read Image Metadata Extracts EXIF and other metadata from an image reachable by URL, including camera make and model, lens and body serial numbers, exposure time, aperture, focal length, ISO, orientation, pixel dimensions, artist, and the original capture timestamp. Used to audit photo provenance and sort media by capture date.

Text Transformation

Convert Text Format Reformats a delimited string into a single clean sentence by treating the supplied indentation character as a separator. Used to turn dot, pipe, or underscore separated machine strings into readable prose for emails, reports, and notifications.
Convert Unicode To Text Resolves Unicode escape sequences into the characters they represent. Used to clean strings that arrive double-escaped from APIs, CSV exports, or database columns before they are stored or displayed.
Convert Binary To Text Decodes a space-separated string of 8-bit binary octets back into readable text. Used to read payloads arriving binary-encoded from legacy systems, devices, or encoded webhook fields.
Convert Text To Binary Encodes plain text into its space-separated 8-bit binary representation. Used to prepare payloads for systems that expect binary-encoded strings.

Location

Geocode Address Converts a postal address or place description into latitude and longitude. Used to enrich records, plot submissions on a map, and supply coordinates to distance calculations later in a flow.
Reverse Geocode Coordinates Resolves a coordinate pair into a structured postal address, returning city, county, state, district, postcode, country, and ISO region code as separate fields. Used to turn GPS pings, delivery check-ins, and mobile form submissions into readable locations.

Dates and Currency

Plan Date Calculates a target date a given number of days from a start date while skipping chosen weekdays and an explicit holiday list. Used to derive SLA deadlines, delivery dates, and follow-up reminders that land on a working day.
Convert Currency Converts an amount between two currencies using the rate published for a specific date, which makes it suitable for restating historical invoices and expenses rather than only for live quotes.

Custom Logic

Execute JavaScript Code Runs a snippet of JavaScript remotely and returns whatever the final expression evaluates to. Used for bespoke transformations, calculations, and conditional logic no dedicated action covers. The snippet should end with the expression whose result you want returned. Review a changed snippet against a sample before it runs across a batch.

Frequently Asked Questions

What can FlowRunner do with 0CodeUtil?

FlowRunner agents can run Convert Binary To Text, Convert Text To Binary, and Convert Unicode To Text in 0CodeUtil, plus 12 more actions.

Does connecting 0CodeUtil to FlowRunner require OAuth?

No. 0CodeUtil connects to FlowRunner with an API key, no OAuth flow required.

Can 0CodeUtil trigger a FlowRunner workflow automatically?

0CodeUtil doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger.

Start building with 0CodeUtil

$100 in credits. No card required. Connect in minutes.

Start Building Free Talk to us