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

The button colors in Material Ui do not update properly after switching themes

Experience the mesmerizing motion of a D3.js Bar Chart as it ascends from the bottom to the top. Feel free to

unable to locate the font file I recently downloaded in the Windows terminal

Implementing conditional button visibility in Angular based on user authorization levels

Retrieve the border color using Selenium WebDriver

How to bypass validation for required input in jQuery validate plugin

Android Gmail Application: Implementing 1px horizontal spacing between inline images placed within <td> tags

Tips for retrieving a parameter from the oncomplete attribute of an a4j:jsFunction tag

Creating a properly formatted JSON output for Java Jersey REST API by displaying the contents of an ArrayList

Generating a Random Number Within a Specified Range

Utilizing namespacing in a JavaScript library can enhance organization and flexibility, providing

Learn how to increase a value with each dynamically clicked button in JavaScript

Is React State with JSON Object Losing Updates?

Connect and interact with others through the Share Dialogues feature in the

Shifting the MUI DataGrid Pagination table to the left with CustomPagination: A step-by-step guide

Add the hue value from Hue into the Chromajs HSL state value

Adjustable Scroll Bar

Battle of Kingdoms API ajax

Guide to securely encrypting passwords when transferring from an Android device to a PHP server

Utilize JSON Objects rather than JSON arrays when using JSON-SERVER