ParseJSON
Quote from kajanken on August 28, 2023, 7:27 pmCreateEmptyObject [myjson] .SetVar [myjson] "{'name':'John','age':30,'city':'NewYork'}" ParseJSON "{'name':'John', 'age':30, 'city':'New York'}" [myjson] MessageBox "Hello" "My Name is [myjson.name] and age is [myjson.age]" "<b>Ok</b>|Cancel" ""In the code above the SetVar version works but the ParseJSON version not. It throws a syntax error: Expected property name or '}' in JSON position 1 at JSON.parse
CreateEmptyObject [myjson]
.SetVar [myjson] "{'name':'John','age':30,'city':'NewYork'}"
ParseJSON "{'name':'John', 'age':30, 'city':'New York'}" [myjson]
MessageBox "Hello" "My Name is [myjson.name] and age is [myjson.age]" "<b>Ok</b>|Cancel" ""
In the code above the SetVar version works but the ParseJSON version not. It throws a syntax error: Expected property name or '}' in JSON position 1 at JSON.parse
Quote from susan on August 28, 2023, 10:54 pmThe JSON standard requires double quotes for property names and values, even though in JavaScript code you can use which ever is most convenient. Try changing your action to this:
ParseJSON '{"name": "John","age": 30,"city": "New York"}' [myjson]The example in the ParseJSON entry of the Help is incorrect and so needs to be updated to stop misleading users. @luishp
The JSON standard requires double quotes for property names and values, even though in JavaScript code you can use which ever is most convenient. Try changing your action to this:
ParseJSON '{"name": "John","age": 30,"city": "New York"}' [myjson]
The example in the ParseJSON entry of the Help is incorrect and so needs to be updated to stop misleading users. @luishp
Quote from kajanken on August 29, 2023, 7:09 pmParseJSON action wizard do not work properly and SetVar does not accept single quotes around json string. I think the JSON syntax should be same everywhere.
ParseJSON action wizard do not work properly and SetVar does not accept single quotes around json string. I think the JSON syntax should be same everywhere.
Quote from susan on August 29, 2023, 10:52 pmI agree that it is a problem, I too have spent time trying to figure out what's wrong in a similar script situation until I understood what was going on and realised the solution.
I agree that it is a problem, I too have spent time trying to figure out what's wrong in a similar script situation until I understood what was going on and realised the solution.
Quote from luishp on August 30, 2023, 2:23 pm@kajanken, @susan
JSON requires double quotes (") for both property names and string values within objects. Using single quotes (') around property names and string values will result in invalid JSON.
I know the help file sample is incorrect. I will fix it as soon as possible.
Sorry for the inconveniences.
JSON requires double quotes (") for both property names and string values within objects. Using single quotes (') around property names and string values will result in invalid JSON.
I know the help file sample is incorrect. I will fix it as soon as possible.
Sorry for the inconveniences.