actions

Automation Action: Update A Database Using CSV Or Json Update multiple rows in a SQL database using CSV or Json data. This action can be used to automatically insert or update multiple records in a database from CSV or Json text (or file). The column names used in the SQL commands are mapped to CSV […]

Automation Action: Update A Database Using Custom SQL Update or Insert data into a database using custom commands. The Update A Database Using Custom SQL automation action can be used to insert or update a row in a database depending on the result of an optional select statement. Select a Database Type to connect to […]

Automation Action: Update A Database Using Extracted Fields Automatically update a SQL database using extracted fields parsed from the incoming message. Update a database with fields extracted from the incoming message. This action can be used to automatically insert or update a record in a database based on the Extract Field actions defined in your […]

Automation Action: Update CRM Entity Add or update Microsoft Dynamics, Salesforce, Sugar or Zoho CRM entities. Creates or updates entities in a CRM system, Click Connect to connect to a CRM system. Currently ThinkAutomation can connect to: Microsoft Dynamics CRM (Online) Salesforce Sugar CRM Zoho CRM See: CRM Connection Notes for specific CRM connection details. […]

Automation Action: Update CSV Add a row to a CSV file or variable containing CSV data. Create or update a comma separated values (CSV) file or CSV data. You can either update a CSV File or a variable containing CSV data. Enter or select the CSV File Name to update. This is the full path […]

Automation Action: Update Excel File Update a Microsoft Excel file. Append new rows or update specific cells. Update a Microsoft Excel Spreadsheet file. Enter or select the Excel File Name to update. Optionally enter the Worksheet Name to update. If no worksheet is specified then the first worksheet in the Excel file will be updated. […]

Automation Action: Update Incoming Message Set flags and/or modify the subject on the incoming Office 365 source message. Set flags and/or modify the subject on the incoming Office 365 source message. This action works with the message currently being processed. Enter a comma separated list of Categories to assign to the message. Leave blank for […]

Automation Action: Update JSON Create or update multiple Json paths within Json text and return the updated Json to a variable. Update Json text. Create or update multiple Json paths within Json text and return the updated Json to a variable. In the Existing Json entry, enter any valid json text or use a %variable% […]

Automation Action: Update MongoDB Create or update MongoDB documents. Insert, Update or Delete documents in a MongoDB collection. This action can update any local MongoDB, or cloud based MongoDB compatible document databases including Amazon DocumentDB, Azure Cosmos and MongoDB Atlas. Specify the MongoDB Connection String, Database Name & Collection Name. Select the Operation: Insert: To […]

Automation Action: Wait For User Response Request confirmation from a user before continuing execution. Waits for a user response before proceeding with the remaining actions for the Automation. This action can be used to provide a human validation response in the form of a unique web form that must be completed before the Automation continues. […]