Skip to main content
  • EN

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

 

It's hard to advise without seeing the json

Hi

file is attached

It looks like you just need to explode the list applications{} after reading with the FeatureReader

Capture

Reply


Community Stats

30,662
Posts
116,111
Replies
38,270
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.