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
- 2 replies
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"]}]This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Celebrity
- 2077 replies
Hi @sieblist
After the transformer ListBuilder use the ListConcatenator.
And the transformer JSONTemplater to create your template:
Thanks,
Danilo
+51- Celebrity
- 2077 replies
Please, see this Workspace template FMWT.
I changed the transformer JSONTemplater:
Thanks, - 27541-problem-none2json-danilo.fmw
Danilo
- 8394 replies
- 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"]}]- 8394 replies
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
+51- Celebrity
- 2077 replies
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
- 2 replies
Hi, thanks for your help ... especially @david_r whose tip has brought the desired result.
Greetings Steffen