Today in APIs: Google Fusion Tables, Useful foursquare and 21 New APIs

Google has some big changes for its database-like Google Fusion Tables API. Conference agenda site Lanyrd is using the foursquare API to make event check-ins more useful. Plus: PadMapper finds a Craigslist API, ESRI buys a mapping startup and 21 new APIs.

Google Deprecates Fusions Tables SQL, Releases RESTful API

There were plenty of Google API announcements at its I/O conference, so apparently a big update to the Fusion Tables API went un-noted:

Amidst all the excitement of I/O followed by the July 4th holiday in the U.S., many developers missed the announcement of the new Fusion Tables API. The new API includes all of the functionality of the existing SQL API, plus the ability to read and modify table and column metadata as well as the definitions of styles and templates for data visualization. This API is also integrated with the Google APIs console which lets developers manage all their Google APIs in one place and take advantage of built-in reporting and Authentication features.

It's a major change, but seems a step in the right direction. There have been other APIs that back-peddled on SQL-like syntax, including the Facebook API when it downplayed its FQL in favor of the Facebook Graph API.

The SQL version of Google Fusion Tables will be supported for the next six months (roughly through the end of 2012).

Did foursquare at Conferences Just Get Useful?

There may not be a Lanyrd API, but the company is at least using APIs. Co-founder Simon Willison tweeted about integrating with foursquare:

Going to ‪#uxbri‬ or ‪#brightonpy‬ this evening? Connect Lanyrd to foursquare before checkin to help test our new feature

Lanyrd is in the foursquare gallery. When users check in with Lanyrd, they can retrieve details of the event they're attending.

API News You Shouldn't Miss

21 New APIs

Today we had 21 new APIs added to our API directory including an avatar hosting service, online gambling Platform, bitcoin payment processor, travel booking service, and geolocated video sharing platform. Below is more details on each of these new APIs. API: is an avatar hosting service. It is designed for Integration with mobile apps and websites. Developers can use the to host the avatars their users assign themselves. After they are uploaded, the avatars can be retrieved at different sizes. is fully compatible with Gravatars and social media sites like Twitter, Instagram, and Facebook. The entirety of functionality is a RESTful API that exposes avatar upload and retrieval. It returns JSON-formatted data.

BetableBetable API: Betable is an online gambling platform that handles the regulation of the gambling industry, as well as the gaming logic based on inputs from developers. The betable API allows developers to incorporate real-money gambling into their games, mobile apps and websites.

Developers can include games of chance, games of skill and player-on-player games. Though the classic casino games are most common, Betable has abstracted the gaming engine so many types of games can be made to incorporate gambling.

The API uses OAuth to authenticate to a user's mobile wallet. The API uses REST, with data returned as JSON.

Bit-PayBit-Pay API: Bit-Pay is a bitcoin payment processing service. They provide bitcoin payment gateways for a variety of merchants, ranging from non-profits to independent contractors. Bit-Pay allows these merchants and others to exchange payment in bitcoins into currencies such as the Euro and USD, and vice versa. The Bit-Pay API is designed for shopping cart integration, third party payment processing, and power users. It is a RESTful API that exposes the Bit-Pay’s essential money-transferring functionality. The data it returns is JSON-encoded.

BitDeliBitDeli API: BitDeli provides data processing solutions. Developers can employ BitDeli to automate and process their datafeeds. The data intake can be customized and analyzed in real time. The BitDeli dashboard allows developers to visualize their results in multiple ways. The BitDeli API exposes the data input and output functionality. It is a RESTful API that returns JSON-encoded data. BitDeli offers an extensive gallery of their API put use for inspiration.

BonFIREBonFIRE API: BonFIRE is consortium dedicated to researching cloud computing. It is comprised of academic and non-academic research institutions, business enterprises, technology analysts, and others. Their goal is to advance and develop cloud services for the Internet of Services community. BonFIRE currently maintains six testbeds of cloud services across Europe and the UK. They offer a RESTful API for developers to access those testbeds and query them for resources. The API returns XML-encoded results.

CleverClever API: Clever is an education-oriented data organization tool. Intended for developers of software developers and school administration, Clever provides data processing, organizing, integration, and security for student information. Administrators and teachers can upload student information to Clever once and share that information with other enabled systems and apps. The Clever API exposes the Clever’s information retrieval functionality. It is a RESTful API that returns JSON-encoded data.

CloudantCloudant API: Cloudant is a data solutions provider. Businesses and research institutions can use their data layer to develop their data management operations. It is a scalable platform that supports data-replication, synchronization, analytics, and more. The Cloudant API exposes the database functionality. It is a RESTful API that allows developers to request information from all of the datasets they have access to and returns JSON-formatted data.

CupónicaCupónica API: Cupónica is a daily deal marketplace for Latin American localities. It provides lead-generation for local businesses and coupons to local businesses for consumers. Businesses can use the marketplace to engage socially engage customers. Consumers can browse for deals to their favorite or new local businesses. Cupónica offers a RESTful API that exposes the daily deal functionality, allowing developers to categorically access information about new offerings. The API returns XML-encoded data. The website is in Spanish.

FullCourt VoiceFullCourt Voice API: FullCourt is a telephony app that connects mobile devices with web services. It transmits voice and other web-based messaging system to apps. The FullCourt service is a RESTful API that can be scaled and recombined to fit each developer’s particular needs. The API exposes the service’s entire telephony functionality. Developers can use the API to send call requests and retrieve user information. The API returns XML-encoded data.

JacTravelJacTravel API: JacTravel is a tourism and hospitality services provider. With an extensive network of hospitality-related enterprises around the globe, JacTravel offers a wide range of lodging solutions. They inspect their partners’ locations individually and help tour operators and retailers find and book the most appropriate lodgings. Their API allows retailers to integrate JacTravel searches directly into their websites. The API returns XML-encoded results.

KinomapKinomap API: Kinomap provides geolocation solutions for video-making. Users who films of their travels, bike rides, or runs can create maps that track the route of their journey. With their smartphones or GPS-enabled cameras and upload them directly to Kinomap through a downloadable app. Kinomap then hosts the videos online on their media-sharing platform. Kinomap offers APIs for uploading videos, embedding videos, and accessing data. The APIs are RESTful and return data encoded in XML and JSON.

Latakoo FlightLatakoo Flight API: The Lakatoo Flight API allows uses to send,store, and share large video files (HD or SD) over the internet. The API allows for integration of Lakatoo Flight into user applications. Using the REST protocol and returning JSON, users can securely send files using SSL supported calls.

The public Lakatoo API is currently in beta, Documentation is available on request.

Loc8Loc8 API: Loc8 is a geolocating service for mobile apps. It provides pan-India coverage for determining the latitudinal and longitudinal coordinates of mobile phones without GPS-enablement. With Loc8 incorporated into their apps, developers can see what cell towers their users are near. This information is shared via Loc8’s RESTful API. The API allows developers to integrate the locational functionality into their apps code. The API responds in GeoJSON.

NameSiloNameSilo API: NameSilo is a domain registrar service. They provide domain management services and tools to businesses, individuals, web designers, and others. From among their tools, users can secure their domains, manage their domain portfolio, update layouts, and earn revenue. NameSilo provides a RESTful API that exposes the entirety of services, allowing web developers to integrate numerous domain management functions to their backend or content management software. The API returns XML-encoded data.

PlagScanPlagScan API: PlagScan is a plagiarism detection service for schools, universities, and businesses. Users begin by uploading text documents to their scanning service. PlagScan will check the content against an internal database and Internet sources. Users can also scan entire zipped directories at once. The RESTful PlagScan API exposes the essential content-comparing functionality for integration with other content-management systems. Users can submit and check files and receive XML-formatted data.

SixFinancialSixFinancial API: The SixFinancial API gives users access to the market data and pricing services offered by SixFinancial. API integration provides access to price quotes, reference data, corporate actions, sector codes, ratings, business news, and term sheets. The API is available in both XML and Java formats.

TextBeltTextBelt API: TextBelt is a telephony service. It provides outgoing SMS services for developers. TextBelt uses carrier-specific gateways to forward free SMS’s without advertisements. It can be used for testing SMS functions instead of Twilio. It supports a large variety of U.S. providers, including Alltel, Verizon, Virgin Mobile, and many more. The entire TextBelt service is a RESTful API that sends messages and responds with success or failure notices.

Transfluent Transfluent API: Transfluent provides language translation solutions. It is designed for businesses and other organizations to communicate with a multilingual audience. Transfluent employs native, professional translators and offers near real-time returns. Transfluent offers an API for integrating translation requests and retrieval with backend software. Developers can Feed it phrases and language codes to specify what translations they want. It is RESTful and returns JSON.

VirusTotal VirusTotal API: VirusTotal is a malware detection service. It runs an aggregate of scanners and antivirus engines to provide analyses of potentially harmful files and sites. Users can upload files or submit URLs to VirusTotal to be scanned for worms, viruses, trojans, and more. VirusTotal also maintains a blacklist of files and URLs known to be harmful. The VirusTotal API exposes the information generated by its scanners to developers for integration and third-party access. The API is REST-based and returns JSON-formatted data.

VoiceboxVoicebox API: Voicebox is a data visualization project. Produced by vInspired, a network that connects to young people to volunteering opportunities in the UK, Voicebox collects information about young peoples’ opinions and draws insightful visuals and conclusions. The data set collected by the Voicebox project is publically available to interested parties. The Voicebox API exposes the data retrieval functionality of this offering. It is a RESTful API that returns XML-encoded data.

Wi-FlightWi-Flight API: The Wi-Flight API allows users to access bulk data from flights, integrate a dispatch and reservation system to Wi-Flight, as well as construct additional Front-end functions. The API uses the rest REST protocol and returns data in XML format. Most operations of the service require that clients be logged in, but certain public data is accessible without log in.