JSON Comments Possibility

Question

I am a complete beginner and trying to use JSON with VBA. This is to pass data from outside excel into the application so I can apply VBA.

The JSON file can look complicated and so to help I was wondering if comments can be added?

Andy · Accepted Answer · 2020-09-20T11:27:44.480

2

JSON does not support comments.

Anything that you put in the JSON object will be treated as data

edited Sep 20 '20 at 11:27

answered Sep 20 '20 at 11:22

Andy

2

*... will be treated as data*. Or as an error if it doesn't conform to JSON syntax! – Stephen C Sep 20 '20 at 11:35

score 1 · Answer 2 · answered Sep 20 '20 at 11:25

1

You can't directly add comments, but you could just create new keys, where you put in your comments:

{
key1: value1,
key1_comment: "This is a comment for key1"
}

answered Sep 20 '20 at 11:25

Konrad Geller

score 0 · Answer 3 · answered Sep 20 '20 at 11:52

0

There is so-called HJSON (Human JSON) which can have comments and other human-friendly features. And it has support in many popular languages.

See also this question at StackOverflow regarding comments in JSON.

answered Sep 20 '20 at 11:52

Arty

3 Answers3