Storing multiple data entities in single transaction

You might want to create a constant for each entity and use in place of process variable. Also you do not need to mention each field in data just a process variable with right data type (CDT) will write the data to entity.

{
{
entity: cons!DSR_PROJECT_ENTITY,
data: pv!DSR_Project
},
{
entity: cons!DSR_PROJECTTEAM_ENTITY,
data: pv!DSR_ProjectTeam
},
{
entity: cons!DSR_MILESTONE_ENTITY,
data: pv!DSR_MileStone
},
{
entity: cons!DSR_MILESTONETASK_ENTITY,
data: pv!DSR_MileStoneTask
}
}

Hi gangadharr0001

You can follow the below structure for writing to multiple data store entity. Your pv should be of cdt type where you can store all the individual field data.

{

{entity:cons!ENTITY_PROJECT,data:pv!Project},

{entity:cons!ENTITY_PROJECT_TEAM,data:pv!projectteaam},

{entity:cons!ENTITY_MILESTONE,data:pv!milestone},

{entity:cons!ENTITY_MILESTONE_TASK,data:pv!milestonetask}

}



Documentation: https://docs.appian.com/suite/help/20.3/Write_to_Multiple_Data_Store_Entities_Smart_Service.html#example-inputs

Vadivelan and rickyc0001 ,

As per you guys suggestion i did but in variables value showing no value .Please look at images

Your data PV's will need to be populated with data beforehand for this to work.  You'll need to troubleshoot your SAIL form and/or the configuration in which your form is passing data back to the process.

Verified SAIL form ,process model executing fine but its not updating process variables .only saving data in project entity remaining entities storing null values .and also projectteam,milestone ,milestonetask  is child tables of project .Can you give suggestion on this

Please provide some further details (screenshots etc) of your user input task's Data Inputs tab as well as the Form configuration.  Those are the things we need to see to verify whether it'd be expected to work.

Per your screenshot above it looks as if your DSR_Project PV is populating with some valid data.  We can't tell much about the others based on what you've provided so far.

As per your request user input data and user input form.Please look t once 

Thanks

mike schmitt

Can you give me suggestion on above post

Thanks

Please find below post regarding above issue

Just to confirm - you showed the project variable in your screenshot of the user input task, and it appears that one is saving data to your process correctly. Are you doing the same thing (using a saveInto in the inputs of your user input task) for the other variables?

Also, is it possible that your form isn't saving the data correctly? If you go to the interface and submit the form from Interface Designer, do you see the rule inputs populated with data you expect?