I want to output a feature with a list (CITY) into a correct JSON array as described below. However, that does not work. Can somebody help me with it?
[
{
"CITY" : ["Frankfurt","Hamburg","Berlin"]
}
]
Solved
Writing a List to JSON Array
- Participant
Best answer by david_r
There's probably no need to use the JSONTemplater here, it comes with it's own set of challenges.
After the ListBuilder, insert a ListRenamer to make the list correspond to what the JSON writer expects:
This will rename city_list{}.CITY to just CITY{}
Result:
[{"CITY":["Frankfurt","Hamburg","Berlin"]}]
+45- Evangelist
Hi @sieblist
After the transformer ListBuilder use the ListConcatenator.
And the transformer JSONTemplater to create your template:
Thanks,
Danilo
+45- Evangelist
Please, see this Workspace template FMWT.
I changed the transformer JSONTemplater:
Thanks, - 27541-problem-none2json-danilo.fmw
Danilo
- Best Answer
There's probably no need to use the JSONTemplater here, it comes with it's own set of challenges.
After the ListBuilder, insert a ListRenamer to make the list correspond to what the JSON writer expects:
This will rename city_list{}.CITY to just CITY{}
Result:
[{"CITY":["Frankfurt","Hamburg","Berlin"]}]david_r wrote:
There's probably no need to use the JSONTemplater here, it comes with it's own set of challenges.
After the ListBuilder, insert a ListRenamer to make the list correspond to what the JSON writer expects:
This will rename city_list{}.CITY to just CITY{}
Result:
[{"CITY":["Frankfurt","Hamburg","Berlin"]}]Here's the complete workspace: json_list.fmwt
+45- Evangelist
david_r wrote:
There's probably no need to use the JSONTemplater here, it comes with it's own set of challenges.
After the ListBuilder, insert a ListRenamer to make the list correspond to what the JSON writer expects:
This will rename city_list{}.CITY to just CITY{}
Result:
[{"CITY":["Frankfurt","Hamburg","Berlin"]}]Thank you for endorsing the response- Participant
Hi, thanks for your help ... especially @david_r whose tip has brought the desired result.
Greetings Steffen
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.