function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Book_GuyBook_Guy 

sforce Excel Connector - Record Type

Hi All,

 

I am trying to upload data to a custom object using the sforce Connector and the Record Type field is not available.  Does anyone know how to make the Record Type field available?

 

--David

Best Answer chosen by Admin (Salesforce Developers) 
Book_GuyBook_Guy

Thanks Jim.  Your post gave me hope that there was an answer.

 

For anyone else who encounters this issue the fix is go to Options (advanced tab) in the sforce dropdown and type:

https://www.salesforce.com/services/Soap/c/7.0

in the Specify Default Server box.  Ours was set at 6.0 which was the cause of the problem.

 

--David

All Answers

JimRaeJimRae

I just checked my install, and the RecordTypeID field is available. 

Have you created record types for the object, and is that field visible to your profile? 

That is all I can think of.

Book_GuyBook_Guy

The field is visible to all users.  Can you verify that you are able to see it on Custom objects.  We can see it fine on all standard objects, but not on any of our custom objects.

 

Thanks,

David

JimRaeJimRae

I can see it on Custom Objects as well.

Book_GuyBook_Guy

Thanks Jim.  Your post gave me hope that there was an answer.

 

For anyone else who encounters this issue the fix is go to Options (advanced tab) in the sforce dropdown and type:

https://www.salesforce.com/services/Soap/c/7.0

in the Specify Default Server box.  Ours was set at 6.0 which was the cause of the problem.

 

--David

This was selected as the best answer
teamkteamk

Current API is between 16 and 18 - putting 16.0 in the api url seems to work best.