Parse JSON with a bunch of variables

Help and Feedback Scripting Support
, ,
#1

Hey everyone! I am trying to get stuff from a JSON. I Decoded it and I am trying to access variable body_totally_main (see the Tree below)

Screen Shot 2022-08-07 at 2.41.28 PM
Screen Shot 2022-08-07 at 2.41.28 PM1034Ă—1052 196 KB

I have tried:

local JSON = "*insert long JSON here*"
local decode = game:GetService("HttpService"):JSONDecode(JSON)

-- Tried:
print(decode.message.body.body_main.body_totally_main)
-- Also Tried
print(decode.body_main[7].body_totally_main)

What am I supposed to do?

#2

Could you link the json?

Also you should print what’s decoded to see exactly what you’re working with. Most likely, you’ll need to do something like this:

print(decode[1].message.body.body_main.body_totally_main)
#3

Sure here is the JSON:

{“message”:{“header”:{“status_code”:200,“execute_time”:0.012158870697021},“body”:{“body_main”:{“id”:23987514,“number”:0,“body_totally_main”:“THING TO GET”,“tracking_url”:“kx_1I1c8oPLwkt3cCLvi9Qq4REbQRmIyi_rS26L5r9de5hS_bSA4BbJ0Tn8HrEb80oPSTM09tJVcZUATadtY8zyKAWUeFickPsjngOIKpyYxn-sQFH4_OJII9OS21EHljHsqXAmYjIbVwkB8MxyGl6jz6ZmH8PRfKULu_jK2OJV1k/”,“copyright”:“Powered by www.nothing.com. This is NOT for Commercial use.”,“updated_time”:“2022-07-28T23:41:59Z”}}}}

Keep in mind that I removed private information from the JSON.

#4

Whatever you removed seems to have made it unable to be parsed.

#5

No, I removed some stuff that I posted (eg. the api key). I am still using the full json

#6

Regardless, I’m unable to parse it to begin with.

#7

Yep. Getting this error: String literal contains malformed escape sequence. I used the full json.

#8

image
image972Ă—631 74.2 KB

‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎

#9

I will get rid of stuff to see if it gets fixed.

#10

jsonlint says it is valid.

EDIT: Gonna try to parse this in python to confirm it is good.

Screen Shot 2022-08-07 at 7.04.55 PM
Screen Shot 2022-08-07 at 7.04.55 PM1190Ă—1152 165 KB

#11

Parsed in Python. It is a valid JSON

#12

The issue was the quotes:

local json = [[{“message”:{“header”:{“status_code”:200,“execute_time”:0.012158870697021},“body”:{“body_main”:{“id”:23987514,“number”:0,“body_totally_main”:“THING TO GET”,“tracking_url”:“kx_1I1c8oPLwkt3cCLvi9Qq4REbQRmIyi_rS26L5r9de5hS_bSA4BbJ0Tn8HrEb80oPSTM09tJVcZUATadtY8zyKAWUeFickPsjngOIKpyYxn-sQFH4_OJII9OS21EHljHsqXAmYjIbVwkB8MxyGl6jz6ZmH8PRfKULu_jK2OJV1k/”,“copyright”:“Powered by www.nothing.com. This is NOT for Commercial use.”,“updated_time”:“2022-07-28T23:41:59Z”}}}}]]
json = string.gsub(json,'“','"')
json = string.gsub(json,'”','"')
local httpService = game:GetService('HttpService')
local decoded = httpService:JSONDecode(json)
print(decoded)
print(decoded.message.body.body_main.body_totally_main)
2 Likes
#13

Thank you! It works! Don’t know why python can do it, but Lua struggled.

#14

It may be a Roblox specific thing. Those quotes are specifically for things like word documents for the fancy open/close quotes. Roblox probably doesn’t support those as normal quotes as they have a different ascii.

To be more specific, it’s the fault of the IDE probably.

2 Likes