Skip to main content
The Sharepoint plugin syncs data locally. Use corsair.sharepoint.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.
New to Corsair? See database operations, data synchronization, and multi-tenancy.

​
Files

Path: sharepoint.db.files.search 
const rows = await corsair.sharepoint.db.files.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
namestringequals, contains, startsWith, endsWith, in
serverRelativeUrlstringequals, contains, startsWith, endsWith, in
timeCreatedstringequals, contains, startsWith, endsWith, in
timeLastModifiedstringequals, contains, startsWith, endsWith, in
lengthstringequals, contains, startsWith, endsWith, in
majorVersionnumberequals, gt, gte, lt, lte, in
minorVersionnumberequals, gt, gte, lt, lte, in
checkOutTypenumberequals, gt, gte, lt, lte, in
eTagstringequals, contains, startsWith, endsWith, in
createdAtdateequals, before, after, between
modifiedAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Folders

Path: sharepoint.db.folders.search 
const rows = await corsair.sharepoint.db.folders.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
namestringequals, contains, startsWith, endsWith, in
serverRelativeUrlstringequals, contains, startsWith, endsWith, in
itemCountnumberequals, gt, gte, lt, lte, in
timeCreatedstringequals, contains, startsWith, endsWith, in
timeLastModifiedstringequals, contains, startsWith, endsWith, in
createdAtdateequals, before, after, between
modifiedAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Items

Path: sharepoint.db.items.search 
const rows = await corsair.sharepoint.db.items.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
listIdstringequals, contains, startsWith, endsWith, in
listTitlestringequals, contains, startsWith, endsWith, in
titlestringequals, contains, startsWith, endsWith, in
authorIdnumberequals, gt, gte, lt, lte, in
editorIdnumberequals, gt, gte, lt, lte, in
createdstringequals, contains, startsWith, endsWith, in
modifiedstringequals, contains, startsWith, endsWith, in
fileSystemObjectTypenumberequals, gt, gte, lt, lte, in
serverRedirectedEmbedUrlstringequals, contains, startsWith, endsWith, in
createdAtdateequals, before, after, between
modifiedAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Lists

Path: sharepoint.db.lists.search 
const rows = await corsair.sharepoint.db.lists.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
titlestringequals, contains, startsWith, endsWith, in
descriptionstringequals, contains, startsWith, endsWith, in
itemCountnumberequals, gt, gte, lt, lte, in
baseTypenumberequals, gt, gte, lt, lte, in
baseTemplatenumberequals, gt, gte, lt, lte, in
createdstringequals, contains, startsWith, endsWith, in
lastItemModifiedDatestringequals, contains, startsWith, endsWith, in
lastItemUserModifiedDatestringequals, contains, startsWith, endsWith, in
hiddenbooleanequals
serverRelativeUrlstringequals, contains, startsWith, endsWith, in
createdAtdateequals, before, after, between
modifiedAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Sites

Path: sharepoint.db.sites.search 
const rows = await corsair.sharepoint.db.sites.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
titlestringequals, contains, startsWith, endsWith, in
descriptionstringequals, contains, startsWith, endsWith, in
urlstringequals, contains, startsWith, endsWith, in
serverRelativeUrlstringequals, contains, startsWith, endsWith, in
createdstringequals, contains, startsWith, endsWith, in
lastItemUserModifiedDatestringequals, contains, startsWith, endsWith, in
webTemplatestringequals, contains, startsWith, endsWith, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Users

Path: sharepoint.db.users.search 
const rows = await corsair.sharepoint.db.users.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
loginNamestringequals, contains, startsWith, endsWith, in
emailstringequals, contains, startsWith, endsWith, in
titlestringequals, contains, startsWith, endsWith, in
principalTypenumberequals, gt, gte, lt, lte, in
isSiteAdminbooleanequals
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.