MongoDB lookup
Automatically run MongoDB lookups, with conditional actions fired based on the results. The ThinkAutomation MongoDB integration allows you to work queries into your automated workflows. So, you can retrieve and act on data without manual administration.
MongoDB lookup – overview
- This baked-in ThinkAutomation action reads a document from a MongoDB collection and assigns the JSON to a variable
- You specify the MongoDB connection string, database name, and collection name
- Then, enter the query JSON and (optionally) the projection and sort JSON
- You can use %field% replacements in the query. For example:
{ "_id": { "$eq": "%OrderNumber%" } }
- Select the variable to assign the returned document(s) to
- You can then use ThinkAutomation’s extract field actions to extract individual fields from the document
- Results can be used to fire any number of subsequent automations in local or cloud systems
MongoDB lookup – use cases
- Create a workflow to query data at scheduled intervals then push data to BI / visualization tools
- Query documents that belong to a specific customer then send an outgoing email to an account manager
- Calculate a total purchase amount for a specific audience subset to feed into a sales report
- Add tokens for field values that you’d like to log and send auto-alerts based on the results
- Plus countless more, depending on your desired use case
- Backup emails
- Email attachment storage
- Email parsing
- Email sentiment analysis
- Email to cloud
- Email to CRM
- Email to CSV
- Email to database
- Email to spreadsheet
- Email translation
- Move email attachment to folder automatically
- Outlook export all emails
- Parse email attachment
- Translate attachment
Database
- Data ETL
- Database automation
- Database counters
- Database monitoring
- Mongo update
- SQL to Excel
- Translate database
- Update a database
Telephony
CRM
- CRM data entry
- CRM sentiment analysis
- Dynamics automation
- Salesforce automation
- SugarCRM automation
- Zoho automation
Automation actions
- Automatic compression
- Automatic encryption
- Automatic translation
- Create hash file
- Database lookup
- Date operation
- Detect language
- Execute PowerShell
- Execute script
- Extract field
- File operation
- FTP download
- FTP upload
- GeoIP lookup
- MongoDB lookup
- OAuth sign-in
- Process files
- Run a program
- Send Teams message
- Sentiment score
- Set variable
- Speak text
- SQL command to update data in a database
- SQL execute command
- String operation
- Summarise text
- Train sentiment analysis model
Product
- .NET scripting
- Automation gateway
- Automation IDE
- Automation studio
- C# scripting
- Continuous processing
- Design actions
- High speed automation
- HTTP API
- JSON parser
- Local automation
- Markdown support
- Message store
- Public web API
- RPA community
- RPA designer
- SendGrid mail server
- Text summariser
- Visual Studio code paste without formatting