Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
2569 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have an XML response that returns a text data type however, the CDT in which I
karlaw
over 11 years ago
I have an XML response that returns a text data type however, the CDT in which I need to save the response values requires this field be an integer. How would I go about converting this value from text to integer?
XML Response value is text data type: AvailableBalance
if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()") )
Need to convert this specific field to integer in multiple PV array....
OriginalPostID-60769
OriginalPostID-60769
Discussion posts and replies are publicly visible
Parents
0
Abhishek Shadangi
Appian Employee
over 11 years ago
Wherever makes sense, Appian also does the implicit data type conversion when saving expression values to the ACPs or the PVs. So, in addition to what Owen mentioned, you can also simply assign an expression with Text output to a PV of type Number (Integer) -- if the text can't be converted to a number, Appian will simply save a NULL value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Abhishek Shadangi
Appian Employee
over 11 years ago
Wherever makes sense, Appian also does the implicit data type conversion when saving expression values to the ACPs or the PVs. So, in addition to what Owen mentioned, you can also simply assign an expression with Text output to a PV of type Number (Integer) -- if the text can't be converted to a number, Appian will simply save a NULL value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data