Takes the Base64 binary data of an excel file and converts rows from the first sheet in a JSON List.

Excel To JSON API

Convert Binary .xlsx to JSON

SFTP File Delete

SFTP File Download

SFTP File List

SMTP Send

Pathfix Automation Docs

Pathfix Automation

Basic Overview

Automation Editor

Introduction

Environments

API Through Pathfix OAuth

API Using Connections

Call Provider API Directly

Editing Existing API

API Editor

Pagination Within API

Create New Automation

Triggering Automation

Import/Export Automation

Sending Data To Your App

Undo/Redo Configuration

Design

Webhooks

Connections

Constants

Log Management

Error Handling Endpoint

Monitor Your Tasks

Asana Webhook

Google Calendar Webhook

Microsoft Mail Webhook

Quickbooks Webhook

Slack V2 Webhook

Stripe Webhook

Square Webhook

Twitter Webhook

Xero Webhook

Zoom Webhook

Webhooks Setup

Core API Functions

Core Multi

Core Bulk

Append to Delimited List

Base64

Clean HTML

Define Text

Extract Emails

Extract URLs

Parse URL

Multi Replace

Multi Switch

Name value to JSON Object

Sentence Case

Replace

SHA256

Split

Split To JSON

Switch

Trim

Text Before

Text After

Uppercase/Lowercase

Text

Average

Evaluate Math Expression

Number 

Multi

Append or Merge Two Lists

Best Non Empty match

Convert to JSONL

Convert to CSV

Convert From CSV

Combine by Index

Combine Lists By Key

Combine One to Many

Compare Two Lists (Text List and JSON)

Convert List Format

Convert to flat JSON

Convert List To JSON (Based on Values)

Convert List To JSON Output

Convert to Paged List

Define List

Extract List From JSON

Filter JSON Objects from a JSON List

JSON to Property List

List to HTML Table

Merge Two JSON Object Lists on Key

Sort

Splice

Sum JSON Objects

Summarize by Group

To Separated Text (From Text OR JSON List)

To Text List

Transform Grouped List to a Flat List

List

Add units to Date

Difference between two dates

Format Date

Split Date (Define)

DateTime

Convert JSON to NameValue

Convert YAML to JSON

Convert JSON to YAML

Convert JSON To XML

Convert XML to JSON

Add Property to JSON

Best Match (Multiple)

Convert a JSON Object from one format to another

Convert JSON Object to Text

Convert JSON Text to JSON Object

Fetch JSON Node or List based on XPath Query

JSON to HTMLTable

Merge Two JSON Objects

JSON

Core APIs

Invite Users

Access Management

SECURITY

Manage Account

Analytics

Request APIs

Request Provider

Convert Binary .xlsx to JSON

API Definition