Hi,
We can use this query to retrieve different teams and the users belonging to that team within Microsoft Dyanmics CRM
Select FT.name TeamName,FSU.Fullname UserName, FSU.Systemuserid from
dbo.FilteredSystemUser FSU
inner Join
dbo.FilteredTeamMembership FTM
on FSU.Systemuserid = FTM.Systemuserid
Inner join dbo.FilteredTeam FT
on FT.TeamID = FTM.TeamID
ORDER BY FT.NAME
Bye
Hi,
Well today i created a webservice which would fetch me some data from oracle database. The method signature was something like this
public DataSet getEmpInfo
{,,,,,,,,,,,,,}
I was calling this webservice within form’s onLoad inside the a custom entity of Microsoft Dyanmics CRM3,0.
I deployed it in my machine and when i was opening the my custom entity form inside CRM in my machine, i was able to see the values fetched using ajax calls to webservice.
But for other machines i was getting an internal server error for my ajax call.
Finally the error got resolved when i included this inside the web.config for my webservice
<webServices>
<protocols>
<add name=”HttpPost”/>
<add name=”HttpGet”/>
</protocols>
</webServices>
By the way, I was using POST in my xmlHttpRequest object Open method.
Plzz check out these links to better understand web services.
Configuration Options for XML Web Services Created Using ASP.NET
http://msdn2.microsoft.com/en-us/library/b2c0ew36(vs.80).aspx
How to: Disable Protocol Support for Web Services
http://msdn2.microsoft.com/en-us/library/9hdd3w8c(VS.80).aspx
Top Five ASP.NET Web Services Tips
http://www.ondotnet.com/pub/a/dotnet/2002/10/07/webservices.html
Bye
This is the code we can make use for calling ASP.NET webservice in form onLoad javascript event handler of our Entity in Microsoft CRM.
This example calls the simple Hello World service and assigns the value returned (i.e. “Hello World”) to a field in the entity form
xmlHttp=new ActiveXObject(“Microsoft.XMLHTTP”);
xmlHttp.open(‘post’, ‘http://localhost/WebService1/Service1.asmx/HelloWorld’, false);
xmlHttp.send();
var xmlDoc=xmlHttp.responseXML;
var responseElement=xmlDoc.getElementsByTagName(“string”)[0];
var exch=responseElement.firstChild.nodeValue;
crmForm.all.address1_name.DataValue=exch ;
return false;
Check this link for more information
https://nishantrana.wordpress.com/2007/10/18/calling-aspnet-webservice-from-javascript-ajax/
Bye
Hi,
Now we will modify the application that we developed in the previous post to work with POST parameter
We have changed the get to post as we are now not passing the value for Name by appending it in the url.
Only make changes to the function getMessage()
function getMessage()
{
var name=’Nishant’;
xmlHttp=new ActiveXObject(“Microsoft.XMLHTTP”);
xmlHttp.open(“POST“, “http://localhost/WebService1/Service1.asmx/HelloWorld”, true);
xmlHttp.onreadystatechange=doUpdate;
xmlHttp.setRequestHeader(“Content-Type”,”application/x-www-form-urlencoded”);
xmlHttp.send(“name=”+escape(name));
return false;
}
Let’s understand the changes that we have made
First of all we have change the method of passing data to POST from GET.
But still we need to pass the name’s value which our web service method needs.
For that we’ll modify our Send() method
xmlHttp.send(“name=”+escape(name));
We are using the same name/value pair in send() which we used at the end of the request URL in the GET version
escape()-It makes sure that the values are valid values i.e. no tricky characters are there.
But this is not enough that is why we added this line
xmlHttp.setRequestHeader(“Content-Type”,”application/x-www-form-urlencoded”);
Here the server doesn’t know what kind of data it can expect or is coming from our application.
We are making use of setRequestHeader function to tell the server about the content type we are going to send.
The server can get this information from request’s header that it recieves.
Content-Type -> Name of the header
application/x-www-form-urlencoded -> http://www.w3.org/TR/html4/interact/forms.html#h-17.13.4.1
Bye
Hi,
Now we will modify the application that we developed in the previous post to work with parameters
https://nishantrana.wordpress.com/2007/10/18/calling-aspnet-webservice-from-javascript-ajax/
1) First we will modify the default Hello World service to accept a parameter like this
[WebMethod]
public string HelloWorld(string Name)
{
return “Hello “+Name+”!”;
}
2) Add the html textbox control in the webform
<INPUT type=”text” id=”Info”>
3) Add the following in the body
<BODY onload=”getMessage()”>
4) Put the following script in our webpage.
<script language=”javascript”>
var xmlHttp;
function getMessage()
{
xmlHttp=new ActiveXObject(“Microsoft.XMLHTTP”);
xmlHttp.open(“get”, “http://localhost/WebService1/Service1.asmx/HelloWorld? name=’Nishant'”, true);
xmlHttp.onreadystatechange=doUpdate;
xmlHttp.send(); return false;
}
function doUpdate()
{
if(xmlHttp.readyState==4)
{
var xmlDoc=xmlHttp.responseXML;
var responseElement=xmlDoc.getElementsByTagName(“string”)[0];
var respText=responseElement.firstChild.nodeValue;
document.forms[0].elements[‘Info’].value=respText;
}
}
</script>
5) We have changed the method of passing the data to server from post to get as we are passing the value for Name by appending it in the url.
6) Right now if we run the application it will give us error as “object not found”.
7) The reason for the error is that we have to make our web service configured for get method.
8- We need to open web.config of our web service and add the following line inside system.web section
<webServices>
<protocols>
<add name=”HttpGet”/>
</protocols>
</webServices>
9) We need to build the service again
10) This time our application should work without any error.
Bye
Nishant Rana's Weblog 
