hostadd.blogg.se - Delphi rest client download file

#Delphi rest client download file generator#
#Delphi rest client download file full#
#Delphi rest client download file code#

Each SQL statement is executed separately and its result is added to an TFDMemTable. AggregateSQLĪggregate SQL is a collection of SQL statements which are all executed and returned in a single response. The Params field can be used to define parameters such as PageId and Limit. SQL will automatically execute the set SQL statement via TFDQuery and return FireDAC JSON when the endpoint is requested. Table will automatically return a database table from an endpoint via TFDTable as FireDAC JSON. These Actions include Table, SQL, AggregateSQL, and Method. There are a number of actions that can be taken when an Auto Tables endpoint is requested.

DELETE Actions include Table, SQL, AggregateSQL, and Method. A DELETE SQL statement will be executed to delete the auto increment id that was passed to the endpoint. If you set Request Type to DELETE the defined endpoint will require an auto increment field (ID) parameter to be passed to it.

AggregateSQL – SQL field will be used to execute a SQL query list and return the results.

SQL – SQL field will be used to execute a SQL query and return the result.

Table – TableName field will be used to append or edit submitted records.

If the auto increment field (ID) is greater than zero Auto Tables will edit and replace the existing record with that auto increment id using the data from the submitted row. If the auto increment field (ID) is zero Auto Tables will create new records with the submitted rows. The FireDAC JSON will be loaded into an TFDMemTable. POST Actions include Table, SQL, AggregateSQL, and Method. If you set Request Type to POST the defined endpoint will expect a FireDAC JSON format to be submitted in the body of the request.

Method – Method field will be used to execute the custom Method.

AggregateSQL – SQL field will be used to execute the SQL query list and return the results.

SQL – SQL field will be used to execute the SQL query and return the result.

#Delphi rest client download file full#

Table – TableName field will be used to return the full database table.

GET Actions include Table, SQL, AggregateSQL, and Method. If RequestType is set to GET then a standard HTTP/HTTPS request with a query string coming in will trigger that request. Request TypesĪuto Tables makes the GET, POST, and DELETE HTTP/S request types available as endpoints in RAD Server. By utilizing version numbers you can run different versions side by side and eventually depreciate older versions. when you release different versions of the same API. The default name is v1 for version 1 but you can change it to v2, v3, v4 etc. You can utilize the ResourceName segment to create different versions of your API. Parameters are passed in via the query string. EndPointsĪuto Tables endpoints utilize a ResourceName for the root segment and then a single dynamic segment for the specific endpoint.

#Delphi rest client download file code#

The OpenAPI 2.0 api spec file allows you to generate clients for your REST API in the following languages: ActionScript, Ada, Apex, Bash, C#, C++, Clojure, Dart, Elixir, Elm, Eiffel, Erlang, Go, Groovy, Haskell, Java, Kotlin, Lua, Node.js, Objective-C, Perl, PHP, PowerShell, Python, R, Ruby, Rust, Scala, Swift, Typescript Check out and download the full Auto Tables for RAD Server source code in Delphi 10.2 Tokyo over on Github. AutoTables for RAD Server outputs a Delphi RAD Server project, a Delphi REST client project suitable for LiveBindings, a Delphi REST SDK, an OpenAPI 2.0 api spec file, and a Swagger UI documentation interface. This gives you the freedom to enhance and modify the source code as needed for your own solutions. The configuration format is the standard FireDAC JSON.įull source code for the Auto Tables RAD Server ResourceModule is provided so you control your REST API server. Once you configure your endpoints you can either generate a new RAD Server project or you can save them out for loading into an existing Auto Tables for RAD Server ResourceModule. It provides powerful API generation functionality rivaling that of DreamFactory, LoopBack, and Sandman without the complexity.Ī graphical Auto Tables for RAD Server Endpoint Editor is provided to help you set up, create, and edit your Auto Tables for RAD Server endpoints. Additionally, you can automatically generate endpoints for over 80 more data sources using the Embarcadero Enterprise Connectors. Database tables can be made available with enterprise permissions for over 30 different databases including databases such as MySQL, Microsoft SQL Server, and InterBase. Everything can be generated from your database tables in just a few clicks. The easy to use interface allows for the quick automatic configuration of a REST server and client SDK with dynamic endpoints providing read, write, and delete access to your data.

#Delphi rest client download file generator#

Auto Tables is an automatic low code REST API generator for RAD Server.