Convert a Content Provider Cursor to JSON

This is a short article where we will read the data from the content provider and convert it to JSON. So, Let's query the SMS table and get a reference to the cursor.

// Query the sms table
val cursor = context?.contentResolver?.query(
    Telephony.Sms.Inbox.CONTENT_URI, null,
    null, null, null
)

With the cursor in hand, loop through it to read the rows and columns.

cursor?.use {
    // Total number of columns in the table
    Log.v(TAG, "Column Count: ${it.columnCount}")
    // Total number of rows in the table
    Log.v(TAG, "Row Count: ${it.count}")
    // Move to the first item
    it.moveToFirst()
    // Temporary json variable that contains all the rows and their values
    val rowJson = JSONArray()
    // Loop through the rows
    do {
        // Temporary json variable that contains all the columns and their vales
        val columnJson = JSONObject()
        // Loop through the columns
        it.columnNames.forEachIndexed { i, columnName ->
            // Add the column name and its value to the column array
            columnJson.put(columnName, it.getString(i))
        }
        Log.v(TAG, "Json Row: $columnJson")
        // Add the column data to the corresponding row
        rowJson.put(columnJson)
    } while (it.moveToNext())
    // Return the json string
    rowJson.toString()
}.apply {
    // Print the entire sms data to the Logcat
    Log.v(TAG, this)
}

Below is a sample row of the SMS table in the JSON format. The columns will differ for different devices and the OS versions.

{  
   "_id":"792",
   "thread_id":"286",
   "address":"IX-OLACBS",
   "person":"0",
   "date":"1545299882278",
   "date_sent":"1545299882000",
   "protocol":"0",
   "read":"0",
   "status":"-1",
   "type":"1",
   "reply_path_present":"0",
   "body":"Hi Srikar Reddy, not only rides, now order food also on Ola! Fire up the app and get delicious food delivered straight to your desk. https:\/\/bit.ly\/2QaptoK",
   "service_center":"+919844047238",
   "locked":"0",
   "sub_id":"0",
   "network_type":"13",
   "error_code":"0",
   "creator":"com.android.mms",
   "seen":"1",
   "mtype":"0",
   "privacy_mode":"0",
   "group_id":"2592",
   "addr_body":"0,",
   "time_body":"0,",
   "risk_url_body":"",
   "is_secret":"0"
}

Popular posts from this blog

How to Read Metadata from AndriodManifest File

Metadata tags are key-value pairs and one of the decent ways to access the API keys from the libraries. They are added to the AndroidManifest.xml under the application tag and are available through the PackageManager . If you have worked with third-party libraries or even with App shortcuts, Downloadable Fonts, Firebase MLKit, you may have come across metadata tags. In the article, let’s add the metadata tags to the app module’s Manifest file and read the metadata key-values and the key-resource from a library module both in kotlin and java. Add meta-data: Add metadata to the app module's AndroidManifest.xml file under the application tag. You can add as many metadata elements as you want and you can also add metadata under the activity, service, broadcast receiver, content provider tags. <meta-data android:name= "com.gsrikar.library.LIBRARY_ACCESS_KEY" android:value= "masndfiu4er9funwikesd" /> <meta-data and
Read more

How to Change Material Chip Text Size, Text Style and Font

Chips in Android is a Material Design Component used primarily for actions or choice or during filters or as an input. The attributes like textColor , textStyle and fontFamily are ignored when added to the Material Chips directly. We need to modify these values using textAppearance . <com.google.android.material.chip.Chip android:id="@+id/maleChip" style="@style/Widget.MaterialComponents.Chip.Choice" android:layout_width="wrap_content" android:layout_height="wrap_content" android:checkable="true" android:layoutDirection="locale" android:text="@string/chip_text_male" android:textAppearance="@style/AppTheme.GenderChip" android:textColor="@color/colorWhiteText" app:chipBackgroundColor="@drawable/select_chip" app:chipEndPadding="@dimen/chip_horizontal_margin" app:chipStartPadding="@dimen/chip_horizontal_margin&quo
Read more

Create Assets Folder, Add Files and Read Data From It

Image
Sometimes, we need to read the data stored in the files during runtime and want to make sure the data is not tampered by the Android build system. In this article, we will take a look at how to create the assets folder using Android Studio and read the stored data from it. First, Right-click on the module name or the package name. This opens an option window where we need to select the Assets Folder option by hovering over New and then on the Folder option. Now, we will see a window where we change the folder location and the source set. Change the values if necessary otherwise keep the defaults and click Finish. It may trigger a Gradle Sync. Irrespective of the sync, the Assets folder is created and is visible in the module. Now, Right-click on the Assets folder and click on the File option by hovering over the New option. Enter the name of the file name and click Enter to create the file. The file with the name user_details.json is created under the assets folder. Add some JSON
Read more

Add Spacing to Recycler View Linear Layout Manager Using Item Decoration

Image
In this article we will learn about, item decoration in Android and how we can use it to add even spacing between the child items. A RecyclerView without spacing will look like the image below but in most cases, we want to add spacing between the items. [You can see there are no margins between the views and only elevation] A more traditional option is adding margins in the list item xml file. If we take this route, we will soon end up with uneven spacing issues with vertical margins. [There are even left, right, top, bottom margins for all the rows except the last item in the first image and in the subsequent image, the top margin for the first item is half of the other items] The best way is to add the ItemDecoration to the RecyclerView as it affects the individual items and you can have more control over them. Kotlin: /** * Add vertical, horizontal spacing to the recycler view */ class DefaultItemDecorator(private val horizontalSpacing: Int,
Read more

Add Options Menu to Activity and Fragment

Image
Options Menu contains a set of primary menu items that are accessible to the user. In this article, we will take a look at how to implement the options menu in an Android Activity or a Fragment. Right click on the res directory in Android Studio and select Android Resource File option. It opens the Resource File creation modal where we need to enter the file name and select Resource Type as Menu. Clicking on OK button creates main_menu.xml under menu directory. Now add the following items to the XML file. <menu xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto"> <item android:id="@+id/search" android:icon="@drawable/ic_search_white" android:orderInCategory="100" android:title="@string/action_title_search" app:actionViewClass="androidx.appcompat.widget.SearchView" app:showAsAction="ifRoo
Read more