Hi Community,
I am facing a similar issues as outlined in the following link :
However, I am unable to extract the data from the database. I guess am missing something in the JSON query parameter of the JSON Fragmenter transformer. Attached are the screenshots
Am very new to FME so it’s possible that I might be missing something basic.
Any suggestions on how to overcome this would be helpful.
Hello
It looks like JSON query is incorrect as it is very unlikely there would have an object named “...” in the JSON.
The correct JSON query to use would depend on the structure of your JSON data. You would have to share an example of the JSON in the data attribute if you want suggestions on the correct query to use in the JSONFragmenter.
If you are unable to share the data, I would suggest writing one feature’s data attribute to a text file and follow the steps in Part 3: The JSON Reader JSON Query Mode section of this Reading JSON article to view the JSON structure from the written file interactively.
You should be able to find a working JSON query and paste into the JSONFragmenter using this method.