Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Xojo Plugin) Outlook -- List Selected Fields in MessagesDemonstrates how to list the messages in a particular Outlook mailbox folder, but selects particular fields to be returned. This uses the OData $select system query option. See OData System Query Option $select for general information.
Also see OData URL Conventions for information about $select and other query options. Note: This example requires Chilkat v9.5.0.68 or greater. This example applies to: Exchange Online | Office 365 | Hotmail.com | Live.com | MSN.com | Outlook.com | Passport.com
// This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. Dim http As New Chilkat.Http // Use your previously obtained access token here: // See the following examples for getting an access token: // Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint). // Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint). // Refresh Access Token (Azure AD v2.0 Endpoint). // Refresh Access Token (Azure AD Endpoint). http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN" Dim sbResponse As New Chilkat.StringBuilder // In this example, we'd like to get the messages in the folder "/Inbox", // but we must specify the corresponding folder_id. The best way to do this is to create // a local map of folderPaths-to-folderIds. // This example does it: Create Outlook Folder Map) Dim htFolderMap As New Chilkat.Hashtable Dim sbMap As New Chilkat.StringBuilder success = sbMap.LoadFile("qa_data/outlook/folderMap.xml","utf-8") success = htFolderMap.AddFromXmlSb(sbMap) // Get the ID for the "/Inbox" folder: Dim folderId As String folderId = htFolderMap.LookupStr("/Inbox") If (htFolderMap.LastMethodSuccess <> True) Then System.DebugLog("Folder ID not found") Return End If success = http.SetUrlVar("folder_id",folderId) // Send the request to list the messages, returning only the subject and from address. Dim success As Boolean success = http.QuickGetSb("https://graph.microsoft.com/v1.0/me/mailFolders/{$folder_id}/messages?$select=subject,from",sbResponse) If ((success <> True) And (http.LastStatus = 0)) Then System.DebugLog(http.LastErrorText) Return End If Dim json As New Chilkat.JsonObject success = json.LoadSb(sbResponse) json.EmitCompact = False System.DebugLog("Status code = " + Str(http.LastStatus)) If (http.LastStatus <> 200) Then System.DebugLog(json.Emit()) System.DebugLog("Failed.") End If System.DebugLog(json.Emit()) // In my test case, the raw JSON returned is shown below. // Iterate over the messages to get information about each.. Dim i As Int32 i = 0 Dim numMessages As Int32 numMessages = json.SizeOfArray("value") While i < numMessages json.I = i // This is the id for the email message. // For REST API calls that require particular email message id, this is what should be used.. Dim messageId As String messageId = json.StringOf("value[i].id") System.DebugLog("id: " + messageId) System.DebugLog("From Name: " + json.StringOf("value[i].from.emailAddress.name")) System.DebugLog("From Addr: " + json.StringOf("value[i].from.emailAddress.address")) System.DebugLog("Subject: " + json.StringOf("value[i].subject")) System.DebugLog("--") i = i + 1 Wend // The output of the above loop: // // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj1oAAAA= // From Name: Chilkat Software // From Addr: admin@chilkat.io // Subject: This is an example email from chilkat.io // -- // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj1kAAAA= // From Name: Chilkat Support // From Addr: chilkat.support@gmail.com // Subject: Hello from GMail // -- // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAHrLra8AAAA= // From Name: Microsoft Office 365 // From Addr: MicrosoftOffice365@email.office.com // Subject: The latest for you in Office 365 // -- // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_EAAAA= // From Name: Amazon Web Services // From Addr: no-reply-aws@amazon.com // Subject: Amazon SES Address Verification Request in region US West (Oregon) // -- // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_AAAAA= // From Name: Amazon Web Services // From Addr: no-reply-aws@amazon.com // Subject: Amazon SES Address Verification Request in region US West (Oregon) // -- // id: AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAAG6l8UAAAA= // From Name: Microsoft // From Addr: msa@communication.microsoft.com // Subject: Updates to our terms of use and privacy statement // -- // // ------------------------------------------------------ // This is the raw JSON response: // { // "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA')/messages(subject,from)", // "value": [ // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AADOpwfo\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj1oAAAA=", // "subject": "This is an example email from chilkat.io", // "from": { // "emailAddress": { // "name": "Chilkat Software", // "address": "admin@chilkat.io" // } // } // }, // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AADOpwfn\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj1kAAAA=", // "subject": "Hello from GMail", // "from": { // "emailAddress": { // "name": "Chilkat Support", // "address": "chilkat.support@gmail.com" // } // } // }, // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAB63d8O\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAHrLra8AAAA=", // "subject": "The latest for you in Office 365", // "from": { // "emailAddress": { // "name": "Microsoft Office 365", // "address": "MicrosoftOffice365@email.office.com" // } // } // }, // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAA1jyl7\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_EAAAA=", // "subject": "Amazon SES Address Verification Request in region US West (Oregon)", // "from": { // "emailAddress": { // "name": "Amazon Web Services", // "address": "no-reply-aws@amazon.com" // } // } // }, // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAA1jyl6\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_AAAAA=", // "subject": "Amazon SES Address Verification Request in region US West (Oregon)", // "from": { // "emailAddress": { // "name": "Amazon Web Services", // "address": "no-reply-aws@amazon.com" // } // } // }, // { // "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAAGt5YG\"", // "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAAG6l8UAAAA=", // "subject": "Updates to our terms of use and privacy statement", // "from": { // "emailAddress": { // "name": "Microsoft", // "address": "msa@communication.microsoft.com" // } // } // } // ] // } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.