function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Alex.AcostaAlex.Acosta 

Salesforce SOAP API returning incorrect data

Hi there,

 

Been having a few issues with the Salesforce API for a while now... this doesn't happen often but it does occur pretty frequent. The link below is just an images to show what is happening....

 

http://i.imgur.com/VsMZf.png

 

Basically, I'm just showing off how 1 particular record looks like and the issue that seem to be occuring within the response from Salesforce which appears to be a bug. 

 

On section:

#1 -- I'm just showing Id of the record that's being retrieved.

#2 -- One of the values we're pulling back is slightly correct, but also very wrong. the value associated to the record is 0.0000 but the response we get back from salesforce is 9.2756605126005708706853560339489977171E-34..... instead of limiting to the 18 character float value it's suppose to be.

#3 -- Just a standard query we are using to pull back records from salesforce

#4 -- Showing the record we retrieved using the salesforce WSDL generated Class sObject

#5 -- Our field definision which is also incorrect. In this case, Salesforce is describing the field as a double with 26 field lenght size when the maxium allowed is 18 and also showing incorrect values.

 

I've tried submitting this as a bug through the partner portal, but Salesforce no longer supports none 'premium' partners when submitting a development case. 

 

I would greatly appreciate some help with this issue and figure out records are being retrieve in this way.

 

Thanks for your time.

 

Alex.AcostaAlex.Acosta

Here's the record from the UI / Browser, which has a completely different value

 

http://i.imgur.com/3ecya.png

 

I also have access to the raw SOAP request / response, and they both show the same as in the parsed value within .NET....

 

Definition

<fields>

<autoNumber>false</autoNumber>
<byteLength>0</byteLength>
<calculated>false</calculated>
<caseSensitive>false</caseSensitive>
<createable>true</createable>
<custom>true</custom>
<defaultedOnCreate>false</defaultedOnCreate>
<deprecatedAndHidden>false</deprecatedAndHidden>
<digits>0</digits>
<filterable>true</filterable>
<groupable>false</groupable>
<idLookup>false</idLookup>
<label>Score</label>
<length>0</length>
<name>Score__c</name>
<nameField>false</nameField>
<namePointing>false</namePointing>
<nillable>true</nillable>
<precision>18</precision>
<restrictedPicklist>false</restrictedPicklist>
<scale>8</scale>
<soapType>xsd:double</soapType>
<sortable>true</sortable>
<type>double</type>
<unique>false</unique>
<updateable>true</updateable>

</fields>

 

Record

<records xsi:type="sf:sObject">
	<sf:type>Analytic_Snapshot__c</sf:type>
	<sf:Id>a1C50000000PlYzEAK</sf:Id>
	<sf:Id>a1C50000000PlYzEAK</sf:Id>
	<sf:OwnerId>00550000001b5RGAAY</sf:OwnerId>
	<sf:IsDeleted>false</sf:IsDeleted>
	<sf:Name>00027182</sf:Name>
	<sf:RecordTypeId>01250000000Q1S3AAK</sf:RecordTypeId>
	<sf:CreatedDate>2011-10-01T04:03:02.000Z</sf:CreatedDate>
	<sf:CreatedById>00550000001b5RGAAY</sf:CreatedById>
	<sf:LastModifiedDate>2011-10-01T04:03:02.000Z</sf:LastModifiedDate>
	<sf:LastModifiedById>00550000001b5RGAAY</sf:LastModifiedById>
	<sf:SystemModstamp>2011-10-01T04:03:02.000Z</sf:SystemModstamp>
	<sf:Account__c xsi:nil="true"/>
	<sf:User_Full_Name__c xsi:nil="true"/>
	<sf:Portal_User_Monthly_Last_Login_Date__c xsi:nil="true"/>
	<sf:Portal_User_Individual_Login_Date_Time__c xsi:nil="true"/>
	<sf:Portal_User_Login_Month__c>Unknown</sf:Portal_User_Login_Month__c>
	<sf:Contact__c xsi:nil="true"/>
	<sf:Portal_User_Individual_Login_Date__c xsi:nil="true"/>
	<sf:Article_Number__c>000001841</sf:Article_Number__c>
	<sf:Channel__c>All Channels</sf:Channel__c>
	<sf:Created_Date__c>2011-01-13</sf:Created_Date__c>
	<sf:First_Published_Date__c>2011-01-13T20:19:29.000Z</sf:First_Published_Date__c>
	<sf:Last_Published_Date__c>2011-01-13T20:19:29.000Z</sf:Last_Published_Date__c>
	<sf:Score__c>9.2756605126005708706853560339489977171E-34</sf:Score__c>
	<sf:Ticket_Association_Count__c>0.0</sf:Ticket_Association_Count__c>
	<sf:Content_Subscriptions__c xsi:nil="true"/>
	<sf:Content_Downloads__c xsi:nil="true"/>
	<sf:Content_Versions__c xsi:nil="true"/>
	<sf:Content_Positive_Votes__c xsi:nil="true"/>
	<sf:Content_Negative_Votes__c xsi:nil="true"/>
	<sf:Content_Overall_Rating__c xsi:nil="true"/>
	<sf:Content_Type__c xsi:nil="true"/>
	<sf:Views__c>4.0</sf:Views__c>
	<sf:Visible_in_Internal_App__c>true</sf:Visible_in_Internal_App__c>
	<sf:Article_Stat_ID__c>0GA500000004JJg</sf:Article_Stat_ID__c>
</records>