Skip to main content
Solved

JSONFragmenter exposing attributes

  • April 11, 2019
  • 1 reply
  • 244 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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

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