1

I am getting results from CURL JSON. but I don't know how to get particular data from the results.

I want to filter the 1st Data from this results and time_Stamp is not in time format.

Please help me in query / filter data and time format.

My Program is as follows:

package IOT;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;

import com.google.gson.Gson;
import com.google.gson.GsonBuilder;
import com.google.gson.JsonElement;
import com.google.gson.JsonParser;    

public class NetClientPost {

    // http://localhost:8080/RESTfulExample/json/product/post
    public static void main(String[] args) {

      try {

        URL url = new URL("https://api.datonis.io/api/v2/datonis_query/sensor_event_raw_data");
        HttpURLConnection conn = (HttpURLConnection) url.openConnection();
        conn.setDoOutput(true);
        conn.setRequestMethod("POST");
        conn.setRequestProperty("Content-Type", "application/json");
        conn.setRequestProperty("X-Auth-Token", "PnR9l96XZnrL3xyoYxuM9g");

        String input = "{\"sensor_key\":\"6f2159f998\",\"from\":\"2016/08/29 16:55:00\",\"to\":\"2016/08/29 17:05:00\",\"time_zone\":\"Mumbai\",\"per\":20,\"metrics\":\"1st Data\"}";

        OutputStream os = conn.getOutputStream();
        os.write(input.getBytes());
        os.flush();

        //if (conn.getResponseCode() != HttpURLConnection.HTTP_CREATED) {
            //throw new RuntimeException("Failed : HTTP error code : "
                //+ conn.getResponseCode());
        //}

        BufferedReader br = new BufferedReader(new InputStreamReader(
                (conn.getInputStream())));

        String output;
        System.out.println("Output from Server .... \n");
        while ((output = br.readLine()) != null) {
            //System.out.println(output);    

            Gson gson = new GsonBuilder().setPrettyPrinting().create();
            JsonParser jp = new JsonParser();
            JsonElement je = jp.parse(output);
            String prettyJsonString = gson.toJson(je);          

            System.out.println("Connection Status2: "+ prettyJsonString);    
        }

        conn.disconnect();

      } catch (MalformedURLException e) {

        e.printStackTrace();

      } catch (IOException e) {

        e.printStackTrace();    
     }    
    }    
}

//package com.objectplanet.chart.testing; 

Also I have posted my results here as follows: Output from Server ....

Connection Status2: {
  "6f2159f998": {
    "total_event_count": 2666,
    "page_number": "1",
    "event_data": [
      {
        "time_stamp": 1472483225,
        "data": {
          "1st data": 20
        }
      },
      {
        "time_stamp": 1472483220,
        "data": {
          "1st data": 20
        }
      },
      {
        "time_stamp": 1472483215,
        "data": {
          "1st data": 20
        }
      },
      {
        "time_stamp": 1472483210,
        "data": {
          "1st data": 20
        }
      },

I want to filter the 1st Data from this results and time_Stamp is not in the correct format

ekad
  • 14,436
  • 26
  • 44
  • 46

0 Answers0