Fix: Fixed issue with Run A Report action. The report designer crashed if an external Excel or CSV data source was added.
Fix: Fixed issue with IMAP Message Source not reading new messages after first run when connected to certain IMAP servers.
Fix: Fixed issue with Office 365 Create Appointment action where an All Day Event spanned multiple dates.
Improvement: The Print action header font was too small.
Improvement: The Run A Program action now has an option to execute the process via the Studio/Desktop Connector. See updated action help for more information.
5.0.898 (25th November 2022)
Fix: Fixed issue with POP3 message source not downloading new messages when Delete Processed Messages not enabled.
Fix: Fixed issue with Read JSON Document action not unescaping extracted paths.
Fix: Fixed issue with Failover Server node configuration showing unauthorized error when verifying the connection to the main server.
Fix: Fixed issue with Update Json action not deleting specific array items when Remove Paths used.
Fix: Fixed issue with Automation editor showing 'Missing Variable' warning message on Database Lookup actions where a hard-coded LIKE value was used instead of a parameter (eg: SELECT * FROM Table WHERE Col LIKE '%somevalue%').
Improvement: Improved handling of invalid incoming email mime text where attachments had duplicate Content-ID header values.
Improvement: You can now enable the Message Source Auto Pause option separately for message source and automation errors. You can also enable Send Notification On Message Source Errors separately from the Auto Pause option (previously these options were combined).
Improvement: Added Recalculate option to Update Excel File action. This option will ensure all formulas are recalculated after the update. A Password entry has also been added (for opening password protected Excel files).
Changed: Update A Database action name changed to Update A Database Using Extracted Fields. Moved Json actions into their own 'Json' group.
5.0.890 (9th November 2022)
Fix: Fixed issue with Create Office 365 Appointment action not replacing the start/end time values if %variable% replacements used.
Fix: Fixed issue with Create Outlook MSG File action failing on certain mime text with non standard charset.
Fix: Fixed issue with Basic Edition only allowing 4 message sources to be enabled at once instead of 5.
Fix: Fixed issue with Call A Soap Web Service action failing if basic authentication was used.
Fix: Fixed issue with OLEDB connection strings not handing 'provider=' correctly.
Fix: Fixed issue with Wait For User Response action not continuing Automation if Continue On Timeout option enabled.
Improvement: The Create Office 365 Appointment action now lists time zones available to the signed-in user in the Time Zone entry (if a %variable% replacement is used for this value then it must be one of the time zones listed).
Improvement: You can now adjust the number of message processor tasks that the Message Processor Service starts. The higher the tasks the more Automations can process messages at the same time (but with potential higher memory requirement). See Server Settings - Message Processor tab.
Improvement: Added Replace: Regex option to Text Operation action for regex replacements of single or multiple matches from any text.
5.0.880 (19th October 2022)
New: Added Get User Presence action for reading current presence information for one or more Office 365 users.
New: Added new Message Source - Microsoft Graph Changes. This message source tracks changes for Microsoft Graph entities: Calendar Events, Organization Contacts, Users & Teams Channel messages.
Improvement: Message Source schedules can now be restricted to days of the week and times during the day (eg: Active Monday-Friday, between 9am-pm).
Fix: Fixed occasional issues with TLS connections to Office 365.
Improvement: The Call A Soap Web Service action now has a Test button.
5.0.875 (4th October 2022)
New: Added Message Store REST API.
New: Added HubSpot OAuth type to providers list for OAuth Action.
Improvement: The Execute A Database Command action can now execute scalar commands and you can then assign any return value or rows affected to a variable (in addition to return values via stored procedure parameters).
Improvement: For Message Sources that use a schedule, you can force the Message Source to check for new messages regardless of the schedule. Right-click a Message Source and select 'Run Now'.
Improvement: The Update Excel File action now allows CSV data or a CSV file to be inserted at a specific start row/column. Note: If you simply want to convert a CSV file to an Excel document use the Convert Document action.
Improvement: Added %func%:CSVValue(csv,row,col) and %func%:CSVWithHeadersValue(csv,row,col) to inline functions for reading specific row/column values from CSV data.
Improvement: Added %func%:Line(value,linenumber) to inline functions for reading a specific line from a value containing multiple lines.
Improvement: On If actions the if value is now editable (previously you could only select a variable). This allows if actions such as If abc%order% Equal To 'abc123' Then .
Improvement: For database action types you can now select an existing connection string from other actions in the same Solution instead of building/entering the connection string on each action.
Improvement: The Cloud Storage action now supports wildcards for downloading files (Eg: /myfiles/docs/*.pdf).
Improvement: The Gmail message source now has the option to permanently delete processed messages (or delete and move to the Trash folder).
Fix: Fixed issue with Cloud Storage action where the full path was not specified in the Download Files entry. Now assumes the selected folder.
Fix: Fixed issue with %WeekDayNumber% built-in variable returning the week day name instead of number.
Fix: Fixed issue with Twitter message source error if using search term and Exclude Retweets enabled.
5.0.870 (2nd September 2022)
New: Added Deploy Solution feature to Studio. This allows a solution to be deployed to another ThinkAutomation Server instance.
New: The Call action now allows you to specify Scheduled Execution. If the Wait For Completion option is not enabled you can specify that the call is executed after x minutes, hours or days or at a specific date/time. This is useful if you want to delay execution of a called automation or have it execute at some specific future time. Called Automations that are waiting to be executed show in the Outbox list when viewing the Message Store.
New: The HTTP Get, HTTP Post actions now support Amazon AWS Signed Request Authentication.
Fix: Fixed issue with Read/Write Text File action showing error if the Make Backup option was enabled.
Fix: Fixed issue with incoming messages containing attachments with very long filenames (>150 characters) which would cause the attachments to not save during processing. Attachment filenames will now be truncated if too long.
Fix: Fixed issue with FTP upload/download still using passive mode even if the Passive Mode option was disabled.
Fix: Fixed issue with Sentiment Analyzer Control Panel showing error after login.
Fix: Fixed issue with Update Incoming Office 365 Message action not updating the Category.
Improvement: When viewing the message store, the message detail Preview window can now be dragged outside of the Studio window. You can then return to the Explorer tab to view/edit an Automation. This is useful if you need to view a recent message and message automation log whilst editing an Automation.
Improvement: When saving an Automation the Studio will now check that all %variables% referenced on all actions have been defined.
Improvement: The Import Solution option will now ask if you want to overwrite an existing solution if the solution already exists.
Improvement: The Message Sources and Automations explorer view sort order can now be changed.
Improvement: The Convert Document To Text action has additional options for PDF to text conversion. The PDF Text Extract Mode option has an additional Keep Positioning Method 2 option which may provide a more accurate human readable plaintext version of the PDF.
Improvement: The Twilio Send SMS action now allows you to specify a Messaging Service SID. If a Messaging Service SID is specified then Twilio will send the message using the specified Messaging Service.
5.0.866 (5th August 2022)
Fix: Fixed issue with Append PDF, Word & Text Attachments To Body For Parsing option on message source not working when original incoming body was multipart.
Fix: Fixed issue with Append PDF, Word & Text Attachments To Body For Parsing option on message source causing error on large text attachments.
Fix: Fixed issue with viewing Sent Items in the Studio showing error when viewing the detail.
Fix: Fixed issue with Move Down button in Automation editor not working when multiple lines selected.
Fix: Fixed issue with Save & Keep Open button in Automation editor showing All If Blocks Must Have Matching EndIf message incorrectly when the button is used multiple times.
Improvement: The Extract Field action Extract Json Path now allows %variable% replacements to be used on the path.
Improvement: Added Extract: Regex option to Text Operation action for simple regex extraction of single or multiple matches from any text.
Improvement: When using the Automation Editor you can now add commonly used actions to the Favorites group at the top of the Toolbox. Right-click an action in the toolbox to add or remove from favorites.
Improvement: Operations that use http calls will no longer offer SSL 3.0 and TLS 1.0 as an option for secure connections. Only TLS 1.1, 1.2 & 1.3 will be offered. This should not matter for most users - since the connecting server selects the protocol (not TA). This may improve connections for users with firewalls that use outbound packet inspection.
5.0.860 (5th July 2022)
New: Added Set Message Store Folder action. Messages in the Message Store can now be organized into sub-folders below the Automation folder.
New: Added Convert Image To Text action to convert image files and attachments to text using Optical Character Recognition (OCR).
New: For custom C# or Visual Basic scripts, you can now add reference any of the .NET Framework System assemblies via the Add Reference button.
Improvement: The Office 365 Update Incoming Message action now allows the Subject text to be modified.
Fix: Fixed issue with Message Store View Reprocess option sometimes showing an error (even though the reprocess worked).
Fix: Fixed issue with Office 365 message source reader not resetting if the sync status was cleared during a sync.
Fix: Fixed issue with Create Document action missing dll error when exporting the document to Word (docx) format.
Fix: Fixed issue with WYSIWYG html email editor not saving 'mailto:' URL's correctly.
Improvement: When viewing the Message Store you can now select to view all messages, successfully executed messages only, or messages that generated Automation errors only. You can also filter by message date.
Improvement: Added Windows 11 Light theme to Studio preferences.
5.0.850 (14th June 2022)
Improvement: When selecting a Message Source in the explorer - the Automation assigned to it is moved to the top of the Automations view along with any called Automations.
Improvement: You can now reset the error counts shown in the Studio status bar by right-clicking the Message Source or Automation logs. The error count is also reset if you reprocess any messages or edit an Automation.
Improvement: Added option to Convert Document To Text for PDF to text conversion, to return all text elements along with position and font information as CSV text.
Improvement: The schedule for Message Sources can be be set to every x seconds or hours in addition to minutes.
Fix: Fixed issue with CRM Actions error message in Studio when connect button clicked in some instances.
5.0.845 (7th June 2022)
Fix: Fixed issue with Reply To option on Send Email action changing the From address instead of just the 'reply-to' header.
Improvement: The Send Email action now has the option of sending the email immediately and the send result returned to a variable, in addition to the default option of adding the email to the outbox queue.
Improvement: When viewing the Automation Process Log you can now right-click a line and select View Message Store Message to view the processed message.
Improvement: The Lookup From Excel action and Excel Pickup Message Sources now support CSV, XLS, XLSB and ODS files in addition to XLSX files.
Improvement: The Convert Document To Text action now has a Test button allowing you to preview the conversion.
New: Added option to run a ThinkAutomation instance as a failover server for another instance. See Configuring A Failover Server in the help.
5.0.835 (17th May 2022)
Improvement: You can now set times of day that the ThinkAutomation performs message store database maintenance (where old processed messages are removed). Previously this was fixed at midnight - which could sometimes clash with other database maintenance operations when using a shared database server for your Message Store. You can specify multiple times if you have a busy ThinkAutomation implementation.
Improvement: File Pickup message sources now have the option of running on a schedule (eg: Every x minutes) instead of real time folder monitoring. Real time folder monitoring cannot be used on some UNC paths where network connectivity is intermittent.
Improvement: The File Operation - Get Folder Contents action now allows a mask to be specified.
Improvement: The FTP Download action now allows you to synchronize a remote folder to a local folder. All new or changed files from the specified remote folder will be downloaded to the local folder.
New: Added Continue Loop action. This can be used inside For Each loops to move processing to the next iteration (or exit the loop if on the last iteration).
New: Added Online Automation Library. When viewing the Automation Library you can now browse Automations in the Online Library. The Online Library will contain sample Automations created by Parker Software and Automations created by other ThinkAutomation users. You can download Automations from the online library which you can then use and edit.
Improvement: You can now use the Send Message option to send test messages against Library Automations.
Improvement: You can now scroll past the end of the last Action when editing an Automation. This makes it easier to add new actions to the end of the Automation when editing Automations with many actions.
Improvement: Improved Excel File Pickup Message Source. Provides better compatibility with Excel files created with older versions of Excel.
Fix: Fixed issue with Wait For User Response action not working when using MySQL for the Message Store database.
5.0.830 (9th May 2022)
New: Added Embedded Value Store. Allows simple storage and retrieval of key/value pairs.
Fix: Fixed issue with Move Incoming Message action not allowing you to select a folder when using Gmail message source.
Fix: Fixed issue the For Each Comma Separated Value In where the loop would stop on a blank CSV column.
Improvement: The HTTP Post action now allows files to be specified for form-data fields. The resulting post will then use 'multipart-form/data' content-type. You can also stream binary data using the Stream Binary Data option.
5.0.826 (28th April 2022)
New: Added Is A Valid Email Address for the If block condition check to check if the email address has a valid MX record. If you are sending emails to unknown recipients then you can use this to check the address is valid AND has a valid MX record before using the Send Email action.
New: Added Append To Remote Path option on Cloud Storage action (upload option). Allows you to dynamically upload to sub folders. Sub folders will be created if they do not exist.
New: Added Create Outlook MSG File action to save the current or a custom message as an Outlook compatible MSG file.
Fix: Fixed issue with deleting messages from the Message Store when using MySQL for the Message Store database.
Fix: Fixed issue with File Pickup message source where the reader did not initialize correctly (introduced in build 815).
Improvement: Added option to use an External Browser for OAuth sign-in's when using the Studio. Depending on your security setup your system may prevent the embedded Edge browser from being used, in which case you can enable this option in the Studio preferences.
5.0.816 (20th April 2022)
New: Added 'OAuth' sign in option for Microsoft Dynamics CRM actions (required for most recent versions of Dynamics).
New: Added 'HTML Editor' field input type for Web Form Message Sources and Wait For User Response action. Displays a full HTML editor. The field value is returned as HTML.
New: The Send Email action now has a WYSIWYG editor option for HTML emails. The previous HTML source editor can still be used if preferred. The Outgoing Email HTML Editing option in the Studio Preferences can be used to toggle.
New: The Send Email action now has the option to disable the automatic conversion of plaintext containing Markdown to HTML. This is useful if you need to send plaintext emails containing markdown characters (eg: **1234**) and do not want the plaintext auto-converted to HTML.
New: For Outgoing emails using the Markdown to HTML conversion, you now have the option of editing the CSS using Server Settings - Email CSS.
Fix: The File Pickup message source will now recover if the pickup folder connection is lost (folder is deleted, renamed or network lost in the case of network drives/unc paths). The Message Reader service will continue to re-check the folder every 30 seconds and will start monitoring it again if the folder re-appears. Previously this would have required a service restart.
Fix: Fixed issue with IMAP Message Source reporting unnecessary error in log when no new messages found.
5.0.812 (31st March 2022)
New: Added Global Constants. These are %variable% replacements that are global to all Automations in all Solutions. Global constants can be created using the Studio - Server Settings - Global Constants.
New: Updated the Select Solution menu. Now shows Solutions sorted by last updated date. Includes a search option.
New: The Professional Edition of ThinkAutomation now supports the hosting of your own Web API Gateway Service. You can run the Gateway Service on your own machine with its own DNS name and SSL Certificate with no daily message count limitations.
Fix: Fixed issue with Gmail Message Source re-syncing when an API rate limit response was returned - causing further rate limit responses.
Fix: Fixed issue with Web Form and API Message Sources not sending 'origins' to Gateway Server unless web form properties changed.
Fix: Fixed issue with Query CRM Entities action where any SELECT columns contained spaces.
5.0.800 (2nd March 2022)
New: The local API addmessage HTTP GET can now return files. Specify a file path in the Automation return value. Embedded File Store files can also be returned. You can return whole html pages, images, PDF files etc. The response Content-Type will be set according to the file extension. See the Local API help for more information.
New: The Twilio Make A Telephone Call action can now use the 'Alice' voice, which provides more languages.
New: Added Wrap HTML action. Wraps text, Markdown or HTML snippets inside HTML tags to create a viewable HTML page. This action is useful if you have content that you have created earlier in your Automation that you then want to wrap inside a HTML page. The resulting HTML can then be used for outgoing emails or for any other purpose. Styles can be added or you can use the built-in basic or Bootstrap styling.
New: Added Read CSV File action - a generic action for reading CSV files. Columns can be deleted and sorted before CSV data is assigned to a variable.
Fix: Fixed issue with File Pickup message source not resetting the reader if the file path/mask is changed, requiring a restart of the service.
Fix: Fixed issue with Database message source error when deleting processed rows.
5.0.795 (17th February 2022)
New: The Embedded Data Store action now has a Browse Data button allowing you to browse data from the Embedded Data Store. You can run SQL SELECT queries against all databases and collections. Query results can be printed and exported.
New: The Send Message form will now show a Enter Field Values button if the Automation has any Extract Field actions. You can then enter specific values for each field. When the message is sent for processing, ThinkAutomation will create the message body accordingly. This is useful during Automation testing.
New: Web Form message sources can now be served locally in addition to the Public API endpoint. This is useful if you want to create Web Form message sources that can be viewed and completed within your internal network - bypassing the public API. The Web Form message source properties page show both the Public and Local URL's.
New: You can now assign a Trusted SSL certificate for the local HTTPS interface using the Server Settings - Client tab.
New: The Spreadsheet action now allows you to read back cell values to Automation %variables% after formula re-calculation.
New: The Update Json action now has a Preview button.
New: Added 'Basic' edition.
Fix: Fixed issue with Date Operations - Add To option where 'Weeks' were specified - days were being added instead.
5.0.785 (8th February 2022)
New: New Spreadsheet action. Create an Excel compatible spreadsheet which can be saved as Excel file, PDF, CSV or HTML. Spreadsheet cells can contain %variables% which will be replaced when the Automation executes.
New: Counter action now has additional periods: Year & Week Number, Hour, Minute.
New: Counter action now has Get All operation, allowing call counter values to be returned to a variable in CSV format.
New: The Embedded Files Store action now has a Browse Files button allowing you to browse the file store.
New: Any File Information data returned from the Embedded Files Store action, Save, Get Info & Get List operations that is included in the Automation return value will now be rendered as clickable links for manual messages executed via the Studio or Client 'Send Message' form.
Fix: Fixed issue with File Pickup Message Source not deleting processed files when the Delete After Processed option enabled.
Improvement: Improved handling of attachment temporary files during Automation processing.
5.0.775 (26th January 2022)
New: New Create Web Form Redirect action. It can be used to conditionally redirect a ThinkAutomation Web Form to another ThinkAutomation Web Form or external URL after the form is submitted. You can also pre-populate field values on the new Web Form with custom values or %field% replacements created in the Automation. Using the Create Web Form Redirect action allows you to create interactive forms that display new forms based on values submitted on a previous one. You should re-save any existing Web Form Message Sources before using this action so that the updated form is sent to the API.
New: Web Forms can now use Bootstrap 5. You can change to Bootstrap 5 in the Server Settings - Web API. Once changed you will need to re-upload any existing Web Forms (by re-saving the Message Source). Form fields can now use 'Floating labels' - set the form field Label Placement to 'Floating'.
New: Web Form fields now include a 'Label' field type. This simply displays text - but can be used with the Create Web Form Redirect action to change the text. Eg: "Hello %Name%, please provide the following additional information".
New: Web Form Header, Footer & Confirmation Message can now include Solution Constants.
New: Web Form Submit button can now be left, right or centre aligned.
New: Database Read message sources can now use a stored procedure call to retrieve records.
New: In the Studio/Client Send Message form - any Automation responses/return values that contain Markdown will now be rendered as a formatted document instead of showing the raw Markdown text.
New: You can now enable Append PDF, Word & Text Attachments To Body For Parsing on Message Source properties. If enabled then any PDF, Word, Richtext or text attachments will be appended to the plain text body of the message for messages received by the Message Source. Document attachments will be converted to plain text before being appended. You can still extract text from PDF or Word documents inside an Automation using the Convert Document To Text action.
5.0.770 (19th January 2022)
New: New ThinkAutomation Desktop Connector Application. This is a stand-alone application that can be optionally installed on network PC's. Users can use the Desktop Connector to execute Automations by sending messages and dragging/dropping files. Emails & attachments can also be dropped directly from Microsoft Outlook (desktop).
New: The Studio Send Message form now supports dragging and dropping of emails directly from Microsoft Outlook (desktop).
New: You can now restrict non-admin users to specific Solutions. When a user connects using the Studio or Client they will only be able to see Solutions that they have been granted access to. Administrator users have access to all Solutions by default.
New: You can now restrict the option of Reprocessing messages to specific users.
New: The Select Case action can now use Contains One Of and Contains All Of case operators. These allow a list of values to be checked against on each Case.
New: The Contains, Does Not Contain, Contains One Of and Contains All Of conditional operators for If and Select Case blocks now support wildcards. For example: The Contains value of 'P123*' will match on text 'P1234' and 'P123456' etc.
Fix: Fixed issue with File Pickup message source when used to read Excel or CSV rows as individual messages. If a column name ended with a dot or contained { } or [ ] characters the auto-created Extract Field action would not extract the value correctly.
Fix: Fixed issue with IMAP message source not reading messages.
Fix: Fixed issue where multiple Message Sources read the same email at the same time causing an error when attachments are saved to the temporary location during Automation execution. During Automation execution attachments are now saved to a unique path.
Fix: Fixed issue with Distributed Setup where the Message Processor or Message Reader services are configured to run on separate computers. The Node Configuration utility was not setting the remote server address in the registry correctly.
5.0.760 (6th January 2022)
New: ThinkAutomation is now a 64bit application only. 32bit support is now dropped.
New: PowerShell action improvements. Also now includes a Test button in the Studio. This allows a command/script to be tested and the results displayed. You can now specify parameter types (string, int, boolean etc).
New: Send Email action now allows Send Via settings to be specified. This allows specific emails to be sent via a specific mail server/SendGrid account instead of the system default.
New: Send Email action now has a Send Test Email button to send the current message immediately.
New: Added UnRegister option to Studio should you need to unregister ThinkAutomation so it can be moved to another computer and re-registered with the same serial.
New: Server HTTP/Client Whitelist now accepts *.*.*.* if you want to allow local API/Client connections from any IP address.
New: Performance improvements for File Pickup message source where folder contains many files.
New: The Email Sending options in the Server Settings now allow the outgoing queue size to be specified. You can reduce the queue size if your outgoing email server imposes send limits or has low memory. Outgoing emails will then be sent in smaller batches over a longer time period.
New: The Set Variable and Text Operation actions now include Convert: XML To JSON operation for converting XML data into JSON.
New: Debug Level Logging now now be enabled globally for a preset number of minutes. The Enable Debug Logging button on the Logs tab switches on debug level logging for all Automations. You can then enter the number of minutes.
New: The Studio Explorer view can now show Messages Sources/Automations in a grid view or card view.
New Twitter message source and Send Tweet action.
Improvement: Performance improvements when using the built-in SQLite Message Store database.
Fix: Fixed issue with Automation Copy/Paste not copying If block conditions correctly when an 'Or' clause used.
Fix: Fixed issue with Document actions and Process Attachments action not working correctly where an individual filename contained a comma.
Fix: Fixed issue with File Pickup message source type when reading individual Excel rows. Message source could pause if a row contained a null value.
Fix: Fixed issue with Date Operations action not showing interval selector in Studio for Add To & Subtract From operations.
Fix: Fixed issue with Server Message Queue using too much memory if average incoming message size is large and the speed of adding to the Message Store database is slower than incoming messages. The in memory Queue now has hard limit of 500mb.
Fix: Fixed issue with Local API message source. If the process queue becomes full the local HTTP API interface will now slow down the response to prevent the server from running out of memory. A 503 response will be returned if a message could not be added due to the queue being full. This would only affect instances where many messages are added in a short time period.
Fix: Fixed issue with PowerShell action not showing errors in log.
Fix: Fixed issue with Gmail Message Source sign-in showing browser error due to Google policy change of not allowing logins from embedded browsers.
Fix: Fixed issue with Web Form Message Source using Google reCaptcha option not working correctly.
5.0.700 (15th November 2021)
New: Added Extract Email Signature action. Parses contact and company information from email signature footers.
New: Added options to HTTP Get action to convert relative links to absolute links.
New: Print actions now allow the printer name to be a %variable% instead of being forced to select a printer. This allows actions that print to use a printer based on some earlier condition.
New: Added option to specifically set outgoing email Smart host security setting.
New: If conditions now include Contains All Of and Contains One Of - for matching a list of words or phrases and RegEx Matches for matching regular expressions.
Fix: Fixed issue with local API where a message was sent via https with the &results= parameter to wait for Automation Results. Results were not returned (Automation executed correctly).
Fix: Improved HTML to PDF conversion which was throwing error on some HTML.
Fix: Fixed issue where Automation Log entries were being deleted from the Message Store too early during daily maintenance.
5.0.686 (6th November 2021)
New: Added Lookup From Excel action to lookup specific cell and cell range values from an Excel spreadsheet and assign to ThinkAutomation variables.
New: Added new built-in field replacement Msg_LastReplyBody. This returns the last reply plain text if the incoming message is an email containing multiple replies and quoted text.
Fix: Fixed issue with nested If..Else..EndIf blocks not executing actions after End If if the Automation was saved without a server restart.
Improvement: Improved Web API connectivity. If the ThinkAutomation Server loses connection to the Web API gateway it will reconnect without requiring a service restart.
5.0.682 (14th October 2021)
New: Added Update Json action to easily update or create Json by setting specific path values.
New: You can now copy Solution Constants from an existing Solution. When editing a Solution - click the Constants tab. From the Merge Constants From Solution list, select another Solution and click Merge Constants. Useful if you have a list of %field% constants that are always used.
New: Added Convert: CSV To Markdown Table option to the Set Variable action.
Fix: Fixed issue with Move Incoming Message action showing error in Studio when used with Gmail.
Fix: Fixed issue with On Error action not displaying correctly in Actions list when Retry option used.
Fix: Fixed issue with Studio now showing New Solution button when default Solution was deleted and no other solutions exist.
Fix: The Update CSV File action when not using Custom Fields list was sometimes adding the Extracted Field columns in the wrong order. Columns are now ordered in the same order that Extracted Fields are setup in the Automation.
Fix: The For..Each Token In loop now includes numeric tokens.
Fix: Fixed issue with CRM actions caching of entities where CRM server address contained '-' character.
Fix: Fixed issue with File Pickup message source - when reading Excel rows was incorrectly reading numeric cell values.
Fix: Fixed issue with Create Json / Update Json actions when update date values. The 'Z' UTC timezone indicator was added when no time zone information was available.
5.0.680 (7th October 2021)
New: Added Embedded Data Store action for easy storage and querying of data using the embedded document database.
New: Added Embedded Files Store action for saving and retrieving files using the embedded document database.
New: Added option to include numeric tokens in the Tokenize action.
New: When %field% replacements are performed, the replaced value will be Json escaped it is is being replaced inside Json text (unless the replaced value is already Json).
New: The Move Incoming Message action will now with Office 365, IMAP or Gmail message sources, allowing you to conditionally move an incoming message to a different folder on the source email account.
New: Added Convert: JSON To CSV option to the Set Variable action.
New: The default Automation Logging Level can now be set server-wide using the Server Settings. This can be overridden in an Automation using the Set Logging Level action.
Fix: Fixed issue with Office 365 Message Reader not moving processed files where more than 1 message was read in a batch.
Fix: Fixed issue with Extract Field action not saving default value option in studio.
Fix: Fixed issue with Create Json action where string values were sometimes not escaped correctly.
Fix: Fixed issue with Exchange Web Services message source not using the configured proxy server settings.
Fix: Fixed issue with Process Attachments action. If Rename Saved Files To was used without specifying a file extension, the saved file would not contain an extension.
Fix: Fixed issue with Tokenize action returning blank value where Unique tokens option not enabled and text contained non-unique tokens.
Fix: Fixed issue with Studio Send Message option - when debugging Automations a send message could cause the Automation to exit prematurely because the Studio updates the Automation during execution.
Fix: Fixed issue with Studio: Dragging an action to move it in the Automation action list would sometimes not drag to the correct place causing the line numbers to show incorrectly until the Automation was saved & reloaded.
Improvement: CRM Actions will now use a proxy server if one is configured in the ThinkAutomation server settings.
5.0.662 (8th September 2021)
New: Added %Msg_MessageStoreId% built-in field. Returns the Message Store database unique id for the current message.
New: Added Query CRM Entities action for performing generic queries on CRM entities and returning the results as Json text, CSV or Markdown.
Improvement: Improved CRM entity table/column name caching.
Fix: Fixed issue with Send Email action not sending to CC, BCC addresses when using Smart Host email sender.
Fix: Fixed issue with %DayOfWeek% built-in field returning yesterdays day name instead of today.