Dynamic SQL and REST API interfaces

Looking for simple and efficient ways to work with distributed data?

FYI, FileMaker, Excel, Sheets, and Acrobat all provide native functions that can merge user-supplied variables into URLs that load and trigger PHP scripts.

https://customdataservices.net/customerquery.php?customerNumber=242

Depending on the variables, the PHP script can execute a single SQL query or a transaction, perform a look-up, call a stored procedure, run a series of complex aggregate queries, interact with a REST API, or trigger another script, and then filter, format, and return a response as a single value or a multi-value array.

Ultra low-code 2-way data interactions, executed from document-based interfaces, that can connect to, query, filter, calculate, re-calculate, and merge data from multiple disparate SQL databases or REST APIs in near real-time.

Interfaces can be extended with additional capabilities depending on type. FileMaker, in particular, provides extremely versatile data processing options.

Regardless of type, any interface can interact with unlimited data sources.

PHP, PDO, cURL

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

Claris FileMaker

FileMaker interfaces 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 or mobile forms, or the FileMaker Data API.

Excel & Sheets

Microsoft Excel and Google Sheets spreadsheet interfaces can also utilize PHP scripts to execute SQL and REST API queries, using PDO and cURL to interact with data services and filter results back to active spreadsheet cells and formulas. Excel spreadsheets work best with queries that return scalar or aggregate results in JSON or XML. Sheets provides the ability to insert HTML-formatted query results in to spreadsheets as dynamic arrays. Nice!






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 3rd-parties, dependencies, concessions



Run from your server, you own the code



“Extraordinarily 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!