{"id":3555,"date":"2019-04-04T05:23:48","date_gmt":"2019-04-04T05:23:48","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=3555"},"modified":"2019-04-04T05:52:15","modified_gmt":"2019-04-04T05:52:15","slug":"fetching-data-based-on-date-field-using-webapi","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3555","title":{"rendered":"Fetching data based on date field using WebAPI"},"content":{"rendered":"

Introduction<\/strong>
\nAre you looking for sample code to fetch data from Dynamics 365 CE using WebAPI ? if yes this post will help. We are discussing how to fetch data based on the datetime field from account entity.<\/p>\n

Look for our other WebAPI Samples here<\/a><\/p>\n

Requirement<\/strong>
\nRetrieve accounts records which created on or before today’s date.<\/p>\n

Solution<\/strong>
\nWrite writing WebAPI request first thing make sure to check all the available filters that we can use in our WebAPI request, you can get full details of supported filters here<\/a>.<\/p>\n

Now our requirement is to compare data based on the current date, so first thing we need to get current data and format it correctly using libraries like Moment.js<\/strong> or you can write your own javascript code to format like following.<\/p>\n

\r\nfunction FormatDate() {\r\n    var today = new Date();\r\n    var month = today.getMonth() + 1; \/\/to use correct month, it will return 0 for jan\r\n    var day = today.getDate();\r\n    var year = today.getFullYear();\r\n    return month + "-" + day + "-" + year;\r\n}\r\n<\/pre>\n
Above function will get current date and will format it to “mm-dd-yyyy”, what we need to query Dynamics 365 CE. Now we can use it in our WebAPI request query. In following example I am going to query account entity record which is created today or before. I am counting total number of records, to count number of records we can use count<\/strong> option in our query.<\/p>\n
\r\nfunction retrieveAccounts() {\r\n   \r\n    var currentDate = FormatDate();\r\n    var entity = "accounts";\r\n    var columnSet = "?$select=name&$filter=createdon le '" + currentDate + "'&$count=true";\r\n    var serverURL = Xrm.Page.context.getClientUrl();\r\n    var Query = entity + columnSet;\r\n    var req = new XMLHttpRequest();\r\n    req.open("GET", serverURL + "\/api\/data\/v9.0\/" + Query, true);\r\n    req.setRequestHeader("Accept", "application\/json");\r\n    req.setRequestHeader("Content-Type", "application\/json; charset=utf-8");\r\n    req.setRequestHeader("OData-MaxVersion", "4.0");\r\n    req.setRequestHeader("OData-Version", "4.0");\r\n  \r\n    req.onreadystatechange = function() {\r\n        if (this.readyState == 4 \/* complete *\/ ) {\r\n            req.onreadystatechange = null;\r\n            if (this.status == 200) {\r\n                var data = JSON.parse(this.response);\r\n                if (data['@odata.count'] != null)\r\n                    alert("Total Records:"+ data['@odata.count']); \r\n            } else {\r\n                var error = JSON.parse(this.response).error;\r\n                alert(error.message);\r\n            }\r\n        }\r\n    };\r\n    req.send();\r\n}\r\n<\/pre>\n
Summary<\/strong>
\nWe learned how to format date using java script code and learned how to use formatted date in WebAPI request. You can use above code in your web resource and can do required changes.<\/p>\n
Hope it will help someone !!<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction Are you looking for sample code to fetch data from Dynamics 365 CE using WebAPI ? if yes this post will help. We are discussing how to fetch data based on the datetime field from account entity. Look for our other WebAPI Samples here Requirement Retrieve accounts records which created on or before today’s date. Solution Write writing WebAPI… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":3036,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[402],"tags":[702,700,698,699,701],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3555"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3555"}],"version-history":[{"count":6,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3555\/revisions"}],"predecessor-version":[{"id":3562,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3555\/revisions\/3562"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/3036"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}