Add item to VBA dictionary with quotes

[kozelibe]

Hello,

I'm trying to add the key classificationLevels with a value of ["Sectors"] (yes, I need the quotes) to a dictionary

When I try

Body.Add "classificationLevels", "[""Sectors""]"

I actually add the following with the extra ""s.

["Sectors"]

I also tried

Body.Add "classifiactionLevels", "[" & chr(34) & "Sectors" & chr(34) & "]"

I still get the unwanted ""s.

This is part of a JSON web request. I can put the entire JSON web request string value in a cell and it will work. However, I will be changing the JSON string many times and my code would be much cleaner if I could create the JSON string as a dictionary.

How can I add ["Sectors"] without the extra ""s?

Thanks.

 

[kozelibe]

Interesting. The problem character disappeared when posting.

I'm not sure how to ask this if my post removed the problem.

The extra character is chr(47). Let me see if I can post the original using that.

Hello,

I'm trying to add the key classificationLevels with a value of ["Sectors"] (yes, I need the quotes) to a dictionary

When I try

Body.Add "classificationLevels", "[""Sectors""]"

I actually add the following with the extra chr(47)s.

[chr(47)"Sectorchr(47)"]

I also tried

Body.Add "classifiactionLevels", "[" & chr(34) & "Sectors" & chr(34) & "]"

I still get the unwanted chr(47)s.

This is part of a JSON web request. I can put the entire JSON web request string value in a cell and it will work. However, I will be changing the JSON string many times and my code would be much cleaner if I could create the JSON string as a dictionary.

How can I add ["Sectors"] without the extra chr(47)s?

Thanks.