GetItemArrayJSONString
PowerScript function
Syntax 1: GetItemArrayJSONString (ParentItemHandle, Key)
Syntax 2: GetItemArrayJSONString (ItemPath)
Syntax 3: GetItemArrayJSONString (ItemHandle)
Syntax 1
Description
Gets the string value of the item whose type is array.
Applies to
Syntax
|
1 |
objectname.GetItemArrayJSONString ( ParentItemHandle, Key ) |
|
Argument |
Description |
|---|---|
|
objectname |
The name of the JSONParser object whose array item you |
|
ParentItemHandle |
A long whose value is the handle of the parent item of |
|
Key |
A string whose value is the key of the child item of |
Return value
String.
Returns the string value of the item if it succeeds and -1 if an
error occurs. If any argument’s value is null, the method returns null.
If an error occurs, the method throws the exception.
Usage
If the item value is null, this function will throw an error,
therefore, it is recommended that before executing this function, call
GetItemType to check if the item
value is null. See example
2.
Example
The following code gets the JSON string of an array according to
the key name:
|
1 2 3 4 5 6 7 8 9 10 |
JsonParser lnv_JsonParser String ls_Json, ls_Array Long ll_RootObject lnv_JsonParser = Create JsonParser ls_Json = '{"id":1001, "name":"evan", "department_array":[999999, {"name":"Website"}, {"name":"PowerBuilder"}, {"name":"IT"}] }' lnv_JsonParser.LoadString(ls_Json) ll_RootObject = lnv_JsonParser.GetRootItem() ls_Array = lnv_JsonParser.GetItemArrayJSONString(ll_RootObject, "department_array") |
Syntax 2
Description
Gets the string value of the item whose type is array.
Applies to
Syntax
|
1 |
objectname.GetItemArrayJSONString ( ItemPath ) |
|
Argument |
Description |
|---|---|
|
objectname |
The name of the JSONParser object whose array item you |
|
ItemPath |
A string whose value is the path of the item of |
Return value
String.
Returns the string value of the item if it succeeds and -1 if an
error occurs. If any argument’s value is null, the method returns null.
If an error occurs, the method throws the exception.
Usage
If the item value is null, this function will throw an error,
therefore, it is recommended that before executing this function, call
GetItemType to check if the item
value is null. See example
2.
Example
The following code gets the JSON string of an array according to
its item path:
|
1 2 3 4 5 6 7 8 9 |
JsonParser lnv_JsonParser String ls_Json, ls_Array, ls_Path lnv_JsonParser = Create JsonParser ls_Json = '{"id":1001, "name":"evan", "department_array":[999999, {"name":"Website"}, {"name":"PowerBuilder"}, {"name":"IT"}] }' lnv_JsonParser.LoadString(ls_Json) ls_Path = "/department_array" ls_Array = lnv_JsonParser.GetItemArrayJSONString(ls_Path) |
Syntax 3
Description
Gets the string value of the item whose type is array.
Applies to
Syntax
|
1 |
objectname.GetItemArrayJSONString ( ItemHandle ) |
|
Argument |
Description |
|---|---|
|
objectname |
The name of the JSONParser object whose array item you |
|
ItemHandle |
A long value specifying the item handle which is |
Return value
String.
Returns the string value of the item if it succeeds. If any
argument’s value is null, the method returns null. If an error occurs,
the method throws the exception.
Usage
If the item value is null, this function will throw an error,
therefore, it is recommended that before executing this function, call
GetItemType to check if the item
value is null. See example
2.
Example
The following code gets the JSON string of an array according to
its item handle:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
JsonParser lnv_JsonParser String ls_Json, ls_Array Long ll_RootObject, ll_ChildArray, ll_Handle lnv_JsonParser = Create JsonParser ls_Json = '{"id":1001, "name":"svan", "active":true,"array":[12,34,[56,78]]}' lnv_JsonParser.LoadString(ls_Json) ll_RootObject = lnv_JsonParser.GetRootItem() ll_ChildArray = lnv_JsonParser.GetItemArray(ll_RootObject,"array") ll_Handle = lnv_JsonParser.GetChildItem(ll_ChildArray, 3) ls_Array = lnv_JsonParser.GetItemArrayJSONString(ll_Handle) |
See also