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

Occasional 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'}

 

 

2 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.