How to add values in each row

Question

I'm currently passing emailaddresses in each line but when i submit it is storing values as test@test.com;test2@test.com but it has tostore in db as in new line and it has to be passed to an integration as {"test@test.com,test2@test.com"}

Can someone please help

Harsha Sharma · Accepted Answer

Glad to hear! Would appreciate if you verify my suggested answers that might have helped!

Shubham Aware · Answer

Give this a try and let me know if that works... For Database Storage (with newlines): Change line 219 --> a!save(ri!GASR_Requests.emailAddresses, local!data.emailAddresses), For integration: local!formattedEmailString: concat( "{""", joinarray(local!individualEmails, ","), """}" ),

Harsha Sharma · Answer

Can you try this if this gives the output you expect 
 a!localVariables(
 local!emailsfromDb:{
 "test1@test.com, test2@test.com, testInvalid@test.com,test3@test.com"
 },
 local!emailsFromIntegration:{
 a!map(
 email:"test1@test.com",
 uuid:"asdf1233"
 ),
 a!map(
 email:"test2@test.com",
 uuid:"qwer123"
 ),
 a!map(
 email:"test3@test.com",
 uuid:"asdf1233"
 )
 },
 local!emaildbFormatted:trim(split(local!emailsfromDb,",")),
 difference(local!emaildbFormatted,local!emailsFromIntegration.email)
)

Harsha Sharma · Answer

I prefer to do in process script task and save in a dedicated variable, but in your case adding in interface shouldn't cause any issues too. So its up to you! If you setup in process then you can see the value in monitoring mode in case any error comes up in integration - it helps in debugging. Hope this clarifies!

Harsha Sharma · Answer

Is this EmailPV a multiple type process variable? Can you try changing it to single and pass the values from local!formattedEmailString to the corresponding rule input and thus pv EmailPV?

Harsha Sharma · Answer

Can you open the expression editor here and verify its not wrapping variable into "". If you see others don't have = signs in the value column except last two. EVen there one is a pv so the last one you should check and map to pv appropriately.

Harsha Sharma · Answer

submit is true for your button. when you click submit the process will get data from rule inputs and proceed ahead. you dont need additional start process smart service here. our current interface where you input email address and has that error field in a user input task in the same process right - GASR_WRITE_REQUESTS ?

Harsha Sharma · Answer

Hi Check the output node variables after integration node execution. Looks like the integration has some error and thus it should only go to UI if its successful. So 2 things need to be done here 
 1. in the xor check that if integration call is successful then only route to 2nd user input task. 
 2. if the inetegration fails then user input node should not execute rather have a separate flow to handle error / exception scenario. Generally it includes retrying integration for 3 times and then notifying app administrators using email that integration has some error.

How to add values in each row

Top Replies