e-mail : customdataservicesinfo@gmail.com
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...
https://yourserver.net/customerquery.php?accountnumber=ABC123
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.
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.
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.
