Save SharePoint People search result as csv file using javascript

http://spr.com/overcoming-office-365sharepoint-online-development-challenges-part-3-exporting-search-results-to-excel/

 

if(queryText == “”) // if you want to select all value have to specify *
queryText = “*”;

Results.url = _spPageContextInfo.webAbsoluteUrl
+ “/_api/search/query”
+ “?sourceId=’b09a7990-05ea-4af9-81ef-edfab16c4e31′”
+ “&querytext='” + queryText + “‘”
+ “&rowlimit=500”
+ “&selectproperties=’LastName,FirstName,JobTitle,Department,WorkPhone,WorkEmail,BaseOfficeLocation'”

 

SharePoint Search REST API overview
https://msdn.microsoft.com/en-us/library/office/jj163876.aspx

Retrieving query suggestions using the Search REST service
https://msdn.microsoft.com/en-us/library/office/dn194079.aspx

Using the SharePoint 2013 search Query APIs
https://msdn.microsoft.com/en-us/library/office/dn423226.aspx

http://www.sharepointblue.com/2015/03/sharepoint-2013-people-search-rest-call.html

https://blogs.msdn.microsoft.com/nadeemis/2012/08/24/sharepoint-2013-search-rest-api/

 

recursive function call : there is 500 max rowlimit both get and post query.

https://www.dsouzajoel.com/2016/02/10/get-all-sites-and-sub-sites-using-rest-api/

http://sharepoint.stackexchange.com/questions/90843/sharepoint-rest-api-call-with-more-than-500-rows

https://www.codeproject.com/articles/1033979/sharepoint-search-how-to-return-all-results

https://social.msdn.microsoft.com/Forums/expression/en-US/40cd83fc-26e5-4408-882c-27e94fd2860c/recursive-people-search-sharepoint-2013-search-rest-api?forum=sharepointdevelopment

https://social.technet.microsoft.com/Forums/en-US/3d21e373-d342-4d2a-b28a-944b65a4a794/how-to-write-fql-in-querytext-field-in-sharepoint-2013-search-rest-api?forum=sharepointsearch

http://stackoverflow.com/questions/37837193/recursive-people-search-sharepoint-2013-search-rest-api

 

https://blogs.msdn.microsoft.com/nadeemis/2012/08/24/sharepoint-2013-search-rest-api/

 

SharePoint Online : Working with People Search and User Profiles
https://social.technet.microsoft.com/wiki/contents/articles/25074.sharepoint-online-working-with-people-search-and-user-profiles.aspx

List of common SharePoint 2013 Result Source IDs

http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2013/01/04/list-of-common-sharepoint-2013-result-source-ids.aspx
Result Source ID
Documents e7ec8cee-ded8-43c9-beb5-436b54b31e84
Items matching a content type 5dc9f503-801e-4ced-8a2c-5d1237132419
Items matching a tag e1327b9c-2b8c-4b23-99c9-3730cb29c3f7
Items related to current user 48fec42e-4a92-48ce-8363-c2703a40e67d
Items with same keyword as this item 5c069288-1d17-454a-8ac6-9c642a065f48
Local People Results b09a7990-05ea-4af9-81ef-edfab16c4e31
Local Reports And Data Results 203fba36-2763-4060-9931-911ac8c0583b
Local SharePoint Results 8413cd39-2156-4e00-b54d-11efd9abdb89
Local Video Results 78b793ce-7956-4669-aa3b-451fc5defebf
Pages 5e34578e-4d08-4edc-8bf3-002acf3cdbcc
Pictures 38403c8c-3975-41a8-826e-717f2d41568a
Popular 97c71db1-58ce-4891-8b64-585bc2326c12
Recently changed items ba63bbae-fa9c-42c0-b027-9a878f16557c
Recommended Items ec675252-14fa-4fbe-84dd-8d098ed74181
Wiki 9479bf85-e257-4318-b5a8-81a180f5faa1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: