Unable to update date & integer data types on salesforce record

[3keymedia]

Using a WSDL and C# I have successfully connected to my salesforce org and can update records, particularly any data type that is "standard" or a "text" string... but when I attempt to update "date" or "integer" the values remain "null"

We have tried various date formats and can not seem to figure out why the values will not successfully update for "date" and "integer" data types.

We have even tried hard coding the values in rather than parsing and still get the same result.

What could I be missing?

 

[jmcilhinney]

Show us the code. ALWAYS show us the code.

 

[3keymedia]

Anyone out there able to help? We have successfully passed data in via workbench, but still can not figure out why this "date" field will not pass when updating record. All other fields will update but this one, even when we attempt to hard code with correct string format. Here is a snippet of the code -

Dim c As Contact = outResult.records(0)
Dim contact As Contact = New Contact() With {
    .Id = c.Id,
    .FirstName = "C4 " & rgx.Replace(dr("FirstName").Replace(",", " "), " ").Trim,
    .LastName = rgx.Replace(dr("LastName").Replace(",", " "), " ").Trim,
    .REC_NO__c = dr("Recomendation").Replace(",", " ").ToString.Trim,
    .REC_EXP_DATE__c = "1/1/2019",
    .ID__c = "1234567"
    }

queryClient.update(header, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, New sObject() {contact}, outInfo, saveResult)

[Image: Gary Strahle]Gary Strahle · May 14

 

[3keymedia]

Just found the solution here! hOpe this helps anyone with the same issue - Update not working in SalesForce API and now the app crashes when trying

 

[3keymedia]

Please upvote this Idea on salesforce community to save people from loosing so much time in the future - https://success.salesforce.com/ideaView?id=0873A0000003e1bQAA

 

[JohnH]

One of the SO posts points to documentation where it is explained here under ".NET, Non-String Fields, and the Enterprise WSDL": Implementation Considerations | SOAP API Developer Guide | Salesforce Developers