Difference between revisions of "XL3Jsonify"

(Created page with "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 XL...")
 
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 an SQL Stored Procedure.
 
XL3Jsonify is often used as an argument for [[XL3RunSQLProc2]] to pass a JSON structure to an SQL Stored Procedure.
  

Revision as of 15:52, 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 an SQL Stored Procedure.

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.

Examples

Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.


See Also