How do you delete mail in IMAP? kOW3imapActionExecute

Mike Matthews - Omnis omnis at lineal.co.uk
Tue Feb 14 18:11:46 UTC 2023 

Hello Miguel,

Yes, we are using O365 with oAuth2 and the OW3 worker.  But it was not easy to start with, we had a lot of help from UK support to figure out what was happening.  The example library is fine however.

Are you subclassing your IMAP worker object?  If so, then after you get the $token successfully, you can’t use it with a subclassed IMAP worker object.  That fault was raised and fixed with a release of new OW3 xcomp.  You need to be using Omnis Studio v10.22 build 31986 or ask for the OW3.xComp

There is no problem using O365 with oAuth2 and the IMAPWorker now.  Let me know if you need any more help.

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co/>



On 14 Feb 2023, at 18:01, Miguel Garcia <miguel.garcia at roig.com<mailto:miguel.garcia at roig.com>> wrote:

Caution: This is a message which has originated from outside the organisation. Ensure the sender is trusted and the content is safe before opening links or attachments.



Hi Mike,

Are you using IMAP WORKER with OAuth2?. It works fine? What email do you
use?

We are testing IMAP WORKER OAuth2 with office365 mail. At the moment it
doesn't work. The authorization using oAuth worker works fine, but we
can't not autenticate with the token received in the authorization proccess.

I think there is something that is not well defined in Office365.

Best Regards.


El 14/2/23 a las 18:31, Mike Matthews - Omnis via omnisdev-en escribió:
Hello Miguel,

Interesting use of the Append function.

I use the kOW3imapActionSetMessageFlags function to flag the email to be deleted.

Then I use the kOW3imapActionExecute function to send the command ‘CLOSE’ or ‘EXPUNGE’ which then does the final removal from the mailbox.

I was trying to move the flagged email to the ‘Deleted Items’ folder if the user wanted to keep it until they clear the old emails.  I now know how to copy/move emails using the OW3 workers.

The original IMAP commands were fine, until the need for oAuth2 came along.

Thanks

Mike


On 14 Feb 2023, at 07:53, Miguel Garcia <miguel.garcia at roig.com<mailto:miguel.garcia at roig.com><mailto:miguel.garcia at roig.com>> wrote:

Caution: This is a message which has originated from outside the organisation. Ensure the sender is trusted and the content is safe before opening links or attachments.



Hi Mike,

We copy messages through the following steps :

1. Read the message that you want copy with kOW3imapActionFetchMessage.

2 Remove the messageid, oIMAP.$removemessageid.$assign(kTrue)

3 Append the message with kOW3imapActionAppendMessage.

Best Reards.

El 11/2/23 a las 15:41, Mike Matthews - Omnis via omnisdev-en escribió:
In some RFC pages, I found a list of commands:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.rfc-editor.org%2frfc%2frfc3501%23page-23&c=E,1,WQ4DQVEiaX0C4YSaxEwRZRIjwwGTRJJ3t-GYgtEF6PWQbisPqEO3In24AgyRPuLueo0pHi9BrPZJbduTeUCIIXCAjVRxUwmsSIzHLyIqpTuJ1rA,&typo=1

Section 6 has them.

I’m trying to use the kOW3imapActionExecute COPY command where I want to move an email to another mailbox.  I just can’t get the OW3 worker to do this.

I can get the same kOW3imapActionExecute to make new MailBoxes, etc.  But copying an email just fails!  Arghh..

Anybody have this working and can share some examples please?

Thanks

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.lineal.co.uk&c=E,1,HsVUWSPvap2JAbAymFHtDrGmtV7cXKyhpbzx3Xq2UUx74UMC0AxwloODPVdZloibtuhGNdw06xW9MyRof6RY8kIcjN9SwHhk1JREG2fCKCr_ZM8,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.lineal.co.uk%2f&c=E,1,O6P-UW3gCTBpBIdrMkyNORkC3FMpm90XqMr8eRSrYggFH1mEGilTa5jJjlfG7DZv2IU5JjWg3E2ARBgKyfyNKO4jiK6i8QXVvvQrLswbJl6ahyg,&typo=1>

https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.sqlworks.co.uk&c=E,1,RKBjZ19QlVg2_KAy4pIIXHTmFNmI9Re5Ge2p_ynErpmDirLPEhPSRIU1BBd9mOD4GPbKcOaXjjk4IOudc9CwqWtVuD0w2vBPPZtSb1H1Z6tivkzdMY01hzFK4Kc,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.sqlworks.co%2f&c=E,1,cL1rCbktqLuhY9zIUY5J9R3ZmKfiDpT2RbTH19NqX9JcdrNI6tUzuQqwrPcI08OavW4wlGlMjEXSYphtmlY2PTLVG9OqFiH9MNBZg9PZGxrmVhuDQHMFKkxW5ZO_&typo=1>



On 11 Feb 2023, at 09:40, Mike Matthews - Omnis via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:

Caution: This is a message which has originated from outside the organisation. Ensure the sender is trusted and the content is safe before opening links or attachments.



Hello All,

I’m following up on this thread from earlier.  How do you find all of the possible commands available when you use ‘kOW3imapActionExecute’?

Kindly, EXPUNGE is shown here by Miguel.  So I’m guessing there must be a reference doc somewhere?  Hoping that might include adding new mailboxes, etc.

Thanks

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:omnis at lineal.co.uk><mailto:mike.matthews at lineal.co.uk>

https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.lineal.co.uk&c=E,1,5iFDCKSIcTnckOx3FX9802oaKTWkMLM3wV1hMkZzyr7zx1Zmd_fFUAvQvXfKRJuLfwjmSrkEfjtpO1DyoBENsxuDexH28fVz4wlaYqM9iEefIw4,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.lineal.co.uk&c=E,1,Lb0Ct6PAOA1bMj0UeJN3R9C7sLPxPt4hMLydv_TSZiFSnv4pFdPYoTbfpfHcWeDliqpkWNjwoBwsGDbg2G-BeNrxp0jTYpGUGnZIBjbsGDWO6sz3XnfB&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.lineal.co.uk%2f&c=E,1,Tr32z6d3MLPOX9DkcWFYeWdA8AKHyuWCBV8fIKJ8UFA8zXF7Ki2YhTkOwCQqj18JE9FsAxmz4AlgttVgRqLkiOZw834mYJNl2k_J0w1p8w-F807EBDU,&typo=1>

https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.sqlworks.co.uk&c=E,1,PG1lcShmmmVYfdqC1w4KxfOZ1g7m2hhTc0urptcborovmnQWymvEVavs-ZTCxfLNX6PQwrTmuvkJdF7E1EALateUauaQofwUOWHvkYuERm9H9lTDeanPYi8piBY,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.sqlworks.co.uk&c=E,1,r28D9QUXOexnfjQgZWGnm-0jupF033poioIj_u3SVexobXrrXGCg9OIQhjWNU_K5uPMe_lsKi8Rn50DtzrxJILfWyekApp8iKmvktcrSEEo,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.sqlworks.co%2f&c=E,1,sZSguuM2IBR2WxVR6xYbfsXZdESKVVK2dv1tPIXKrLfnfi-nDc4goG-e551_y2C3lRQvCw6Uz0838r4n523aX8ew_mwgWOgN3rUvUUaWtg,,&typo=1>



On 12 Apr 2022, at 07:50, Miguel Garcia <miguel.garcia at roig.com<mailto:miguel.garcia at roig.com><mailto:miguel.garcia at roig.com>> wrote:

Hi Das,

First set the "deleted" flag to kTrue using kOW3imapActionSetMessageFlags.

Example :

   Do RowFlags.$addcols('answered',kInteger,k32bitint,)
   Do RowFlags.$addcols('deleted',kInteger,k32bitint,)
   Do RowFlags.$addcols('draft',kInteger,k32bitint,)
   Do RowFlags.$addcols('flagged',kInteger,k32bitint,)
   Do RowFlags.$addcols('seen',kInteger,k32bitint,)
   Do RowFlags.$assigncols(kUnknown,kTrue,kUnknown,kUnknown,kUnknown)
   Do $cinst.$start(kOW3imapActionSetMessageFlags,pMailboxName,pUID,RowFlags) Returns lOk

Then to delete completely de message execute the EXPUGNE imap command.

Example :

           Calculate lCmd as $cinst.$chartoutf7(nfd(trim('EXPUNGE')))

           Do $cinst.$start(kOW3imapActionExecute,pMailboxName,lCmd) Returns lOk

$cinst is an IMAPClientWorker object and pMailboxName is the folder of the message.

Best regards.


El 11/4/22 a las 20:52, Das Goravani escribió:
Talking 10.2 here

In IMAP I have noticed actions for things like listing mailboxes, listing messages and so on…

But there’s no action for deleting a message completely

How do you delete a message completely in the IMAP world within Omnis

The one mention of "get’s rid of message" was in reference to appending the same message again to a list.. it said messages with duplicate ID’s disappear by the IMAP engine, so I was thinking one way to get rid of a message is to append itself to the same list and then both copies will go away?

Then there’s the Action for commands and there is some type of DELETE command within IMAP since I was able to find it’s error codes

I guess I have to make a custom command binary and execute that having the delete command within it

Anyone have that or know the way to delete?
_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,3ze8tf6ZqESwdscwTNECTaPbR89OzPd_VnZo5WKfJVtFrh4YBqWmD9K55Cuotr9wzbcFmESkGqqNE-dhufuNbVcsgZqGPPsK5Bob0i10WpS1cKPWO2VK&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com
--
*Miguel Garcia Segui
DPTO Informatica
971 65 71 73 Ext. 2044*


_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,6snWB8ymdDIaxDdiuvUxuxCurcJgjahuha-WsoQV7IZ3jbLOR7dP0szdUw8fM1pThjslAQufhseXAYrWHUDMwQ_4bEngD37gmzlOPHe2ZdgzpqY-GGPa8wavTw,,&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,nCeGDxJB5Vi-2KXdAD8s_MeJ2ADEAPbpi3fhK7jI0ti8ECI9EXcd-2TrP7uhsJgBW4VkJ1BBHE6fDMALRgHjUkD5EK3Fz-xoWGQrpM33zrxUopGX&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,-lPXV2_xix8LE306UM8SzT-2Mu3UIp8sA6sW6rup--vKwzRs7aTK0mRo-HqO0lENjf950u2uHA9Pp8I4u40V38WA3Eezhl1xT-6Kp1lmLkF9YHty&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com
--
*Miguel Garcia Segui
DPTO Informatica
971 65 71 73 Ext. 2044*


_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,rsUqaeAunQagT8oQly-BLtOLlU62VZUA_N0iChEZQ5uKGF2gbkcJUk6CjhzIQh__OV1RPgNHzzJnE9PIRVJYl5MwWyuhfl-kE5xzqlmPiVkmAZYzPSQ3Iw,,&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,qHX4SVzXb7E-3yngIFOqF1wfdx0mmB4YXNEx-V7dbPkiz0_M-vgg-6qsl5Tu8sZm-zftH7lHArdGJC0EY4URXl5m7Y-MdKB9sxugsYEQzyU,&typo=1
Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com
--
*Miguel Garcia Segui
DPTO Informatica
971 65 71 73 Ext. 2044*


_____________________________________________________________
Manage your list subscriptions at https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,OKRG5SN7RzThaBLtCkQfS6s-9jpyWfaPPsFWrHksNkuw2pcQ2UASX_mh6jAT9lGExAvpMQ7ddjqKY0MiUl1o6fgKquYEhBsBOyJ4Ij9S9tZUKP8,&typo=1
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

More information about the omnisdev-en mailing list