(MFC) QuickBooks - Parse the JSON of a Customer Balance Detail Report

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

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkHttp.h>
#include <CkJsonObject.h>
#include <CkCsv.h>

void ChilkatSample(void)
    {
    CkString strOut;

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

    bool success;
    CkHttp http;

    // Get the JSON we'll be parsing..
    const char *jsonStr = http.quickGetStr("https://www.chilkatsoft.com/exampleData/qb_customer_balance_detail_report_2.json");
    if (http.get_LastMethodSuccess() != true) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    CkJsonObject json;
    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;
    csv.put_HasColumnNames(true);

    // Set the column names of the CSV.
    int numColumns = json.SizeOfArray("Columns.Column");
    if (numColumns < 0) {
        strOut.append("Unable to get column names");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        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) {
        strOut.append("Unable to get data rows");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        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 
    strOut.append(csv.saveToString());
    strOut.append("\r\n");

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


    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }