I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured in cdt as autogenerate),Like paasing a code in userId which returns {2,2,2,2}code in product id returns {1,2,3,4}code in userProduct quantity returns {100,55,68,75}code in total price returns {100,230,45,67}
isactive is trueCan you help me what is the issue here?
Discussion posts and replies are publicly visible
Could it be that you changed the ID field to auto-generate after publishing that data store? Appian will not modify an already existing field.
XSD for the same<xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:TS" targetNamespace="urn:com:appian:types:TS"> <xsd:complexType name="TS_DataType_User_Product_Cart"> <xsd:sequence> <xsd:element name="id" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="userId" nillable="true" type="xsd:int" /> <xsd:element name="productId" nillable="true" type="xsd:int" /> <xsd:element name="userProductQuantity" nillable="true" type="xsd:double" /> <xsd:element name="totalPrice" nillable="true" type="xsd:double" /> <xsd:element name="isActive" nillable="true" type="xsd:boolean" /> </xsd:sequence> </xsd:complexType></xsd:schema>
You need to check that directly in the database.
Thanks for the help,Actually I don't know what to check,Is the below screenshot is fine?
Hi Thanks a Lot, The error got resolved but
I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured as autogenerate),Like paasing a code in userId which returns {2,2,2,2}code in product id returns {1,2,3,4}code in userProduct quantity returns {100,55,68,75}code in total price returns {100,230,45,67}
isactive is truein table only 1st values are getting writtenin above case it is only creating only 1 row instead of 4 rowsin this case am I supposed to use looping and writing every time?
No. You need to pass multiple CDT items instead of multiple values per each field.
Thanks a Lot ,I need to rework my interface with CDT, then it should work fine.