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.