Unicode C++

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

Unicode C++

#include <CkHttpW.h>
#include <CkJsonObjectW.h>
#include <CkCsvW.h>

void ChilkatSample(void)
    {
    bool success = false;

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

    CkHttpW http;

    // Get the JSON we'll be parsing..
    const wchar_t *jsonStr = http.quickGetStr(L"https://www.chilkatsoft.com/exampleData/qb_customer_balance_detail_report_2.json");
    if (http.get_LastMethodSuccess() != true) {
        wprintf(L"%s\n",http.lastErrorText());
        return;
    }

    CkJsonObjectW 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.
    CkCsvW csv;
    csv.put_HasColumnNames(true);

    // Set the column names of the CSV.
    int numColumns = json.SizeOfArray(L"Columns.Column");
    if (numColumns < 0) {
        wprintf(L"Unable to get column names\n");
        return;
    }

    int i = 0;
    while (i < numColumns) {
        json.put_I(i);
        csv.SetColumnName(i,json.stringOf(L"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(L"Rows.Row[0].Rows.Row");
    if (numRows < 0) {
        wprintf(L"Unable to get data rows\n");
        return;
    }

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

        row = row + 1;
    }

    // Show the CSV 
    wprintf(L"%s\n",csv.saveToString());

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