Skip to main content
Question

JSON Transformer: Headlines /Error on Reading


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

2 replies

  • Author
  • January 13, 2017

Hi there,

Any hints?

Regards

Timo


jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • January 13, 2017
timoc wrote:

Hi there,

Any hints?

Regards

Timo

It would probably be helpful to post the actual json snippet and/or the workspace that is producing the error.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings