Graphit Node Properties

What Are Node Properties?

Node Properties are additional instructions that can be given to a node. For example, how to format a number, which database to query, or if the node is active or disabled.

To assign a property to a node, click the (+) adjacent to the node and select the property from the dropdown menu.

Note that there is a short description of each property in the dropdown menu.

What Are the Node Properties Options?

Please refer to the files in the following table's Example column. We suggest that you run each file in Debug mode and observe the response. The files are saved in the Project environment under Project Tree > Web Services > Resources.

Node Property	Description	Examples
Session Provider	Defines which interface should be used for a query. This property should be defined each time a node is defined as SQL or Non-prepared SQL and the queried database is not Fabric. Note that this property affects the node and its children nodes.	grShowFormat
Enabled	If enabled is set to False, the node and its children are disregarded.	grShowEnabled
Nice	Defines the layout of the output format. True defines that each tag is printed in a new line and is indented. Note that this property affects the node and its child nodes.	grShowEnabled
One	Defines whether the node is handled as an array or a single value. True defines that the result is always a single entry also if the query it is based on returns multiple rows.	grOne
Entry Tag	Defines the tag surrounding XML array entries. When not used or set as None, the [entry] value is used.	grEntry
Attribute	Defines in XML whether a value is set as an attribute or child node (default).	grAttribute
Format	When defined, the node is evaluated and added when the output format matches the format's JSON, XML or CSV value. Note that this property only affects the node where it is defined.	grFormat
Show Empty	Defines whether empty nodes are displayed in the output. Default = True. Note that this property affects the node and its children nodes.	grShowEmpty
Show Null	Defines whether null entries are displayed in the output. Default = True. Note that this property affects the node and its child nodes.	grShowNull
Number Format	Controls how numbers are formatted in the output. Either use a built-in format or use the following syntax to create your own: `0 Digit # Digit, zero shows as absent . Decimal separator or monetary decimal separator - Minus sign , Grouping separator E Separates mantissa and exponent in scientific notation. ; Separates positive and negative subpatterns % Multiply by 100 and show as percentage` Note that this property affects the node and its children nodes.	grFormatNumber
Keys	Advanced mechanism that replaces nested queries by joining the data on the root query and grouping it with a key when query keys are used to select a subset of rows to group each invocation of the node. When keys are specified in children nodes, each node groups its parent's node according to the key.	grKeys
csvHeader, csvRow, csvCol, csvEnclose	The following node properties control CSV format: csvHeader, disables a header row csvRow, defines the delimiter between rows in CSV format. The default value is set to the CR sign (\n). csvCol, defines the delimiter between columns in CSV format. The default value is set to the comma character. csvEnclose, defines the character used to enclose a value in CSV format. This is only used if the value holds a special character (csvEnclose, csvRow, csvCol).	grCSV