PHP ActiveX

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

PHP ActiveX

<?php

$success = 0;

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

$http = new COM("Chilkat.Http");

// Get the JSON we'll be parsing..
$jsonStr = $http->quickGetStr('https://www.chilkatsoft.com/exampleData/qb_customer_balance_detail_report_2.json');
if ($http->LastMethodSuccess != 1) {
    print $http->LastErrorText . "\n";
    exit;
}

$json = new COM("Chilkat.JsonObject");
$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.
$csv = new COM("Chilkat.Csv");
$csv->HasColumnNames = 1;

// Set the column names of the CSV.
$numColumns = $json->SizeOfArray('Columns.Column');
if ($numColumns < 0) {
    print 'Unable to get column names' . "\n";
    exit;
}

$i = 0;
while ($i < $numColumns) {
    $json->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.
$row = 0;
$numRows = $json->SizeOfArray('Rows.Row[0].Rows.Row');
if ($numRows < 0) {
    print 'Unable to get data rows' . "\n";
    exit;
}

while ($row < $numRows) {
    $json->I = $row;
    $numColumns = $json->SizeOfArray('Rows.Row[0].Rows.Row[i].ColData');
    $col = 0;
    while ($col < $numColumns) {
        $json->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 
print $csv->saveToString() . "\n";

// Save to a CSV file
$success = $csv->SaveFile('qa_output/customerDetailReport.csv');

?>