Go

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

Go

    success := false

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

    http := chilkat.NewHttp()

    // 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() != true {
        fmt.Println(http.LastErrorText())
        http.DisposeHttp()
        return
    }

    json := chilkat.NewJsonObject()
    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 := chilkat.NewCsv()
    csv.SetHasColumnNames(true)

    // Set the column names of the CSV.
    numColumns := json.SizeOfArray("Columns.Column")
    if numColumns < 0 {
        fmt.Println("Unable to get column names")
        http.DisposeHttp()
        json.DisposeJsonObject()
        csv.DisposeCsv()
        return
    }

    i := 0
    for i < numColumns {
        json.SetI(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 {
        fmt.Println("Unable to get data rows")
        http.DisposeHttp()
        json.DisposeJsonObject()
        csv.DisposeCsv()
        return
    }

    for row < numRows {
        json.SetI(row)
        numColumns = json.SizeOfArray("Rows.Row[0].Rows.Row[i].ColData")
        col := 0
        for col < numColumns {
            json.SetJ(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 
    fmt.Println(*csv.SaveToString())

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

    http.DisposeHttp()
    json.DisposeJsonObject()
    csv.DisposeCsv()