Question

extracting data from a JSON file

Forum|Forum|5 years ago
December 11, 2020
3 replies
68 views

+2

simonhume
Contributor

Hi

I've been given a JSON file containing registrations for 5 properties. We are looking to use other datasets with a single field in the json file to identify the location of the property.

I am looking to produce a csv file initially with each record on a separate line

Can someone comfirm if the following is correct or not please.

Open the JSON file using the JSONFeature Reader

Connected a JSONFragmenter, using one of the fields as the JSON Query. I've attached a screenshot of the settings for the JSONFragmenter.

When i run the workspace and view the result in the Inspector,i can see the records listed in the right hand pane, but writing out a csv file with each record on a separate line doesn't work.

thanks for any assistance

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.