Can WP Webhooks Do This?

Hey @randit – Thank you a lot for your message!
Can you please give me some more details on how you want/can access the external database?
Depending on that I can give you more information on how it would work.
Thank you already a lot.

Hi!

Thank you so much for the fast response. I am open to ideas/suggestions as I have never done this before.

Here is more info that might help you know what I need:

The goal of the combined report link is to search for a property in Realist and return an XML form containing information on that property for use in the vendor’s system. This enables a vendor to instantly incorporate current Realist property data into reports and functions.
1. The link enables a user to search the Realist record for that particular listing by:
? Search Type o searchType = CombinedAutopopDetail ? Search Parameters (Optional) o operator = option to select the search operator for searching (is or startswith) o displayFormat = option to return the XML in either fixed or dynamic format (dynamic or fixed) o formatValues = option to return XML with or without formatting (true, false or TextCamelCase) ? County o countyId = the unique FIPS code assigned to each US county and as used within Realist ? Address, where: o address = full street address ? Street Components, where: o houseNo = House number (numeric input only) o preDir = Street pre-directional preceding a street name (N, S, E, W, NE, NW, SE, or SW only) o streetName = main body of street name only (alphanumeric characters only; i.e., no special characters except dashes, no nulls or spaces at the beginning or end of the string) o suffix = Street Suffix Ex. St, Rd o postDir = post-directional following a street name (N, S, E, W, NE, NW, SE, or SW only) o unitNumber = Condo or apartment unit number (no special characters except dashes) o city = Property City name o zip = 5 digit zip code of property ? Tax, where: o taxId = the assessor’s parcel number or tax-id (alphanumeric data, dashes or periods only – other special characters are not permitted) ? Owner Name, where: o ownerLastName = Owner Last Name o ownerFirstName = Owner First Name (first name is optional) ? Formatted Data Values, where: o formatValues = Yes, results in values being returned formatted o formatValues = No, results in values being returned not formatted and passed RAW in the XML o formatValues = TextCamelCase, results in values being returned formatted with camel case text and unformatted numbers o Default of no value will be the same as formatValues = Yes

Note: Suggested parameters to link and retrieve a property in Realist are:
? County AND ? Tax-id AND ? Address AND ? Owner Last Name Owner Last Name is an option, but not highly recommended, whereas Tax-id and Address parameters are highly recommended. Our recommendation is to send the concatenated Address, but as shown above, discreet fields are also available as an option.

Realist will conduct a cascaded search using Tax-id first, then if no matches are found use Address, then Owner Last Name, if provided.
Realist Specifications for Integration Confidential – Page 4

The request will pass a URL to Realist in one of the following forms (Post):

Expected Post Request for Tax-id, Address, or Owner name search:

APN Search: Service URL: https://mls.realist.com/spring/autopopDetail Post Input: userId=user&password=pass&groupName=group& searchType=CombinedAutopopDetail&countyId=06059&taxId=03520210

Address Search: Service URL: https://mls.realist.com/spring/propertylink Post Input: userId=user&password=pass&groupName=group& searchType=CombinedAutopopDetail&countyId=06059&address=714+Vine+ST+Anaheim+CA+ 92805

Alternative Address Search to include zip separately: Service URL: https://mls.realist.com/spring/propertylink Post Input: userId=user&password=pass&groupName=group& searchType=CombinedAutopopDetail&countyId=06059&address=714+Vine+ST&zip=92805

Owner-name Search: Service URL: https://mls.realist.com/spring/propertylink Post Input: userId=user&password=pass&groupName=group& searchType=CombinedAutopopDetail&countyId=06059&ownerLastName=smith

Cascaded Search: Service URL: https://mls.realist.com/spring/propertylink Post Input: userId=user&password=pass&groupName=group& searchType=CombinedAutopopDetail&countyId=06059&taxId=03&address=714+Vine+ST+Ana heim+CA+92805&ownerLastName=smith

2. Realist will execute a search for the property and return one of the three following scenarios:

? No record found ? Single record found ? More than one record found

3. Return XML Form:
The vendor system will initiate the link via a URL like the one shown above. One of 6 conditions will be addressed in an XML form returned by Realist:
? No record found ? One record found ? Multiple records found
? Too many records found ? Database connection failure
? Invalid parameters passed

Hey @randit – thank you for the fast response as well! ??
I checked on it and I have some more questions:

When should this Database be triggered? (After a user makes an input, with a cronjob or something else?)
Can you also tell me how the authentication would work on that API?

What I already want to mention up front: You probably need some custom development to make the webhooks work properly. (Unfortunately, we don’t have something out-of-the-box that makes this work).
Thanks already a lot for your answer.

Hi.

The database would need to be triggered when the user makes an input.

Here is the authentication requirements:

Realist requires that each link to Realist pass certain data that identifies and authenticates a user. Such data includes Realist group name, user id, password, first name and last name. These credentials must be encrypted during the transit to the Realist website, using a secure socket layer (SSL).
All parameters noted below must be included in each link.

Parameter (Authentication) [Mandatory]
Description Maximum Length
groupName
the unique name assigned to the Realist Account for the organization by CoreLogic
N/A
Password
the password assigned by Realist to the organization using the service
32 characters
userId
the unique logon id assigned by Realist to the organization using the service
50 characters
agentFirstName
the users first name as assigned by Realist to the organization using the service
40 characters
agentLastName
the users last name as assigned by Realist to the organization using the service
40 characters
countyId
the unique FIPS code assigned to each US county and as used within Realist
N/A

DO you think this would work with some custom development and if so what customization would be needed?

I sincerely appreciate your help with this! ??

Hey @randit – thank you again for your response.
I think in this case it makes more sense to use an API since it will be a lot more convenient later on to make changes to it.
Since it has to run on a users input, you need to have certain calls available that process this action, which means you need some custom development anyway.
I suggest you hire some good developer that can help you to solve this task.
Sorry to tell you that our plugin is not the best fit for that, but I’m feeling better to let you know that some custom work saves you a lot of struggle in the long run. ??
If you have any questions, just let me know.