Forum Discussion
Get ListItem Using Search REST API
Hi Team,
I am beginner in Search REST API. I want to fetch the data from list using Search REST API Call but unable to accomplish it.
It will be great help if you provide me couple of options to get the desired results.
I had tried below REST API Call which returns only 5 items but list contains more than 100 items.
These are the steps I had followed
1. Created the contentype and site columns.
2. Created the mapped properties for local list item.
Second want to fetch userId in search REST API Call.
const queryString ='querytext=\'ContentTypeId:0x0100C39236969AED684AB3138CC274A973B0*\''
+'&selectproperties=\'ListItemID,ActualEndDateOWSDATE,ActualStartDateOWSDATE,AllDeliveryResourcesOWSUSER,AllOperationresourcesOWSUSER,AnnotationBinderOWSCHCS,ArchivalStatusOWSTEXT,AuditCheckListOWSMTXT,AuthorsOWSMTXT,'
+'BDOWSUSER,BDBackupOWSUSER,BillingEntityOWSTEXT,BusinessVerticalOWSTEXT,ClientLegalEntityOWSTEXT,CMBackupOWSUSER,CMLevel1OWSUSER,CMLevel2OWSUSER,CommentsMTOWSMTXT,ConferenceJournalOWSMTXT,Created,CSRuleOWSTEXT,DeliverableTypeOWSTEXT,DeliveryBackupOWSUSER,'
+'DeliveryLevel1OWSUSER,DeliveryLevel2OWSUSER,DeliveryRuleOWSTEXT,DescriptionMTOWSMTXT,EditorsOWSUSER,FinanceAuditCheckListOWSMTXT,GraphicsMembersOWSUSER,IndicationOWSTEXT,IsApprovedOWSCHCS,IsPubSupportOWSTEXT,IsStandard,JournalSelectionDateOWSDATE,JournalSelectionURLOWSTEXT,'
+'LastSubmissionDateOWSDATE,MilestoneOWSTEXT,MilestonesOWSMTXT,ModifiedOWSDATE,MoleculeOWSTEXT,OvernightRequestOWSTEXT,PageCountOWSNMBR,POCOWSTEXT,PrevStatusOWSTEXT,PrimaryPOCOWSNMBR,PrimaryResMembersOWSUSER,PrioritySTOWSTEXT,ProjectCode,ProjectCodeOWSTEXT,ProjectFolderOWSTEXT,ProjectTaskOWSTEXT,ProjectTypeOWSTEXT,'
+'ProposeClosureDateOWSDATE,ProposedEndDateOWSDATE,ProposedStartDateOWSDATE,PSMembersOWSUSER,PubSupportStatusOWSTEXT,QCOWSUSER,QuickProjectOWSCHCS,ReasonOWSMTXT,ReasonTypeOWSTEXT,ReferenceCountOWSNMBR,RejectionDateOWSDATE,RelatedProject,ReviewersOWSUSER,ServiceLevelOWSTEXT,SlideCountOWSNMBR,'
+'SOWBoxLinkOWSTEXT,SOWCodeOWSTEXT,SOWLinkOWSMTXT,StandardBudgetHrsOWSNMBR,StandardServiceOWSTEXT,StandardTemplateConfigOWSMTXT,Status,SubDeliverableOWSTEXT,SubDivisionOWSTEXT,TAOWSTEXT,WBJIDOWSTEXT,WritersOWSUSER,Writers,YearOWSTEXT\''
//+ '&sourceid=\'ee88a06a-6bb4-4950-8066-558d3f431784\''
+ '&properties=\'SourceName:medcomdev,SourceLevel:SPSite\''
1 Reply
- Have you tried first to use search to see if it returns more than 5 items?
Just put this in SharePoint Search box: ContentTypeId:0x0100C39236969AED684AB3138CC274A973B0*
