When I tried to use the JSON function JSONFormat.IndentFour to format JSON text I found it has a limitation that is peculiar to say the least.
When you read in standard JSON the formatting doesn't work.
Set( FormattedJSON , JSON( JSONinput , JSONFormat.IndentFour ))
I found out it requires me to strip off the quotes around field names.
Why is that?
So this wrong:
This is right:
And then when it finally formats the JSON correctly with the proper indenting, it puts these quotes back on.
Giving the result, it will not accept as input!
That is weird.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.