Zig
Zig
JSON FindRecord Example
See more JSON Examples
Demonstrates the FindRecord method for searching an array of JSON records. The data used in this example is available at JSON sample data for FindRecord.Note: This example requires Chilkat v9.5.0.63 or later.
Chilkat Zig Downloads
const std = @import("std");
const chilkat = @import("chilkat");
pub fn main(init: std.process.Init) !void {
const alloc = init.arena.allocator();
// Note: This example requires Chilkat v9.5.0.63 or later.
const json = try chilkat.JsonObject.init();
defer json.deinit();
try json.loadFile("qa_data/json/qb_accounts.json");
// A sample of the content of qb_accounts.json is shown at the bottom of this example.
// The goal is to search the array of Account records to return the 1st match
// Find the account with the name "Advertising"
const array_path = "QueryResponse.Account";
var relative_path: [:0]const u8 = "Name";
var value: [:0]const u8 = "Advertising";
var case_sensitive: bool = true;
var account_rec: chilkat.JsonObject = json.findRecord(array_path, relative_path, value, case_sensitive) catch {
std.debug.print("Record not found.\n", .{});
return;
};
defer account_rec.deinit();
// The accountRec should contain this:
// {
// "Name": "Advertising",
// "SubAccount": false,
// "FullyQualifiedName": "Advertising",
// "Active": true,
// "Classification": "Expense",
// "AccountType": "Expense",
// "AccountSubType": "AdvertisingPromotional",
// "CurrentBalance": 0,
// "CurrentBalanceWithSubAccounts": 0,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "7",
// "SyncToken": "0",
// "MetaData": {
// "CreateTime": "2016-09-09T14:42:07-07:00",
// "LastUpdatedTime": "2016-09-09T14:42:07-07:00"
// }
// }
std.debug.print("FullyQualifiedName: {s}\n", .{try account_rec.stringOf(alloc, "FullyQualifiedName")});
std.debug.print("AccountType: {s}\n", .{try account_rec.stringOf(alloc, "AccountType")});
std.debug.print("AccountSubType: {s}\n", .{try account_rec.stringOf(alloc, "AccountSubType")});
std.debug.print("----\n", .{});
// ------------------------------------------------------------------
// Find the first account where the currency is USD
relative_path = "CurrencyRef.value";
value = "USD";
case_sensitive = true;
{
const next = try json.findRecord(array_path, relative_path, value, case_sensitive);
account_rec.deinit();
account_rec = next;
}
if (!json.getLastMethodSuccess()) {
std.debug.print("Record not found.\n", .{});
return;
}
std.debug.print("Name: {s}\n", .{try account_rec.stringOf(alloc, "Name")});
std.debug.print("CurrencyRef.name: {s}\n", .{try account_rec.stringOf(alloc, "CurrencyRef.name")});
std.debug.print("----\n", .{});
// ------------------------------------------------------------------
// Find the first account with "receivable" in the name (case insensitive)
relative_path = "Name";
value = "*receivable*";
case_sensitive = false;
{
const next = try json.findRecord(array_path, relative_path, value, case_sensitive);
account_rec.deinit();
account_rec = next;
}
if (!json.getLastMethodSuccess()) {
std.debug.print("Record not found.\n", .{});
return;
}
std.debug.print("Name: {s}\n", .{try account_rec.stringOf(alloc, "Name")});
std.debug.print("----\n", .{});
// -----------------------------------------------------------------
// qb_accounts.json contains this data
//
// {
// "QueryResponse": {
// "Account": [
// {
// "Name": "Accounts Payable (A/P)",
// "SubAccount": false,
// "Description": "Description added during update.",
// "FullyQualifiedName": "Accounts Payable (A/P)",
// "Active": true,
// "Classification": "Liability",
// "AccountType": "Accounts Payable",
// "AccountSubType": "AccountsPayable",
// "CurrentBalance": -1602.67,
// "CurrentBalanceWithSubAccounts": -1602.67,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "33",
// "SyncToken": "1",
// "MetaData": {
// "CreateTime": "2016-09-10T10:12:02-07:00",
// "LastUpdatedTime": "2016-10-24T16:41:39-07:00"
// }
// },
// {
// "Name": "Accounts Receivable (A/R)",
// "SubAccount": false,
// "FullyQualifiedName": "Accounts Receivable (A/R)",
// "Active": true,
// "Classification": "Asset",
// "AccountType": "Accounts Receivable",
// "AccountSubType": "AccountsReceivable",
// "CurrentBalance": 5281.52,
// "CurrentBalanceWithSubAccounts": 5281.52,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "84",
// "SyncToken": "0",
// "MetaData": {
// "CreateTime": "2016-09-14T14:49:29-07:00",
// "LastUpdatedTime": "2016-09-17T13:16:17-07:00"
// }
// },
// {
// "Name": "Advertising",
// "SubAccount": false,
// "FullyQualifiedName": "Advertising",
// "Active": true,
// "Classification": "Expense",
// "AccountType": "Expense",
// "AccountSubType": "AdvertisingPromotional",
// "CurrentBalance": 0,
// "CurrentBalanceWithSubAccounts": 0,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "7",
// "SyncToken": "0",
// "MetaData": {
// "CreateTime": "2016-09-09T14:42:07-07:00",
// "LastUpdatedTime": "2016-09-09T14:42:07-07:00"
// }
// },
// {
// "Name": "Arizona Dept. of Revenue Payable",
// "SubAccount": false,
// "FullyQualifiedName": "Arizona Dept. of Revenue Payable",
// "Active": true,
// "Classification": "Liability",
// "AccountType": "Other Current Liability",
// "AccountSubType": "GlobalTaxPayable",
// "CurrentBalance": 0,
// "CurrentBalanceWithSubAccounts": 0,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "89",
// "SyncToken": "0",
// "MetaData": {
// "CreateTime": "2016-09-16T12:17:04-07:00",
// "LastUpdatedTime": "2016-09-17T13:05:01-07:00"
// }
// },
// {
// "Name": "Automobile",
// "SubAccount": false,
// "FullyQualifiedName": "Automobile",
// "Active": true,
// "Classification": "Expense",
// "AccountType": "Expense",
// "AccountSubType": "Auto",
// "CurrentBalance": 0,
// "CurrentBalanceWithSubAccounts": 0,
// "CurrencyRef": {
// "value": "USD",
// "name": "United States Dollar"
// },
// "domain": "QBO",
// "sparse": false,
// "Id": "55",
// "SyncToken": "0",
// "MetaData": {
// "CreateTime": "2016-09-14T10:15:53-07:00",
// "LastUpdatedTime": "2016-09-14T10:16:05-07:00"
// }
// },
// ...
//
}