mfmathis | 2023-03-01 18:34:25 UTC | #1
I am running into an issue with using the new Json data type in Architect, specifically reading the information back out. Here is the scenario: I am creating an array from a string collection the resulting json looks like this {"2":["Msg1","Msg2","Msg3"]) When I go to select an entry from the array and place it in a string variable, the value in the string variable has the quotes around it, ie: "Msg2" instead of just Msg2. If I then try to preform any string operation like subString to remove the quotes it just errors out. How do I work around this?
Edit: I figured out how to the remove the quotes using JsonStringify, GetJsonObjectProperty, and Substring. First use JsonStringify on the result you get back from the GetJsonObjectProperty call. The value returned from the JsonStringify call run Substring(value, 1, Length(value)-2). Hope this saves someone some headaches
Thanks. -Mark
system | 2023-04-01 16:02:40 UTC | #2
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 18670