(Unicode C) Outlook -- Search Multiple Folders

I don't yet see how it's possible to do a recursive search of Outlook folders using the Microsoft Graph API. My best guess is to somehow use OData v4.0's $expand query option, but the hierarchical structure of the "mailFolder" and "messages" Microsoft Graph resources don't quite fit. Suggestions are welcome and can be sent to support@chilkatsoft.com.

This example will iterate over a list of folder previously obtained by a recursive traversal of the Outlook mail folders. (See the link in the example code below.)

A separate search is performed on each desired folder, and the results are combined into a single result set.

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

Chilkat C/C++ Library Downloads
MS Visual C/C++ Linux/CentOS C/C++ Alpine Linux C/C++ MAC OS X C/C++	armhf/aarch64 C/C++ C++ Builder iOS C/C++ Android C/C++	Solaris C/C++ MinGW C/C++

#include <C_CkHttpW.h>
#include <C_CkXmlW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkStringBuilderW.h>

void ChilkatSample(void)
    {
    HCkHttpW http;
    HCkXmlW xmlMap;
    BOOL success;
    HCkJsonObjectW json;
    HCkJsonObjectW jsonCombined;
    HCkStringBuilderW sbResponse;
    HCkStringBuilderW sbPath;
    int numFolders;
    int i;
    int j;
    int k;
    int numMessages;

    // This example requires the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    http = CkHttpW_Create();

    // 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).

    CkHttpW_putAuthToken(http,L"MICROSOFT_GRAPH_ACCESS_TOKEN");

    // This example will iterate over the folders previously discovered by recursively traversing the Outlook folders
    // as shown in this example:  Outlook Recursive Folder Traversal)

    // The XML map produced by the recursive traversal looks like this:

    // 	<?xml version="1.0" encoding="utf-8"?>
    // 	<hashtable>
    // 	<e><k>/Sent Items</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEJAAAA</v></e>
    // 	<e><k>/Inbox</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA</v></e>
    // 	<e><k>/Junk Email</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEiAAAA</v></e>
    // 	<e><k>/Inbox/xyz</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwEAAAA=</v></e>
    // 	<e><k>/Inbox/abc/subFolderA/a</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwIAAAA=</v></e>
    // 	<e><k>/Inbox/abc</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAAA=</v></e>
    // 	<e><k>/Outbox</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgELAAAA</v></e>
    // 	<e><k>/Inbox/abc/subFolderA</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwAAAQ==</v></e>
    // 	<e><k>/Inbox/abc/subFolderB</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwMAAAA=</v></e>
    // 	<e><k>/Archive</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAG8XunwAAAA=</v></e>
    // 	<e><k>/Deleted Items</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEKAAAA</v></e>
    // 	<e><k>/Drafts</k><v>AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEPAAAA</v></e>
    // 	</hashtable>

    // We'll iterate over the folders, and search all folders beginning with "/Inbox" (effectively, we're recursively searching
    // everything under Inbox)
    xmlMap = CkXmlW_Create();
    success = CkXmlW_LoadXmlFile(xmlMap,L"qa_data/outlook/folderMap.xml");
    if (success != TRUE) {
        wprintf(L"Failed to load XML folder map.\n");
        CkHttpW_Dispose(http);
        CkXmlW_Dispose(xmlMap);
        return;
    }

    // We're going to return just the message id, subject, and FROM name/address.
    CkHttpW_SetUrlVar(http,L"select",L"id,subject,from");

    // Our search will be for emails with the word "sample" in the subject.
    CkHttpW_SetUrlVar(http,L"filter",L"contains(subject,'sample')");

    json = CkJsonObjectW_Create();
    CkJsonObjectW_putEmitCompact(json,FALSE);

    jsonCombined = CkJsonObjectW_Create();
    CkJsonObjectW_putEmitCompact(jsonCombined,FALSE);

    sbResponse = CkStringBuilderW_Create();
    sbPath = CkStringBuilderW_Create();
    numFolders = CkXmlW_getNumChildren(xmlMap);
    i = 0;
    j = 0;
    k = 0;
    while (i < numFolders) {
        CkXmlW_putI(xmlMap,i);
        CkStringBuilderW_SetString(sbPath,CkXmlW_getChildContent(xmlMap,L"e[i]|k"));

        if (CkStringBuilderW_StartsWith(sbPath,L"/Inbox",TRUE) == TRUE) {

            wprintf(L"------------------------------------------------------------------\n");
            wprintf(L"Searching %s\n",CkStringBuilderW_getAsString(sbPath));

            // Search this mail folder..
            CkHttpW_SetUrlVar(http,L"folder_id",CkXmlW_getChildContent(xmlMap,L"e[i]|v"));

            CkStringBuilderW_Clear(sbResponse);
            success = CkHttpW_QuickGetSb(http,L"https://graph.microsoft.com/v1.0/me/mailFolders/{$folder_id}/messages?$filter={$filter}&$select={$select}",sbResponse);
            if ((success != TRUE) && (CkHttpW_getLastStatus(http) == 0)) {
                wprintf(L"%s\n",CkHttpW_lastErrorText(http));
                CkHttpW_Dispose(http);
                CkXmlW_Dispose(xmlMap);
                CkJsonObjectW_Dispose(json);
                CkJsonObjectW_Dispose(jsonCombined);
                CkStringBuilderW_Dispose(sbResponse);
                CkStringBuilderW_Dispose(sbPath);
                return;
            }

            CkJsonObjectW_LoadSb(json,sbResponse);

            if (CkHttpW_getLastStatus(http) != 200) {
                wprintf(L"HTTP response status = %d\n",CkHttpW_getLastStatus(http));
                wprintf(L"%s\n",CkJsonObjectW_emit(json));
                wprintf(L"Failed.\n");
                CkHttpW_Dispose(http);
                CkXmlW_Dispose(xmlMap);
                CkJsonObjectW_Dispose(json);
                CkJsonObjectW_Dispose(jsonCombined);
                CkStringBuilderW_Dispose(sbResponse);
                CkStringBuilderW_Dispose(sbPath);
                return;
            }

            wprintf(L"%s\n",CkJsonObjectW_emit(json));

            // Each mail folder search will return JSON with a value array, which is non-empty if any matching messages were found:

            // 			{
            // 			  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA')/messages(id,subject,from)",
            // 			  "value": [
            // 				Individual messages, if any, are listed here.
            // 			  ]
            // 			}

            numMessages = CkJsonObjectW_SizeOfArray(json,L"value");
            j = 0;
            while (j < numMessages) {
                CkJsonObjectW_putJ(json,j);

                // Add this message to the final result set.
                CkJsonObjectW_putK(jsonCombined,k);
                CkJsonObjectW_UpdateString(jsonCombined,L"value[k].folderPath",CkStringBuilderW_getAsString(sbPath));
                CkJsonObjectW_UpdateString(jsonCombined,L"value[k].id",CkJsonObjectW_stringOf(json,L"value[j].id"));
                CkJsonObjectW_UpdateString(jsonCombined,L"value[k].subject",CkJsonObjectW_stringOf(json,L"value[j].subject"));
                CkJsonObjectW_UpdateString(jsonCombined,L"value[k].from.emailAddress.name",CkJsonObjectW_stringOf(json,L"value[j].from.emailAddress.name"));
                CkJsonObjectW_UpdateString(jsonCombined,L"value[k].from.emailAddress.address",CkJsonObjectW_stringOf(json,L"value[j].from.emailAddress.address"));
                k = k + 1;

                j = j + 1;
            }

        }

        i = i + 1;
    }

    // Show the final combined JSON search result.
    wprintf(L"------------------------------------------------------------------\n");
    wprintf(L"Combined Search Results:\n");
    wprintf(L"%s\n",CkJsonObjectW_emit(jsonCombined));

    // Sample output for the above program:

    // ------------------------------------------------------------------
    // Searching /Inbox
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA')/messages(id,subject,from)",
    //   "value": [
    //     {
    //       "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AADOpwfr\"",
    //       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj10AAAA=",
    //       "subject": "A sample email with Amazon in the body",
    //       "from": {
    //         "emailAddress": {
    //           "name": "Chilkat Software",
    //           "address": "support@chilkatsoft.com"
    //         }
    //       }
    //     }
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Searching /Inbox/xyz
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwEAAAA%3D')/messages(id,subject,from)",
    //   "value": [
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Searching /Inbox/abc/subFolderA/a
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwIAAAA%3D')/messages(id,subject,from)",
    //   "value": [
    //     {
    //       "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AADOpzfb\"",
    //       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwIAAADn68XtMop0TpsYJGpfKXY9AAAAzombFQAAAA==",
    //       "subject": "Sample email from admin@chilkat.io",
    //       "from": {
    //         "emailAddress": {
    //           "name": "Chilkat Software",
    //           "address": "admin@chilkat.io"
    //         }
    //       }
    //     }
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Searching /Inbox/abc
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAAA%3D')/messages(id,subject,from)",
    //   "value": [
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Searching /Inbox/abc/subFolderA
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwAAAQ%3D%3D')/messages(id,subject,from)",
    //   "value": [
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Searching /Inbox/abc/subFolderB
    // {
    //   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwMAAAA%3D')/messages(id,subject,from)",
    //   "value": [
    //   ]
    // }
    // 
    // ------------------------------------------------------------------
    // Combined Search Results:
    // {
    //   "value": [
    //     {
    //       "folderPath": "/Inbox",
    //       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAAM6Jj10AAAA=",
    //       "subject": "A sample email with Amazon in the body",
    //       "from": {
    //         "emailAddress": {
    //           "name": "Chilkat Software",
    //           "address": "support@chilkatsoft.com"
    //         }
    //       }
    //     },
    //     {
    //       "folderPath": "/Inbox/abc/subFolderA/a",
    //       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAL8huwIAAADn68XtMop0TpsYJGpfKXY9AAAAzombFQAAAA==",
    //       "subject": "Sample email from admin@chilkat.io",
    //       "from": {
    //         "emailAddress": {
    //           "name": "Chilkat Software",
    //           "address": "admin@chilkat.io"
    //         }
    //       }
    //     }
    //   ]
    // }
    // 


    CkHttpW_Dispose(http);
    CkXmlW_Dispose(xmlMap);
    CkJsonObjectW_Dispose(json);
    CkJsonObjectW_Dispose(jsonCombined);
    CkStringBuilderW_Dispose(sbResponse);
    CkStringBuilderW_Dispose(sbPath);

    }