[SalesForce] Determine sobject Type From Id Using SOAP API

I'm using C# and would like to determine the type of an sObject based on it's id.

I would like to pass an id to my app and have it return a list of accounts related to it. I need to identify the sobject type of the id so I can create a proper soql query for it. (If it's an Invoice__c do one query, if it's a Crazy_Custom_Grandchild__c do another, etc…)

I tried a .search() api call like this:

FIND {'001800000116UUiAAM'} IN Id FIELDS RETURNING Contact(Id, Phone, FirstName, LastName), 
Lead(Id, Phone, FirstName, LastName), Account(Id, Phone, Name)

but received a malformed query error because of the id field.

I don't want to have to do a whole bunch of try ... catch calls, there has to be a better way…

Best Answer

best solution I've come up with so far is to use .describeGlobal() like this:

DescribeGlobalResult dgr = binding.describeGlobal();
DescribeGlobalSObjectResult dgsr = dgr.sobjects.FirstOrDefault(x =>
    string.IsNullOrEmpty(x.keyPrefix) ? false : id.StartsWith(x.keyPrefix));

    if (dgsr != null)
    {
        switch (dgsr.name)
        {
            case "custom1__c":
                ...
                break;
            case "custom2__c":
                ...
                break;
            case "custom3__c":
                ...
                break;
            default:
                ...
                break;
        }
    }

Related Solutions

[SalesForce] Examples of using queryAsync in SOAP API

The following is using the G4S .NET wrapper to establish the Salesforce Session, but the SalesforceServiceWrapper from the Binding property will be more or less the same as what you get from importing the SOAP WSDL.

    // Used to synchronise the threads in the test case.
    ManualResetEvent completion = null;

    [TestMethod]
    public void QueryAsync()
    {
        // Custom G4S code to establish a Salesforce session.
        SalesforceSession salesforceSession = codeRemoved; 

        // This should be the class that gets generated from the SOAP WSDL.
        SalesforceServiceWrapper salesforceServiceWrapper = salesforceSession.Binding;

        // Register for the async completion event.
        salesforceServiceWrapper.queryCompleted += 
            new queryCompletedEventHandler(Binding_queryCompleted);

        completion = new ManualResetEvent(false);
        // Note that you can optionally pass a UserState object that will be returned
        // in the completed EventArgs
        salesforceServiceWrapper.queryAsync("select Id from lead limit 1", "HelloWorld");
        completion.WaitOne();
    }

    void Binding_queryCompleted(object sender, queryCompletedEventArgs e)
    {
        // Check the EventArgs to see is the query was cancelled or there
        // was an exception.
        System.Diagnostics.Debug.WriteLine("Cancelled:{0} Error:{1} UserState:{2}", e.Cancelled, e.Error, e.UserState);

        // Get the results of the query
        QueryResult qr = e.Result;

        // Signal that the async operation is complete
        completion.Set();
    }

[SalesForce] sObject ‘ ‘ type is not supported

Check that the Profile of the User you are using has at least Read Acess to the sObjects you are missing. Also I believe Assets need to be enabled by enabling Products, so worth checking that Products are enabled.

Also you are missing all the standard CRM objects like Account and Contact so worth checking what type of license is assigned to your user, you would need a Salesforce (CRM) license to be able to access the CRM objects.

Additionally, similar to Assets, certain objects become available only when the associated features are enabled eg Product Schedules

Best Answer

Related Solutions

[SalesForce] Examples of using queryAsync in SOAP API

[SalesForce] sObject ‘ ‘ type is not supported

Related Topic