In recent days Node Js becoming quite popular. Different kind of portals and applications are made on Node Js technology because of it’s performance and efficiency.
So it’s becoming important to integrated Dynamics CRM 365 with node JS.
In this blog I will try to explain how we can integrate Dynamics 365 to Node Js with help of Azure Apps.
After
creating azure app we can integrate Dynamics 365 with our other products also.
There are two kind of Azure App which can be used for integration.
1. Native App
2. Web App/ API Application
We can use Both type of application in
integration. But the major difference is:-
integration. But the major difference is:-
1. We need to use User name and
Password while integrate via Native APP.
Password while integrate via Native APP.
2. We need to use secret key and
application user while integrate via Web App /API APP.
application user while integrate via Web App /API APP.
Native APP Integration:-
1. Login in Azure with admin permission
2. Click on “Azure Active Directory”
3. You will find two App registration
a) App Registrations.
b) App Registrations(Legacy)
For more information visit:
4. Click on App registration not
Legacy.
Legacy.
5. Here we will find “Owned
applications” and “All applications”, where we can see all registered Apps.
applications” and “All applications”, where we can see all registered Apps.
6. Click
on “New registration” and select below options.
Click
on “Register” button.
7. Copy
and Save Application (client) ID for further use.
8. Click
on Authentication and made below changes and save.
9. Click
on API permission and add Dynamics CRM Online.
10. Grant
admin consent
11. Go
back to App registration and select Endpoints.
and copy Token endpoint(v1)
If
you still want to create Legacy APP, select App registration(Legacy)
1. Provide
information and select Application Type as “Native”.
2. Copy
Application ID to use as Client Id while integration.
3. Click
on settings and select “Required Permissions”.
4. Add
Dynamics CRM Online in permission.
We
can also use Web App /API APP for Integration
1. With new App you can use same App for Native and Web API as both.
2. Go to Authentication and provide Type as Web.
3. Add
secret Key and create Application User .
Copy
and Save secret key for further use.
1. (Web
App with Legacy App Registration) Provide information and select Application
Type “Web App/ API”.
2. Click
on settings and select “Key”.
on settings and select “Key”.
We can choose one of four (Legacy Native App, Legacy Web App, New Native App, New Web App)
for integration.
Now
our App ready to integrate for other product like Node.Js
1. To
test application Node.js online, open
and paste below code. Update organization and
application information in Code.
//Use Below Sample Code started For Native App Integration Testing
‘use strict’;
var https = require(‘https’);
//set these values to retrieve the oauth token
var crmorg = ‘https://CRMORG.crm8.dynamics.com’;
//Application ID
var clientid = ‘Application ID’;
var username = ‘User Name’;
var userpassword = ‘Password‘;
var tokenendpoint = ‘Pasted copied Endpoint’;
var crmwebapihost = ‘ CRMORG.api.crm8.dynamics.com’;
var crmwebapipath = ‘/api/data/v9.1/contacts’;
//basic query to select contacts
//basic query to select contacts
//remove https from tokenendpoint url
tokenendpoint =
tokenendpoint.toLowerCase().replace(‘https://’, ”);
tokenendpoint.toLowerCase().replace(‘https://’, ”);
//get the authorization endpoint host name
var authhost = tokenendpoint.split(‘/’)[0];
//get the authorization endpoint path
var authpath = ‘/’ +
tokenendpoint.split(‘/’).slice(1).join(‘/’);
tokenendpoint.split(‘/’).slice(1).join(‘/’);
//build the authorization request
var reqstring = ‘client_id=’ + clientid;
reqstring += ‘&resource=’ + encodeURIComponent(crmorg);
reqstring += ‘&username=’ +
encodeURIComponent(username);
encodeURIComponent(username);
reqstring += ‘&password=’ +
encodeURIComponent(userpassword);
encodeURIComponent(userpassword);
reqstring += ‘&grant_type=password’;
//set the token request parameters
var tokenrequestoptions = {
host:
authhost,
authhost,
path:
authpath,
authpath,
method:
‘POST’,
‘POST’,
headers: {
‘Content-Type’: ‘application/x-www-form-urlencoded’,
‘Content-Length’: Buffer.byteLength(reqstring)
}
};
//make the token request
var tokenrequest = https.request(tokenrequestoptions,
function (response) {
function (response) {
//make an
array to hold the response parts if we get multiple parts
array to hold the response parts if we get multiple parts
var
responseparts = [];
responseparts = [];
response.setEncoding(‘utf8’);
response.on(‘data’, function (chunk) {
//add
each response chunk to the responseparts array for later
each response chunk to the responseparts array for later
responseparts.push(chunk);
});
response.on(‘end’, function () {
//once
we have all the response parts, concatenate the parts into a single string
we have all the response parts, concatenate the parts into a single string
var
completeresponse = responseparts.join(”);
completeresponse = responseparts.join(”);
//console.log(‘Response: ‘ +
completeresponse);
completeresponse);
console.log(‘Token response retrieved . . . ‘);
//parse
the response JSON
the response JSON
var
tokenresponse = JSON.parse(completeresponse);
tokenresponse = JSON.parse(completeresponse);
//extract the token
var
token = tokenresponse.access_token;
token = tokenresponse.access_token;
//pass
the token to our data retrieval function
the token to our data retrieval function
getData(token);
});
});
tokenrequest.on(‘error’, function (e) {
console.error(e);
});
//post the token request data
tokenrequest.write(reqstring);
//close the token request
tokenrequest.end();
function getData(token) {
//set the
web api request headers
web api request headers
var
requestheaders = {
requestheaders = {
‘Authorization’: ‘Bearer ‘ + token,
‘OData-MaxVersion’: ‘4.0’,
‘OData-Version’: ‘4.0’,
‘Accept’: ‘application/json’,
‘Content-Type’: ‘application/json; odata.metadata=minimal’,
‘Prefer’: ‘odata.maxpagesize=500’,
‘Prefer’: ‘odata.include-annotations=*’
};
//set the
crm request parameters
crm request parameters
var crmrequestoptions
= {
= {
host:
crmwebapihost,
crmwebapihost,
path:
crmwebapipath,
crmwebapipath,
method:
‘Get’,
‘Get’,
headers: requestheaders,
};
//make the
web api request
web api request
var
crmrequest = https.request(crmrequestoptions, function (response) {
crmrequest = https.request(crmrequestoptions, function (response) {
//make
an array to hold the response parts if we get multiple parts
an array to hold the response parts if we get multiple parts
var
responseparts = [];
responseparts = [];
response.setEncoding(‘utf8’);
response.on(‘data’, function (chunk) {
//add each response chunk to the responseparts array for later
responseparts.push(chunk);
});
response.on(‘end’, function () {
//once we have all the response parts, concatenate the parts into a
single string
var
completeresponse = responseparts.join(”);
completeresponse = responseparts.join(”);
//
console.log(completeresponse);
console.log(completeresponse);
//parse the response JSON
var
collection = JSON.parse(completeresponse).value;
collection = JSON.parse(completeresponse).value;
collection.forEach(function (row, i) {
console.log(row[‘fullname’]);
});
//loop through the results and write out the fullname
});
});
crmrequest.on(‘error’, function (e) {
console.error(e);
});
//close the
web api request
web api request
crmrequest.end();
}
//Use Below Sample Code started For WEB App Integration Testing
‘use strict’;
var https = require(‘https’);
//set these values to retrieve the oauth
token
token
var crmorg = ‘https://CRMORG.crm8.dynamics.com’;
//Application ID
var clientid = ‘Application/Client ID’;
var Client_secret = ‘Copied Key’;
var tokenendpoint = ‘Copied endpoint’;
//set these values to query your crm data
var crmwebapihost = ‘CRMorg.api.crm8.dynamics.com’;
var crmwebapipath =
‘/api/data/v9.1/contacts’; //basic query to select contacts
‘/api/data/v9.1/contacts’; //basic query to select contacts
//remove https from tokenendpoint url
tokenendpoint =
tokenendpoint.toLowerCase().replace(‘https://’, ”);
tokenendpoint.toLowerCase().replace(‘https://’, ”);
//get the authorization endpoint host name
var authhost = tokenendpoint.split(‘/’)[0];
//get the authorization endpoint path
var authpath = ‘/’ + tokenendpoint.split(‘/’).slice(1).join(‘/’);
//build the authorization request
//if you want to learn more about how
tokens work, see IETF RFC 6749 – https://tools.ietf.org/html/rfc6749
tokens work, see IETF RFC 6749 – https://tools.ietf.org/html/rfc6749
var reqstring = ‘client_id=’ + clientid;
reqstring += ‘&resource=’ +
encodeURIComponent(crmorg);
encodeURIComponent(crmorg);
reqstring += ‘&client_secret=’ +
Client_secret;
Client_secret;
reqstring +=
‘&grant_type=client_credentials’;
‘&grant_type=client_credentials’;
//set the token request parameters
var tokenrequestoptions = {
host: authhost,
path: authpath,
method: ‘POST’,
headers: {
‘Content-Type’: ‘application/x-www-form-urlencoded’,
‘Content-Length’: Buffer.byteLength(reqstring)
}
};
//make the token request
var tokenrequest =
https.request(tokenrequestoptions, function (response) {
https.request(tokenrequestoptions, function (response) {
//make an array to hold the response parts if we get multiple parts
var responseparts = [];
response.setEncoding(‘utf8’);
response.on(‘data’, function (chunk) {
//add each response chunk to the responseparts array for later
responseparts.push(chunk);
});
response.on(‘end’,
function () {
function () {
//once we have all the response parts, concatenate the parts into a
single string
var completeresponse = responseparts.join(”);
//console.log(‘Response: ‘ + completeresponse);
console.log(‘Token response retrieved . . . ‘);
//parse the response JSON
var tokenresponse = JSON.parse(completeresponse);
//extract the token
var token = tokenresponse.access_token;
console.log(token);
//pass the token to our data retrieval function
getData(token);
});
});
tokenrequest.on(‘error’, function (e) {
console.error(e);
});
//post the token request data
tokenrequest.write(reqstring);
//close the token request
tokenrequest.end();
function getData(token) {
//set the web api request headers
var requestheaders = {
‘Authorization’: ‘Bearer ‘ + token,
‘OData-MaxVersion’: ‘4.0’,
‘OData-Version’: ‘4.0’,
‘Accept’: ‘application/json’,
‘Content-Type’: ‘application/json; odata.metadata=minimal’,
‘Prefer’: ‘odata.maxpagesize=500’,
‘Prefer’: ‘odata.include-annotations=*’
};
//set the crm request parameters
var crmrequestoptions = {
host: crmwebapihost,
path: crmwebapipath,
method: ‘Get’,
headers: requestheaders,
};
//make the web api request
var crmrequest = https.request(crmrequestoptions, function (response) {
//make an array to hold the response parts if we get multiple parts
var responseparts = [];
response.setEncoding(‘utf8’);
response.on(‘data’, function (chunk) {
//add each response chunk to the responseparts array for later
responseparts.push(chunk);
});
response.on(‘end’, function () {
//once we have all the response parts, concatenate the parts into a
single string
var completeresponse = responseparts.join(”);
// console.log(completeresponse);
//parse the response JSON
var collection = JSON.parse(completeresponse).value;
collection.forEach(function (row, i) {
console.log(row[‘fullname’]);
});
//loop through the results and write out the fullname
});
});
crmrequest.on(‘error’, function (e) {
console.error(e);
});
//close the web api request
crmrequest.end();
}
For Fetch query use below code
var fetchQuery = “encoded fetch query”;
var crmwebapipath =
‘/api/data/v9.1/dynamicproperties?fetchXml=’ + fetchQuery;
‘/api/data/v9.1/dynamicproperties?fetchXml=’ + fetchQuery;