GSheets Operator > Google Sheets Sheet Tab Data > Get All Array Values as Json String

Get All Array Values as Json String

Returns the values in this object as a JSON 2D array, represented as FString. See pins for examples.

Inputs

Target
Google Sheets Sheet Tab Data Object Reference

Add Values Key
Boolean

Whether to prefix the values with '"values": '. Example, '"values": [["one","two","three"]["four","five","six"]]', assuming bWrapInCurlyBraces is false.

Wrap in Curly Braces
Boolean

Whether to surround the final string with curly braces. Example, '{[["one","two","three"]["four","five","six"]]}', assuming bAddValuesKey is false.

Outputs

Return Value
String

The values in this object as a JSON 2D array, represented as FString. Full example, '{"values": [["one","two","three"]["four","five","six"]]}', assuming bAddValuesKey and bWrapInCurlyBraces are true.