Select_XMLV2 returns a value of 0.0000 when field is set up to store data as an Integer.

dknoben — Tue, 06 Feb 2018 00:25:33 GMT

I do a Select_XMLV2 call to get a record, and one value, that is set up to be an Integer, is being returned as 0.0000 in the XML and that value is not an integer. Also, when I look at the value from within Method it is blank. The value is messing up my update call, because the API complains 0.0000 is not a number. Any ideas why that number is being returned at all when it is not set in Method and why it is returning 0.000 instead of just 0?

Here is the XML data that is returned from the select call, I have removed all the fields except the record id and offending data value.

<?xml version="1.0" encoding="windows-1252" ?>
    <MethodAPI response = "Success" MaxRecords= "False">
        <MethodIntegration Table='Enrollments'>
            <Record>
                <RecordID>1087</RecordID>
                <WelcomeReceptionUnder21Additional>0.0000</WelcomeReceptionUnder21Additional>
            </Record>
        </MethodIntegration>
    </MethodAPI>

Method:API Q&A

Select_XMLV2﻿ returns a value of 0.0000 when field is set up to store data as an Integer.

Select_XMLV2 returns a value of 0.0000 when field is set up to store data as an Integer.