Data Output error

Question

Getting error in the script task. I'm trying to pass the below jsonPV in PM.I want to store the id values in DB as separate row

Stefan Helzle · Answer

That jsonPV is not JSON. Keep in mind that the way Appian displays maps and dictionaries looks almost like JSON, but is not.

Megha Ramnani · Answer

The error occurs because a!fromJson() expects a Text input with valid JSON, but pv!jsonPv is already a Map (parsed structure). You don&rsquo;t need to use a!fromJson() in this case. or you could change the type of your process variable to text . Hope this helps! Let me know if you&rsquo;d like more assistance.

Varun Teja Gurrapu · Answer

Hi ZAINAB ,

You are trying to convert JsonPV which is of Map Type and not JSON Type.

You can directly write the data without using a!fromJson() function. Check the mappings thoroughly and write it to other PV!

Varun Teja Gurrapu · Answer

You need to iterate the IDs from Result PV, take an output, construct the record and save it Use PV as multiple, I can see the output_Requests is not multiple. You cannot add multiple IDs to a single employeeIDs column, if you are doing that.

Harsha Sharma · Answer

Just remove the fromjson() from your expression and try!

Megha Ramnani · Answer

Sure! The issue is happening because you're iterating only at the top level. To save each employeeID along with its corresponding emailAddress , you&rsquo;ll need to flatten the structure using nested a!forEach() . This code might help you generate one row per id with its corresponding email address.

Data Output error

Top Replies