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": [
- {
- "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],
- {
Best answer by wgsl2005
View original