Timeline for Lookup Column Value through Rest API
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 6, 2019 at 8:40 | comment | added | jayant khushalani | They are normal lookup columns. i havent. will give it a try. | |
| Jun 6, 2019 at 8:32 | comment | added | Morten K | The lookup columns are normal lookup and not people fields? Did you try replacing the /Title with /Id? | |
| Jun 6, 2019 at 7:28 | comment | added | jayant khushalani | it works if i remove the lookup column value. | |
| Jun 6, 2019 at 6:11 | comment | added | Morten K | Ok does it work if you remove all fields that needs to be expanded (along with the expand parametre)? | |
| Jun 6, 2019 at 6:04 | comment | added | jayant khushalani | yup i did but it did not work | |
| Jun 6, 2019 at 5:32 | comment | added | Morten K | I assume the xyz is a placeholder in the above? Did you try it in the browser? | |
| Jun 5, 2019 at 6:28 | comment | added | jayant khushalani | still did not work. | |
| Jun 4, 2019 at 6:30 | comment | added | Morten K | From what I can see the query is just slightly off here: &$expand=SC_x0020_Team_x0020_Leader/Id,Program_x0020_Name_x003a_BU_x002 <-- you don't want the "/Id". You only need to tell which fields you want to expand. | |
| Jun 4, 2019 at 5:22 | comment | added | jayant khushalani | Hi , i am using this query 'url: _spPageContextInfo.siteAbsoluteUrl + "/_api/web/lists(guid'xyz')/items?$select=CP_x0020_Should_x0020_Cost_x0020,Program_x0020_Name_x003a_BU_x002/Title,Planned_x0020_Model_x0020_Close,Actual_x0020_Model_x0020_Close,SC_x0020_Team_x0020_Leader/Title&$filter=SC_x0020_Team_x0020_Leader/Title eq '"+employeeName+"'&$expand=SC_x0020_Team_x0020_Leader/Id,Program_x0020_Name_x003a_BU_x002", ' where in Program_x0020_Name_x003a_BU_x002 is the lookup column. Can you help me with this query itself? | |
| May 24, 2019 at 6:34 | history | edited | Morten K | CC BY-SA 4.0 |
added 25 characters in body
|
| May 24, 2019 at 5:55 | history | answered | Morten K | CC BY-SA 4.0 |