Objective-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

Objective-C

#import <CkoHttp.h>
#import <NSString.h>
#import <CkoJsonObject.h>
#import <CkoCsv.h>

BOOL success = NO;

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

CkoHttp *http = [[CkoHttp alloc] init];

// Get the JSON we'll be parsing..
NSString *jsonStr = [http QuickGetStr: @"https://www.chilkatsoft.com/exampleData/qb_customer_balance_detail_report_2.json"];
if (http.LastMethodSuccess != YES) {
    NSLog(@"%@",http.LastErrorText);
    return;
}

CkoJsonObject *json = [[CkoJsonObject alloc] init];
[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.
CkoCsv *csv = [[CkoCsv alloc] init];
csv.HasColumnNames = YES;

// Set the column names of the CSV.
int numColumns = [[json SizeOfArray: @"Columns.Column"] intValue];
if (numColumns < 0) {
    NSLog(@"%@",@"Unable to get column names");
    return;
}

int i = 0;
while (i < numColumns) {
    json.I = [NSNumber numberWithInt: i];
    [csv SetColumnName: [NSNumber numberWithInt: i] columnName: [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"] intValue];
if (numRows < 0) {
    NSLog(@"%@",@"Unable to get data rows");
    return;
}

while (row < numRows) {
    json.I = [NSNumber numberWithInt: row];
    numColumns = [[json SizeOfArray: @"Rows.Row[0].Rows.Row[i].ColData"] intValue];
    int col = 0;
    while (col < numColumns) {
        json.J = [NSNumber numberWithInt: col];
        [csv SetCell: [NSNumber numberWithInt: row] col: [NSNumber numberWithInt: col] content: [json StringOf: @"Rows.Row[0].Rows.Row[i].ColData[j].value"]];
        col = col + 1;
    }

    row = row + 1;
}

// Show the CSV 
NSLog(@"%@",[csv SaveToString]);

// Save to a CSV file
success = [csv SaveFile: @"qa_output/customerDetailReport.csv"];