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
Discussion posts and replies are publicly visible
The error occurs because a!fromJson() expects a Text input with valid JSON, but pv!jsonPv is already a Map (parsed structure). You don’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’d like more assistance.
a!fromJson()
pv!jsonPv
Hi Megha Ramnani I want to save the ID values in employeeIDs as a row in db for each emailaddress but now it is taking only value of first emailaddress. can you please help
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.
Shall I create a separate DB for mail & employeeIds and then create record for it .After that , in process model i need to call this record to store the ID values..?
can you briefly explain what you want to achieve?Just a scenario is pretty enough!
I will enter some emailaddresses on UI .After integration is success then it has save Email & ID related to that in db in each row.Example : {id: "abcienbfe" ,email:"tet@test.vom" ; {id:"124n2iw",email:"test@test.com"}}In DB my value should be stored as requestid(foreignkey ,employeeID,emailAddress)1 abcdei test@test.vom2 124n2i1 test@test.com