Hi,
I am using mail_client api to read emails from outlook server which is working fine. But i need to sync new emails once they come to inbox immediately. Current load email procedure loads all the emails from inbox which will take tooo much time.
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
In that mail_client API post, I have given the example to load emails, but if you want to load only the new mails then you can use the date criteria to pick only for the current day. For example, modify the cursor of load_email procedure as follows:
Also, you need to identify the unique column in the above header so that you can download only the new emails. Then you can schedule the procedure to run every hour to get the daily unique mails. You can check the following tutorials:
Run PL/SQL Job every hour example
Run PL/SQL job every day once
Thank you so much. working now.