Not able to Write data into Data Store Entity

Question

Hi team, I am unable to write the data in data store entity. Data is getting stored in process variable but when I am trying to store the same process vaiable data into appian db, only auto-generated key value and a new row is getting stored and not the whole data which I am trying to store. Please help me in this regard. 
 Below is the process model-

For fetch data from API, I have the following configurations as shown in the screenshots below-

I am getting the data as list of texts as you can see in the above screenshot. I have created a CDT from the table. Table and CDT structure can be seen below-

I have created a process variable which can be shown in below screenshot-

Below are the screenshots showing the Write To Data Store Entity node configuration

Now after running the process, the value in the process variable is not getting saved and not in table too. However in the table, blank rows are getting added with a auto generated incremental id.The status of the table can be seen in below screenshot.

Below you can see the running process status screenshots,

Even after checking the "Multiple" option in Write To Data Store Entity node, I am getting the following error on the same node,

Could any one please help in this regard ?

Stefan Helzle · Accepted Answer

Can you add the details of the database node? You need to turn that list of strings into a list of that CDT type. I do not see this happen.

Harshit Bumb (Appyzie) · Answer

As Stefan said, you need to cast the primitive datatype into a custom data type.
In order to save data in the DB, the data should be casted in the corresponding table's CDT. You will need to integrate through the list of text strings that are being generated in your Expression rule and then in the expression part of the loop, you need to construct a CDT using type!

Also, because it is multiple, please mark the Process variable and Node Variable as "Multiple"

Harshit Bumb (Appyzie) · Answer

Not able to Write data into Data Store Entity

Top Replies