I want to generate an excel sheet using JSON to Excel converter plug in. Even though I am passing the json correctly, I am getting an error message:
Discussion posts and replies are publicly visible
What's the full error text say? Your screenshot is too cramped to really tell, and it may also be truncated. Also, can you clarify what plug-in this is? I haven't seen this smart service before, and I'm actually rather interested in it.
Error Message: Invalid Document com.google.gson.JsonSyntaxException: com.google.gson.stream.MalformedJsonException: Unterminated array at line 1 column 7 path $[1]See github.com/.../Troubleshooting.md
FYI as I mentioned in my earlier reply, this appears to work when the JSON you pass in is a valid array. Here's mine after passing it into an arbitrary pre-configured excel base template I already had sitting around in our Dev environment (with a "name" column and some other columns with irrelevant names). Note my JSON is an array of items, not a single dictionary. Also even though the smart service doesn't let you choose the starting column (just row), you can accomplish this by formatting the JSON such that the first column is left blank (just mentioning this since my templates mostly have a blank "spacer" column first).
thank you for your help, it is working now.
Hi, I am also using this plugin and its working for my first set of json, i need to fill other sheets in same excel too then its not creating doc or generating error as well for the exact same info. what seems to be issue here?
are you passing the output doc from first node as base template or document to update field in the 2nd Json to excel converter node? If you are passing it will not create a new doc but update the first doc itself.
yeah, can you share any more info about your configuration for the first node, and exaclty what you're passing into the second node?
Yes, when I pass first document as template to second one then it did nothing..i was expecting it would write on to sheet 2 as configured but it just didn't create any document or error. When I passed same document template as for first one then it created 2 documents from both nodes but I wanted single document with 2 sheets in it
Can you show a little more detail about the output configuration from the 1st node and the input configuration in the 2nd node?