Apex Code Development You need to sign in to do that
Don't have an account?
Mike Lee 12 Possible to query number of validation rules in use?
Hello,
I wanted to know if it's possible to query via the REST API the number of validation rules in use by an Object? We're starting a rollout of Salesforce Enterprise and from what I've read there is a limit of 100 validation rules for a single object. I'd like to programmatically setup a job on an external server that queries things like validation rules and if we approach some sort of threshold to email/alert out.
Thanks,
Mike
I wanted to know if it's possible to query via the REST API the number of validation rules in use by an Object? We're starting a rollout of Salesforce Enterprise and from what I've read there is a limit of 100 validation rules for a single object. I'd like to programmatically setup a job on an external server that queries things like validation rules and if we approach some sort of threshold to email/alert out.
Thanks,
Mike
For this you want to use what we all the MetaData API... its just a REST api, but connects you to the "configuration layer" - the meta data - of your org. All your custom objects, all your approval processes and yes, all your validations rules are in there, so you can start to build up queries over that info and do what you want with them.
Now this post uses the Metadata API from within an Apex page - but the example an be easily ported across to things like Java - or whatever you are a programmer in..
Here is the validation rules query bit:
https://developer.salesforce.com/forums/?id=906F0000000Ai6kIAC
here is a little example of connecting to the metadata api from Java
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_quickstart_java_sample.htm
(use the left nav to find tasty bits)
And here is what you can get about each validation rule:
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_validationformulas.htm
post back if you have any luck? I would be interested to hear how this goes. :)
All Answers
For this you want to use what we all the MetaData API... its just a REST api, but connects you to the "configuration layer" - the meta data - of your org. All your custom objects, all your approval processes and yes, all your validations rules are in there, so you can start to build up queries over that info and do what you want with them.
Now this post uses the Metadata API from within an Apex page - but the example an be easily ported across to things like Java - or whatever you are a programmer in..
Here is the validation rules query bit:
https://developer.salesforce.com/forums/?id=906F0000000Ai6kIAC
here is a little example of connecting to the metadata api from Java
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_quickstart_java_sample.htm
(use the left nav to find tasty bits)
And here is what you can get about each validation rule:
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_validationformulas.htm
post back if you have any luck? I would be interested to hear how this goes. :)
Mike