Android™

QuickBooks - Parse the JSON of a Customer Balance Detail Report

See more CSV Examples

This example is to show how to parse the JSON of a particular Quickbooks report. The techniques shown here may help in parsing similar reports.

The JSON to be parsed is available at Sample Quickbooks Customer Balance Detail Report JSON

Android™

// Important: Don't forget to include the call to System.loadLibrary
// as shown at the bottom of this code sample.
package com.test;

import android.app.Activity;
import com.chilkatsoft.*;

import android.widget.TextView;
import android.os.Bundle;

public class SimpleActivity extends Activity {

  private static final String TAG = "Chilkat";

  // Called when the activity is first created.
  @Override
  public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    boolean success = false;

    // This example assumes the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    CkHttp http = new CkHttp();

    // Get the JSON we'll be parsing..
    String jsonStr = http.quickGetStr("https://www.chilkatsoft.com/exampleData/qb_customer_balance_detail_report_2.json");
    if (http.get_LastMethodSuccess() != true) {
        Log.i(TAG, http.lastErrorText());
        return;
        }

    CkJsonObject json = new CkJsonObject();
    json.Load(jsonStr);

    // As an alternative to manually writing code, use this online tool to generate parsing code from sample JSON: 
    // Generate Parsing Code from JSON

    // Let's parse the JSON into a CSV, and then save to a CSV file.
    CkCsv csv = new CkCsv();
    csv.put_HasColumnNames(true);

    // Set the column names of the CSV.
    int numColumns = json.SizeOfArray("Columns.Column");
    if (numColumns < 0) {
        Log.i(TAG, "Unable to get column names");
        return;
        }

    int i = 0;
    while (i < numColumns) {
        json.put_I(i);
        csv.SetColumnName(i,json.stringOf("Columns.Column[i].ColTitle"));
        i = i + 1;
        }

    // Let's get the rows.
    // We'll ignore the Header and Summary, and just get the data.
    int row = 0;
    int numRows = json.SizeOfArray("Rows.Row[0].Rows.Row");
    if (numRows < 0) {
        Log.i(TAG, "Unable to get data rows");
        return;
        }

    while (row < numRows) {
        json.put_I(row);
        numColumns = json.SizeOfArray("Rows.Row[0].Rows.Row[i].ColData");
        int col = 0;
        while (col < numColumns) {
            json.put_J(col);
            csv.SetCell(row,col,json.stringOf("Rows.Row[0].Rows.Row[i].ColData[j].value"));
            col = col + 1;
            }

        row = row + 1;
        }

    // Show the CSV 
    Log.i(TAG, csv.saveToString());

    // Save to a CSV file
    success = csv.SaveFile("qa_output/customerDetailReport.csv");

  }

  static {
      System.loadLibrary("chilkat");

      // Note: If the incorrect library name is passed to System.loadLibrary,
      // then you will see the following error message at application startup:
      //"The application <your-application-name> has stopped unexpectedly. Please try again."
  }
}