Cloud Workflow
Raise an IssueJoin Community
  • Getting Started
    • Introduction
    • Integration Basics
    • Sign Up and Get a License
    • Features and Benefits
  • DBSync Platform
    • Core Components
    • System Requirements
    • AppCenter
      • Company and User Management
    • Development Studio
    • Security Features
  • iPaaS
    • Home
    • Apps
    • Extend
      • Functions
    • Administration
      • User & Role Management
    • Logs
    • Remote Agent
    • Published Templates
  • Create your Workflow
    • Project
    • Task
    • Flow Builder
      • Standard Functions
    • Actions
      • Flow
      • Variable
      • Transform and Write
      • IDP - Intelligent Document Processing
      • SQL
      • Restructure
      • Query
      • Debug
      • ReST
      • Conditions
        • If (Condition)
        • For (Loop)
      • Storage
        • XML
        • Dropbox
        • File
        • CSV
        • Google Drive
        • FTP
        • S3
      • Flow Management
        • Flow
        • Logs
        • Notification
        • Schedule
        • API
        • Webhook
        • Forms
    • Configuring DBSync Environment
  • Connectors
    • Amazon S3
    • Authorize.NET
    • ChannelAdvisor
    • Database
    • Dropbox
    • Filevine
    • FTP
    • Google Drive
    • Google Sheets
    • HubSpot
    • JIRA Cloud
    • JIRA Service Management
    • Linnworks
      • Creating the DBsync Application on Linnworks Developer Instance
    • Mailchimp
    • Microsoft Dynamics 365 Business Central
    • Microsoft Dynamics 365 Finance and Operations (D365 F&O)
    • Microsoft Dynamics CRM Online
    • Microsoft Dynamics GP
    • Microsoft Dynamics NAV
    • monday.com
    • Narvar
    • NetSuite
      • NetSuite Connector Settings
    • OpenAPI
    • PointClickCare
    • QuickBooks Desktop
    • QuickBooks Online
    • Sage Intacct
    • Salesforce
    • ShipStation
    • Shopify
    • SkuVault
    • WooCommerce
  • Template Library
    • Salesforce and QuickBooks Online Integration
    • Salesforce and QuickBooks Desktop Integration
    • Salesforce to FTP Integration
    • QuickBooks Online to Business Central Integration
    • QuickBooks Online to ShipStation Orders
    • QuickBooks Desktop to Shipstation Orders
    • QuickBooks Desktop to monday.com Integration
    • QuickBooks Online to monday.com Integration
    • Shopify to QuickBooks Online
    • Shopify to QuickBooks Desktop
    • Linnworks Orders to QuickBooks Online
    • Linnworks Orders to QuickBooks Desktop
    • Linnworks to Salesforce Integration
    • Salesforce Litify and QuickBooks Online
    • Salesforce Litify and QuickBooks Desktop
    • Business Central to Salesforce Integration
    • HubSpot to QuickBooks Online Order to Cash
    • HubSpot to QuickBooks Desktop Order to Cash
    • SkuVault Orders to QuickBooks Desktop
    • SkuVault Orders to QuickBooks Online
    • SkuVault and Salesforce
    • ChannelAdvisor Orders and Salesforce
    • ChannelAdvisor and QuickBooks Online
    • ChannelAdvisor and QuickBooks Desktop
    • Shopify Orders to Dynamics365 CRM
    • Shopify Orders to Salesforce
    • ShipStation to Dynamics 365 CRM
    • ShipStation Orders to Salesforce
    • ShipStation to QuickBooks Online Orders
    • ShipStation to QuickBooks Desktop
    • Target Recruit to QuickBooks Online
    • Target Recruit to QuickBooks Desktop
    • QuickBooks Online to Database
    • QuickBooks Desktop to Database
  • Troubleshooting
    • Common Errors & Fixes
    • Adding Trusted IP Address in Salesforce
    • Installing QuickBooks Web Connector
    • QuickBooks to Salesforce Data Migration
    • Setting Password in QuickBooks Web Connector
    • Starting QuickBooks Web Connector
    • Update Salesforce Password & Security Token in DBSync
  • Additional Resources
    • Billing Information - Auto Renewal
  • Tutorials
    • Salesforce and QuickBooks
      • Account Hierarchy in Salesforce and QuickBooks
      • Account Owner Mapping
      • Resolving Email Fields Sync Issues in QuickBooks Online
      • Mulitple Price Levels in Salesforce QuickBooks Integration
      • Multicurrency in QuickBooks to Salesforce Integration
      • Multicurrency in Salesforce - QuickBooks Desktop Integration
      • Multicurrency in Salesforce QuickBooks Online Integration
      • Product Hierarchy in QuickBooks and Salesforce
      • QuickBooks Data Extraction Queries
      • QuickBooks File Backup and Recovery Process
      • QuickBoooks Reports to Salesforce Integration
      • Recurring Transactions to Accounting System
      • Retrieve Value from custom Field of QuickBooks Online
      • Salesforce Opportunity to QuickBooks - Disabling Jobs
      • Salesforce QuickBooks Custom Mappings
        • Use Case
      • Salesforce QuickBooks Integration with Multiple QuickBooks
      • Syncing Standard Group Line Items in QuickBooks Desktop
    • Using Date Function in DBSync Integration
    • Salesforce and Database
      • Database to Salesforce Integration
    • Database to Database
      • Database to Database Integration
Powered by GitBook
On this page
  • Introduction
  • Setup
  • Runtime Configuration
  • Saving and Exiting
  • IDP Action: Common Use Cases
  • Best Practices
  • Troubleshooting
  • FAQ
  1. Create your Workflow
  2. Actions

IDP - Intelligent Document Processing

Learn how to use the IDP storage action in your workflows

PreviousTransform and WriteNextSQL

Last updated 1 day ago

Introduction

The IDP (Intelligent Document Processing) Action in DBSync enables users to upload, process, and transform documents or images into structured XML outputs using customizable prompts. This action streamlines the extraction and transformation of data from uploaded files, making it easier to integrate unstructured data into your workflows.

Setup

Accessing the IDP Action

  1. Navigate to your project in DBSync.

  2. Add the IDP Action to your workflow using the Flow Builder.

  3. Click the Configure button to open the IDP Action setup modal.

Configure Modal

The configuration opens in a pop-up modal with the following UI elements:

  • Left Panel

    • Upload multiple documents or image files to train the model and generate XML.

    • Click on a file to highlight and preview it.

  • Center Panel

    • Displays the selected file name and its preview.

  • Right Panel

    • Transform Prompt: Enter or modify a prompt to customize the XML output.

    • Run: Processes the selected document and generates the XML output.

    • Save & Close: Saves configuration and closes the modal.

    • Cancel: Discards changes and closes the modal.

    • Code Mirror: Shows the XML preview after running the action. Users can edit or paste XML content directly and save changes.

File Upload and Preview

  • Upload multiple files (documents or images).

  • After uploading, the first file is previewed automatically.

  • Click any uploaded file to preview it in the center panel.

  • XML preview is auto-generated post-upload; users can further customize it with a prompt.

File Upload Limit

  • Maximum file size per upload: 10 MB.

Runtime Configuration

Runtime Variables

  • In the Flow Builder > IDP Action details panel, the runtime property dropdown lists only variables and form fields containing file paths or file content.

  • If no runtime variable is selected, a pop-up alert is shown.

  • Users must select a variable for files to process.

Editing XML Output

  • On the runtime tab, users can select the variable for files to process.

  • Click Edit to modify the expected XML output.

Saving and Exiting

  • On clicking Save, the entire configuration is saved, and the modal closes, redirecting users to the IDP Action details panel (Tab 2: Runtime).

  • Ensure all files are within the 10MB limit for smooth processing.

  • Use clear, concise prompts in the Transform Prompt field to generate accurate XML outputs.

  • Regularly save your configuration to prevent data loss.

IDP Action: Common Use Cases

Finance & Accounting

  • Invoice processing: Automatically extract vendor names, PO numbers, totals, due dates, and payment terms from invoices, and route them for review or approval.

  • Accounts payable/receivable: Match invoices to purchase orders, extract payment terms, and post to finance systems.

  • Expense receipt extraction: Parse scanned or digital, or handwritten receipts, extract totals and categories, and log them into expense trackers.

  • Audit tagging: Auto-classify documents as audit-relevant and organize them for easy retrieval.

Legal & Compliance

  • Contract analysis: Extract key clauses, dates, and obligations from legal contracts for review and compliance.

  • Regulatory reporting: Automate the extraction and classification of data for regulatory filings and compliance monitoring.

  • Public records management: Digitize and archive government records for efficient retrieval and transparency.

Best Practices

  • Ensure all files are within the 10MB limit for smooth processing.

  • Use clear, concise prompts in the Transform Prompt field to generate accurate XML outputs.

  • Regularly save your configuration to prevent data loss.

Troubleshooting

  • If the runtime property dropdown is empty, ensure that variables or form fields with file paths/content exist in your workflow.

  • For persistent upload or processing errors, check file formats and sizes.

FAQ

Q: What file types are supported for upload? A: Supported file types include common document and image formats. Refer to the platform's file upload guidelines for specifics.

Q: Can I process multiple files at once? A: Yes, you can upload and process multiple files. Each file can be previewed and processed individually.

Q: How do I customize the XML output? A: Use the Transform Prompt to guide the XML generation, and edit the output directly in the Code Mirror panel if needed.