Skip to main content
Solved

JSONFragmenter exposing attributes

  • April 11, 2019
  • 1 reply
  • 101 views

Forum|alt.badge.img

please see below the json response from a httpcaller transformer.  I want to extract the items (only id and type attributes are interested) and format them to new fme features with 2 separate fields id and type. I have tried JSONFragmenter (setting like below). However the output gives me a flat table with 704 records (352*2) like below. How to output a table of 352 records with two fields id and type?

{
  • "total": 352,
  • "start": 1,
  • "num": 352,
  • "nextStart": -1,
  • "items": [
    1. {
      • "id": "5c6729ea37f84ffbb9ece1f428d83bf4",
      • "owner": "Admin",
      • "created": 1425413285228,
      • "modified": 1547658596161,
      • "guid": null,
      • "name": null,
      • "title": "World Population Density",
      • "type": "Map Service",
      • "typeKeywords": [6 items],
      • "description": "",
      • "tags": [5 items],
      • "snippet": "World Population Density data service provided by ESRI",
      • "thumbnail": "thumbnail/World_Populations.PNG",
      • "documentation": null,
      • "extent": [2 items],

 

0684Q00000ArCojQAF.png

0684Q00000ArCkYQAV.png

Best answer by wgsl2005

never mind. i figured it out with the following JSON Query on JSONFragmenter

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

1 reply

Forum|alt.badge.img
  • Author
  • Best Answer
  • April 11, 2019

never mind. i figured it out with the following JSON Query on JSONFragmenter


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