Consuming Visualization Data

  1. Run any SELECT statement.
    You get JSON data in the following format:
    {  "queueDuration":1,"queryDuration":175,"results":[ {"resultSet":true,  "data":[   {  "name":"user1","address":"santa clara" }, {  "name":"user2","address":"san jose" }  ],  "rowCount":12,  "rowLimitExceeded":false   }]
    }
    
  2. In the script code, add $$$$$$ where you want the data you extracted to be inserted at runtime.
    For example:
    <html>
    <head>
    <meta content='text/html; charset=utf-8' http-equiv='Content-Type' />
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
    </head>
    <body>
    <script type='text/javascript'>$(document).ready(function() {var data = $$$$$$;$('div p').text(JSON.stringify(data)); //converting the data to string for display});
    </script><div style="width: 100%; height: 100%; width: 100%;">  <p></p></div>
    </body>
    </html>

results matching ""

    No results matching ""