JsonArray ActiveX Reference Documentation
JsonArray
Current Version: 11.5.0
Chilkat.JsonArray
Work with JSON arrays as ordered lists containing strings, numbers,
booleans, nulls, objects, arrays, and mixed value types.
Retrieve, insert, replace, delete, or swap values by array index when
processing JSON list data.
Access child
Search arrays of strings or arrays of objects to locate matching values
without manually scanning every element.
Parse date/time values and preserve exact numeric strings when JSON data
contains values that must not be rounded or reformatted.
Produce compact or pretty JSON output after array data has been loaded,
edited, searched, or built programmatically.
For an extended overview, see
JsonArray Class Overview.
Read, modify, search, and emit ordered JSON arrays.
Chilkat.JsonArray is the JSON array companion to
Chilkat.JsonObject. It represents an ordered list of JSON values
and provides index-based methods for reading, inserting, replacing, deleting,
swapping, searching, and emitting array data. It supports scalar values,
nested objects, nested arrays, date/time parsing, exact numeric string
handling, compact or pretty output, and search helpers for arrays of strings
or arrays of objects.
Ordered JSON values
Index-based access
Nested objects and arrays
JsonObject and JsonArray values to
navigate and modify deeper JSON structures.
Search helpers
Date and numeric handling
Emit JSON output
JsonObject to navigate named members and JSON paths, then
use JsonArray to iterate or modify ordered lists found within
the object tree. Retrieve nested objects or arrays as needed, update values
by index, and emit the final JSON in compact or pretty form.
Object Creation
Note: For a specific major version, use "Chilkat.JsonArray.<major_version>", such as "Chilkat.JsonArray.10" for Chilkat v10.*.* See Chilkat ActiveX Object Creation (ASP) set obj = Server.CreateObject("Chilkat.JsonArray") (AutoIt) $obj = ObjCreate("Chilkat.JsonArray") (Visual Basic 6.0) Dim obj As New ChilkatJsonArray (VBScript) set obj = CreateObject("Chilkat.JsonArray") (VBA, such as Excel) Dim obj As New ChilkatJsonArray See How to Use ActiveX in Excel (Delphi) obj := TChilkatJsonArray.Create(Self); (FoxPro) loObject = CreateObject('Chilkat.JsonArray') (PowerBuilder) lole_object = create oleobject li_rc = lole_object.ConnectToNewObject("Chilkat.JsonArray") (SQL Server) EXEC @hr = sp_OACreate 'Chilkat.JsonArray', @obj OUT (Javascript) var obj = new ActiveXObject("Chilkat.JsonArray");
Properties
DebugLogFilePath
If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. This logging helps identify the context and history of Chilkat calls leading up to any crash or hang, aiding in debugging.
Enabling the VerboseLogging property provides more detailed information. This property is mainly used for debugging rare instances where a Chilkat method call causes a hang or crash, which should generally not happen.
Possible causes of hangs include:
- A timeout property set to 0, indicating an infinite timeout.
- A hang occurring within an event callback in the application code.
- An internal bug in the Chilkat code causing the hang.
EmitCompact
Controls whether emitted JSON is compact or pretty-formatted. If 1, output contains no unnecessary whitespace and is emitted on a single line. If 0, indentation and line breaks are added for readability. The default is 1.
EmitCrlf
Controls line endings when pretty-formatted JSON is emitted. If 1, line breaks use CRLF (
); if 0, they use LF (
). The default is 1.
EmitCompact is 1, the JSON is emitted on one line and this setting has no effect.FindStartIndex
Specifies the zero-based array index at which FindString and FindObject begin searching. The default value is 0.
n, set this property to n + 1 before the next search to continue with later elements.LastBinaryResult
This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. It is only accessible if Chilkat.Global.KeepBinaryResult is set to 1. This feature allows for the retrieval of large varbinary results in an SQL Server environment, which has restrictions on returning large data via method calls, though temp tables can handle binary properties.
LastErrorHtml
Provides HTML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.
topLastErrorText
Provides plain text information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.
LastErrorXml
Provides XML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.
topLastMethodSuccess
Indicates the success or failure of the most recent method call: 1 means success, 0 means failure. This property remains unchanged by property setters or getters. This method is present to address challenges in checking for null or Nothing returns in certain programming languages. Note: This property does not apply to methods that return integer values or to boolean-returning methods where the boolean does not indicate success or failure.
LastStringResult
In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. It is accessible only when Chilkat.Global.KeepStringResult is set to TRUE. SQL Server has limitations on string lengths returned from methods and properties, but temp tables can be used to access large strings.
LastStringResultLen
The length, in characters, of the string contained in the LastStringResult property.
topSize
Returns the number of values currently contained in the JSON array. Array indexes therefore range from 0 through Size - 1.
VerboseLogging
If set to 1, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is 0. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.
Version
Version of the component/library, such as "10.1.0"
Methods
AddArrayAt
Inserts a new, empty JSON array at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddArrayAt2
Inserts a new, empty JSON array at zero-based position index and updates jarr to reference the newly inserted array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
jarr references the inserted array, it can be populated directly without a separate ArrayAt lookup.Returns 1 for success, 0 for failure.
topAddBoolAt
Inserts a new JSON boolean value at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddIntAt
Inserts a new JSON integer value at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddNullAt
Inserts a JSON null value at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddNumberAt
Inserts a JSON number at zero-based position index. The numericStr argument supplies the exact JSON numeric text to store. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
12345678901234567890, 1.2500, or scientific notation. The supplied text must be valid JSON number syntax; JSON does not permit NaN or infinity.Returns 1 for success, 0 for failure.
AddObjectAt
Inserts a new, empty JSON object at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddObjectAt2
Inserts a new, empty JSON object at zero-based position index and updates json to reference the newly inserted object.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
json references the inserted object, it can be populated directly without a separate ObjectAt lookup.Returns 1 for success, 0 for failure.
topAddObjectCopyAt
Inserts an independent copy of jsonObj at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
jsonObj do not serve as edits to the inserted array value.Returns 1 for success, 0 for failure.
AddStringAt
Inserts a new JSON string value at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
AddUIntAt
Inserts a new JSON unsigned integer value at zero-based position index. Existing elements at that position and after it are shifted one position toward the end of the array.
0 | Insert as the first array element. |
-1 | Append as the last array element. |
n | Insert at zero-based position n. |
Add*At methods insert a new array element. Use the corresponding Set*At method when replacing an existing element.Returns 1 for success, 0 for failure.
topAppendArrayItems
Appends copies of all values from jarr to the end of this array, preserving their order.
Returns 1 for success, 0 for failure.
ArrayAt
Returns the nested JSON array stored at zero-based position index.
JsonArray refers to the existing nested array in the same JSON document. Changes made through the returned object modify that nested array.index must be an array. Use TypeAt when the value type is not already known.Returns Nothing on failure
ArrayAt2
Updates jarr so that it references the nested JSON array stored at zero-based position index.
jarr modify the existing nested array in the same JSON document.Returns 1 for success, 0 for failure.
topBoolAt
Returns the boolean value stored at zero-based position index.
TypeAt when the JSON type at index is not already known.Clear
Removes all values from the array, leaving an empty JSON array ([]).
DateAt
Parses the date/time value at zero-based position index and loads the result into dateTime. Recognized forms include ISO 8601 timestamps (for example, 2009-11-04T19:55:41Z), RFC 822-style date/time strings, and Unix timestamp integers.
Returns 1 for success, 0 for failure.
topDeleteAt
Deletes the value at zero-based position index. Elements following the deleted value shift down by one position.
Returns 1 for success, 0 for failure.
DtAt
Parses the date/time value at zero-based position index and loads the result into dt. If bLocal is 1, the populated fields represent local time; if 0, they represent UTC/GMT. Recognized forms include ISO 8601 timestamps, RFC 822-style date/time strings, and Unix timestamp integers.
Returns 1 for success, 0 for failure.
topEmit
Serializes this JSON array and returns the resulting JSON text.
EmitCompact to choose compact versus pretty output. When pretty output is enabled, EmitCrlf selects CRLF or LF line endings.Returns Nothing on failure
EmitSb
Serializes this JSON array into the supplied StringBuilder.
EmitCompact to choose compact versus pretty output. When pretty output is enabled, EmitCrlf selects CRLF or LF line endings.StringBuilder can avoid returning a very large JSON document as a language-native string before passing it to another Chilkat method or writing it to a file.Returns 1 for success, 0 for failure.
FindObject
Searches array elements that are JSON objects and returns the zero-based index of the first object whose direct member name has a value matching value. Returns -1 if no match is found. The value pattern may contain *, which matches zero or more characters. Set caseSensitive to control whether letter case must match.
name identifies a direct member of each object being tested; it is not a JSON path.FindStartIndex, whose default is 0. To continue searching after a match, set FindStartIndex to the previous returned index plus 1.FindString
Searches for the first string array element matching value and returns its zero-based index, or -1 if no match is found. The pattern may contain *, which matches zero or more characters. Set caseSensitive to control whether letter case must match.
FindStartIndex, whose default is 0. To continue searching after a match, set FindStartIndex to the previous returned index plus 1.IntAt
Returns the integer value stored at zero-based position index.
TypeAt when the JSON type at index is not already known.IsNullAt
Returns 1 if the value at zero-based position index is the JSON value null; otherwise returns 0.
null is a distinct JSON value. It is not the same as an empty string, zero, false, an empty object, or an empty array.Load
Parses the JSON array text in jsonArray and loads it into this object. The input must represent a JSON array, beginning with [ and ending with ].
JsonArray its own independent JSON document. If the object previously referenced an array nested inside another JSON document, that relationship is discarded. For this reason, call Load/LoadSb on a new JsonArray instance.Returns 1 for success, 0 for failure.
LoadSb
Parses the JSON array contained in sb and loads it into this object. The input must represent a JSON array, beginning with [ and ending with ].
JsonArray its own independent JSON document. If the object previously referenced an array nested inside another JSON document, that relationship is discarded. For this reason, call Load/LoadSb on a new JsonArray instance.Returns 1 for success, 0 for failure.
ObjectAt
Returns the JSON object stored at zero-based position index.
JsonObject refers to the existing object in the same JSON document. Changes made through the returned object modify that nested object.index must be an object. Use TypeAt when the value type is not already known.Returns Nothing on failure
ObjectAt2
Updates jsonObj so that it references the JSON object stored at zero-based position index.
jsonObj modify the existing object in the same JSON document.Returns 1 for success, 0 for failure.
topSetBoolAt
Replaces the value at zero-based position index with the specified JSON boolean value. The array length and the positions of other elements are unchanged.
Returns 1 for success, 0 for failure.
SetIntAt
Replaces the value at zero-based position index with the specified JSON integer value. The array length and the positions of other elements are unchanged.
Returns 1 for success, 0 for failure.
SetNullAt
Replaces the value at zero-based position index with the JSON value null. The array length and the positions of other elements are unchanged.
Returns 1 for success, 0 for failure.
topSetNumberAt
Replaces the value at zero-based position index with a JSON number. The value argument supplies the exact JSON numeric text to store.
NaN or infinity.Returns 1 for success, 0 for failure.
SetStringAt
Replaces the value at zero-based position index with the specified JSON string value. The array length and the positions of other elements are unchanged.
Returns 1 for success, 0 for failure.
SetUIntAt
Replaces the value at zero-based position index with the specified JSON unsigned integer value. The array length and the positions of other elements are unchanged.
Returns 1 for success, 0 for failure.
topStringAt
Returns the string value stored at zero-based position index.
TypeAt when the JSON type at index is not already known.Returns Nothing on failure
Swap
Exchanges the values at zero-based positions index1 and index2. The array length does not change.
Returns 1 for success, 0 for failure.
topTypeAt
Returns an integer identifying the JSON type of the value at zero-based position index. Returns -1 if no value exists at that index.
1 | string |
2 | number |
3 | object |
4 | array |
5 | boolean |
6 | null |
ObjectAt, ArrayAt, or IntAt for the wrong kind of value.UIntAt
Returns the unsigned integer value stored at zero-based position index.
TypeAt when the JSON type at index is not already known.