Difference between revisions of "XL3Jsonify"
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
XL3Jsonify transforms an array into a JSON string. | XL3Jsonify transforms an array into a JSON string. | ||
The source array can optionnaly be filtered on the basis of a column tracking changed values (used in conjunction with [[XL3TrackChanges]]). | The source array can optionnaly be filtered on the basis of a column tracking changed values (used in conjunction with [[XL3TrackChanges]]). | ||
| − | XL3Jsonify is often used as an argument for [[XL3RunSQLProc2]] to pass a JSON structure to | + | XL3Jsonify is often used as an argument for [[XL3RunSQLProc2]] to pass a JSON structure to a SQL Stored Procedure. |
==Syntax== | ==Syntax== | ||
| Line 19: | Line 19: | ||
|} | |} | ||
| − | == | + | ==Example== |
| − | {{Code|=XL3Jsonify($ | + | {{Code|=XL3Jsonify($E$7:$I$12,$J$8:$J$12)}} |
| − | ''Rows of the $ | + | ''Rows of the $E$7:$I$12 range for which the cell value is equal to TRUE for the same row in the $J$8:$J$12 range are returned as a JSON string.'' |
| − | [[File: | + | [[File:03 XL3Jsonify.png|center]] |
| − | [[File: | + | [[File:04 XL3Jsonify.png|center]] |
==See Also== | ==See Also== | ||
| Line 35: | Line 35: | ||
* [[XL3Filter]] | * [[XL3Filter]] | ||
* [[XL3TrackChanges]] | * [[XL3TrackChanges]] | ||
| + | * [[XL3RunSQLProc2]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:Report Management Formulae]] | [[Category:Report Management Formulae]] | ||
[[Category:Report Management]] | [[Category:Report Management]] | ||
Latest revision as of 16:16, 8 April 2024
XL3Jsonify transforms an array into a JSON string. The source array can optionnaly be filtered on the basis of a column tracking changed values (used in conjunction with XL3TrackChanges). XL3Jsonify is often used as an argument for XL3RunSQLProc2 to pass a JSON structure to a SQL Stored Procedure.
Contents
[hide]Syntax
XL3Jsonify( Input, Filter )
Parameters
| Parameter | Description |
|---|---|
| Input | The range to watch for changes. |
| Filter | The range (column) that contains TRUE values to corresponding changed rows. |
Example
Rows of the $E$7:$I$12 range for which the cell value is equal to TRUE for the same row in the $J$8:$J$12 range are returned as a JSON string.
