How do I Edit my JSON

I am looking to work with the datetime information.

I can pull the datetime as a string, and now I want to remove the "-"s and store 2022 as a variable 01 as a variable and 08 as a variable. Any help would be appreciated. thank you :)

Here is my JSON

{

"abbreviation": "EST",

"client_ip": "73.28.195.233",

"datetime": "2022-01-08T13:45:58.545677-05:00",

"day_of_week": 6,

(Removed to shorten)

"week_number": 1

}

JSON.Parse, then set a variable t to JSON.Get("datetime")

Then you can extract year, month and date from t using left() and mid() expressions.

For example:

Set year to int(left(t, 4))

I was able to get it to work, thank you for the help!

Once done getting the variables do I close out of the JSON file some how.

JSON Destroy?

You don't need to close the file. You can destroy JSON if you want, but it's not necessary either.