Managed Hosting



Project Home Blog Forums Wiki Known Issues Screenshots External Project Link Contact Project

Author: Luiz Milfont (All RIAForge projects by this author)
Last Updated: January 25, 2016 6:16 AM
Version: 1.1.2
Views: 38,954
Downloads: 539
License: MIT


CFapi dynamically creates APIs instantly, at the hit of a button. Allows production of REST-JSON/SOAP-WSDL/CSV/KML/GeoJSON/XML and Google Protocol Buffers (binary) APIs by just providing a Coldfusion database connection, and a name of a database view or table. From version 1.0.9 also allows CSV files as source for datasets! CFapi is based on ETL (Extract, Transform and Load) and anticipated consuming technic, which means that a Coldfusion Scheduled Task will query your database from time to time and put the data into RAM memory to expose it to your API consumers in variable formats. This means that data will always be available in optimized way and database will not be queried every time an user makes a request, allowing blazing fast responses and low overheaded databases. For the developer, CFapi means an instant way to deliver a complete API, ready to be deployed to the server. Just fill in the form, providing details of you database system and CFapi will create the classes, methods, webservices, entry points, everything you would take hours to do by hand in another way. CFapi is the perfect companion for CKAN or Socrata open data systems and also great to create Android, IPhone and Windows Phone mobile application back-ends.

Last Update:

1.1.2 Generate separate data gateway files (one for each dataset) to allow easier server deployment of generated APIs without overwrites.

Put all the fields inside every format. All formats now expose the data in the same way.

Bug solved: If two dynamic generated APIs resided on the same server and had identical named datasets, they were spoiling each otherĀ“s cached contents. Added apiName identifier to cache names.

Now developer can choose if wants to generate API from database only or also from CSV files.

Now CSV files sourced datasets also generate Google Protocol Buffers output.

New feature allows user to review or evaluate API exposed items, rating them with stars and comment.

1.1.1 Corrected to make Google Protocol Buffers
also work on Railo and Lucee.


A database connection and a Coldfusion datasource defined in Coldfusion Administrator or CSV text files. A database view or table with the data you want to expose or CSV text files. CFapi also uses Javaloader and GSON library. From version 1.0.1 is compatible with Railo/Lucee Server. For Google Protocol Buffers a Windows machine is needed (because of protoc.exe).

Issue Tracker:

5 Java compiler not found on Lucee Server Fixed 12/21/15 11:17 AM
4 Android App should be separate project or optional Closed 11/10/15 10:50 AM
3 Changing version on main form generates a file not found error Closed 10/21/15 5:57 AM
2 Some GeoJSON are being generated corrupted Fixed 10/20/15 8:37 AM
1 Railo incompatibility Fixed 10/16/15 12:16 PM

View All Issues

To enter issues for this (or any other) project, you must be logged in.

Subversion Access:

You may access this project's Subversion repository with your client here: http://svn.riaforge.org/CFapi.

To view files and changelists associated with this repository, go here: http://CFapi.riaforge.org/index.cfm?event=page.svnbrowse.

Anonymous users have read access to the repository while the administrator has write access.

This project is sharing its code via Subversion. Subversion is an open source source control method. You may find more information about Subversion here: http://subversion.tigris.org/