SharePoint Search API not returning results - Getting "ERROR" - SharePoint online

Copper Contributor

I am getting Search Error when I try to execute search API with "SelectProperties" more than 100 properties. This behavior is only in SharePoint online and experiencing this issue all of sudden. If I try to make search with limited "selectproperties" (below 100) I am getting values.

 

Error: {"error":{"code":"-1, Microsoft.Office.Server.Search.REST.SearchServiceException","message":{"lang":"en-US","value":"We didn't understand your search terms. Make sure they're using proper syntax."}}}

 

Anyone facing this issue?

 

Here is the my sample search API:

{~/_api/search/query?querytext='(Filename:pdf)'&trimduplicates=false&enablefql=false&rowlimit=200&selectproperties='Path,LastModifiedTime,Title,Filename,OriginalPath,ContentType,DefaultEncodingURL,AboutMe,Account,AccountName,acronym,acronymaggre,acronymexpansion,acronymexpansionaggre,AssignedTo,AttachmentDescription,AttachmentType,AttachmentURI,Author,AuthorOWSUSER,AverageRating,BaseOfficeLocation,BasicScope,BodyOWSMTXT,CCAMetadata,charset,CollapsingStatus,CombinedName,CommunityMembersCount,CommunityRepliesCount,CommunityTopicsCount,companies,contentclass,ContentSource,ContentTypeId,Created,CreatedBy,CreatedOWSDATE,deeplinks,def,defaggre,definitioncontent,definitioncontentaggre,Department,Description,DetectedLanguage,DiscoveredTime,DiscussionBestAnswerID,DiscussionCategory,DiscussionLastUpdatedOWSDATE,DiscussionLikesCount,DiscussionPost,DisplayAuthor,DisplayDate,DMSDocAccessRight,DMSDocAuthor,DMSDocTitle,DMSLeaseTerm,docaclmeta,DocId,docrank,DocSubject,DocumentSignature,DocumentSummary,DocumentSummarySize,docvector,domain,DuplicateHash,Duplicates,EditorOWSUSER,EduAssignmentCategory,EduAssignmentFormat,EduEntityId,EduMaximumScore,EndDate,ExcludeFromSummary,ExpiresOWSDATE,ExternalMediaURL,ExtractedAuthor,ExtractedDate,FileExtension,FileType,FirstLevelColleagues,FirstLevelMutualFollowings,FirstName,FullPostBody,GeneratedTitle,Genre,HierarchyUrl,HitHighlightedProperties,HitHighlightedSummary,ImageDateCreated,importance,Interests,InternalFileType,IsContainer,IsData,IsDefaultView,IsDocument,IsEmptyList,IsFeaturedOWSBOOL,IsListItem,IsMyDocuments,IsPublishingCatalog,IsQuestionOWSBOOL,IsReport,JobTitle,Keywords,language,languages,LastAnalyticsUpdateTime,LastName,LastReplyByOWSUSER,LevelsToTop,LikesCount,ListID,ListItemID,ListUrl,Location,MediaDuration,Memberships,MetadataAuthor,MicroBlogType,MobilePhone,ModifiedBy,ModifiedOWSDATE,MyEditorOWSUSER,Notes,NumItemsInCollection,OfficeNumber,OrgNames,OrgParentNames,OrgParentUrls,OrgUrls,OWS_ItemURL,owsmetadatafacetinfo,owstaxidmetadataalltagsinfo,owstaxIdProductCatalogItemCategory,ParentItemEditorOWSUSER,ParentItemIDOWSINTG,ParentLink,PastProjects,People,PeopleInMedia,PeopleKeywords,PhoneNumber,PictureHeight,PictureThumbnailURL,PictureURL,PictureWidth,PopularSocialTags,PostAuthor,PreferredName,Priority,processingtime,ProductCatalogGroupNumberOWSTEXT,ProductIdOWSGUID,Pronunciations,PublishedDateOWSDATE,PublishingCatalogSettings,PublishingContactOWSUSER,PublishingImage,PublishingIsFurlPageOWSBOOL,PublishingPageContentOWSHTML,PublishingPageLayoutOWSURLH,QLogClickedText,QueryTerms,Rank,Rating,RatingCount,RecsClickedLifeTime,RecsClickedRecent,RefinableDate00,RefinableDate01,RefinableDate02,RefinableDate03,RefinableDate04,RefinableDate05,RefinableDate06,RefinableDate07,RefinableDate08,RefinableDate09,RefinableDate10,RefinableDate11,RefinableDate12,RefinableDate13,RefinableDate14,RefinableDate15,RefinableDate16,RefinableDate17,RefinableDate18,RefinableDate19,RefinableDecimal00,RefinableDecimal01,RefinableDecimal02,RefinableDecimal03,RefinableDecimal04,RefinableDecimal05,RefinableDecimal06,RefinableDecimal07,RefinableDecimal08,RefinableDecimal09,RefinableDouble00,RefinableDouble01,RefinableDouble02,RefinableDouble03,RefinableDouble04,RefinableDouble05,RefinableDouble06,RefinableDouble07,RefinableDouble08,RefinableDouble09,RefinableInt00,RefinableInt01,RefinableInt02,RefinableInt03,RefinableInt04,RefinableInt05,RefinableInt06,RefinableInt07,RefinableInt08,RefinableInt09,RefinableInt10,RefinableInt11,RefinableInt12,RefinableInt13,RefinableInt14,RefinableInt15,RefinableInt16,RefinableInt17,RefinableInt18,RefinableInt19,RefinableInt20,RefinableInt21,RefinableInt22,RefinableInt23,RefinableInt24,RefinableInt25,RefinableInt26,RefinableInt27,RefinableInt28,RefinableInt29,RefinableInt30,RefinableInt31,RefinableInt32,RefinableInt33,RefinableInt34,RefinableInt35,RefinableInt36,RefinableInt37,RefinableInt38,RefinableInt39,RefinableInt40,RefinableInt41,RefinableInt42,RefinableInt43,RefinableInt44,RefinableInt45,RefinableInt46,RefinableInt47,RefinableInt48,RefinableInt49,RefinableString00,RefinableString01,RefinableString02,RefinableString03,RefinableString04,RefinableString05,RefinableString06,RefinableString07,RefinableString08,RefinableString09,RefinableString10,RefinableString11,RefinableString12,RefinableString13,RefinableString14,RefinableString15,RefinableString16,RefinableString17,RefinableString18,RefinableString19,RefinableString20,RefinableString21,RefinableString22,RefinableString23,RefinableString24,RefinableString25,RefinableString26,RefinableString27,RefinableString28,RefinableString29,RefinableString30,RefinableString31,RefinableString32,RefinableString33,RefinableString34,RefinableString35,RefinableString36,RefinableString37,RefinableString38,RefinableString39,RefinableString40,RefinableString41,RefinableString42,RefinableString43,RefinableString44,RefinableString45,RefinableString46,RefinableString47,RefinableString48,RefinableString49,RefinableString50,RefinableString51,RefinableString52,RefinableString53,RefinableString54,RefinableString55,RefinableString56,RefinableString57,RefinableString58,RefinableString59,RefinableString60,RefinableString61,RefinableString62,RefinableString63,RefinableString64,RefinableString65,RefinableString66,RefinableString67,RefinableString68,RefinableString69,RefinableString70,RefinableString71,RefinableString72,RefinableString73,RefinableString74,RefinableString75,RefinableString76,RefinableString77,RefinableString78,RefinableString79,RefinableString80,RefinableString81,RefinableString82,RefinableString83,RefinableString84,RefinableString85,RefinableString86,RefinableString87,RefinableString88,RefinableString89,RefinableString90,RefinableString91,RefinableString92,RefinableString93,RefinableString94,RefinableString95,RefinableString96,RefinableString97,RefinableString98,RefinableString99,ReplyCount,Responsibilities,RobotsNoIndexOWSBOOL,RootPostID,RootPostOwnerID,RootPostUniqueID,SBWPageContent1OWSHTML,Schools,SecondaryFileExtension,SecondLevelColleagues,SectionIndexes,SectionNames,ServerRedirectedEmbedURL,ServerRedirectedPreviewURL,ServerRedirectedURL,ServiceApplicationID,SharedWithInternal,SipAddress,Site,SiteDescription,SiteID,SiteLogo,SitemapChangeFrequency,SitemapChangeFrequencyOWSCHCS,SitemapPriority,SiteMembers,SiteNumFollowers,SiteOwners,SitePath,SiteTitle,Size,Skills,SocialTag,SPSiteURL,SPVersion,StartDate,Status,Tags,TAUCURL,teaser,tld,UIVersionStringOWSTEXT,UniqueID,UrlDepth,urls,UsageAnalyticsId,UsageEvent10LifeTime,UsageEvent10Recent,UsageEvent11LifeTime,UsageEvent11Recent,UsageEvent12LifeTime,UsageEvent12Recent,UsageEvent1LifeTime,UsageEvent1Recent,UsageEvent2LifeTime,UsageEvent2Recent,UsageEvent3LifeTime,UsageEvent3Recent,UsageEvent4LifeTime,UsageEvent4Recent,UsageEvent5LifeTime,UsageEvent5Recent,UsageEvent6LifeTime,UsageEvent6Recent,UsageEvent7LifeTime,UsageEvent7Recent,UsageEvent8LifeTime,UsageEvent8Recent,UsageEvent9LifeTime,UsageEvent9Recent,UsageEventItemId,UserEncodingURL,UserName,UserProfile_GUID,VideoSetRenditionsInfo,ViewsLast1Days,ViewsLast1DaysUniqueUsers,ViewsLast2Days,ViewsLast2DaysUniqueUsers,ViewsLast3Days,ViewsLast3DaysUniqueUsers,ViewsLast4Days,ViewsLast4DaysUniqueUsers,ViewsLast5Days,ViewsLast5DaysUniqueUsers,ViewsLast6Days,ViewsLast6DaysUniqueUsers,ViewsLast7Days,ViewsLast7DaysUniqueUsers,ViewsLastMonths1,ViewsLastMonths1Unique,ViewsLastMonths2,ViewsLastMonths2Unique,ViewsLastMonths3,ViewsLastMonths3Unique,ViewsLifeTime,ViewsLifeTimeUniqueUsers,ViewsRecent,ViewsRecentUniqueUsers,WebId,WebTemplate,WeightedMemberships,WikiCategory,WikiFieldOWSMTXT,WordCustomRefiner1,WordCustomRefiner2,WordCustomRefiner3,WordCustomRefiner4,WordCustomRefiner5,WordExactCustomRefiner,WordPartCustomRefiner1,WordPartCustomRefiner2,WordPartCustomRefiner3,WordPartCustomRefiner4,WordPartCustomRefiner5,WordPartExactCustomRefiner,WorkEmail,WorkPhone,YomiDisplayName'&sourceid='8413cd39-2156-4e00-b54d-11efd9abdb89'&clienttype='ContentSearchRegular'}

 

 

4 Replies
Please try to add the search results web part again by removing the existing one and try.

@Ratnakumar_Paleru Tried adding webpart again still same result. The problem is with the REST API which suddenly stopped working from JUNE 1st week.

Do you still have this issue? Might be related to my issue (SharePoint Search API not giving any results with application permissions)
Yes I am still facing the issue. SharePoint Search API is not returning results if the request having more than 100 return indexes.