JSON.GetValuesAtPath doesn't honor blank values in the array.

[flybynight27]

If I have an array where a certain key sometimes contains data and sometimes does not, the JSON.GetValuesAtPath does not leave those blank values in place, because it uses List. Since these are arrays, I would expect the order and placement to be honored.

Here is an alternative method that would leave blank lines in place:

While (

[
	¢Count = ValueCount ( JSONListKeys ( Array ; "" ) ) ;
	¢Iteration = 0 ;
	¢Values = ""
] ;

¢Iteration < ¢Count ;

[
	¢Values = ¢Values & Case ( not IsEmpty ( ¢Values ) ; "¶" ) & JSONGetElement ( Array ; "[" & ¢Iteration & "]" & Path ) ;
	¢Iteration = ¢Iteration + 1
] ;

¢Values

)

[DanShockley]

Interesting point. I guess the counter-argument is that this is getting "Values" as FileMaker defines them, so perhaps this behavior is intentional? In other words, this function is doing for arrays what the "List" function does for related fields?
Maybe a secondary function would be needed, to preserve the existing behavior that people might have relied on.