Tooling Api query on metadata field of workflowRule and ValidationRule

Question

Hi Experts,

I want to get the metadata result of workflow rule and Validation Rule through tooling api.

but salesforce have a limit "Query this field only if the query result contains

no more than one record. Otherwise, an error is returned. If more than one record exists,

use multiple queries to retrieve the records. This limit protects performance."

this query working fine:

/services/data/v41.0/tooling/query/?q=Select+Name,MetaData,TableEnumOrId+From+WorkflowRule+LIMIT+1

but I want more than record like the below query and this not work :

/services/data/v41.0/tooling/query/?q=Select+Name,MetaData,TableEnumOrId+From+WorkflowRule

is there another alternate solution to overcome of such type of situation.

Thanks

Mukesh Kumar

Amit Chaudhary · Answer

Cannot retrieve more than one record with Metadata or FullName fields in the query

Please check below post for workaround

NOTE:- If you will remove metadata then your query will work

/services/data/v41.0/tooling/query/?q=Select+Name,TableEnumOrId+From+WorkflowRule

I hope this will help you

Apex