![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/761061/image.png)
How to parse JSON with ThingHTTP when field names have spaces? Standard dot notation doesn't with ThingHTTP?
1 view (last 30 days)
Show older comments
Hi everyone,
I'm stuck with a challenge how to parse JSON with ThingHTTP when fields have spaces? Standard dot notation doesn't with ThingHTTP - by "standard" I mean I've tried what I've found in terms of syntax on dotted notation with spaces but none have worked.
I'm specifically asking on how to enter the "Parse String" parameters when parsing JSON when fields have spaces in them using the dotted notation. Screen show below. Thank you
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/759321/image.png)
0 Comments
Answers (1)
Vinod
on 7 Oct 2021
Edited: Vinod
on 7 Oct 2021
You can parse JSON using the dot notation. Here's an example:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/761061/image.png)
Of course, this is a bit contrived to create a thingHTTP to read from ThingSpeak API, but, since I don't know the URL you are trying to get the data from, I cannot give you a more targeted example.
Can you tell me more about the application so I may give you appropriate suggestions?
3 Comments
Vinod
on 8 Oct 2021
That JSON is particularly hard to build a parse string in the thingHTTP parse string - specifically because of the periods and spaces in the JSON keys. However, you could use the vastly more flexible MATLAB Analysis app on ThingSpeak to get the data, parse and write it to a channel's field, for example:
data = webread('https://wozo9.mocklab.io/json/1')
thingSpeakWrite(<YOUR_CHANNEL_ID>,str2double(data.GlobalQuote.x05_Price),'WriteKey','YourChannelWriteAPIKey')
Then you can read it back using the channel's last.json
Communities
More Answers in the ThingSpeak Community
See Also
Categories
Find more on Read Data from Channel in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!