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
Kelly KKelly K 

Bypass Validation Rules with Excel Connector?

Hi All,

 

Is it possible to bypass validation rules using the Excel Connector? If so, how? 

 

Thanks

Kelly KKelly K

I was able to figure this out after several testing instances.

 

For anyone who's curious - Validation rules are only checked with API versions 7 or newer. Source: http://na1.salesforce.com/help/doc/en/fields_validation_considerations.htm

 

The excel connector is able to change which API version they use as Salesforce does not block older API versions currently. You change this on login by modifying the Server URL to read something like this:

 

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

 

Any versions 6.0 or lower bypass validation rules.

 
RupaliJRupaliJ

Hi,

 

I have changed ALI version in url to 7.0. Still my validation rules are not executed while inserting records. Can you please help me out?

 

Thanks.
Kelly KKelly K

I did a quick check and it does look like 7.0 doesn't use validation rules. If you switch it to 8.0 or higher, it does.

 

If I recall correctly, some of the older versions of the excel connector default to an API version that doesn't requrie validation rules (such as 6.0). You can upgrade to one of the more recent versions to get the default URL to go to a higher version so you don' thave to change it every time you log in.

 

My default URL that I use is https://www.salesforce.com/services/Soap/c/13.0. It hits validation rules.

 

I'm also using this version (for EE version): http://code.google.com/p/excel-connector/downloads/detail?name=sforce_connector_ee_1603.zip&can=2&q= with the Office Toolkit 4.0 MSI: http://code.google.com/p/excel-connector/downloads/detail?name=SForce_Office_Toolkit_MSI.zip&can=2&q=.

 

Hope this helps!