javascript - calling Google bigquery with service account from JS -


i used below code call gogole bigquery chart js using client account. how configure same script google service account, , have p12 key also, can pass key information.

     <html> <head> <script type="text/javascript" src="https://apis.google.com/js/client.js"></script> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript">     google.load('visualization', '1', { packages: ['geochart'] }); </script> <script>     // update use project id , client id     var project_id = 'xxxxx';     var client_id = 'xxx.apps.googleusercontent.com';      var config = {         'client_id': client_id,                'scope': 'https://www.googleapis.com/auth/bigquery'     };      function runquery() {         var request = gapi.client.bigquery.jobs.query({             'projectid': project_id,             'timeoutms': '30000',             'query': 'select state, avg(mother_age) theav [publicdata:samples.natality] year=2000 , ever_born=1 group state order theav desc;'         });         request.execute(function (response) {             var statevalues = [["state", "age"]];             $.each(response.result.rows, function (i, item) {                 var state = item.f[0].v;                 var age = parsefloat(item.f[1].v);                 var statevalue = [state, age];                 statevalues.push(statevalue);             });             var data = google.visualization.arraytodatatable(statevalues);             var geochart = new google.visualization.geochart(                 document.getelementbyid('map'));             geochart.draw(data, { width: 556, height: 347, resolution: "provinces", region: "us" });         });     }      function auth() {         gapi.auth.authorize(config, function () {             gapi.client.load('bigquery', 'v2', runquery);             $('#client_initiated').html('bigquery client initiated');         });         $('#auth_button').hide();     } </script> </head>  <body> <h2>average mother age @ first birth in 2000</h2> <button id="auth_button" onclick="auth();">authorize</button> <button id="query_button" style="display:none;" onclick="runquery();">run query</button> <div id="map"></div> </body> </html>

i got know google bigquery documentation - because of security reasons form js can't able use service accounts.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more