Simple document-based SQL and REST API client interfaces

In 2023, several basic document types can be extended with open-source PHP technologies to enable dynamic interactions with SQL databases or REST APIs.

PHP scripts make it easy to connect to and interact with data in near real-time.

FileMaker, Excel, Sheets, and Acrobat documents all have native functions that can merge user-supplied parameters (ABC123) into URLS that call PHP scripts...

Depending on the parameters, the PHP script can execute a SQL query or a transaction, perform a look-up, call a stored procedure, run a series of KPI or aggregate queries, interact with APIs, or trigger another script, and then insert a filtered response back into the document as a single value or array of values.

Efficient 2-way data interactions, modeled, connected, and executed from document-based interfaces that calculate, query, and programmatically process responses from multiple disparate data sources in near real-time.

Documents retain native capabilities and can be shared in a variety of ways, and any document can interact with unlimited SQL databases or REST APIs.

Compared to Zapier, Make, Cdata... UTILIZING DOCUMENT-BASED INTERFACES REDUCES OR ELIMINATES DEPENDENCIES, FEES, RESTRICTIONS, AND SECURITY CONCESSIONS. Simple, efficient, low-code, mechanical client-server connection, interaction, and automation methods using open-source technologies. Simple is good, take a look!


PHP is popular open-source server-side technology, available on roughly 80% of web servers. PHP Data Objects (PDO) and cURL code libraries DRASTICALLY simplify data interactions with SQL databases or REST APIs. PHPRunner interfaces provide secure Create-Read-Update-Delete controls for MySQL, SQL Server, Oracle, PostgreSQL, or DB2 databases and can also create authentication-enabled REST API endpoints for these database types.

Claris FileMaker

FileMaker documents can calculate and execute URLs that use PDO and cURL to interact with SQL databases and APIs. FileMaker additionally provides an advanced multi-user development environment, ideal for building bespoke programmable controls and data processing interfaces that can be securely shared via Apple or Windows desktop application, WebDirect web browser or mobile forms, or the FileMaker Data API.

Excel & Sheets

Microsoft Excel and Google Sheets spreadsheet documents can also use calculations and native functions to execute PHP scripts that interact with SQL databases and REST APIs. PHP scripts can filter and return scalar or aggregate query results back to active cells in a variety of formats. For instance, Excel dynamic arrays are generated with XML-formatted results, Sheets dynamic arrays are generated with HTML-formatted results.

PDO can interact with lots of popular databases

cURL can interact with practically any REST API

Depending on the document type, you can...

insert real-time
SQL or REST API query results to spreadsheet calculations...

share calculating web forms that merge data from distributed and disparate sources...

execute key performance indicator or complex aggregate queries in real time...

add dynamic
SQL CRUD or REST API functionality to spreadsheets or
PDF forms...

deploy extraordinarily well connected desktop and mobile workgroup applications

Extremely low-code, easy to understand

No VBA, xDBC, proxies, or SaaS dependencies

Run from your servers, you own the code

“Extremely efficient, ridiculously cost-effective.”

“Simplified, lightness added.”

“That is way less complicated. Thanks."

Web-enabled desktop or mobile interfaces, simple deployment, minimized dependencies, integrating disparate technologies to build simple or complex data automation solutions.

Take a look at the examples at the top of the page and e-mail with any questions. Thanks!