Hello,
I have a requirement to store smileys in Database(SQL server). A user enters a value in a paragraph field and insert some smileys along with text, It is a free text field.
When I tried to store the user entered value in Database using "Write to data store entity" smart service then it get stored successfully in DB but when I tried to store the same value into the same table using "Write to multiple Data Store entities" smart service then I am getting below error:
XML handling failure trying to convert value EntityData [entity=DataStoreEntityRef[id=02377f7c-84c4-4948-9170-470ec382075e@22976, uuid=null], data=[TypedValue[it=3921,v={7,via Multiple data store }]]] to Appian type EntityData (id=2134).
I can store values in DB using "Write to data store entity" Smart service but I want to know why the same case can't be handled with "Write to multiple Data Store entities".
Suggestion much appreciated!!
Discussion posts and replies are publicly visible
Hi umesh
Thanks for suggestion but I have tested this case for single entity only. As I mentioned that I got this error while trying to enter same data in same table using multiple data store entities(contains single entity only, as it is for testing purpose).
Just for confirmation, smileys which you are able to store in DB are of what type
1. :) (This what we can type in from keyboard).
2. Proper smiley which we generally use in chat apps (I am not able to attach it here).
Because if it is first case then there is no problem in either case. But in second case(proper smiley face) multiple data store is not able to convert it into proper Xml as what I figured out from alert.
Hi Prateek,
Its working for me in oracle DB. please check attached images.
May be its an issue with SQL Server Db to interpret emoji character. below link might be useful for you.
Below is the image of grid showing emoji.
Below is the image of DB table with emoji's
Hi Umesh,
I don't know why it is working in your case.
I have created a POC for this and tested it using both "Write to data store entity" & "Write to Multiple Data store entity" and it caused error for the later case.
I am attaching the screenshots of the issue in below attachment , If possible could you please check this and let me know if I am doing something wrong here:
Write to Multiple Data store entity issue.docx
Are you talking about actual icons? Because if you are, I do not think Appian can do this.
All input text fields are plain text while I believe the icon functionality is enabled only with rich text, which you cannot use as an input field.
If the 'Write to Data Store Entity' node is working while the 'Write to Multiple Data Store Entities' is not, why don't you use multiple 'Write to Data Store Entity' nodes?
@Eliot: this was my first thought, but why in this user's case would the single WTDS node work while the (M)WTDS node fails? saniyag - Smileys are actually unicode characters. i.e. the expression "char(128514)" would result in my favorite smiley: