![Logo-RETR-300x300-1.png]](https://kb.retr.app/hs-fs/hubfs/Logo-RETR-300x300-1.png?width=60&height=60&name=Logo-RETR-300x300-1.png){kind=logo}
RETR Loan Officer Webhook Data Specification: JSON Fields and Definitions
RETR Loan Officer Webhook Data Specification: JSON Fields and Definitions
RETR sends loan officer (LO) contacts to your CRM through a webhook as a JSON object. This page shows a sample payload and defines every field RETR sends.
How Does RETR Send Loan Officer Data to My CRM?
When you export loan officers from a RETR CRM Cart, RETR sends each contact to your CRM’s webhook URL as one JSON object. The object uses the fields listed below.
How to Test Your RETR Webhook Integration Before Exporting
Test your integration in Postman before you spend export credits on your RETR CRM Carts.
Step 1: Open the RETR Postman workspace
Open the RETR webhook testing workspace in Postman.
Step 2: Send the sample payload to your webhook
Send the sample loan officer payload to your CRM’s webhook URL.
Step 3: Check the field mapping in your CRM
Confirm that each field lands in the right place in your CRM before you run a real export.
{
"Owner": "RETR-Login-Email@email.com",
"NMLSId": "123456",
"FirstName": "Stephen",
"LastName": "Loaner",
"FullName": "Stephen Loaner",
"Phone_Cell": "555-555-1212",
"Phone_Work": "555-555-9999",
"Email_Personal": "StephenLoaner@gmail.com",
"Email_Work": "StephenLoaner@retr.app",
"WebsiteURL": "https://www.StephensHomeLoansForYou.com",
"LinkedInURL": "https://www.linkedin.com/in/stephenloaner/",
"TwitterURL": "https://twitter.com/StephenLoanerMortgages",
"ZillowURL": "https://www.zillow.com/lender-profile/StephenLoanerMortgages",
"ExperienceURL": "https://www.experience.com/reviews/Stephen-Loaner",
"FacebookURL": "https://www.facebook.com/StephenLoanerMortgages",
"GoogleURL": "https://search.google.com/local/writereview?placeid=abc123",
"InstagramURL": "https://www.instagram.com/stephenloanermortgages",
"Company": "ACME Mortgage",
"Office_Address": "1234 Main St",
"Office_City": "Fairfax",
"Office_State": "VA",
"Office_Zip": "22033",
"CompanyNMLSId": "111111",
"BranchName": "ACME Mortgage - Fairfax Branch",
"BranchNMLSId": "999999",
"LoanCount_12Mo": 33,
"LoanVol_12Mo": 25975406,
"LoanCt_Conventional_12Mo": 22,
"LoanCt_VA_12Mo": 2,
"LoanCt_FHA_12Mo": 8,
"LoanCt_Other_12Mo": 1,
"LoanCt_LMI_12Mo": 1,
"LoanVol_LMI_12Mo": 345000,
"LoanCt_MMCT_12Mo": 2,
"LoanVol_MMCT_12Mo": 567890,
"IsManager": "Yes",
"LastLoanDate": "12/29/2023",
"LoanCount_3Mo": 5,
"LoanVolume_3Mo": 5200725,
"LastPurchase_LoanDate": "3/4/2022",
"LastPurchase_Address": "1007 Mountain Drive, Gotham, NJ 12345",
"LastPurchase_Buyer1": "Bruce Wayne",
"LastPurchase_Buyer2": "Selina Kyle",
"LastPurchase_Agent": "Stephen Loaner",
"LastPurchase_AgentCompany": "RETR Realty",
"LastPurchase_SalePrice": 8625000,
"LastPurchase_LoanAmount": 646875,
"Tags": "New Jersey, Top Producer",
"ListName": "New Jersey Loan Officers",
"Source": "RETR",
"RETRProfileURL": "https://retr.app/LoanOfficer/Profile/0",
"RETRLoId": 1,
"ExportDate": "2/18/2024",
"Notes": [
{
"Summary": "4/14/2026 Interviewed candidate",
"Type": "Personal",
"Status": "Qualified",
"ListName": null,
"SharedListId": null
},
{
"Summary": "4/14/2026 - Team has all had great interactions with this candidate and they want to proceed forward",
"Type": "Shared List",
"Status": "Lead",
"ListName": "My shared list 1",
"SharedListId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
}
],
Loan Officer Data Field Definitions
Contact and Identity Fields
| Field | Description |
|---|---|
| Owner | Email of the RETR user who sent the data |
| NMLSId | The contact’s unique Nationwide Multistate Licensing System (NMLS) ID |
| FirstName | First name |
| LastName | Last name |
| FullName | First and last name |
| Phone_Cell | Mobile number |
| Phone_Work | Work number |
| Email_Personal | Personal email |
| Email_Work | Work email |
| IsManager | Whether the contact is a manager (“Yes” or “No”) |
Website and Social Profile Fields
| Field | Description |
|---|---|
| WebsiteURL | Contact’s website |
| LinkedInURL | Contact’s LinkedIn profile |
| TwitterURL | Contact’s Twitter (X) profile |
| ZillowURL | Contact’s Zillow profile |
| ExperienceURL | Contact’s Experience.com profile |
| FacebookURL | Contact’s Facebook profile |
| GoogleURL | Contact’s Google profile |
| InstagramURL | Contact’s Instagram profile |
Company, Branch, and Office Fields
| Field | Description |
|---|---|
| Company | The contact’s employer. If the contact belongs to a branch, this is the branch’s parent company. |
| CompanyNMLSId | NMLS ID of the contact’s company |
| BranchName | Name of the contact’s branch |
| BranchNMLSId | NMLS ID of the branch |
| Office_Address | Work street address. This is the branch address if a branch is listed, or the company address if not. For contacts in more than one branch, it’s usually the oldest active location on file. |
| Office_City | Work city (same rules as Office_Address) |
| Office_State | Work state (same rules as Office_Address) |
| Office_Zip | Work ZIP code (same rules as Office_Address) |
Loan Production Fields
All 12-month and 3-month fields cover the period before the ExportDate.
| Field | Description |
|---|---|
| LoanCount_12Mo | Total number of loans in the last 12 months |
| LoanVol_12Mo | Total loan volume in the last 12 months |
| LoanCt_Conventional_12Mo | Number of conventional loans in the last 12 months |
| LoanCt_VA_12Mo | Number of Department of Veterans Affairs (VA) loans in the last 12 months |
| LoanCt_FHA_12Mo | Number of Federal Housing Administration (FHA) loans in the last 12 months |
| LoanCt_Other_12Mo | Number of “Other” loans in the last 12 months |
| LoanCt_LMI_12Mo | Number of loans in low- or moderate-income (LMI) census tracts in the last 12 months |
| LoanVol_LMI_12Mo | Loan volume in LMI census tracts in the last 12 months |
| LoanCt_MMCT_12Mo | Number of loans in majority-minority census tracts (MMCT) in the last 12 months |
| LoanVol_MMCT_12Mo | Loan volume in MMCT in the last 12 months |
| LoanCount_3Mo | Total number of loans in the last 3 months |
| LoanVolume_3Mo | Total loan volume in the last 3 months |
| LastLoanDate | Date of the contact’s most recent loan of any type |
Most Recent Purchase Loan Fields
These fields describe the contact’s most recent loan that has a matching real estate transaction.
| Field | Description |
|---|---|
| LastPurchase_LoanDate | Loan date |
| LastPurchase_Address | Property address |
| LastPurchase_Buyer1 | First buyer |
| LastPurchase_Buyer2 | Second buyer |
| LastPurchase_Agent | Buyer’s agent |
| LastPurchase_AgentCompany | Buyer’s agent’s company |
| LastPurchase_SalePrice | Sale price |
| LastPurchase_LoanAmount | Loan amount |
RETR Record and Export Fields
| Field | Description |
|---|---|
| Source | Always “RETR” |
| Tags | Comma-separated custom tags for the contact |
| ListName | Name of the list the contact was exported from, if any |
| RETRLoId | Unique RETR ID for this loan officer |
| RETRProfileURL | Link to the contact’s RETR profile |
| ExportDate | Date the data was exported. Use it to see how recent your data is. |
| Notes | List of notes on the contact (see below) |
Notes Object Fields
Each item in the Notes list contains:
| Field | Description |
|---|---|
| Summary | Note text |
| Type | Note type, such as “Personal” or “Shared List” |
| Status | Contact status on the note, such as “Qualified” or “Lead” |
| ListName | Name of the shared list the note belongs to (null for personal notes) |
| SharedListId | ID of the shared list (null for personal notes) |