Today in APIs: Google BigQuery Goes JSON, Yahoo PlaceFinder and 16 New APIs

" JSON is the data format of the web," begins the Google blog post announcing that JSON has come to its service for large datasets. And has Yahoo already upgraded its PlaceFinder to v2? Plus: YouTube shares some cool apps, $3 million healthcare contest and 16 new APIs.

BigQuery: JSON Joins CSV

Google skipped right past XML when deciding on a format to add to its Google BigQuery API. In the announcement post the search giant explains why it's useful for large datasets:

Google BigQuery, our cloud service for ad-hoc analytics on Big Data, has now added support for JSON and the nested/repeated structure inherent in the data format. JSON opens the door to a more object-oriented view of your data compared to CSV, the original data format supported by BigQuery. It removes the need for duplication of data required when you flatten records into CSV.

Previously BigQuery only supported CSV for import. The API itself supports JSON only.

Yahoo PlaceFinder Launching V2 Prematurely?

Last week Yahoo announced a PlaceFinder transition. The service operated as a free geocoder in the Yahoo PlaceMaker API would become part of the paid Yahoo BOSS search API.

Now some developers are reporting that the change is already here, with apps already receiving errors.

$3 Million to Improve Healthcare

Developers interested in the Heritage Health Prize should register before Thursday, October 4, when no new competitors and teams will be admitted. Register now, compete later. The competition ends in April.

API News You Shouldn't Miss

16 New APIs

Today we had 16 new APIs added to our API directory including a secondary ticket broker Platform, barcode creation service, medical research text mining service, international SMS service, usability testing service and photo enhancement application. Below is more details on each of these new APIs.

Bank of Lithuania PaymentsBank of Lithuania Payments API: The Bank of Lithuania (Lietuvos Bankas) is the central bank of the Republic of Lithuania. The Bank of Lithuania Payments API enables users to perform checks against the dictionaries of payment systems and the dictionaries of securities settlement systems. This API uses SOAP calls issued in XML format. The Bank of Lithuania's website and API Documentation are available in both English and Lithuanian.

Bank of Lithuania StatisticsBank of Lithuania Statistics API: The Bank of Lithuania (Lietuvos Bankas) is the central bank of the Republic of Lithuania. The Bank of Lithuania Statistics API provides users with SOAP-based access to information on the bank's official foreign currency exchange rates as well as the current and historical loan interest rates, state of liquidity indicators, and VILIBID and VILIBOR interest rates.

The Bank of Lithuania's website and API documentation are available in both English and Lithuanian.

Broker VisionsBroker Visions API: Broker Visions offers solutions for the secondary ticket market through a cloud based platform. The Broker Visions API provides a RESTful interface for customers to integrate Broker Visions features such as real-time ticket exchange and purchase, ticket selection and seating charts, and event search.

CodeGenerateCodeGenerate API: CodeGenerate is a free service where users can create barcodes and QR codes for advertising and packaging. The site offers free updates every time new features are added, and users can save created barcodes. The CodeGenerate API allows users to integrate the barcode functionality into third party systems to easily create barcodes using REST calls.

The API is currently in Beta, contact CodeGenerate for documentation and access.

CoPubCoPub API: The service provides search and text mining within the MedLine database of published literature on medical and biological research. It identifies occurrence of text specified by the searcher and detects combinations of biomedical concepts within the same abstract. This Function returns results that are highly targeted to the combination rather than merely mentioning individual terms or concepts.

API methods support search for a single term with or without association with specified categories from a controlled list. Methods also support matches for a pair or a larger group of terms, with possible filters for fields where the terms co-occur and category matches.

Msg2sendMsg2send API: Msg2send is an international web SMS provider that helps businesses connect directly with mobile users through SMS marketing, enables users to respond with keywords, manage contact lists and set up to auto respond to users requests, and many other features. The API allows customers to send customized messages through the API endpoints as well as integrate the Msg2send features with third party applications. The Msg2send API uses REST calls.

OpenHallwayOpenHallway API: OpenHallway is a usability testing service that was created to make the web more usable. The site allows users to create a test scenario for a website, send the link to a participant, then record the audio and the video from the users during the test. Results are then available for review and sharing. The OpenHallway API allows users to integrate screen recording technology into third party applications. Premium Account required for API access and documentation available on request.

PassSlotPassSlot API: PassSlot is a service for developers for Passbook Integration with their applications. Developers can create passes and tickets for Apple's PassBook.

The PassSlot API allows developers to access and integrate the functionality of PassSlot with other applications and to create new applications. Some example API methods include retrieving passes, creating and editing passes and templates, and retrieving information associated with passes.

Penki Top 100Penki Top 100 API: Penki: Top100 is a system that provides website attendance statistics and analyses thereof. The service keeps track of data such as the number of unique visitors, the most frequently searched terms within the website, visitors' countries of origin, and whether visitors' computers support JAVA. All of this information can be retrieved programmatically using a SOAP API. Top100 offers both free and paid versions of its services. The website is available in three languages: Lithuanian, Russian, and English.

Schenker Norway WebservicesSchenker Norway Webservices API: DB Schenker is a Norwegian shipping service that operates over land, ocean, and air. In addition to regular cargo, it is capable of handling food and other goods that require thermo-regulated transportation. DB Schenker provides webservices that allow users to log in and track an item based on its shipment number, consignment number, or other relevant identifier. Users may also retrieve pricing and timetable information. These functions are available using SOAP calls issued in XML format.

TaggstarTaggstar API: Taggstar is an application that allows users to make their images on websites interactive by adding and embedding videos, text, maps, and other pictures into the images.

The Taggstar API allows developers to access and integrate the functionality of Taggstar with other applications and websites. Example API methods include viewing tags and embeds, disabling and enabling tagging, and suspending embed functions.

TapstreamTapstream API: Tapstream is a service that helps developers identify traffic sources, such as Twitter, application stores, websites, and emails for their applications.

The Tapstream API allows developers to access and integrate the functionality of Tapstream with other applications. The available API method is to tag applications with data to trigger events.

TerraServer Landmark ServiceTerraServer Landmark Service API: TerraServer offers satellite image licenses for print, film, and TV purposes. Customers may browse through the map viewer or look at preselected landmarks and then purchase files, prints, or posters of the desired imagery. TerraServer offers its Landmark Service API to enable users to search for landmarks within a given area. Users can access this service using SOAP calls issued in XML format.

Tiscali Email ServicesTiscali Email Services API: Tiscali Services is the IT engine of the Tiscali Group, an Italian telecommunications company. Tiscali Services provides a collection of email-related APIs that perform functions such as validating e-mail addresses and account passwords, sending emails from a user-selected Simple Mail Transfer Protocol (SMTP) server, and returning the name of the SMTP server for a given domain.

In spite of its Italian origins, the Tiscali Services website is provided to users in English.

TrakQRTrakQR API: TrakQR is a service allowing users to create, manage, and track dynamic Quick Response Codes. Features include a dashboard for managing multiple campaigns and instant analytics. The TrakQR API provides a RESTful interface for customers to build QR Code features into applications.

VideograbberVideograbber API: The service provides a capability to discover the file URLS for video displayed by a specified web page. Documentation specifies a list of dozens of video hosting platforms from which it can capture video, including YouTube and Der Spiegel in Germany. Access to file URLs allows for direct access to the media files rather than through the hosting site's player interface.

API methods allow submission of a video URL on a selection of video hosting sites. Returned data provide basic metadata such as the title and thumbnail image URL along with file URLs for different video quality options (from 1080-pixel HD to 240 pixel) and formats (MP4 and FLV) available.