YQL open api

Many of the developers knows that the yql is well structured open api which can be used to retrieve the stock rates,photographs from flicker ,tweets of the person,statuses of the facebook etc. I dealt with this api and found it very beneficial for making the applications in various fields whether it is an app related to social networking entertainment and many if you want to use the yql you have to just query its database through the link and then it will return you the data either in the json(java script object notation) or in the xml format to view its console you can go here YQL console.

private static String convertStreamToString(InputStream is) {

        /*

         * To convert the InputStream to String we use the BufferedReader.readLine()

         * method. We iterate until the BufferedReader return null which means

         * there's no more data to read. Each line will appended to a StringBuilder

         * and returned as String.

         */

        BufferedReader reader = new BufferedReader(new InputStreamReader(is));

        StringBuilder sb = new StringBuilder();

 

        String line = null;

        try {

            while ((line = reader.readLine()) != null) {

                sb.append(line + "\n");

            }

        } catch (IOException e) {

            e.printStackTrace();

        } finally {

            try {

                is.close();

            } catch (IOException e) {

                e.printStackTrace();

            }

        }

        return sb.toString();

    }

 

    /* This is a test function which will connects to a given

     * rest service and prints it's response to Android Log with

     * labels "Praeda".

     */

    public void  connect(String url)

    {tv=(TextView)findViewById(R.id.TextView06);

tv1=(TextView)findViewById(R.id.TextView07);

tv2=(TextView)findViewById(R.id.TextView08);

tv3=(TextView)findViewById(R.id.TextView09);

tv4=(TextView)findViewById(R.id.TextView10);

   

        HttpClient httpclient = new DefaultHttpClient();

 

        // Prepare a request object

        HttpGet httpget = new HttpGet(url); 

 

        // Execute the request

        HttpResponse response;

        try {

            response = httpclient.execute(httpget);

            // Examine the response status

            Log.i("Praeda",response.getStatusLine().toString());

 

            // Get hold of the response entity

            HttpEntity entity = response.getEntity();

            // If the response does not enclose an entity, there is no need

            // to worry about connection release

            

            if (entity != null) {

 

                // A Simple JSON Response Read

                InputStream instream = entity.getContent();

                String result= convertStreamToString(instream);

                Log.i("Praedaresult",result);

 

                // A Simple JSONObject Creation

                JSONObject json=new JSONObject(result);

                Log.i("Praedaobject","<jsonobject>\n"+json.toString()+"\n</jsonobject>");

 

                // A Simple JSONObject Parsing

               // JSONArray nameArray=json.names();

                //Log.i("query",nameArray.toString());

                //JSONObject query=json.getJSONObject("query");

                //Log.i("query",query.toString());

                //JSONArray results=query.getJSONArray("results");

                //Log.i("rslts",results.toString());

               // JSONArray quote=results.getJSONArray("quote");

                //JSONObject quote=results.getJSONObject("quote");

                //Log.i("quote",quote.toString());

                JSONObject query=json.getJSONObject("query");

                Log.i("query",query.toString());

                JSONObject results=query.getJSONObject("results");

                Log.i("rslt",results.toString());

                JSONObject quote=results.getJSONObject("quote");

                Log.i("quote",quote.toString());

                for(int i=0;i<quote.length();i++)

                {

               

//                    Log.i("Praedafor","<jsonname"+i+">\n"+nameArray.getString(i)+"\n</jsonname"+i+">\n"

//                            +"<jsonvalue"+i+">\n"+valArray.getString(i)+"\n</jsonvalue"+i+">");

                //JSONObject quotes = results.getJSONObject(i)

                    //.getJSONObject("quote");

//                 Log,i

                //Log.i("name",quote.getString("Name"));

                //Log.i("name","pahunch");

                //Log.i("name",quote.getString("Symbol"));

               

                //Log.i("name",quote.getString("DaysLow"));

               

                //Log.i("name",quote.getString("DaysHigh"));

               

                //Log.i("name",quote.getString("Open"));

               

                //Log.i("name",quote.getString("PreviousClose"));

                String symbol=quote.getString("Symbol");

                tv.setText(symbol);

                String dayslow=quote.getString("DaysLow");

                tv1.setText(dayslow);

            //tv1.setText(quote.getString("DaysLow"));

            tv2.setText(quote.getString("DaysHigh"));

            tv3.setText(quote.getString("Open"));

            tv4.setText(quote.getString("Change"));

                }

 

                // A Simple JSONObject Value Pushing

                //json.put("execution-start-time", "sample value");

                Log.i("Praeda","<jsonobject>\n"+json.toString()+"\n</jsonobject>");

                //Log.i("Praeda12",json.get("").toString());

 

                // Closing the input stream will trigger connection release

                instream.close();

            }

 

 

        } catch (ClientProtocolException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        } catch (IOException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        } catch (JSONException e) {

            // TODO Auto-generated catch block

            e.getMessage();

        }

        

    }

 

}

Its a simple call to the url and how to retrieve the data from the json format hope it would be beneficial for you if any queries then you can drop a comment.!!!!!!!!