Skip to main content
Solved

JSONFragmenter exposing attributes

  • April 11, 2019
  • 1 reply
  • 153 views
W
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

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

W
Forum|alt.badge.img
  • wgsl2005
  • Author
  • 15 replies
  • Best Answer
  • April 11, 2019

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

Community Stats

32,081
Posts
121,824
Replies
39,716
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.