I have an XML response that returns a text data type however, the CDT in which I

tointeger() forum.appian.com/.../Mathematical_Functions

I tried that in multiple places...it doesn't work.

These are where I tried them:
tointeger(if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()") ))


if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", tointeger(xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()") ))


if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/tointeger()") )


if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text(tointeger())") )

Where does the tointeger go?

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.

I would expect both the first and second things you pasted to work. Depending on what "it doesn't work" means, there are different ways to debug.

I would start with confirming the actual type of the result of your expression. You can use the typename() and runtimetypeof() expressions for that. typename(runtimetypeof(<your whole expression>)) will tell you if you're actually getting an integer back or a string.

Some clarification, after testing further this sytax does convert the value to integer...
tointeger(if( (xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "//*[local-name(.)='AccountNumber']/text()") ))

The only problem remaining is that it only converts the first value in the pv array. There are several account number values in the XML response.

You should be able to use apply() like =apply(fn!tointeger,<if xpath here>) Or like Abishek mentioned try just saving into a List of Number (Integer) pv.

When values that exceed the Number(Integer) range are passed through a user interface, the excessive value is changed.

?In most cases, this is changed to a null value

I have solved my problem. I must convert to a string. Thanks everyone for providing me with direction!