Skip to main content
Solved

Exposed attributes empty from JSONFragmenter using flattening

  • February 16, 2022
  • 2 replies
  • 65 views
M

I'm using the JSONFragmenter to choose a segment of a JSON file and am trying to expose the values from this segment as attributes. However, the JSONFragmenter just returns the values as separate objects, and the attributes are empty. I've tried without the "[*]" at the end of the JSON query, yielding just one object but still empty attributes.

 

I've also tried using the JSONflattener on this segment and on the full JSON string, but it does not seem to do anything. It just returns the same attributes as on the input straight through.

 

The parameters of the JSONFragmenter:

image 

The segment og JSON looks like this:

{

 "id": "8a463f67-99c2-4f6b-8703-d154de3dd7ef",

 "vejnavn": "Tietgensvej",

 "adresseringsvejnavn": "Tietgensvej",

 "husnr": 4,

 "supplerendebynavn": null,

 "postnr": 8600,

 "postnrnavn": "Silkeborg",

 "status": 1,

 "virkningstart": "2015-03-26T15:05:24.620Z",

 "virkningslut": null,

 "adgangsadresseid": "0a3f5095-8e08-32b8-e044-0003ba298018",

 "etage": null,

 "dør": null,

 "href": "https://api.dataforsyningen.dk/adresser/8a463f67-99c2-4f6b-8703-d154de3dd7ef"

}

 

The separate objects with empty attributes

Attributes empty

Best answer by redgeographics

Can you select one of those features and then check the Feature Information panel in your Visual Preview? That should show you the attributes actually coming out of the 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.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • Best Answer
  • February 16, 2022

Can you select one of those features and then check the Feature Information panel in your Visual Preview? That should show you the attributes actually coming out of the JSONFragmenter

FME rocks! \m/
M
  • mikols
  • Author
  • 1 reply
  • February 16, 2022

Can you select one of those features and then check the Feature Information panel in your Visual Preview? That should show you the attributes actually coming out of the JSONFragmenter

Thank you for taking the time to answer my question!

I wasn't aware of the Feature information panel - Thant' s very useful :)

 

I'm not sure why i suddenly worked, but removing the "[*]" from the query again made the attributes appear.

image

Community Stats

32,070
Posts
121,771
Replies
39,694
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.