Retrieving list data from multiple sub-sites using same site content type with JavaScript

%3CLINGO-SUB%20id%3D%22lingo-sub-861084%22%20slang%3D%22en-US%22%3ERetrieving%20list%20data%20from%20multiple%20sub-sites%20using%20same%20site%20content%20type%20with%20JavaScript%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861084%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20running%20a%20SharePoint%20site%20for%20projects%20where%20every%20project%20is%20created%20as%20a%20sub-site%20with%20a%20number%20of%20lists.%20Each%20sub-site%20has%20a%20list%20with%20one%20list%20item%20including%20the%20most%20important%20project%20data.%20This%20list%20is%20using%20a%20Site%20Content%20Type.%20I'd%20like%20to%20pull%20the%20data%20from%20all%20those%20lists%20and%20write%20it%20to%20one%20list%20on%20the%20parent%20site%2C%20e.g.%20by%20a%20weekly%20run%20of%20a%20workflow%20or%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20task%20be%20done%20by%20using%20JavaScript%2C%20Rest%20API%2C%20etc.%3F%20Has%20anybody%20done%20something%20similar%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20tips.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861084%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Econtent%20type%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EJavaScript%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EREST%20API%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-890846%22%20slang%3D%22en-US%22%3ERe%3A%20Retrieving%20list%20data%20from%20multiple%20sub-sites%20using%20same%20site%20content%20type%20with%20JavaScript%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890846%22%20slang%3D%22en-US%22%3E%3CP%3ENobody%20out%20there%20who%20could%20give%20me%20a%20tip%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911689%22%20slang%3D%22en-US%22%3ERe%3A%20Retrieving%20list%20data%20from%20multiple%20sub-sites%20using%20same%20site%20content%20type%20with%20JavaScript%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911689%22%20slang%3D%22en-US%22%3E%3CP%3EFound%20some%20very%20good%20pages%20for%20achieving%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Create%20Your%20First%20Search%20Refiner%20Control%20Template%22%20href%3D%22https%3A%2F%2Fwww.eliostruyf.com%2Fpart-1-create-first-search-refiner-control-template%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.eliostruyf.com%2Fpart-1-create-first-search-refiner-control-template%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Display%20Templates%22%20href%3D%22https%3A%2F%2Fgithub.com%2FSPCSR%2FDisplayTemplates%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSPCSR%2FDisplayTemplates%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20it%20working%20finally!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPatrick%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear all,

 

I'm running a SharePoint site for projects where every project is created as a sub-site with a number of lists. Each sub-site has a list with one list item including the most important project data. This list is using a Site Content Type. I'd like to pull the data from all those lists and write it to one list on the parent site, e.g. by a weekly run of a workflow or manually.

 

Can this task be done by using JavaScript, Rest API, etc.? Has anybody done something similar?

 

Thanks for your tips.

2 Replies