Third Party Integration with CampusNexus CRM Through OData

Third party integration (with Microsoft Excel or Power BI) with CampusNexus CRM through OData can be accomplished using basic authentication.

In the request header, set the authorization header to basic authentication as indicated in the following example:

Authorization:Basic dGFsaXNtYWFkbWluOnRhbGlzbWE=

This example is a Base64encoded version of <Username>:<Password>.

The following image illustrates the selection of the Basic option when Microsoft Excel is integrated to extract information from CampusNexus CRM through OData:

Note

•   The basic authentication framework is not supported for users with custom security settings in Business Administrator.

•   If you are using CRM OData queries through third-party integration, it’s recommended to use separate (dedicated) user credentials in the third-party application (MS Excel or Power BI. If you use your Web Client credentials, you may be logged off from Web Client when the OData query is executed in MS Excel or Power BI.