JsonArray DataFlex Reference Documentation

JsonArray

Current Version: 10.1.2

Represents a JSON array, which contains an ordered list of JSON values, where each value can be a string, number, JSON object, JSON array, true, false, or null.

Object Creation

// (Dataflex programs use the 32-bit Chilkat ActiveX)
Handle hoJsonArray
Get Create(RefClass(cComChilkatJsonArray)) to hoJsonArray

Properties

DebugLogFilePath
Function ComDebugLogFilePath Returns String
Procedure Set ComDebugLogFilePath String value

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.

More Information and Examples
top
EmitCompact
Function ComEmitCompact Returns Boolean
Procedure Set ComEmitCompact Boolean value
Introduced in version 9.5.0.64

If True then the Emit method outputs in the most compact form possible (a single-line with no extra whitespace). If False, then emits with whitespace and indentation to make the JSON human-readable.

The default value is True.

top
EmitCrlf
Function ComEmitCrlf Returns Boolean
Procedure Set ComEmitCrlf Boolean value
Introduced in version 9.5.0.64

If True then the Emit method uses CRLF line-endings when emitting the non-compact (pretty-print) format. If False, then bare-LF's are emitted. (The compact format emits to a single line with no end-of-line characters.) Windows systems traditionally use CRLF line-endings, whereas Linux, Mac OS X, and other systems traditionally use bare-LF line-endings.

The default value is True.

top
LastBinaryResult
Function ComLastBinaryResult Returns Variant

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 True. 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.

top
LastErrorHtml
Function ComLastErrorHtml Returns String

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.

top
LastErrorText
Function ComLastErrorText Returns String

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.

top
LastErrorXml
Function ComLastErrorXml Returns String

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.

top
LastMethodSuccess
Function ComLastMethodSuccess Returns Boolean
Procedure Set ComLastMethodSuccess Boolean value

Indicates the success or failure of the most recent method call: True means success, False 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.

top
LastStringResult
Function ComLastStringResult Returns String

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.

top
LastStringResultLen
Function ComLastStringResultLen Returns Integer

The length, in characters, of the string contained in the LastStringResult property.

top
Size
Function ComSize Returns Integer
Introduced in version 9.5.0.56

The number of JSON values in the array.

top
VerboseLogging
Function ComVerboseLogging Returns Boolean
Procedure Set ComVerboseLogging Boolean value

If set to True, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is False. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.

top
Version
Function ComVersion Returns String

Version of the component/library, such as "10.1.0"

More Information and Examples
top

Methods

AddArrayAt
Function ComAddArrayAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Inserts a new and empty JSON array member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
AddBoolAt
Function ComAddBoolAt Integer index Boolean value Returns Boolean
Introduced in version 9.5.0.56

Inserts a new boolean member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
AddIntAt
Function ComAddIntAt Integer index Integer value Returns Boolean
Introduced in version 9.5.0.56

Inserts a new integer member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
AddNullAt
Function ComAddNullAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Inserts a new null member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
AddNumberAt
Function ComAddNumberAt Integer index String numericStr Returns Boolean
Introduced in version 9.5.0.56

Inserts a new numeric member to the position indicated by index. The numericStr is an integer, float, or double already converted to a string in the format desired by the application. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
AddObjectAt
Function ComAddObjectAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Inserts a new and empty JSON object member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
AddObjectCopyAt
Function ComAddObjectCopyAt Integer index cComChilkatJsonObject jsonObj Returns Boolean
Introduced in version 9.5.0.82

Inserts a copy of a JSON object to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
AddStringAt
Function ComAddStringAt Integer index String value Returns Boolean
Introduced in version 9.5.0.56

Inserts a new string at the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
AddUIntAt
Function ComAddUIntAt Integer index Variant value Returns Boolean
Introduced in version 9.5.0.96

Inserts a new unsigned integer member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
AppendArrayItems
Function ComAppendArrayItems cComChilkatJsonArray jarr Returns Boolean
Introduced in version 9.5.0.82

Appends the array items contained in jarr.

Returns True for success, False for failure.

More Information and Examples
top
ArrayAt
Function ComArrayAt Integer index Returns cComChilkatJsonArray
Introduced in version 9.5.0.56

Returns the JSON array that is the value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns null on failure

More Information and Examples
top
BoolAt
Function ComBoolAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Returns the boolean value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

top
Clear
Procedure ComClear
Introduced in version 9.5.0.76

Deletes all array elements.

top
DateAt
Function ComDateAt Integer index cComCkDateTime dateTime Returns Boolean
Introduced in version 9.5.0.73

Fills the dateTime with the date/time string located in the Nth array element. Indexing is 0-based (the 1st member is at index 0). Auto-recognizes the following date/time string formats: ISO-8061 Timestamp (such as "2009-11-04T19:55:41Z"), RFC822 date/time format (such as "Wed, 18 Apr 2018 15:51:55 -0400"), or Unix timestamp integers.

Returns True for success, False for failure.

top
DeleteAt
Function ComDeleteAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Deletes the array element at the given index. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
DtAt
Function ComDtAt Integer index Boolean bLocal cComDtObj dt Returns Boolean
Introduced in version 9.5.0.73

Fills the dt with the date/time string located in the Nth array element. If bLocal is True, then dt is filled with the local date/time values, otherwise it is filled with the UTC/GMT values. Indexing is 0-based (the 1st member is at index 0). Auto-recognizes the following date/time string formats: ISO-8061 Timestamp (such as "2009-11-04T19:55:41Z"), RFC822 date/time format (such as "Wed, 18 Apr 2018 15:51:55 -0400"), or Unix timestamp integers.

Returns True for success, False for failure.

top
Emit
Function ComEmit Returns String
Introduced in version 9.5.0.58

Writes the JSON array (rooted at the caller) and returns as a string.

Note: To control the compact/non-compact format, and to control the LF/CRLF line-endings, set the EmitCompact and EmitCrlf properties.

Returns null on failure

top
EmitSb
Function ComEmitSb cComChilkatStringBuilder sb Returns Boolean
Introduced in version 9.5.0.65

Writes the JSON array to the sb.

Note: To control the compact/non-compact format, and to control the LF/CRLF line-endings, set the EmitCompact and EmitCrlf properties.

Returns True for success, False for failure.

More Information and Examples
top
FindObject
Function ComFindObject String name String value Boolean caseSensitive Returns Integer
Introduced in version 9.5.0.73

Return the index of the first object in the array where value of the field at name matches value. name is an object member name. The value is a value pattern which can use "*" chars to indicate zero or more of any char. If caseSensitive is False, then the matching is case insenstive, otherwise it is case sensitive. Returns -1 if no matching string was found.

More Information and Examples
top
FindString
Function ComFindString String value Boolean caseSensitive Returns Integer
Introduced in version 9.5.0.73

Return the index of the first matching string in the array. The value is a value pattern which can use "*" chars to indicate zero or more of any char. If caseSensitive is False, then the matching is case insenstive, otherwise it is case sensitive. Returns -1 if no matching string was found.

top
IntAt
Function ComIntAt Integer index Returns Integer
Introduced in version 9.5.0.56

Returns the integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

More Information and Examples
top
IsNullAt
Function ComIsNullAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Returns the True if the Nth array element is null, otherwise returns False. Indexing is 0-based (the 1st member is at index 0).

More Information and Examples
top
Load
Function ComLoad String jsonArray Returns Boolean
Introduced in version 9.5.0.64

Loads a JSON array from a string. A JSON array must begin with a "[" and end with a "]".

Note: The Load method causes the JsonArray to detach and become it's own JSON document. It should only be called on new instances of the JsonArray. See the example below.

Returns True for success, False for failure.

top
LoadSb
Function ComLoadSb cComChilkatStringBuilder sb Returns Boolean
Introduced in version 9.5.0.64

Loads a JSON array from a StringBuilder. A JSON array must begin with a "[" and end with a "]".

Note: The Load method causes the JsonArray to detach and become it's own JSON document. It should only be called on new instances of the JsonArray. See the example below.

Returns True for success, False for failure.

More Information and Examples
top
ObjectAt
Function ComObjectAt Integer index Returns cComChilkatJsonObject
Introduced in version 9.5.0.56

Returns the JSON object that is the value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns null on failure

top
SetBoolAt
Function ComSetBoolAt Integer index Boolean value Returns Boolean
Introduced in version 9.5.0.56

Sets the boolean value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
SetIntAt
Function ComSetIntAt Integer index Integer value Returns Boolean
Introduced in version 9.5.0.56

Sets the integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
SetNullAt
Function ComSetNullAt Integer index Returns Boolean
Introduced in version 9.5.0.56

Sets the Nth array element to the value of null. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
SetNumberAt
Function ComSetNumberAt Integer index String value Returns Boolean
Introduced in version 9.5.0.56

Sets the numeric value of the Nth array element. The value is an integer, float, or double already converted to a string in the format desired by the application. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
SetStringAt
Function ComSetStringAt Integer index String value Returns Boolean
Introduced in version 9.5.0.56

Sets the string value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

More Information and Examples
top
SetUIntAt
Function ComSetUIntAt Integer index Variant value Returns Boolean
Introduced in version 9.5.0.96

Sets the unsigned integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns True for success, False for failure.

top
StringAt
Function ComStringAt Integer index Returns String
Introduced in version 9.5.0.56

Returns the string value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns null on failure

More Information and Examples
top
Swap
Function ComSwap Integer index1 Integer index2 Returns Boolean
Introduced in version 9.5.0.76

Swaps the items at positions index1 and index2.

Returns True for success, False for failure.

top
TypeAt
Function ComTypeAt Integer index Returns Integer
Introduced in version 9.5.0.58

Returns the type of data at the given index. Possible return values are:

  1. string
  2. number
  3. object
  4. array
  5. boolean
  6. null
Returns -1 if no member exists at the given index.

top
UIntAt
Function ComUIntAt Integer index
Introduced in version 9.5.0.96

Returns the unsigned integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

top