private ContentValues getQuestionContentValues(JSONObject question) { Log.d("QuestionSync", question.toString()); ContentValues values = new ContentValues(); values.put( QuestionsEntry.COLUMN_TIMESTAMP, SyncHelper.getUnixMillisecondsFromJsonDate(question.optString("LastChangedTime"))); values.put(QuestionsEntry.COLUMN_QUESTION, question.optString("Content")); values.put( QuestionsEntry.COLUMN_DATE, SyncHelper.getUnixMillisecondsFromJsonDate(question.optString("CreationTime"))); values.put(QuestionsEntry.COLUMN_TITLE, question.optString("Title")); values.put(QuestionsEntry.COLUMN_IS_PRIVATE, question.optString("IsPrivate")); values.put( QuestionsEntry.COLUMN_QUESTIONSTATE, getQuestionState(question.optInt("QuestionState")).toString()); String answer = question.optString("Answer"); if (answer != null) { values.put(QuestionsEntry.COLUMN_ANSWER_ID, SyncHelper.getIdFromURI(answer)); } String answerer = question.optString("Answerer"); if (answer != null) { values.put(QuestionsEntry.COLUMN_ANSWERER_ID, SyncHelper.getIdFromURI(answerer)); } String asker = question.optString("User"); if (answer != null) { values.put(QuestionsEntry.COLUMN_ASKER_ID, SyncHelper.getIdFromURI(asker)); } String backendid = question.optString("Id"); if (backendid != null) { values.put(QuestionsEntry.COLUMN_BACKEND_ID, SyncHelper.getIdFromURI(backendid)); } return values; }