Skip to main content
Solved

How can i extract data from this line?


nick3_s75
Contributor
Forum|alt.badge.img+2

How can i extract data from this line? 

 

{"sl:stand": {"sl-bag-extract:bagObject": {"Objecten:Pand": {"Objecten:status": "Pand in gebruik", "Objecten:geometrie": {"gml:Polygon": {"@srsName": "urn:ogc:def:crs:EPSG::28992", "gml:exterior": {"gml:LinearRing": {"gml:posList": {"#text": "114062.419 542728.035 0.0 114067.343 542726.792 0.0 114067.637 542728.082 0.0 114068.445 542728.468 0.0 114069.011 542730.438 0.0 114068.36 542731.246 0.0 114068.639 542732.471 0.0 114063.762 542733.793 0.0 114064.204 542735.512 0.0 114057.619 542737.161 0.0 114055.721 542729.372 0.0 114055.572 542729.428 0.0 114053.081 542719.589 0.0 114059.937 542717.727 0.0 114062.353 542727.763 0.0 114062.419 542728.035 0.0", "@count": "16"}}}, "@srsDimension": "3"}}, "Objecten:voorkomen": {"Historie:Voorkomen": {"Historie:BeschikbaarLV": {"Historie:tijdstipRegistratieLV": "2010-11-26T12:31:16.436", "Historie:tijdstipEindRegistratieLV": "2014-10-27T12:32:20.904"}, "Historie:eindGeldigheid": "2014-09-25", "Historie:beginGeldigheid": "1930-10-17", "Historie:eindRegistratie": "2014-10-27T12:00:33.000", "Historie:tijdstipRegistratie": "2010-11-26T12:11:13.000", "Historie:voorkomenidentificatie": "1"}}, "Objecten:documentdatum": "1930-10-17", "Objecten:geconstateerd": "N", "Objecten:identificatie": {"#text": "0366100000006739", "@domein": "NL.IMBAG.Pand"}, "Objecten:documentnummer": "BV 100", "Objecten:oorspronkelijkBouwjaar": "1935"}}}}

 

Best answer by nielsgerrits

Attached sample workspace.

 

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

7 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

It depends on what info you want exactly.

Transformers generally used for JSON extracting:

  • JSONExtractor
    • Extract specific portions to attributes.
  • JSONFlattener
    • Flattens objects, extracting keys and values to attributes. You will need to expose these attributes as they are unexposed.
  • JSONFragmenter
    • Extract specific portions to features.

david_r
Celebrity
  • May 13, 2025

Try a JSONExtractor followed by a JSONFlattener:

Remember to expose the attributes you need in the JSONFlattener.


nick3_s75
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • May 14, 2025

Thanks for the help, i'm still don't get there.

 


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • May 14, 2025

Attached sample workspace.

 


redgeographics
Celebrity
Forum|alt.badge.img+49
nick3_s75 wrote:

Thanks for the help, i'm still don't get there.

 

One quick remark: FME is case sensitive when it comes to attribute names. So you have set Objecten_pand in the JSONExtractor but then refer to Objecten_Pand in the JSONFlattener


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • May 14, 2025
nielsgerrits wrote:

Attached sample workspace.

 

Great job


nick3_s75
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • May 15, 2025

Tanks everybody 


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