Jump to content
MarkIT

[Query] Office365 API for AutoIT?

Recommended Posts

Hi guys,

Been searching the forum but would need to ask for your confirmation if we have a UDF that can be used to send/receive emails by interacting with Office 365 APIs.

Just like the one on this link:

https://www.codeguru.com/csharp/csharp/cs_internet/mail/send-e-mail-using-office-365-apis-and-exchange-web-services.html

With similar implementation done on .NET:

https://www.emailarchitect.net/eagetmail/ex/c/9.aspx

The purpose is that we are working on a project where client requires that our Automation that sorts  emails gets triggered using Task Scheduler activities. The plan is to run the automation on the backend without using the Outlook UI and only connects to the Office365 platform via API? 

Edited by MarkIT

Share this post


Link to post
Share on other sites

I'm absolutely shocked you didn't stumble across across the OutlookEX UDF in your search in these forums! Probably does EXACTLY what you are looking for.

All the three options you have noted will be accessing the mail environment as objects. Is it worth mixing your development code between various languages and the support/maintenance overhead and confusion that entails?

Some good reading at https://www.autoitscript.com/wiki/OutlookEX_UDF_-_General

Edited by Confuzzled

Share this post


Link to post
Share on other sites

For performance and maintenance reasons, interspersing an AutoIT layer between code and the mail environment is probably going to end in some extra work they do not need.

A scripting platform compared to calling APIs direct? Naaah. Just one more level to debug. Whip out the Microsoft Tools and start coding!

..Horses for courses..

Share this post


Link to post
Share on other sites
On 10/31/2020 at 5:11 AM, Confuzzled said:

I'm absolutely shocked you didn't stumble across across the OutlookEX UDF in your search in these forums! Probably does EXACTLY what you are looking for.

All the three options you have noted will be accessing the mail environment as objects. Is it worth mixing your development code between various languages and the support/maintenance overhead and confusion that entails?

Some good reading at https://www.autoitscript.com/wiki/OutlookEX_UDF_-_General

Hi Confuzzled, 

Thanks! We have already implemented OutlookEX UDF and functionalities for the project. Automation is already running perfectly for 1 year. Only issue now is that client doesnt want interactive login on the servers for the automation to work. They want services to run on backend and perform the process. They wanted now to access the O365 Exchange directly using APIs instead of an Outlook UI.

Thanks!

Share this post


Link to post
Share on other sites

BTW: The OutlookEX UDF does not automate the UI (User Interace) of Outlook but uses the Microsoft API (COM) to access incoming mails etc.

I do not think it is a good idea to have such automation run on the server. The main purpose of an Exchange server is to provide a service for many, many users. it should not be overcharged with other tasks. If the automation tasksbrings the server to a halt (eats up all CPU, memory or disk space etc.) all users are affected.
If this happens on a client automating Outlok then just one user is affected.

This seems to be a good reading what MS intends: https://techcommunity.microsoft.com/t5/exchange-team-blog/upcoming-changes-to-exchange-web-services-ews-api-for-office-365/ba-p/608055

Graph overview: https://docs.microsoft.com/en-us/graph/overview?view=graph-rest-1.0

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites
1 hour ago, water said:

BTW: The OutlookEX UDF does not automate the UI (User Interace) of Outlook but uses the Microsoft API (COM) to access incoming mails etc.

I do not think it is a good idea to have such automation run on the server. The main purpose of an Exchange server is to provide a service for many, many users. it should not be overcharged with other tasks. If the automation tasksbrings the server to a halt (eats up all CPU, memory or disk space etc.) all users are affected.
If this happens on a client automating Outlok then just one user is affected.

This seems to be a good reading what MS intends: https://techcommunity.microsoft.com/t5/exchange-team-blog/upcoming-changes-to-exchange-web-services-ews-api-for-office-365/ba-p/608055

Graph overview: https://docs.microsoft.com/en-us/graph/overview?view=graph-rest-1.0

Thanks Water! Will check on these

Share this post


Link to post
Share on other sites

MarkIT,

When you reply in future, please use the "Reply to this topic" button at the top of the thread or the "Reply to this topic" editor at the bottom rather than the "Quote" button - responders know what they wrote and it just pads the thread unnecessarily. Thanks in advance for your cooperation.

M23


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...