SP List Ajax call web service return value assign to SP list textbox

Question

SP List Ajax call web service return value assign to SP list textbox

Shri Shankran 1

Test help ajax call web service to assign return value into Textbox

ZhengyuGuo 10,591 Reputation points Moderator

2020-08-18T06:25:07.86+00:00

Hi @Shri Shankran ,

Do you want to use SharePoint Rest API to get a item field value and place the value into a Textbox within List New/Edit form ?

Please explain more details so that we can know about your requirement more clearly :)
Shri Shankran 1 Reputation point

2020-08-18T16:07:33.917+00:00

Thank you. I get access denied if I add any code. it looks like new forum error. Basically I auto populate textfield via ajax call from EmployeeList. which is working fine. I am then calling getcountofemployee() but calling another web service ajax call here under SELECT section. The error I get: Access to XMLHttpRequest at http:// from origin has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
Shri Shankran 1 Reputation point

2020-08-18T16:10:21.65+00:00
Shri Shankran 1 Reputation point

2020-08-18T16:13:02.327+00:00

can you assist me where getCountEmployees() ajax. All I need is to print the total number of array the web service above returns <employee>...<employee><employee>...<employee><employee>...<employee> etc. for 3 employees. I want to print 3 in the textbox

2 answers

Your answer

ZhengyuGuo 10,591 Reputation points Moderator

2020-08-18T06:25:07.86+00:00

Hi @Shri Shankran ,

Do you want to use SharePoint Rest API to get a item field value and place the value into a Textbox within List New/Edit form ?

Please explain more details so that we can know about your requirement more clearly :)
Shri Shankran 1 Reputation point

2020-08-18T16:07:33.917+00:00

Thank you. I get access denied if I add any code. it looks like new forum error. Basically I auto populate textfield via ajax call from EmployeeList. which is working fine. I am then calling getcountofemployee() but calling another web service ajax call here under SELECT section. The error I get: Access to XMLHttpRequest at http:// from origin has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
Shri Shankran 1 Reputation point

2020-08-18T16:10:21.65+00:00
Shri Shankran 1 Reputation point

2020-08-18T16:13:02.327+00:00

can you assist me where getCountEmployees() ajax. All I need is to print the total number of array the web service above returns <employee>...<employee><employee>...<employee><employee>...<employee> etc. for 3 employees. I want to print 3 in the textbox

Answer 1

ZhengyuGuo 10,591 Moderator

Hi @Shri Shankran ,

Per my understanding, "http://services.myportal.com/employee/advisees" should be an external domain custom web service which is outside SharePoint Online.

Then it's necessary to add Access-Control-Allow-Origin header in your custom web service, for example here is a demo to add custom header in .NET Web API Web.Conig:

Access-Control-Allow-Origin Header and the ASP.NET Web API

SharePoint CORS fix

Here is a similiar question for your reference:

AJAX POST REST call generates CORS error

If the response is helpful, please click "Accept Answer" and upvote it.

Shri-6058 326 Reputation points

2020-08-19T07:17:39.327+00:00

There is another approach I did it for autopopulate field is just working on the same list without any CORS configurations or no change. Here is the code. Is there a way modifying this to just count the total array from this script?

Answer 2

ZhengyuGuo 10,591 Moderator

Hi @ShridharHegde-2034,

The total count of array data can be got from the data in function(data), you can try to log it to browser Developer Tool using console.log(data) so that it's available to
check the detailed struct for data object.

It should be data.d.results.length similar as SharePoint Rest API. (maybe no d/results in data object as it's a custom web service)

In additional, I found your account is different with the account which post the original question, you can switch to the original account rather than use another account to response ther reply.

If the response is helpful, please click "Accept Answer" and upvote it.

Shri-6058 326 Reputation points

2020-08-20T04:44:35.92+00:00

Thank you. I am having difficult time with Microsoft new forum as any special characters or code results in access denied. I am trying to upload image, text etc.
The old forum was very quick and easy to post and manage items.

I tried various technics such as assigning the success and fail to associate textbox value and its always returns error block shows net::ERR_FAILED the textbox shows [object object]
Shri-6058 326 Reputation points

2020-08-20T04:45:20.31+00:00

Is there an html local file I can build textbox and assign web service api value? any reference?

Thanks
ZhengyuGuo 10,591 Reputation points Moderator

2020-08-20T05:55:05.85+00:00

Hi @ShridharHegde-2034,

If you can get the array data in the code snippet above, then you can get the total count using array.length, here is a sample for your reference:

How do I get the total Json record count using JQuery?

And can you please switch to the forum account the same as original question's, so that it could be clear for others :)

Share via

SP List Ajax call web service return value assign to SP list textbox

2 answers

Your answer