Microsoft Power Automate Integration
Integrate Venym Search with Microsoft's enterprise automation platform. Build workflows that connect web intelligence to Microsoft 365, Dynamics 365, and Azure services.
Enterprise Integration
Native integration with Microsoft 365 and Dynamics 365
Security & Compliance
Enterprise-grade security with GDPR and SOC compliance
Team Collaboration
Share workflows across teams with role-based access
What you'll build
Enterprise automation workflows that search the web, process data with AI, integrate with Microsoft 365, and maintain full compliance with your organization's security policies.
Setup Instructions
01
Create Custom Connector
Create a custom connector for Venym Search API using OpenAPI definition to enable native integration.
Venym Search OpenAPI DefinitionJSON
{
"swagger": "2.0",
"info": {
"title": "Venym Search",
"description": "Venym Search API for web search, scraping, and research",
"version": "1.0",
"contact": {
"name": "Venym Search Support",
"url": "https://VENYM_SEARCH.com/support",
"email": "support@VENYM_SEARCH.com"
}
},
"host": "search.venym.io/api",
"basePath": "/",
"schemes": ["https"],
"consumes": [],
"produces": [],
"paths": {
"/v1/search": {
"post": {
"responses": {
"200": {
"description": "Search results",
"schema": {
"type": "object",
"properties": {
"search_results": {
"type": "array",
"items": {
"type": "object",
"properties": {
"title": {"type": "string"},
"link": {"type": "string"},
"snippet": {"type": "string"},
"date": {"type": "string"},
"contact_info": {
"type": "object",
"properties": {
"email": {"type": "string"},
"phone": {"type": "string"}
}
}
}
}
}
}
}
}
},
"summary": "Search - Enhanced Web Search",
"description": "Search the web with enhanced results and optional contact extraction",
"operationId": "Search",
"x-ms-visibility": "important",
"parameters": [
{
"name": "body",
"in": "body",
"required": true,
"schema": {
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "Search query",
"title": "Query",
"x-ms-visibility": "important"
},
"max_results": {
"type": "integer",
"description": "Maximum number of results",
"title": "Max Results",
"default": 10,
"minimum": 1,
"maximum": 50
},
"auto_scrape": {
"type": "boolean",
"description": "Automatically scrape result pages",
"title": "Auto Scrape",
"default": false
},
"extract_contacts": {
"type": "boolean",
"description": "Extract contact information",
"title": "Extract Contacts",
"default": false
}
},
"required": ["query"]
}
}
]
}
},
"/v1/scrape": {
"post": {
"responses": {
"200": {
"description": "Scraped content",
"schema": {
"type": "object",
"properties": {
"primary_content": {
"type": "object",
"properties": {
"title": {"type": "string"},
"text": {"type": "string"},
"images": {"type": "array"},
"links": {"type": "array"}
}
}
}
}
}
},
"summary": "Scrape - Web Scraping",
"description": "Extract content from any webpage",
"operationId": "Scrape",
"x-ms-visibility": "important",
"parameters": [
{
"name": "body",
"in": "body",
"required": true,
"schema": {
"type": "object",
"properties": {
"url": {
"type": "string",
"description": "URL to scrape",
"title": "URL",
"x-ms-visibility": "important"
},
"extract_options": {
"type": "array",
"description": "What to extract",
"title": "Extract Options",
"items": {
"type": "string",
"enum": ["title", "text", "images", "links", "metadata"]
},
"default": ["title", "text"]
}
},
"required": ["url"]
}
}
]
}
}
},
"definitions": {},
"parameters": {},
"responses": {},
"securityDefinitions": {
"API Key": {
"type": "apiKey",
"in": "header",
"name": "Authorization": "Bearer"
}
},
"security": [
{
"API Key": []
}
],
"tags": []
}Connector Creation Steps:
- Go to Power Automate → Data → Custom connectors
- Create from OpenAPI definition
- Import the Venym Search OpenAPI specification
- Configure authentication (API Key)
- Test the connector and save
02
Configure Authentication
Set up secure API key authentication for Venym Search in your Power Automate environment.
Security Features
API keys are encrypted and stored securely in Microsoft's Azure infrastructure with enterprise compliance.
Connection Sharing
Share connections across your organization with role-based access control and audit logging.
03
Build Your First Flow
Create an automated flow that demonstrates Venym Search integration with Microsoft 365 services.
Lead Generation Flow DefinitionJSON
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"$connections": {
"defaultValue": {},
"type": "Object"
}
},
"triggers": {
"Recurrence": {
"recurrence": {
"frequency": "Day",
"interval": 1,
"schedule": {
"hours": ["9"]
}
},
"type": "Recurrence"
}
},
"actions": {
"Initialize_Search_Terms": {
"runAfter": {},
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "SearchQuery",
"type": "string",
"value": "construction companies Seattle"
}
]
}
},
"Venym_Search_Search": {
"runAfter": {
"Initialize_Search_Terms": ["Succeeded"]
},
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['VENYM_SEARCH']['connectionId']"
}
},
"method": "post",
"path": "/v1/search",
"body": {
"query": "@variables('SearchQuery')",
"max_results": 20,
"extract_contacts": true
}
}
},
"Filter_Valid_Contacts": {
"runAfter": {
"Venym_Search_Search": ["Succeeded"]
},
"type": "Query",
"inputs": {
"from": "@body('Venym_Search_Search')['search_results']",
"where": "@and(not(empty(item()['contact_info']['email'])), not(contains(item()['contact_info']['email'], 'noreply')))"
}
},
"Apply_to_each_result": {
"foreach": "@body('Filter_Valid_Contacts')",
"actions": {
"Add_to_SharePoint_List": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent('https://contoso.sharepoint.com/sites/sales')}/tables/@{encodeURIComponent('Leads')}/items",
"body": {
"Title": "@items('Apply_to_each_result')['title']",
"Company": "@items('Apply_to_each_result')['title']",
"Website": "@items('Apply_to_each_result')['link']",
"Email": "@items('Apply_to_each_result')['contact_info']['email']",
"Phone": "@items('Apply_to_each_result')['contact_info']['phone']",
"Source": "Venym Search Automation",
"DateFound": "@utcNow()"
}
}
},
"Send_Teams_Message": {
"runAfter": {
"Add_to_SharePoint_List": ["Succeeded"]
},
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['teams']['connectionId']"
}
},
"method": "post",
"path": "/v1.0/teams/@{encodeURIComponent('team-id')}/channels/@{encodeURIComponent('channel-id')}/messages",
"body": {
"body": {
"content": "🎯 New lead found: @{items('Apply_to_each_result')['title']} - @{items('Apply_to_each_result')['contact_info']['email']}"
}
}
}
}
},
"runAfter": {
"Filter_Valid_Contacts": ["Succeeded"]
},
"type": "Foreach"
}
}
}
}TIP
Use Power Automate's visual designer to build flows, then export to JSON for version control and team collaboration.
Microsoft 365 & Dynamics Integrations
Microsoft 365 Integration
Seamlessly integrate with Outlook, Teams, SharePoint, and OneDrive
Connected Apps
OutlookTeamsSharePointOneDrivePower BI
Use Case
Lead data flows directly into SharePoint lists, Teams notifications, and Outlook tasks
Dynamics 365 CRM
Automated lead generation and customer data enrichment
Connected Apps
Dynamics CRMSales InsightsCustomer ServiceMarketing
Use Case
Venym Search data automatically creates and enriches CRM records with web intelligence
Power Platform Ecosystem
Connect with Power BI, Power Apps, and Power Virtual Agents
Connected Apps
Power BIPower AppsPower Virtual AgentsAI Builder
Use Case
Create dashboards, build apps with Venym Search data, and enhance chatbots with web search
Azure Services
Enterprise-grade integration with Azure cloud services
Connected Apps
Azure Logic AppsAzure FunctionsCognitive ServicesAzure Storage
Use Case
Build scalable, secure workflows with AI processing and enterprise storage
Enterprise Compliance & Security
Build workflows that meet enterprise security and compliance requirements with built-in audit trails and data governance.
GDPR Compliant Workflow ExampleJSON
{
"name": "GDPR Compliant Lead Processing",
"description": "Enterprise workflow with compliance controls",
"triggers": {
"Manual": {
"type": "Request",
"kind": "Http",
"inputs": {
"schema": {
"type": "object",
"properties": {
"search_query": {"type": "string"},
"data_processing_consent": {"type": "boolean"},
"retention_period_days": {"type": "integer"}
},
"required": ["search_query", "data_processing_consent"]
}
}
}
},
"actions": {
"Validate_Consent": {
"type": "If",
"expression": {
"and": [
{
"equals": [
"@triggerBody()['data_processing_consent']",
true
]
}
]
},
"actions": {
"Log_Data_Processing": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['azureloganalytics']['connectionId']"
}
},
"method": "post",
"path": "/api/logs",
"body": {
"event_type": "data_processing_start",
"user_consent": true,
"search_query": "@triggerBody()['search_query']",
"timestamp": "@utcNow()",
"retention_period": "@triggerBody()['retention_period_days']"
}
}
},
"Venym_Search_Search_With_Audit": {
"runAfter": {
"Log_Data_Processing": ["Succeeded"]
},
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['VENYM_SEARCH']['connectionId']"
}
},
"method": "post",
"path": "/v1/search",
"body": {
"query": "@triggerBody()['search_query']",
"max_results": 10,
"extract_contacts": false
}
}
},
"Store_in_Compliance_Storage": {
"runAfter": {
"Venym_Search_Search_With_Audit": ["Succeeded"]
},
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['azureblob']['connectionId']"
}
},
"method": "post",
"path": "/datasets/default/files",
"queries": {
"folderPath": "/compliance-data",
"name": "search-@{utcNow('yyyyMMdd-HHmmss')}.json"
},
"body": {
"search_query": "@triggerBody()['search_query']",
"results": "@body('Venym_Search_Search_With_Audit')",
"processed_at": "@utcNow()",
"retention_until": "@addDays(utcNow(), triggerBody()['retention_period_days'])",
"user_consent": true
}
}
}
},
"else": {
"actions": {
"Return_Consent_Error": {
"type": "Response",
"inputs": {
"statusCode": 403,
"body": {
"error": "Data processing consent required",
"code": "CONSENT_REQUIRED"
}
}
}
}
}
}
}
}Security Features
Azure AD authentication integration
Data encryption in transit and at rest
Role-based access control (RBAC)
Conditional access policies
Compliance Capabilities
GDPR data processing controls
SOC 2 Type II compliance
Audit logging and monitoring
Data residency controls
Advanced Enterprise Features
AI Builder Integration
Enhance Venym Search data with Microsoft's AI Builder for document processing, sentiment analysis, and custom AI models.
Document AI for scraped content processing
Sentiment analysis on search results
Custom object detection in images
Text classification and entity extraction
Power Platform Ecosystem
Power Apps Integration:
- • Build custom apps with Venym Search data
- • Real-time search interfaces
- • Mobile apps for field research
Power BI Dashboards:
- • Market intelligence dashboards
- • Competitive analysis reports
- • Lead generation metrics
Enterprise Pricing & Limits
Power Automate Plans
Per User Plan$15/user/month
Per Flow Plan$100/5 flows/month
Process Plan$150/bot/month
Premium ConnectorsIncluded
Venym Search custom connector available with all paid plans.
Venym Search Usage
Search1 credit per search
Scrape1 credit per page
5 credits per research
Enterprise Support24/7 available
Volume discounts available for enterprise customers.
Start Building
Ready for enterprise automation? Get your Venym Search API key and build with Power Automate.
Enterprise Support
Need enterprise support? Contact our team for custom integrations and onboarding.