The following pipeline demonstrates how you can implement a filter the Execute Snap's query parameters to retrieve a specific Account.
In this example, we have used a Mapper Snap to pass the value we are searching for into the name variable.
Now we craft the query parameter key and value pair in the Execute Snap. Note: In order to follow MS Dynamics 365 For Sales guidelines, we have to surround our "$name" variable with single quotes. This is because the "$name" variable is going to be evaluated by Microsoft as a string of characters. If we had been evaluating a numeric value such as a dollar amount, we would not surround the variable in single quotes. Note that there are some values that are entirely full of numeric characters, but are in fact strings (phone numbers, fax numbers, etc). Microsoft has provided the following detailed information regarding the use of "$filter" queries : Query Data using the Web API.
Now we see that we were able to successfully execute the request, and have indeed retrieved the account with the specified "$name" variable:
Download the sample pipeline