{"id":14994,"date":"2019-03-08T12:03:50","date_gmt":"2019-03-08T12:03:50","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=14994"},"modified":"2021-12-06T14:56:48","modified_gmt":"2021-12-06T09:26:48","slug":"retrieve-dynamics-365-crm-data-in-portal-by-calling-odata-using-javascript","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/03\/retrieve-dynamics-365-crm-data-in-portal-by-calling-odata-using-javascript\/","title":{"rendered":"Retrieve Dynamics 365 CRM data in Portal by calling Odata using JavaScript"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

When user needs to display all the record using the \u201caccount\u201d entity on the portal page then he can perform the retrieve operation by calling OData query using JavaScript.<\/p>\n

Working<\/strong><\/h2>\n

First we will create the entity list. On the entity list there is tab \u201cOData\u201d where we need to fill the information like \u201cEntity Type Name\u201d, \u201cEntity Set Name\u201d, select the view and enable the Odata feed as shown in the below screenshot:<\/p>\n

\"Retrieve<\/p>\n

Based on above configuration system we will generate Odata Based URL as\u00a0https:\/\/<portalurl>\/_odata\/entity_set_name<\/strong>, now we can retrieve the data on other webpages as well as show in the below screenshot<\/p>\n

\"Retrieve<\/p>\n

Retrieve the data using Javascript:<\/strong><\/p>\n

We have created a button \u201cGet Accounts\u201d on the html as shown below in the screenshot.<\/p>\n

\"Retrieve<\/p>\n

On clicking the button we call the function retrieveAccount() JavaScript code shown below:<\/p>\n

function retreiveAccount () {<\/p>\n

var oDataUrl = “\/_odata\/AccountSet”;<\/p>\n

var response = getResponse(oDataUrl);<\/p>\n

var accounts = new Array();<\/p>\n

accounts.push([“Sr. No.”, “Name”]);<\/p>\n

if (response != null) {<\/p>\n

$.each(response, function (index, responseVal) {<\/p>\n

accounts.push([(index + 1), (responseVal.name.toString())]);<\/p>\n

});<\/p>\n

}<\/p>\n

\/\/Create a HTML Table element to show the data.<\/p>\n

var table = document.createElement(“TABLE”);<\/p>\n

table.border = “1”;<\/p>\n

\/\/Get the count of columns.<\/p>\n

var columnCount = accounts[0].length;<\/p>\n

\/\/Add the header row.<\/p>\n

var row = table.insertRow(-1);<\/p>\n

for (var i = 0; i < columnCount; i++) {<\/p>\n

var headerCell = document.createElement(“TH”);<\/p>\n

headerCell.innerHTML = accounts[0][i];<\/p>\n

row.appendChild(headerCell);<\/p>\n

}<\/p>\n

\/\/Add the data rows.<\/p>\n

for (var i = 1; i < accounts.length; i++) {<\/p>\n

row = table.insertRow(-1);<\/p>\n

for (var j = 0; j < columnCount; j++) {<\/p>\n

var cell = row.insertCell(-1);<\/p>\n

cell.innerHTML = accounts[i][j];<\/p>\n

}<\/p>\n

}<\/p>\n

var dvTable = document.getElementById(“dvTable”);<\/p>\n

dvTable.innerHTML = “”;<\/p>\n

dvTable.appendChild(table);<\/p>\n

}<\/p>\n

function getResponse(oDataUrl) {<\/p>\n

var response = null;<\/p>\n

$.ajax({<\/p>\n

type: “GET”,<\/p>\n

url: oDataUrl,<\/p>\n

dataType: “json”,<\/p>\n

async: false<\/p>\n

}).done(function (json) {<\/p>\n

response = json.value;<\/p>\n

});<\/p>\n

return response;<\/p>\n

}<\/p>\n

Now data can be shown on the website as shown below in the screenshot:<\/p>\n

\"Retrieve<\/p>\n

Conclusion<\/strong><\/h2>\n

User can perform the retrieve operation by calling OData query using JavaScript<\/p>\n

One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n

Get optimum visualization of Dynamics 365 CRM data with –<\/em>
\nKanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
\nMap My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction When user needs to display all the record using the \u201caccount\u201d entity on the portal page then he can perform the retrieve operation by calling OData query using JavaScript. Working First we will create the entity list. On the entity list there is tab \u201cOData\u201d where we need to fill the information like \u201cEntity\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":15002,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[33,37],"tags":[1162,1467],"class_list":["post-14994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-javascript","category-microsoft-portals","tag-microsoft-portal","tag-retrieve-dynamics-365-crm-data"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/14994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=14994"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/14994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/15002"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=14994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=14994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=14994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}