JSONPackage object

The JSONPackage object provides the ability to merge data in a JSON
object or extract data from a JSON object. Merging and extracting can
occur at both the client side and the server side. The resulted JSON can
be posted from the client to the server via HTTPClient, or retrieved from
the server to the client via RESTClient.

For the JSON string that can be loaded by the JSONPackage object,
see the section called “Supported JSON formats” in Application Techniques.

Note

It is not recommended to use this object to process large data (20
MB or 100,000 data rows can be considered as large data based on our
tests), because this object will call a third-party library which is
memory intensive.

Note

This object cannot be referenced in .NET Web Service or .NET
Assembly components, otherwise the component will fail to be
deployed.

Note

The data to be merged can be from DataWindow, DataStore,
DataWindowChild, or from an existing JSON.

Composite, Crosstab, OLE 2.0, and RichText DataWindows are
unsupported.

Properties

JSONPackage property	Datatype	Description
IgnoreCase	Boolean	A boolean value that specifies whether to ignore the case for key.
ClassDefinition	PowerObject	An object of type PowerObject containing information about the class definition of the object or control.
ReturnsNullWhenError	Boolean	Specifies whether the getting value function returns a null value when error occurs.

Events

JSONPackage event	Occurs
Constructor	When the object is created.
Destructor	When the object is destroyed.

Functions

JSONPackage function	Datatype returned	Description
ClassName	String	Returns the name assigned to the object.
Clear	Integer	Deletes all of the keys.
ContainsKey	Boolean	Checks if the key name exists.
GetContextService	Integer	Creates a reference to a context-specific instance of the specified service.
GetJSONBlob	Blob	Gets the JSON blob data.
GetJSONString	String	Gets the JSON string data.
GetKey	String	Gets the key name.
GetParent	PowerObject	Returns a reference to the name of the parent object.
GetValue	String	Gets the value of the key.
GetValueBlob	Blob	Gets the blob value of the key.
GetValueBoolean	Boolean	Gets the boolean value of the key.
GetValueDate	Date	Gets the date value of the key.
GetValueDateTime	DateTime	Gets the datetime value of the key.
GetValueNumber	Number	Gets the number value of the key.
GetValueString	String	Gets the string value of the key.
GetValueTime	Time	Gets the time value of the key.
GetValueToDataWindow	Long	Gets the value of the key and inserts it into a DataWindow control, DataStore object, or DataWindowChild object.
KeyCount	Long	Gets the total number of keys.
LoadFile	String	Loads a JSON file.
LoadString	String	Loads a JSON string.
PostEvent	Boolean	Adds an event to the end of the message queue for the object.
Remove	Integer	Removes a key.
SaveToFile	Integer	Saves the JSON data to the local file.
SetValue	Integer	Sets the value of the key.
SetValueBlob	Integer	Sets the blob value for a key.
SetValueBoolean	Integer	Sets the boolean value for a key.
SetValueByDataWindow	Integer	Sets the value of the key using the data from a DataWindow control, DataStore object, or DataWindowChild object.
SetValueDate	Integer	Sets the date value for a key.
SetValueDateTime	Integer	Sets the datetime value for a key.
SetValueNumber	Integer	Sets the number value for a key.
SetValueString	Integer	Sets the string value for a key.
SetValueTime	Integer	Sets the time value for a key.
TriggerEvent	Integer	Triggers a specific event in the object and executes the script for the event.
TypeOf	Object	Returns the type of the object.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information

JSONPackage object – PB Docs 2019