Having trouble extracting the date modified from a JSON file

Question

Having trouble extracting the date modified from a JSON file

I am able to retrieve section name, URL, web title, and headline from parsing JSON data with this code snippet. However, I seem to be encountering an issue where I cannot extract the last modified date. Here is the JSON structure:

{  
   "response":{  
      "status":"ok",
      "userTier":"developer",
      "total":368,
      "startIndex":1,
      "pageSize":10,
      "currentPage":1,
      "pages":37,
      "orderBy":"relevance",
      "results":[  
         {  
            "id":"technology/2017/may/24/fitness-trackers-out-of-step-when-measuring-calories-research-shows",
            "type":"article",
            "sectionId":"technology",
            "sectionName":"Technology",
            "webPublicationDate":"2017-05-24T15:00:24Z",
            "webTitle":"Fitness trackers out of step when measuring calories, research shows",
            "webUrl":"https://www.theguardian.com/technology/2017/may/24/fitness-trackers-out-of-step-when-measuring-calories-research-shows",
            "apiUrl":"https://content.guardianapis.com/technology/2017/may/24/fitness-trackers-out-of-step-when-measuring-calories-research-shows",
            "fields":{  
               "headline":"Fitness trackers out of step when measuring calories, research shows",
               "lastModified":"2017-05-24T15:02:19Z",
               "thumbnail":"https://media.guim.co.uk/8d3e17604195078ec89e20329e2ddc5027eca8ea/0_213_6362_3817/500.jpg"
            },
            "isHosted":false
         },

Below is my code for parsing the JSON data:

JSONObject response = root.getJSONObject("response");

        if(response.has("results")){

            JSONArray results = response.getJSONArray("results");
            for(int i=0;i<results.length();i++){
                long lastModified=0;
                String headline=null;
                JSONObject details=results.getJSONObject(i);
                String sectionName=details.getString("sectionName");
                Log.i(LOG_TAG,sectionName);
                String webUrl=details.getString("webUrl");
                Log.i(LOG_TAG,webUrl);
                if(details.has("fields")){
                JSONObject fields=details.getJSONObject("fields");
                    if(fields.has("headline")){

                 headline =fields.getString("headline");
                Log.i(LOG_TAG,headline);}
                if(fields.has("lastModified")){
                 lastModified =fields.getLong("lastModified");
                Log.i(LOG_TAG, String.valueOf(lastModified));}}

Despite implementing this code, I am unable to retrieve the last modified date. I am unsure of why this particular information is not being successfully extracted.

javascript java android json

Answer 1

Answer №1

Extracting Json data and retrieving the lastModified timestamp can be achieved with the following code snippet:

public static void parseJsonData(String jsonResponse) {
    try {
        JSONObject baseObject = new JSONObject(jsonResponse);

        if (baseObject == null) {
            return;
        }

        JSONObject responseObj = baseObject.optJSONObject("response");

        if (responseObj == null) {
            return;
        }

        JSONArray resultsArray = responseObj.getJSONArray("results");

        if (resultsArray == null) {
            return;
        }

        for (int i = 0; i < resultsArray.length(); i++) {
            JSONObject resultObj = resultsArray.getJSONObject(i);

            if (resultObj == null) {
                continue;
            }

            String id = resultObj.optString("id", "");
            String type = resultObj.optString("type", "");
            String sectionId = resultObj.optString("sectionId", "");
            String sectionName = resultObj.optString("sectionName", "");
            String webPublicationDate = resultObj.optString("webPublicationDate", "");
            String webTitle = resultObj.optString("webTitle", "");
            String webUrl = resultObj.optString("webUrl", "");
            String apiUrl = resultObj.optString("apiUrl", "");
            boolean isHosted = resultObj.optBoolean("isHosted", false);

            JSONObject fieldsObj = resultObj.optJSONObject("fields");

            if (fieldsObj == null) {
                continue;
            }

            String headline = fieldsObj.optString("headline", "");
            String lastModified = fieldsObj.optString("lastModified", "");
            String thumbnail = fieldsObj.optString("thumbnail", "");
        }

    } catch (JSONException e) {
        e.printStackTrace();
    }
}

If you need to format a date string into a specific pattern, use this method:

public static String formatDate(String inputDateStr) {
    SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssz");

    Date date = null;
    try {
        date = simpleDateFormat.parse(inputDateStr);
    } catch (ParseException e) {
        e.printStackTrace();
    }

    if (date == null) {
        return "";
    }

    SimpleDateFormat convertedDateFormat = new SimpleDateFormat("yyyy-MM-dd");

    return convertedDateFormat.format(date);
}

Answer 2

Extracting Json data and retrieving the lastModified timestamp can be achieved with the following code snippet:

public static void parseJsonData(String jsonResponse) {
    try {
        JSONObject baseObject = new JSONObject(jsonResponse);

        if (baseObject == null) {
            return;
        }

        JSONObject responseObj = baseObject.optJSONObject("response");

        if (responseObj == null) {
            return;
        }

        JSONArray resultsArray = responseObj.getJSONArray("results");

        if (resultsArray == null) {
            return;
        }

        for (int i = 0; i < resultsArray.length(); i++) {
            JSONObject resultObj = resultsArray.getJSONObject(i);

            if (resultObj == null) {
                continue;
            }

            String id = resultObj.optString("id", "");
            String type = resultObj.optString("type", "");
            String sectionId = resultObj.optString("sectionId", "");
            String sectionName = resultObj.optString("sectionName", "");
            String webPublicationDate = resultObj.optString("webPublicationDate", "");
            String webTitle = resultObj.optString("webTitle", "");
            String webUrl = resultObj.optString("webUrl", "");
            String apiUrl = resultObj.optString("apiUrl", "");
            boolean isHosted = resultObj.optBoolean("isHosted", false);

            JSONObject fieldsObj = resultObj.optJSONObject("fields");

            if (fieldsObj == null) {
                continue;
            }

            String headline = fieldsObj.optString("headline", "");
            String lastModified = fieldsObj.optString("lastModified", "");
            String thumbnail = fieldsObj.optString("thumbnail", "");
        }

    } catch (JSONException e) {
        e.printStackTrace();
    }
}

If you need to format a date string into a specific pattern, use this method:

public static String formatDate(String inputDateStr) {
    SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssz");

    Date date = null;
    try {
        date = simpleDateFormat.parse(inputDateStr);
    } catch (ParseException e) {
        e.printStackTrace();
    }

    if (date == null) {
        return "";
    }

    SimpleDateFormat convertedDateFormat = new SimpleDateFormat("yyyy-MM-dd");

    return convertedDateFormat.format(date);
}

Answer 3

Answer №2

The DateTime format being used here is ISO 8601 DateTime, which JSON does not have a specific format for dates/times. If you take some time to search online, you will come across several implementations that can help parse it in Java.

Check out this resource for one of them.

If you are willing to explore alternatives to Java's Date/Time/Calendar classes, I recommend considering Joda Time. They provide various functionalities including the ability to parse strings like these using ISODateTimeFormat.

Answer 4

The DateTime format being used here is ISO 8601 DateTime, which JSON does not have a specific format for dates/times. If you take some time to search online, you will come across several implementations that can help parse it in Java.

Check out this resource for one of them.

If you are willing to explore alternatives to Java's Date/Time/Calendar classes, I recommend considering Joda Time. They provide various functionalities including the ability to parse strings like these using ISODateTimeFormat.

Answer 5

Answer №3

It's important to note that when using the code snippet
lastModified =fields.getLong("lastModified");
, it might be more appropriate to utilize getString() instead. This is due to the fact that your lastModified date appears to be of String Type.

Answer 6

It's important to note that when using the code snippet
lastModified =fields.getLong("lastModified");
, it might be more appropriate to utilize getString() instead. This is due to the fact that your lastModified date appears to be of String Type.

Answer 7

Answer №4

This Java program defines a class for handling news articles.


public class News {
    private String title;
    private String sectionName;
    private String url;
    private String date;

    // Constructor
    public News(String title, String sectionName, String date, String url) {
        this.title = title;
        this.sectionName = sectionName;
        this.date = date;
        this.url = url;
    }

    // Overloaded constructor
    public News(String title, String sectionName) {
        this.title = title;
        this.sectionName = sectionName;
    }
    
    // Get methods
    public String getTitle() {
        return title;
    }

    public String getSectionName() {
        return sectionName;
    }

    public String getUrl() {
        return url;
    }

    public String getDate() {
        return date;
    }
}

Answer 8

This Java program defines a class for handling news articles.


public class News {
    private String title;
    private String sectionName;
    private String url;
    private String date;

    // Constructor
    public News(String title, String sectionName, String date, String url) {
        this.title = title;
        this.sectionName = sectionName;
        this.date = date;
        this.url = url;
    }

    // Overloaded constructor
    public News(String title, String sectionName) {
        this.title = title;
        this.sectionName = sectionName;
    }
    
    // Get methods
    public String getTitle() {
        return title;
    }

    public String getSectionName() {
        return sectionName;
    }

    public String getUrl() {
        return url;
    }

    public String getDate() {
        return date;
    }
}

Having trouble extracting the date modified from a JSON file

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

exchange the class using only JavaScript

How can you conceal an object based on specific conditions in JavaScript?

What are the steps to install node.js on hosting servers like Hostinger, JustHost, and others?

Setting the column width and border-top in Highcharts

Unexpected JSON data received compared to JSON data sent in Spring Rest and Hibernate

The column in Pandas that contains JSON data is refusing to split into multiple columns, causing a JSONDecodeError

Understanding how to translate the content of email confirmation and password reset pages in Parse Server

Encountering the "node:internal/modules/cjs/loader:1050" error while attempting to execute a folder using the "npm run dev" command

The parameter always comes up empty when using $state.go in AngularJS

Toggle visibility of div based on current business hours, incorporating UTC time

What is the process of synchronizing state in react.js?

Need help incorporating a "section trail" into your website's navigation sidebar using JS/jquery? Here's how you can do it!

Show a preview of an image in an HTML document

Navigating Form Submission in Next.js

Are you experimenting with a web application by utilizing jUnit or another API?

The form within the while loop is only functioning with the initial result

Is there a reason behind why this functionality is only applicable to a class component and not a functional one?

An error message 'module.js:557 throw err' appeared while executing npm command in the terminal

Is there a Java-based solution for encapsulating Cloudfoundry's VCAP_SERVICE?

What is the best way to guide users to a different page once they have submitted form data