Skip to main content
Solved

JSON Splitter

  • November 29, 2019
  • 3 replies
  • 238 views
soothsayers
Contributor
Forum|alt.badge.img+7

Hello,

I am new to JSON formatted strings and have spent a few hours trying to split out some content with JSON Extractors and Fragmenters with no luck. I have an array of 10 "items" which I need splitting into separate features.

 

What I need to pull from each item is the publishedParameters list (as a split list) and WorkspacePath.

 

So they resulting objects should be formatted as such:

Item# ¦ WorkspacePath ¦ publishedParameters

0 ¦ "APIrepository_prod....." ¦ "name": "user_email", raw: "Glenn.sayers@halliburton.com"

0 ¦ "APIrepository_prod....." ¦ "name": "cell_size", raw: ""

0 etc.

1 ¦ "APIrepository_prod....." ¦ "name": "_layers_other", raw: ""

1 ¦ "APIrepository_prod....." ¦ "name": "_layers_gde", raw: "present_nonclipped.gde_drainage,..."

1 etc.

 

 

I have attached the full JSON in a text file.

Many thanks,

Glenn

Best answer by soothsayers

Thanks for your help guys, I have now got this working. It's not exactly how your examples worked but they were very useful. I used something similar to your multiple JSONFragmenter example @takashi, filtered out just the WorkspacePaths I needed, then crucially set a counter on them.

 

Splitting out the request.publishedParameters shown in the list in your image @daveatsafe, I could then aggregate them back up based on the Counter result. Finally I then could expose the request.publishedParameters to get the attributes needed to FeatureMerge other incoming data based on these attributes! Wonderful!

View original
1 Attachments
Did this help you find an answer to your question?

3 replies

daveatsafe
Safer
Forum|alt.badge.img+19
  • daveatsafeSafer
  • Safer
  • November 29, 2019

Hi @soothsayers,

Please try the following settings in the JSONFragmenter:

 

 

This will produce the following results:

 

You can use the JSONTemplater to create the new JSON in the format you want, or a ListConcatenator to merge the list elements into a formatted string.

takashi
Influencer
  • takashiInfluencer
  • November 30, 2019

Hi @soothsayers, if I understood your requirement correctly, this workflow might help you.

soothsayers
Contributor
Forum|alt.badge.img+7
  • soothsayersContributor
  • Author
  • Contributor
  • Best Answer
  • December 4, 2019

Thanks for your help guys, I have now got this working. It's not exactly how your examples worked but they were very useful. I used something similar to your multiple JSONFragmenter example @takashi, filtered out just the WorkspacePaths I needed, then crucially set a counter on them.

 

Splitting out the request.publishedParameters shown in the list in your image @daveatsafe, I could then aggregate them back up based on the Counter result. Finally I then could expose the request.publishedParameters to get the attributes needed to FeatureMerge other incoming data based on these attributes! Wonderful!

Reply


Helpful Members This Week

Community Stats

31,075
Posts
117,804
Replies
38,834
Members

Latest FME

Terms & ConditionsCookie settings

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
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.