Skip to main content
Question

extracting data from a JSON file

  • December 11, 2020
  • 3 replies
  • 38 views

simonhume
Contributor
Forum|alt.badge.img+2

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

 

3 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • December 11, 2020

It's hard to advise without seeing the json


simonhume
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • December 14, 2020

Hi

file is attached


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • December 14, 2020

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

Capture


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings