Avatar of Isaac
Isaac
Flag for United States of America asked on

Join two SharePoint 2013 lists using operator

I have two SharePoint lists. 1) Posts and 2) Categories

The Posts list has a lookup field called 'Category' into the Categories list.

I am trying to use the $expand option to join the two lists but I'm unsuccessful.  I'm trying to follow the example used in this site but I'm confused.

Any ideas?

I've tried the following and many other combinations but I get errors
http://understandsp.com/blog/_api/web/lists/getbytitle('Posts')/items/?&select=Title,Category/Id&$expand=Title/Id

Here's where you can look at my lists
http://understandsp.com/blog/_layouts/15/start.aspx#/_layouts/15/viewlsts.aspx

Please help!
Microsoft SharePointREST

Avatar of undefined
Last Comment
Isaac

8/22/2022 - Mon
Rajendra Shekhawat

Hi,

I have used following REST Query to get the data related to lookup.

Posts - Parent List
Posts has Category Lookup Column - Display Column 'Title'

Please try below query -

origin + "/_api/web/lists/getbytitle('Posts')/items?$select=Title, Category/Title&$expand=Category/Title

Let me know, in case of any issues.

Cheers,
Raj
Isaac

ASKER
That did not work.
http://understandsp.com/blog/_api/web/lists/getbytitle('Posts')/items/?&select=Title,Category/Title&$expand=Category/Title
When using a blog site, it's really different. If you have access to a blog site, try it for your self. Post and Categories are created by default.
Rajendra Shekhawat

Hi,

As you said lists in your question, i missed blog.

Field Name of Category in blog is PostCategory .

I have tried below query on blog and works fine, gives me list of categories.

Try this -

http://c4968397007/sites/blog/_api/web/lists/getbytitle('Posts')/items?$select=Title,PostCategory/Title&$expand=PostCategory/Title

Cheers,
Raj
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Rajendra Shekhawat

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Isaac

ASKER
That worked! Thank you very much.  I've been dealing with this for days.
Isaac

ASKER
Rajendra Shekhawat,

Can you please assist with this question? Thanks!
https://www.experts-exchange.com/questions/28735845/REST-api-postCatgory-showing-as-object.html