How do I pass parameters into a Salesforce Query?
For example:
I have an input component for Name
In my Salesforce Query Contact Service, I have the following query:
SELECT Name FROM Contact
However, I want to only retrieve Contacts that match, or are like the value inputted
Should I change the service, and add a new Parameter for Name, and change the query to this:
SELECT Name FROM Contact WHERE Name like '%{Name}%'
Or, is there another way to retrieve values based on search parameters in a Salesforce Query Service?
When I perform a test in the Service, I get a Test Successful, but retrieve no results:
{
"totalSize":0,
"done":true,
"records":[]
}