title: How to use filter in Microsoft Graph API to get SharePoint items?
body: <p>Here I am trying to filter data based on created date. At 1st I tried in Graph Explorer and it's working.</p>
  
  <pre><code>https://graph.microsoft.com/v1.0/me/messages?$filter=createdDateTime ge 2017-09-04&amp;$select=subject,lastModifiedDateTime
  </code></pre>
  
  <p>Now trying to implement same in Dell Boomi. This is resource path to pull all the items: <code>sites/{id}.sharepoint.com:/sites/{id}:/lists/{list_id}/items</code>
  it's working fine.</p>
  
  <p>After that I am adding filter condition:</p>
  
  <pre><code>sites/{id}.sharepoint.com:/sites/{id}:/lists/{list_id}/items?$filter=lastModifiedDateTime ge 2017-09-04&amp;$select=email,displayName
  </code></pre>
  
  <p>Here is getting error. This is the error message:</p>
  
  <pre><code>&lt;HTML&gt;&lt;HEAD&gt;&lt;TITLE&gt;Bad Request&lt;/TITLE&gt;
  &lt;META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"&gt;&lt;/HEAD&gt;
  &lt;BODY&gt;&lt;h2&gt;Bad Request&lt;/h2&gt;
  &lt;hr&gt;&lt;p&gt;HTTP Error 400. The request is badly formed.&lt;/p&gt;
  </code></pre>
  
  <p>Can some one help on this, how to fix this issue?
  Here is the Sample data.</p>
  
  <pre><code>&gt; {   "@odata.context":
  &gt; "https://graph.microsoft.com/v1.0/$metadata#Collection(microsoft.graph.list)(&amp;#39;1334af71-5b7a-4276-a8d8-c3f3f129051d&amp;#39;)/items",
  &gt; "value": [
  &gt;     {
  &gt;       "@odata.etag": "&amp;quot;ef6e961c-a956-400e-a77d-f044d2e0b894,8&amp;quot;",
  &gt;       "createdDateTime": "2018-05-24T13:38:10Z",
  &gt;       "eTag": "&amp;quot;ef6e961c-a956-400e-a77d-f044d2e0b894,8&amp;quot;",
  &gt;       "id": "3",
  &gt;       "lastModifiedDateTime": "2018-06-18T10:24:27Z",
  &gt;       "webUrl": "https://{id}.sharepoint.com/sites/{id}/Doc%20Interfaces/757391.pdf",
  &gt;       "createdBy": {
  &gt;         "user": {
  &gt;           "email": "abc@abc.COM",
  &gt;           "id": "173abc",
  &gt;           "displayName": "abc"
  &gt;         }
  &gt;       },
  &gt;       "lastModifiedBy": {
  &gt;         "user": {
  &gt;           "email": "xyz@abc.COM",
  &gt;           "id": "234xyz",
  &gt;           "displayName": "xyz"
  &gt;         }
  &gt;       },
  &gt;       "parentReference": {
  &gt;         "id": "03fe-16595a0da875"
  &gt;       },
  &gt;       "contentType": {
  &gt;         "id": "0x01"
  &gt;       },
  &gt;       "fields@odata.context": "https://graph.microsoft.com/v1.0/$metadata#Collection(microsoft.graph.list)(&amp;#39;1334f71-c3f3f129&amp;#39;)/items(&amp;#39;3&amp;#39;)/fields/$entity",
  &gt;       "fields": {
  &gt;         "@odata.etag": "&amp;quot;ef6e961-f044d2e0b894,8&amp;quot;",
  &gt;         "FileLeafRef": "757391.pdf",
  </code></pre>