187
I have requirement to retrieve account records by using webapi filter condition (Filter condition should have more than one value).
Can you please help me on how to connect CRM from console application using WebApi. Please share any sample working code
Thanks
*This post is locked for comments
Hi Balaji ,
Below code is working for me , try with this -
using System;
using System.Net;
using System.Net.Http;
namespace CRMConnectionTestProject
{
class WebAPI
{
static void Main(string[] args)
{
string _userName = "goutam"; // Replace User Name
string _passWord = "*****"; //Replace password
string _domain = "*****"; // Replace domain name
HttpClient client = new HttpClient(new HttpClientHandler() { Credentials = new NetworkCredential(_userName, _passWord, _domain) });
client.BaseAddress = new Uri("http://XXX.XX.XX.X/TEST" ); // Put organization URL here
client.Timeout = new TimeSpan(0, 2, 0);
HttpRequestMessage request = null;
try
{
//Here you need to put web api URL
request = new HttpRequestMessage(HttpMethod.Get, new Uri("http: // XXX.XX.XX.X/.../accounts?$select=name ");
var response = client.SendAsync(request, HttpCompletionOption.ResponseContentRead).Result;
if (response.IsSuccessStatusCode)
{
var accountInfoJson = response.Content.ReadAsStringAsync(); // You will get the JSON result here
}
else
{
throw new Exception("An error occured.");
}
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
}
Hi Goutam Das
thank you for response, We are using On-Premise environment
Hi,
Please refer below samples from documentation. As suggested above, you first need to authenticate and then query data. The documentation has some other basic concepts as well.
docs.microsoft.com/.../query-data-csharp
Hope this helps.
Hi Adrian Begovich,
thank you for response.
I want to use WebApi url not organization url
Hi Balaji Karpurapu,
Start by connecting to your Dynamics CRM instance using a C# Console Application. You will be able to retrieve data from the Account entity once you have connected to your instance. This article explains how to achieve this.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
