I have a requirement to fetch 2 large lists and merge data into a single CSV file. Suppose Lists are as below :

List A

  • Column1

  • Data1

  • Data2

List B

  • Column2

  • Data3

  • Data4

Then Data should be displayed in csv file as below :

  • Column1 Column2
  • Data1 Data3
  • Data2 Data4

Is there any way to achieve this using REST/JSOM ?

Please note that as per the requirement we want to do it multiple times so there should not be any manual work to do.

1 Answer 1


This could easily be done via PowerShell. Check out the get-pnplistitem cmdlet, in conjunction with the export-csv cmdlet.

  • This does not help me, we need a script in JSOM/REST to perform this as mentioned in the question clearly.
    – Ravi
    Feb 19, 2019 at 4:51
  • There is a pnp js library as well. Here is a page with samples: github.com/SharePoint/PnP-JS-Core/wiki/Basic--Operations. Once you have the data, you can generate a csv: stackoverflow.com/questions/14964035/…
    – Mike2500
    Feb 19, 2019 at 13:19
  • Thanks for the references Mike but I am very much struggling to fulfill this and references of complete raw data are not helping me here. If possible please post a sample code so I can modify that and use.
    – Ravi
    Feb 19, 2019 at 14:39
  • That's why i orginally posted the powershell, it's the simplest way. If you need the javascript route, you'll need a way to get js on the page. In a modern page, that means either SPFx, or the modern script editor web part, which is an open source part available here: github.com/SharePoint/sp-dev-fx-webparts/tree/master/samples/… - Once you are able to get script on the page, you'd need to reference the pnp js. Once that's done, then the rest shouldnt be too bad, as the above links have samples.
    – Mike2500
    Feb 19, 2019 at 14:42
  • I am working on classic experience so that is not a problem. I will look into PnP libraries and will update here.
    – Ravi
    Feb 19, 2019 at 14:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.