ChEMBL / MySQL tables

A simple ajax (JSONP) request to the data API using jQuery.

  var data = {
    resource_id: 'f6adcc49-1681-455b-b216-e23f8086db6d', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
  };
  $.ajax({
    url: 'http://thedatahub.org/api/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
      alert('Total results found: ' + data.result.total)
    }
  });

import urllib
url = 'http://thedatahub.org/api/action/datastore_search?limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()