Question

JSON Transformer: Headlines /Error on Reading

Forum|Forum|8 years ago
January 12, 2017
2 replies
24 views

timoc

Hi Guys,

I am new at the FME Software and actually trying to transform an json file to an csv file. With the example i could create such flow that works.

I checked the Output and wondering a little bit that the headlines of the json objects are in the fields. Example:

{"cruise_nid":413358

Cruise_nid is the object name (in a json array) and the 413358 is value. In my powershell script that i actually using for that transformation, the cruise_nid used as Headline. How i can configure the JsonFragmenter to use the objective names as Headlines?

The second Point that i got is that on anorther json i got an error that the json is not valid:

A JSON syntax error was found at line 39, column 28

A sequence of bytes was found which is invalid in the utf-8 Encoding.

I checked the json file, but there isnt a column 28 in the line 39. In column 59 i got an umlaut. But i thought that that will be in UTF8 be no Problem. Any tips?

Regards

Timo

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.