I'm getting the following...

Code:

SOAP Exception: INVALID_FIELD: No such column 'Name' on entity 'user'.
 at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse
(SoapClientMessage message, WebResponse response, Stream responseStream,
 Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol
.Invoke(String methodName, Object[] parameters) at ApexEnterprise.SforceService
.update(sObject[] sObjects) in c:\WINDOWS\Microsoft.NET\Framework\
v2.0.50727\Temporary ASP.NET Files\root\8ad21003\1a001cc1\
App_WebReferences.bxqdj_uh.0.cs:line 603 at SF_DAL.SaveLead(Object CurrentLead)
 in C:\Inetpub\TESTSITE\App_Code\SF_DAL.vb:line 78

Whenever I  call this function with a Lead object as an arguement.


 Code:

 Public Shared Function SaveLead(ByVal CurrentLead As Object) As Boolean
        Dim SFContact As ApexEnterprise.Lead = CType(CurrentLead, ApexEnterprise.Lead)
        'HttpContext.Current.Response.Write(SFContact.FirstName)
        Dim strUsername As String = ConfigurationSettings.AppSettings("SFUsername")
        Dim strPassword As String = ConfigurationSettings.AppSettings("SFPassword")
        SFLogin(strUsername, strPassword)
        Try
            Dim myLeads(1) As sObject
            myLeads(0) = SFContact
            Dim saveResult() As SaveResult = Nothing
            SaveResult = myBinding.update(myLeads)
        Catch e As System.Web.Services.Protocols.SoapException
            HttpContext.Current.Response.Write("SOAP Exception: " & e.Message & e.StackTrace)
            Return False
        Catch ex As Exception
            HttpContext.Current.Response.Write("Exception: " & ex.Message & ex.StackTrace)
            Return False
        End Try
        Return True
    End Function

You can see there I've been checking that the Lead object passes to the function properly... and everything seems fine until the update method pukes. 

Any ideas?

I've added two custom fields to my leads, call them custom1__c and custom2__c, which are both text fields.

For some reason, when I generate and consume the enterprise api in a project, the lead object shows a property for custom1__c but never custom2__c.

If I look at the wsdl, the custom2__c is listed, but never shows as a property of a lead object.

Any idea why this would happen?

Message Edited by L0t3k on 08-02-2007 03:58 PM

I'll say right away, I'm just beginning to work with Salesforce, as we're evaluating now.

I've gotten the enterprise wsdl imported, and have managed to created a binding to SF, but I'm having trouble trying to add a lead.

This is what I have in that particular function...

Code:

        Dim newLead As New ApexAPI.Lead
        Dim createdUser As New ApexAPI.User
        createdUser.Username = "ttesterson@nowhere.com"
        Dim ownerUser As New ApexAPI.Name
        ownerUser.FirstName = "Test"
        ownerUser.LastName = "Testerson"

        newLead.FirstName = "James"
        newLead.LastName = "Dean"
        newLead.Company = "UltraMegaMart"
        newLead.LeadSource = "Web"
        newLead.CreatedBy = createdUser
        newLead.Owner = ownerUser

 Now I want to commit this object as a lead in our salesforce database.  I've seen examples of doing this with the partner wsdl, but not the enterprise one.  Unfortunately, I have no idea how to actually insert this lead.  A quick pointer would be much appreciated!

I'm getting the following...

Code:

SOAP Exception: INVALID_FIELD: No such column 'Name' on entity 'user'.
 at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse
(SoapClientMessage message, WebResponse response, Stream responseStream,
 Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol
.Invoke(String methodName, Object[] parameters) at ApexEnterprise.SforceService
.update(sObject[] sObjects) in c:\WINDOWS\Microsoft.NET\Framework\
v2.0.50727\Temporary ASP.NET Files\root\8ad21003\1a001cc1\
App_WebReferences.bxqdj_uh.0.cs:line 603 at SF_DAL.SaveLead(Object CurrentLead)
 in C:\Inetpub\TESTSITE\App_Code\SF_DAL.vb:line 78

Whenever I  call this function with a Lead object as an arguement.


 Code:

 Public Shared Function SaveLead(ByVal CurrentLead As Object) As Boolean
        Dim SFContact As ApexEnterprise.Lead = CType(CurrentLead, ApexEnterprise.Lead)
        'HttpContext.Current.Response.Write(SFContact.FirstName)
        Dim strUsername As String = ConfigurationSettings.AppSettings("SFUsername")
        Dim strPassword As String = ConfigurationSettings.AppSettings("SFPassword")
        SFLogin(strUsername, strPassword)
        Try
            Dim myLeads(1) As sObject
            myLeads(0) = SFContact
            Dim saveResult() As SaveResult = Nothing
            SaveResult = myBinding.update(myLeads)
        Catch e As System.Web.Services.Protocols.SoapException
            HttpContext.Current.Response.Write("SOAP Exception: " & e.Message & e.StackTrace)
            Return False
        Catch ex As Exception
            HttpContext.Current.Response.Write("Exception: " & ex.Message & ex.StackTrace)
            Return False
        End Try
        Return True
    End Function

You can see there I've been checking that the Lead object passes to the function properly... and everything seems fine until the update method pukes. 

Any ideas?

I've added two custom fields to my leads, call them custom1__c and custom2__c, which are both text fields.

For some reason, when I generate and consume the enterprise api in a project, the lead object shows a property for custom1__c but never custom2__c.

If I look at the wsdl, the custom2__c is listed, but never shows as a property of a lead object.

Any idea why this would happen?

Message Edited by L0t3k on 08-02-2007 03:58 PM

I'll say right away, I'm just beginning to work with Salesforce, as we're evaluating now.

I've gotten the enterprise wsdl imported, and have managed to created a binding to SF, but I'm having trouble trying to add a lead.

This is what I have in that particular function...

Code:

        Dim newLead As New ApexAPI.Lead
        Dim createdUser As New ApexAPI.User
        createdUser.Username = "ttesterson@nowhere.com"
        Dim ownerUser As New ApexAPI.Name
        ownerUser.FirstName = "Test"
        ownerUser.LastName = "Testerson"

        newLead.FirstName = "James"
        newLead.LastName = "Dean"
        newLead.Company = "UltraMegaMart"
        newLead.LeadSource = "Web"
        newLead.CreatedBy = createdUser
        newLead.Owner = ownerUser

 Now I want to commit this object as a lead in our salesforce database.  I've seen examples of doing this with the partner wsdl, but not the enterprise one.  Unfortunately, I have no idea how to actually insert this lead.  A quick pointer would be much appreciated!