AI-Mortgage Document Parser in Power Automate

PDF4me AI-Mortgage Document Parser extracts structured data from mortgage documents using AI-powered machine learning through Power Automate flows. Process mortgage document PDFs or images via Power Automate triggers, binary data, base64 strings, or public URLs to automatically extract loan amounts, interest rates, loan terms, borrower information, property details, appraiser data, closing costs, title information, payment projections, compliance fields, and other mortgage document fields with high accuracy and intelligent field recognition. This solution is ideal for mortgage document processing automation, loan processing digitization, real estate document management, automated mortgage data extraction, property information processing, loan compliance tracking, and mortgage document management workflows that require AI-powered extraction with structured output and seamless Microsoft 365 integration.

Authenticating Your API Request

To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful AI-powered mortgage document processing services.

Get your API Key

Key Features

• AI-Powered Extraction: Advanced machine learning technology for accurate mortgage document data extraction
• Multi-Format Support: Process mortgage documents in PDF, PNG, JPG, and JPEG formats
• Comprehensive Loan Information: Extract loan amounts, interest rates, loan terms, loan types, and effective dates
• Borrower Details: Extract borrower names, co-borrower information, employment details, income, and employment status
• Property Information: Extract property addresses, legal descriptions, property types, condition ratings, and appraised values
• Appraiser Data: Extract appraiser names, license numbers, and property assessment details
• Closing Information: Extract closing costs, cash to close, settlement agents, closing dates, and disbursement dates
• Title Information: Extract current owner, liens, encumbrances, easements, and title insurance amounts
• Payment Projections: Extract projected payment schedules with principal, interest, insurance, and escrow details
• Compliance Fields: Extract homestead act compliance, farmland act compliance, and other regulatory information
• Comparable Sales: Extract comparable sale data with addresses, sale prices, dates, and adjustments
• Microsoft 365 Integration: Seamlessly integrate extracted data with SharePoint, Excel, Dynamics 365, and Power BI

Parameters

Complete list of parameters for the AI-Mortgage Document Parser action. Configure these parameters to control mortgage document processing and data extraction.

Important: Parameters marked with an asterisk (***) are required and must be provided for the action to function correctly.

Document Source Parameters

Parameter	Type	Description	Example
Mortgage Document File Content***	Binary	Source Mortgage Document Binary Data • Map mortgage document file content from previous Power Automate action • Supports dynamic expressions: body('Get_file_content') • Compatible with Dropbox, SharePoint, OneDrive, and email attachments • Supports .pdf, .png, .jpg, .jpeg formats	body('Get_file_content')
Mortgage Document Name***	String	Mortgage Document File Identifier with Extension • Specify the name of the input mortgage document file with proper extension • Used for format detection and AI processing optimization • Supports dynamic naming from flow variables • Must include file extension (.pdf, .png, .jpg, .jpeg) • Enables document tracking in logs and audit trails	mortgage_document_2024.pdf

Advanced Parameters

Parameter	Type	Description	Example
Body/documentType	String	Optional Document Type • Optional document type for improved parsing accuracy • Specify mortgage document type to enhance extraction precision • Examples: "Deed of Trust", "Promissory Note", "Mortgage Agreement", "Loan Application" • Helps AI engine optimize field recognition for specific document formats • Improves accuracy when processing known mortgage document types	Deed of Trust
Body/customFieldKeys	Array	Optional Custom Field Keys List • Optional list of custom field keys to extract from the mortgage document • Specify additional fields beyond standard mortgage data • Supports multiple custom field keys for enhanced data extraction • Enables extraction of domain-specific or custom mortgage document fields • Each item in the array represents a custom field key to extract	["customField1", "customField2"]

Output

The PDF4me AI-Mortgage Document Parser action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
documentType	String	The type of mortgage document extracted (e.g., Deed of Trust, Promissory Note)
lenderName	String	The name of the lender or financial institution providing the mortgage loan
propertyAddress	String	The complete address of the property being mortgaged
legalDescription	String	The legal description of the property extracted from the mortgage document
loanAmount	Number	The principal amount of the mortgage loan, with precise decimal handling
interestRate	Number	The annual interest rate of the mortgage loan (as a percentage)
loanTerm	Number	The term or duration of the loan in months or years
loanType	String	The type of loan (e.g., Fixed Rate, Adjustable Rate, FHA, VA)
appraisedValue	Number	The appraised value of the property, with precise decimal handling
effectiveDate	String	The effective date of the mortgage document, formatted in ISO 8601 format (YYYY-MM-DD)
borrowerName	String	The name of the primary borrower extracted from the mortgage document
coBorrowerName	String	The name of the co-borrower, if applicable
employerName	String	The name of the borrower's employer
position	String	The job position or title of the borrower
income	Number	The income amount of the borrower, with precise decimal handling
employmentStatus	String	The employment status of the borrower (e.g., Full-time, Part-time, Self-employed)
employmentStartDate	String	The start date of employment, formatted in ISO 8601 format (YYYY-MM-DD)
appraiserName	String	The name of the property appraiser
appraiserLicenseNumber	String	The license number of the property appraiser
propertyType	String	The type of property (e.g., Single Family, Condominium, Commercial)
conditionRating	String	The condition rating of the property
comparableSales	Array	Array of comparable sale objects with address, sale price, sale date, and adjustments
closingCosts	Number	The total closing costs associated with the mortgage, with precise decimal handling
cashToClose	Number	The amount of cash required to close the mortgage, with precise decimal handling
settlementAgent	String	The name of the settlement agent or closing agent
closingDate	String	The closing date of the mortgage, formatted in ISO 8601 format (YYYY-MM-DD)
disbursementDate	String	The disbursement date of the loan funds, formatted in ISO 8601 format (YYYY-MM-DD)
currentOwner	String	The current owner of the property
liensAndEncumbrances	Array	Array of liens and encumbrances on the property
easements	Array	Array of easements affecting the property
titleInsuranceAmount	Number	The amount of title insurance coverage, with precise decimal handling
propertyTaxesStatus	String	The status of property taxes (e.g., Current, Delinquent, Exempt)
projectedPayments	Array	Array of projected payment objects with payment type, principal and interest, mortgage insurance, escrow, and total monthly payment
notarySignatureWitness	String	The name of the notary or witness who signed the document
controlNumber	String	The control number or reference number of the mortgage document
parish	String	The parish or county where the property is located
currency	String	The currency code (ISO 4217) of the mortgage amounts (e.g., USD, EUR, GBP)
witnessName	String	The name of the witness to the mortgage document
witnessType	String	The type of witness (e.g., Notary Public, Attorney)
preparerCompany	String	The name of the company that prepared the mortgage document
homesteadActCompliance	String	Compliance information regarding the Homestead Act
farmLandActCompliance	String	Compliance information regarding the Farmland Act
securesLiabilities	String	Information about liabilities secured by the mortgage
guaranteeMortgage	String	Information about guarantee mortgage provisions
collateralMortgage	String	Information about collateral mortgage provisions
warnings	Array	Array of warning messages indicating potential data quality issues or extraction challenges encountered during processing
fallbackUsed	Boolean	Boolean flag indicating whether fallback extraction methods were used during processing
jobId	String	Unique identifier for the AI processing job, used for tracking and debugging
jobIdExt	String	External job identifier for integration with third-party systems, if applicable
success	Boolean	Boolean flag indicating the success or failure of the AI-powered mortgage document data extraction
message	String	Descriptive message indicating the result of the AI-powered mortgage document data extraction process

JSON

JSON Response Format

The raw JSON response from the action:

{
  "documentType": "Deed of Trust",
  "lenderName": "ABC Bank",
  "propertyAddress": "123 Main Street, New York, NY 10001",
  "legalDescription": "Lot 5, Block 10, Subdivision A",
  "loanAmount": 350000.00,
  "interestRate": 4.5,
  "loanTerm": 360,
  "loanType": "Fixed Rate",
  "appraisedValue": 400000.00,
  "effectiveDate": "2024-01-15",
  "borrowerName": "John Michael Smith",
  "coBorrowerName": "Sarah Elizabeth Smith",
  "employerName": "Tech Corporation Inc.",
  "position": "Software Engineer",
  "income": 85000.00,
  "employmentStatus": "Full-time",
  "employmentStartDate": "2020-06-01",
  "appraiserName": "Jane Appraiser",
  "appraiserLicenseNumber": "APP-12345",
  "propertyType": "Single Family",
  "conditionRating": "Good",
  "comparableSales": [
    {
      "address": "120 Main Street, New York, NY 10001",
      "salePrice": 380000.00,
      "saleDate": "2023-12-01",
      "adjustments": 5000.00
    },
    {
      "address": "125 Main Street, New York, NY 10001",
      "salePrice": 395000.00,
      "saleDate": "2023-11-15",
      "adjustments": -5000.00
    }
  ],
  "closingCosts": 8500.00,
  "cashToClose": 75000.00,
  "settlementAgent": "XYZ Title Company",
  "closingDate": "2024-02-01",
  "disbursementDate": "2024-02-02",
  "currentOwner": "John Michael Smith",
  "liensAndEncumbrances": ["First Mortgage Lien"],
  "easements": ["Utility Easement"],
  "titleInsuranceAmount": 350000.00,
  "propertyTaxesStatus": "Current",
  "projectedPayments": [
    {
      "paymentType": "Principal and Interest",
      "principalAndInterest": 1772.78,
      "mortgageInsurance": 150.00,
      "estimatedEscrow": 500.00,
      "estimatedTotalMonthlyPayment": 2422.78
    }
  ],
  "notarySignatureWitness": "Notary Public - Jane Doe",
  "controlNumber": "MC-2024-001234",
  "parish": "New York County",
  "currency": "USD",
  "witnessName": "Robert Williams",
  "witnessType": "Notary Public",
  "preparerCompany": "Legal Document Services Inc.",
  "homesteadActCompliance": "Compliant",
  "farmLandActCompliance": "N/A",
  "securesLiabilities": "Secures promissory note dated 2024-01-15",
  "guaranteeMortgage": "None",
  "collateralMortgage": "Property at 123 Main Street, New York, NY 10001",
  "warnings": [],
  "fallbackUsed": false,
  "jobId": "12345678-1234-1234-1234-123456789012",
  "jobIdExt": "MORT-2024-001",
  "success": true,
  "message": "Mortgage document data extracted successfully using AI technology"
}

Flow Integration

Power Automate Flow Usage

The extracted mortgage document data enables powerful automation across Microsoft ecosystem:

• SharePoint Lists: Store extracted mortgage data in SharePoint lists for loan portfolio management
• Excel Integration: Export mortgage data to Excel workbooks for financial analysis and reporting
• Dynamics 365: Create mortgage loan records in Dynamics 365 Finance automatically
• SQL Database: Insert extracted mortgage data into SQL Server databases for loan management systems
• Power BI: Feed mortgage data into Power BI dashboards for loan portfolio analytics
• Email Notifications: Send mortgage processing confirmations via Outlook
• Approval Workflows: Route mortgage documents for approval using Power Automate approvals
• Loan Processing: Automate loan processing workflows using extracted mortgage data
• Compliance Tracking: Track mortgage compliance using extracted compliance fields
• Document Storage: Link extracted mortgage data with original documents in SharePoint document libraries

Workflow Examples

The PDF4me AI-Mortgage Document Parser action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Loan Processing Automation

Automated Loan Processing Workflow

Streamline loan processing with AI-powered mortgage document data extraction:

Complete Workflow Steps:

1. Trigger: Mortgage document uploaded to SharePoint or received via email
2. AI Mortgage Document Parser: Extract loan details, borrower information, and property data using PDF4me AI
3. Document Type Detection: Identify document type for appropriate processing workflow
4. Loan Validation: Validate extracted loan amount, interest rate, and loan term
5. Borrower Verification: Verify borrower information and employment details
6. Create Loan Record: Insert mortgage data into Dynamics 365 Finance or loan management system
7. Update SharePoint: Store extracted mortgage data in SharePoint list with metadata
8. Approval Workflow: Route high-value loans for manager approval
9. Email Notification: Notify loan processing team with mortgage processing summary
10. Archive: Move processed mortgage document to archive folder with extracted metadata

Business Benefits:

• Automates mortgage document data entry for loan processing
• Reduces manual data entry time by 90%
• Eliminates human errors in loan processing
• Accelerates loan approval cycles
• Maintains complete audit trail of all processed mortgages

Create Flow

Loan Portfolio Management

Automated Loan Portfolio Management Workflow

Manage loan portfolios with intelligent mortgage document data extraction:

Complete Workflow Steps:

1. Trigger: Mortgage documents uploaded to SharePoint portfolio folder
2. AI Mortgage Document Parser: Extract loan amounts, interest rates, property details, and payment projections
3. Portfolio Analysis: Calculate portfolio metrics using extracted loan data
4. Excel Export: Export mortgage data to Excel workbook for portfolio analysis
5. Power BI Update: Send extracted data to Power BI dataset for portfolio dashboards
6. Risk Assessment: Assess loan risk using extracted borrower and property information
7. Payment Tracking: Monitor payment schedules using extracted projected payments
8. Compliance Check: Verify compliance using extracted compliance fields
9. Reporting: Generate portfolio reports from extracted mortgage data
10. Alert Management: Create alerts for loans requiring attention

Business Benefits:

• Real-time loan portfolio visibility and management
• Automated portfolio analytics and reporting
• Improved risk assessment and monitoring
• Proactive loan management and alerts
• Comprehensive portfolio insights and analytics

Create Flow

Mortgage Compliance Tracking

Automated Mortgage Compliance Tracking Workflow

Ensure compliance with mortgage regulations using extracted compliance data:

Complete Workflow Steps:

1. Trigger: Mortgage document uploaded to SharePoint compliance folder
2. AI Mortgage Document Parser: Extract compliance fields, homestead act compliance, and farmland act compliance
3. Compliance Validation: Verify extracted compliance data meets regulatory requirements
4. Compliance Check: Compare extracted data against compliance rules and regulations
5. Create Compliance Record: Document compliance status in SharePoint list or SQL database
6. Compliance Reporting: Generate compliance reports from extracted mortgage data
7. Alert Management: Create alerts for non-compliant mortgages
8. Audit Trail: Maintain complete audit trail of all compliance activities
9. Dashboard Update: Update compliance dashboard with latest compliance metrics
10. Notification: Send compliance status notifications to compliance team

Business Benefits:

• Automated mortgage compliance tracking and reporting
• Ensures regulatory compliance for all mortgages
• Comprehensive compliance audit trails
• Proactive compliance monitoring and alerts
• Reduced compliance risks and penalties

Create Flow

Title Processing Automation

Automated Title Processing Workflow

Streamline title processing with automated mortgage document data extraction:

Complete Workflow Steps:

1. Trigger: Mortgage document received for title processing
2. AI Mortgage Document Parser: Extract property address, legal description, liens, encumbrances, and easements
3. Title Search: Use extracted property information for title search
4. Lien Verification: Verify extracted liens and encumbrances
5. Easement Check: Review extracted easements affecting the property
6. Title Insurance: Calculate title insurance using extracted property value
7. Create Title Record: Add title information to title management system
8. Update SharePoint: Store title data in SharePoint list with metadata
9. Title Report: Generate title report from extracted mortgage data
10. Archive: Store processed mortgage document with title information

Business Benefits:

• Automated title processing reduces manual effort
• Faster title search and verification processes
• Improved accuracy in title processing
• Real-time visibility into property title information
• Streamlined title insurance processing

Create Flow

Industry Use Cases & Applications

Banking & Lending

Banking & Lending Use Cases

• Loan Processing: Automate mortgage loan processing using extracted document data
• Loan Portfolio Management: Manage loan portfolios using extracted mortgage information
• Risk Assessment: Assess loan risk using extracted borrower and property data
• Compliance Tracking: Track mortgage compliance using extracted compliance fields
• Loan Servicing: Service loans using extracted payment and borrower information

Real Estate & Property Management

Real Estate & Property Management Use Cases

• Property Management: Manage properties using extracted mortgage and property data
• Property Valuation: Assess property values using extracted comparable sales data
• Title Processing: Process property titles using extracted title and lien information
• Property Analytics: Analyze property portfolios using extracted mortgage data
• Real Estate Reporting: Generate real estate reports from extracted mortgage documents

Title Insurance Companies

Title Insurance Companies Use Cases

• Title Processing: Process property titles using extracted mortgage and title data
• Lien Verification: Verify liens and encumbrances using extracted information
• Title Insurance: Calculate title insurance using extracted property values
• Title Reports: Generate title reports from extracted mortgage documents
• Compliance Management: Ensure compliance with title insurance regulations

Legal & Compliance

Legal & Compliance Use Cases

• Legal Document Processing: Process mortgage documents for legal purposes
• Compliance Tracking: Track mortgage compliance with legal and regulatory requirements
• Document Review: Review mortgage documents using extracted structured data
• Evidence Management: Manage mortgage documents as legal evidence
• Audit Preparation: Prepare audits using extracted mortgage data

Financial Services

Financial Services Use Cases

• Mortgage Servicing: Service mortgages using extracted payment and borrower data
• Loan Analytics: Analyze loan performance using extracted mortgage information
• Risk Management: Manage mortgage risk using extracted borrower and property data
• Financial Reporting: Generate financial reports from extracted mortgage documents
• Asset Management: Manage mortgage assets using extracted loan data

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation