I got alert message when I click ‘Open with explorer’  such as

We’re having a problem opening this location in File Explorer, Add this web site to your Trusted sites list and try again

Check list

  1. Add the site as Trusted sites from internet options/Security
  2. Desktop experience feature install from Service Manager
  3. Run web client service from services

Reference )

We’re having a problem opening this location in File Explorer, Add this web site to your Trusted sites list and try again

Only basic OData query operators supported in the SharePoint Rest service

https://msdn.microsoft.com/en-us/library/office/fp142385.aspx#bk_supported

String Comparisions (startWith, substringof, Eq, Ne)

 

Full OData Query option from odata.org

http://www.odata.org/documentation/odata-version-2-0/uri-conventions/#FilterSystemQueryOption

 

SharePoint REST API Supporting keywords – OData query URL

SharePoint REST API Supporting keywords – OData query URL

http://www.andrewconnell.com/blog/Applying-Filters-to-Lookup-Fields-with-the-SP2013-REST-API

 

-When you filter user object field you can filter without id postfix.

when you select the user field(Created by)

you can use $select=AuthorId

but you can’t use $filter=AuthorId eq 10

instead of you can use $filter=Author eq 10 without Id postfix.

or you can use $expand option

However there is no way to check user field is null or empty with OData query

Query for multi-value lookup fields and users

: Because multi-value lookup fields are returned as a string of multiple values, there is no way to query for them (for example, the equivalent of an Includes element or NotIncludes element is not supported).

So we have to use Rest Caml query

https://<site>/_api/web/Lists/GetByTitle(‘%5Blist name]’)/GetItems(query=@v1)?@v1={“ViewXml”:”<View><Query>[other CAML query elements]</Query></View>”}

 

 

 

 

 

 

normally I use..

_spPageContextInfo.siteAbsoluteUrl

_spPageContextInfo.webAbsoluteUrl

_spPageContextInfo.userId

 

 

Name

SP2010

SP2013

Example Value

currentLanguage

X

X

1033

pageItemId

X

X

1

pageListId

X

X

Guid

webLanguage

X

X

1033

webServerRelativeUrl

X

X

/

webUIVersion

X

X

4 or 15

alertsEnabled

X

X

False

allowSilverlightPrompt

X

X

False

userId

X

X

9

clientServerTimeDelta

X

Time

crossDomainPhotosEnabled

X

False

currentCultureName

X

en-US

currentUICultureName

X

en-US

layoutsUrl

X

_layouts/15

pagePersonalizationScope

X

1

serverRequestPath

X

/SitePages/Home.aspx

siteAbsoluteUrl

X

http://sp

siteClientTag

X

0$$15.0.4420.1017

siteServerRelativeUrl

X

/

systemUserKey

X

1:0).w|<sid>

tenantAppVersion

X

0

webAbsoluteUrl

X

http://sp

webTemplate

X

1

webLogoUrl

X

_layouts/15/images/siteicon.png

webPermMasks

X

Object with properties
High & Low

webTitle

X

Test

 

from http://rambabuinsharepoint.blogspot.com.au/2015/11/sppagecontextinfo-properties-in.html

 

https://your_sp_site.sharepoint.com/_api/web/lists/getByTitle(‘Test&#8217;)/breakroleinheritance(copyRoleAssignments=true, clearSubscopes=true)
https://your_sp_site.sharepoint.com/_api/web/lists/getByTitle(‘Test&#8217;)/roleassignments/addroleassignment(principalid=20,roleDefId=1073741828)

 

Reference from :

http://spsite.pro/Blog/Post/3/SharePoint-2013-REST-API-%E2%80%93-How-to-set-Unique-Permissions-(Item-Level-Permissions)#disqus_thread

http://sharepoint.stackexchange.com/questions/113317/manage-file-permissions-using-rest-api

https://msdn.microsoft.com/en-us/library/office/dn495392.aspx

 

If the current user who run the javascript has site owner permission the ‘created by’ filed can be changed when you create item or update item in the SharePoint list.

However the user has only contribute permission, the field would not be changed even though you specify the ‘author’ field.

I just tested using CSOM Javascript on SharePoint 2013 so next time I will test using Restful Javascript.

var userIDnumber = you have to get the specific user id;

oListItem.set_item(‘Author’, userIDnumber );