How to Retrieve Account data using Web Api in console application

(0) Share

Report

Posted on by Balaji Karpurapu

193

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Balaji Karpurapu 193 on at

Like (0)

Report

Hi Adrian Begovich,

thank you for response.

I want to use WebApi url not organization url

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi,

Please check below reference-

rajeevpentyala.com/.../

Was this reply helpful? Yes No
Balaji Karpurapu 193 on at

Like (0)

Report

Hi Goutam Das

thank you for response, We are using On-Premise environment

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

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);
}

}
}
}

Was this reply helpful? Yes No