How do you delete mail in IMAP? kOW3imapActionExecute

Miguel Garcia miguel.garcia at roig.com
Wed Feb 15 17:49:49 UTC 2023 

Hi Mike,

The latest version of Omnis Studio 10.22 actually corresponds to build 
31896. But this build does not solve a very important bug for us solved 
in Omnis Studio 8.1.7.3.

We are migrating from 8.1.7.3 to Omnis 10.22.

As it is very important for us to have this bug resolved, Support sent 
us a new build starting with build 31896 that incorporates the 
resolution of this bug. This build is 31918.

Best Regards.

El 15/2/23 a las 9:09, Mike Matthews - Omnis via omnisdev-en escribió:
> Hello Miguel,
>
> With the build numbers, I mean you to use the latest version available on website download, I think I should quote
> 31896
>
>
>
> Mike Matthews
> Lineal Software Solutions
> Commercial House, The Strand
> Barnstaple, Devon, EX31 1EU
>
> omnis at lineal.co.uk
>
> www.lineal.co.uk
>
> www.sqlworks.co.uk
>
>
>
>> On 14 Feb 2023, at 19:01, Miguel Garcia<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 are using imap_ow3.lbs sample library provided by Omnis Studio 10.22
>> 31918. Effectively the imap object is a subclass of the imap worker
>> object. I will ask support for the new build 31986 or for the OW3.xComp.
>>
>> If it not work with the new built i will ask you for the configuration
>> in O365.
>>
>> Thanks.
>>
>> Best regards.
>>
>> El 14/2/23 a las 19:11, Mike Matthews - Omnis via omnisdev-en escribió:
>>> 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>
>>>
>>> https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.lineal.co.uk&c=E,1,Qh6KDppohDOv2pdJxAXbMUl8dIQ092z0SMcmsl4nFFz7Z6wf-xP5I6Vefa7hk2szxBQNL5XQlYFNSI81Sn2AIib0ZQCMFOVrKoPEqRLSCcM,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.lineal.co.uk%2f&c=E,1,-DsTzGMuNWX3usnZV0idDGn4h7UUQUDuojcsFqH0mN186Hi8eVsiUxXz_PVONB9L38QxKX32GMJEenLpxJTv1jUvjeCwx-a3oAqWiKLXyu6ovJ_CLw,,&typo=1>
>>>
>>> https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.sqlworks.co.uk&c=E,1,IwW0NA9wCH_S7fcS4G6DKQduh-pxSH3qcf091SS_FlJCSeDNnqC1eEwfIrvkrTERpblGjWMWrwWKSatFG_v6zzwH6pMZ0iWeYo3yzHQn7AErLYAR31TnzvY3pI4,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.sqlworks.co%2f&c=E,1,-vYP6CHJUOio9yo_KPTUK7aIjHsnKI0QlwxFKzH5_R_6EKqtT4pitQya0rkiUUbYaOs0oi2ym2vKg71vFAZJG1tkPVvbbSXV4D_efXlLHKs,&typo=1>
>>>
>>>
>>>
>>> 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 athttps://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
>>>
>>> _____________________________________________________________
>>> Manage your list subscriptions athttps://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.omnis-dev.com&c=E,1,zN0qwXTN8OfaXM6Tn5TdFOvlmWweCDQoI1IPq5pm245LE1wO-2LtdDzrdiUxEYIF_JDPWfaMf8AGmvF6rEZn0NEgLBcWOJ-RBcKiJrTLPRe47nbriJHiH9jURw,,&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,ycOV2ghFSqglxwJPNXF1FSLwNbBzqcyvASVr9CvDoTpZpHoclQatrfB50IyAbjbnPYtLuyShiXEgZfTn4V6sI3B7PC1QSE0TA0P7jeQ-Ne8Pdl4,&typo=1
>> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions athttps://lists.omnis-dev.com
> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com  
-- 
*Miguel Garcia Segui
DPTO Informatica
971 65 71 73 Ext. 2044*

More information about the omnisdev-en mailing list