How REST service endpoint will be available for SOA service

Kartik Mody

11y1.3k

Hi,

I have refered following url for REST service endpoint available in SharePoint 2013

https://msdn.microsoft.com/en-us/library/office/dn292556.aspx , So I have technical query how SOA service will access this endpoint services?

Fetching list items

To fetch list items, just append /items() to the previous url :

Type

http://servername/_api/web/lists/getbytitle(‘Products’)/items()

SOA service can consume following url to add data to SharePoint 2013 list? OR in SharePoint we will have to add any custom service to expose below mention url for SOA?

http://servername/_api/web/lists/getbytitle('name%20of%20List')/items?$para%Name1='1',$Varchar%20No='s3SS2'

With Method="Post" SOA can push data to list? kindly confirm and please assist me suitably.Thanks Kartik cell +91 9987072052 or +91 9987521326

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kartik Mody11y ago
Hi Priyan, tried to reach you but your number was ringing. If possible could you please confirm your availability, so I can call you again?
Kartik Mody11y ago
Thanks a lot for help!I will call you tomorrow at 11:30am.:)
Priyaranjan K S11y ago
Karthik,

Please have a look at this .
http://www.c-sharpcorner.com/UploadFile/Roji.Joy/working-with-sharepoint-2013-rest-api-in-a-C-Sharp-managed-code/

This is a solution to communicate with SharePoint which can be used irrespective of the platform you are in . It creates an HTTP request using the REST URL . Make Sure you have the right credentials in the code . More over you don't need any SharePoint specific DLLs or references .
By all means 401 was due tocredentials that do not have adequate rights to access the SharePoint List . Please see if this fits in your requirement . Else contact me on my number so that I can know more about the situation .
HttpWebRequest endpointRequest = (HttpWebRequest)HttpWebRequest.Create("Site URL/_api/web/lists/getByTitle(List Name')/items");
endpointRequest.Method = "GET";
endpointRequest.Accept = "application/json;odata=verbose";
NetworkCredential cred = new System.Net.NetworkCredential("username", "password", "domain");
endpointRequest.Credentials = cred;
HttpWebResponse endpointResponse = (HttpWebResponse)endpointRequest.GetResponse();
try
{
WebResponse webResponse = endpointRequest.GetResponse();
Stream webStream = webResponse.GetResponseStream();
StreamReader responseReader = new StreamReader(webStream);
string response = responseReader.ReadToEnd();
JObject jobj = JObject.Parse(response);
JArray jarr = (JArray)jobj["d"]["results"];
foreach (JObject j in jarr)
{
Console.WriteLine(j["Title"]+" "+j["Body"]);
}
If you found this useful please mark this as answer
Priyaranjan K S11y ago
I will ping you my number . You can reach out to me tomorrow . I will try to help out .

Thanks,
Priyan
Kartik Mody11y ago
Sure, Priyan.

SOA service will have business rules and it will validate data comes from other CRM application.So SOA service will call sharepoint REST endpoints to add informations to SharePoint list.

If possible please share your contact number else you could call me on my cell :+91 9987072052, so I can able discuss with on solution aspect.

Thank you!
Priyaranjan K S11y ago
Kartik, Can you briefly explain the requirement and what kind of SOA service is used and how it is invoked ?
Kartik Mody11y ago
Thanks Priyan for reply.

Actually REST service endpoint will be access by SOA service to add data to SharePoint list.

So REST service endpoint same you have mentioned in your example is enough?

Please confirm I don't have to create any additional service apart from out-of-box REST service endpoints.

Also, accessible this endpoint url through SOAP UI we are getting an error "Error code 401:unauthorized" message. So please help to resolve this issue also. Thanks once again.

Thanks!!
Priyaranjan K S11y ago
Hi Kartik ,

You can make an ajax call using the REST endpoint URL . Say if you are calling this from within a Sharepoint App the code to get list items will look like :

$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + endpointurl,
type: "GET",
headers: {
"accept": "application/json;odata=verbose",
},
success: function (data) {
console.log(data.d.results);
},
error: function (error) {
alert(JSON.stringify(error));
}
});

here _spPageContextInfo.webAbsoluteUrl gets the server relative url and endpointurl will be "/_api/Web/Lists/GetByTitle('ListName')/Items"

Similary if you want to update a list item you can use the POST method .

Thanks
Priyan

If you found this useful please mark this as answer