I've successfully used the Bizops API for a couple tasks in the past.
What I'd like to do now is use the Bizops API to find the constituent associated with an EDM finder number.
When a user receives an EDM sent by us through CRM/BBIS the links (such as the unsubscribe link) include a querystring which includes a value for efndnum.
By looking up the value of efndnum in the table CONSTITUENTAPPEAL I can see that I can find the correct associated constituent guid. But I need to look this up using the Bizops API.
The right tool for the job would seem to be the Bizops "DataList" service called "Marketing Finder Number Lookup". I've tried making a request to this service but I get an error response saying that the underlying stored procedure requires the FINDERNUMBER parameter, even when I pass a filter containing a value for FINDERNUMBER in the request.
Does anyone have any experience with this or suggestions? Or alternative Bizops services I could try?
With much thanks!
Here's the response (truncated):
"StatusMessage":"Unable to load data list.
Procedure or function 'USP_DATALIST_MKTFINDERNUMBERLOOKUP'
expects parameter '@FINDERNUMBER',
which was not supplied.",