JSON to Excel converter in process model is throwing an error

Question

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:

Stefan Helzle · Accepted Answer

Even if it might be confusing, the text box in which you enter your JSON is not meant to understand JSON. This is a SAIL language editor. 
 If you want to directly write JSON, then you need to wrap it in quotation marks. If you want to write it in Appian SAIL syntax, then you can use the toJson() function to turn it into JSON. 
 I suggest the second approach.

Mike Schmitt · Answer

I would expect the smart service expects a JSON string representing an array. The JSON present in your PV looks like a single dictionary. 
 A valid JSON array will take a decidedly different format, and requires you to input an array (fwiw).

Mike Schmitt · Answer

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).

Mike Schmitt · Answer

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.

Mike Schmitt · Answer

Can you show a little more detail about the output configuration from the 1st node and the input configuration in the 2nd node?

JSON to Excel converter in process model is throwing an error

Top Replies