{"id":9457,"date":"2022-02-10T11:09:08","date_gmt":"2022-02-10T19:09:08","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/?p=9457"},"modified":"2022-10-12T16:12:05","modified_gmt":"2022-10-12T23:12:05","slug":"microsoft-graph-mailbag-filter-search-driveitems-for-only-files","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/microsoft-graph-mailbag-filter-search-driveitems-for-only-files\/","title":{"rendered":"Microsoft Graph Mailbag – Search DriveItems for Only Files"},"content":{"rendered":"

In today\u2019s Microsoft Graph Mailbag post, we\u2019ll use the Microsoft Search APIs on Microsoft Graph to return only files\/documents.<\/p>\n

\"Microsoft<\/a><\/p>\n

Please be sure to follow this blog series using\u202fhttps:\/\/aka.ms\/MSGraphMailbag<\/a>\u202for with RSS using\u00a0https:\/\/devblogs.microsoft.com\/microsoft365dev\/tag\/MSGraphMailbag<\/a>.<\/p>\n

Introduction<\/h2>\n

Recently, I was reviewing questions on Microsoft Q&A. I found an interesting question on How to differentiate between folders and files<\/a>. The author asked how to use the Microsoft Search APIs on Microsoft Graph to search for only files\/documents from OneDrive or SharePoint. By default, when you specify entityType of “driveItem,” this will return files, folders, pages, and news. The following is a sample query from Microsoft Graph Explorer<\/a> to search for “driveItem” content.<\/p>\n

POST https:\/\/graph.microsoft.com\/v1.0\/search\/query<\/p>\n

\n
\n
{\r\n  \"requests\":[\r\n    {\r\n      \"entityTypes\":[\r\n        \"driveItem\"\r\n      ],\r\n      \"query\":{\r\n        \"queryString\":\"contoso\"\r\n      }\r\n    }\r\n  ]\r\n}<\/pre>\n<\/div>\n
I ran the above request in one my lab tenants. The following screenshot shows the sample output. Notice the first result is a site page.<\/p>\n
\"Screenshot<\/a><\/p>\n
Solution<\/h2>\n<\/div>\n
In order to filter for only files\/documents, you can add either of the following (ContentType or ContentTypeId) to the “queryString” property within the “query” element of your request.<\/p>\n
\"query\": {\r\n  \"queryString\": \"test document AND ContentType:Document<\/strong>\"\r\n}<\/pre>\n
or<\/p>\n
\"query\": {\r\n  \"queryString\": \"test document AND ContentTypeId:0x0101*<\/strong>\"\r\n}<\/pre>\n
I updated my sample query and re-ran in my lab tenant. Notice that the sample response now has fewer search hits, and the first result is now a file.<\/p>\n
\"Screenshot<\/a><\/p>\n
Here is one of the final sample queries for filtering for only files\/documents.<\/p>\n
POST https:\/\/graph.microsoft.com\/v1.0\/search\/query<\/p>\n
\n
\n
{\r\n  \"requests\":[\r\n    {\r\n      \"entityTypes\":[\r\n        \"driveItem\"\r\n      ],\r\n      \"query\":{\r\n        \"queryString\":\"contoso AND ContentType:Document\"\r\n      }\r\n    }\r\n  ]\r\n}<\/pre>\n<\/div>\n<\/div>\n
Conclusion<\/h2>\n
In this post we looked at the sample request to search for driveItems using the Microsoft Search APIs on Microsoft Graph. We then modified it to filter for only files\/documents. You can use similar modifications to filter for other types of content as needed. Hopefully this will save you time and give you inspiration on how you can adapt the standard sample requests to retrieve the data you need with Microsoft Graph.<\/p>\n
Today\u2019s post was written by\u00a0<\/span>Brian T. Jackett, Principal PM with the Microsoft Graph Customer and Partner Experience (CPx) team.\u202fYou can follow Brian on Twitter @BrianTJackett<\/a>.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
In today\u2019s Microsoft Graph Mailbag post, we\u2019ll use the Microsoft Search APIs on Microsoft Graph to return only files\/documents.<\/p>\n","protected":false},"author":73055,"featured_media":6135,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[210,153,17],"class_list":["post-9457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-graph","tag-files","tag-microsoft-search","tag-msgraphmailbag"],"acf":[],"blog_post_summary":"
In today\u2019s Microsoft Graph Mailbag post, we\u2019ll use the Microsoft Search APIs on Microsoft Graph to return only files\/documents.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/9457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/users\/73055"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/comments?post=9457"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/9457\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media\/6135"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media?parent=9457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=9457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=9457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}