I am using SP 2013 and trying to joint two lists which are linked through a lookup field in the second list. I have tried several things like XML and SpSiteDataQuery but I am not familiar with using C#. I just know using javascript and jquery in SP. So what should I use in SP2013 to join the lists and present their data?

Can I use SPQuery or REST API for this? I found examples here:

Sharepoint 2010 SPQuery to join two custom lists

How to join two lists using REST API sharepoint 2013

1 Answer 1


As you mentioned that you are not much familiar with c#, for SharePoint and you have already created lookup field so for your expertise you use REST API to get the data of both list by expanding the fields of the list referred by lookup column. And also explained the referenced you mentioned. And for more understanding you can refer

  • 1
    This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
    – Benny Skogberg
    Jul 20, 2018 at 6:53

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.