Regarding JavaScript with SharePoint 2019 on premise REST API

Question

I use a JavaScript with REST APIs to access backend List for specific purpose to do some limitations in Personal Site. It turns out different result between my Lab with testing environment. I list out my code as the shown below:

There are somewhat different between two environments: 1. Lab - Standalone Machine; 2. Testing - 1* WFE plus 1* Application with WFE;

var raJsEnableOrDisableUrl = _PersonalSiteHostUrl + "/_api/web/lists/getbytitle('PS Configuration')/items?$select=sp_Value&$filter=Title eq 'PS_OD_VERIFY_USER_STATUS'"

and

Testing Environment:

if (_dataJsEnableOrDisable.results[0].sp_Value === "1") -> the sp_Value should be 1 or 0, but <results> length is always 0. That means I cannot get anything from my List.

My Lab : work properly and get 1 record from the List.

Is there anything missing?? or Is environment issue??

js: https://1drv.ms/t/s!AitVMPLIZ4qBigtoN7ocYz6t59lH?e=dC01fA

Answer 1

I suggest you add "async: false" attribute to GetPersonalSiteHostUrl function, otherwise _PersonalSiteHostUrl will be " " when executed.
And when I use _PersonalSiteHostUrl = data.d.PersonalSiteHostUrl , the code report error ,I change it to _PersonalSiteHostUrl = data.d.PersonalUrl.
No matter which one you use, the Url ends with “/”，

you should modify the part of the code you used to splice the URL.

var raJsEnableOrDisableUrl = _PersonalSiteHostUrl + "_api/web/lists/getbytitle('PS Configuration')/items?$select=sp_Value&$filter=Title eq 'PS_OD_VERIFY_USER_STATUS'";  
    var raJsSCAdminsUrl = _PersonalSiteHostUrl + "_api/web/lists/getbytitle('PS Configuration')/items?$select=sp_Value&$filter=Title eq 'PS_SC_Admins'";  

After I made the above changes to the code and created the corresponding list, it ran successfully.

Full code for your reference:45102-code.txt
You could use developer tool to debug the code, then you will understand the code running sequence and potential errors, which can help you write better code.
Debug JavaScript in Chrome

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.