+4Hello,
Is it possible to transform a table (ie from Postgresql, or Excel) into this complicated Json format within FME please? I have attached the json file and also a small dummy sample excel file (which doesnt quite have the correct column headers as its a work in progress).
I am completely new to JSON and I have done the JSON Templater tutorial but no idea how to actually apply it to my needs!!
Help wanted!!
Looking at the supplied JSON it might be quite a bit of work, depending on how much you actually have to supply and how much is optional or static. One solution could be to forego the JSONTemplater and import the sample JSON file as the writer definition:
You will then have a JSON writer containing the necessary definition to reproduce your JSON.
However, you’ll see that you now have to contend with nested lists on several levels:
However, if you’re more comfortable working with lists it might be the easiest solution.
+4Looking at the supplied JSON it might be quite a bit of work, depending on how much you actually have to supply and how much is optional or static. One solution could be to forego the JSONTemplater and import the sample JSON file as the writer definition:
You will then have a JSON writer containing the necessary definition to reproduce your JSON.
However, you’ll see that you now have to contend with nested lists on several levels:
However, if you’re more comfortable working with lists it might be the easiest solution.
I’ll have a look at this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
