About
Pricing
Community
Teams
Start Free Trial
Log in
Isaac
asked on
9/25/2015
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 SharePoint
REST
6
1
Last Comment
Isaac
8/22/2022 - Mon
Rajendra Shekhawat
9/29/2015
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/getbytitl
e('Posts')
/items?$se
lect=Title
, Category/Title&$expand=Cat
egory/Titl
e
Let me know, in case of any issues.
Cheers,
Raj
Isaac
9/29/2015
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
9/29/2015
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
9/30/2015
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
9/30/2015
ASKER
That worked! Thank you very much. I've been dealing with this for days.
Isaac
10/1/2015
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
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/getbytitl
Let me know, in case of any issues.
Cheers,
Raj