Skip to content

Bug report: The commands "spo listitem list" and "spo listitem get" does not work with lookup columns #3391

Closed
Closed
Bug report: The commands "spo listitem list" and "spo listitem get" does not work with lookup columns#3391
Assignees
nanddeepn
Labels
bugwork in progress
@nanddeepn

Description

@nanddeepn
nanddeepn
opened on Jun 10, 2022

Description

Initiated from the discussion pnp/script-samples#310 (comment) with @Adam-it

The commands m365 spo listitem list with parameter --fields does not seem to work with lookup columns.

When lookup column is passed to --fields parameter, it throws below error:

Error: The query to field 'LookupColumn' is not valid. The $select query string must specify the target fields and the $expand
 query string must contains Parent.

Also, same error occurs when m365 spo listitem get command is used with --properties parameter as lookup column.

Steps to reproduce

Execute below commands:

spo listitem list

m365 spo listitem list --title "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --fields "ID,Title,LookupColumn"

Pass LookupColumn to --fields parameter.

spo listitem get

m365 spo listitem get --listTitle "Demo List" --id 147 --webUrl https://contoso.sharepoint.com/sites/project-x --properties "Title,Created,LookupColumn"

Pass LookupColumn to --properties parameter.

Expected results

The commands should return the information on the Lookup columns passed as parameter

Actual results

The command returns below error:

Error: The query to field 'LookupColumn' is not valid. The $select query string must specify the target fields and the $expand
query string must contains Parent.

Diagnostics

In both the below command executions, Company is a lookup column in Vendors list.

PS C:\pnp\cli-microsoft365> m365 spo listitem list --title "Vendors" --webUrl https://contoso.sharepoint.com/sites/SPD
emo --fields "ID,Title,Company" --debug

Executing command spo listitem list with options {"options":{"title":"Vendors","webUrl":"https://contoso.sharepoint.co
m/sites/SPDemo","fields":"ID,Title,Company","debug":true}}
Existing access token eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI6ImpTMV
hvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL25hY2hhbjM2NS5zaGFyZXBvaW50LmNvbSIsImlzcyI6Imh0dHBzOi8vc3RzLndpb
mRvd3MubmV0L2RlMzQ4YmM3LTFhZWItNDQwNi04Y2IzLTk3ZGIwMjFjYWRiNC8iLCJpYXQiOjE2NTQ4NDQwNDcsIm5iZiI6MTY1NDg0NDA0NywiZXhwIjoxN
jU0ODQ5NzQ2LCJhY3IiOiIxIiwiYWlvIjoiQVRRQXkvOFRBQUFBblQ2WFovRXIxOWhuaXVoaUNaaW1ZWkdJR2M0Vmx3Z25Nc2dTY1BISks0eGNQT3paNWU2a
2J1bWFyOWVJTytCUSIsImFtciI6WyJwd2QiXSwiYXBwX2Rpc3BsYXluYW1lIjoiUG5QIE1hbmFnZW1lbnQgU2hlbGwiLCJhcHBpZCI6IjMxMzU5YzdmLWJkN
2UtNDc1Yy04NmRiLWZkYjhjOTM3NTQ4ZSIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiTmFjaGFuIiwiZ2l2ZW5fbmFtZSI6Ik5hbmRkZWVwIiwia
WR0eXAiOiJ1c2VyIiwiaXBhZGRyIjoiMjAuMjM5LjUxLjEyOCIsIm5hbWUiOiJOYW5kZGVlcCBOYWNoYW4iLCJvaWQiOiJlMTI1MWIxMC0xYmE0LTQ5ZTMtY
jM1YS05MzNlM2YyMTc3MmIiLCJwdWlkIjoiMTAwMzIwMDA2NTEzRTU4NCIsInJoIjoiMC5BVDRBeDRzMDN1c2FCa1NNczVmYkFoeXR0QU1BQUFBQUFQRVB6Z
0FBQUFBQUFBQS1BREUuIiwic2NwIjoiQWxsU2l0ZXMuRnVsbENvbnRyb2wgQXBwQ2F0YWxvZy5SZWFkV3JpdGUuQWxsIEF1ZGl0TG9nLlJlYWQuQWxsIENoY
W5uZWxNZW1iZXIuUmVhZFdyaXRlLkFsbCBDaGFubmVsTWVzc2FnZS5SZWFkLkFsbCBDaGFubmVsTWVzc2FnZS5TZW5kIENoYW5uZWxTZXR0aW5ncy5SZWFkV
3JpdGUuQWxsIENoYXQuUmVhZCBDaGF0LlJlYWRXcml0ZSBEaXJlY3RvcnkuQWNjZXNzQXNVc2VyLkFsbCBEaXJlY3RvcnkuUmVhZFdyaXRlLkFsbCBHcm91c
C5SZWFkV3JpdGUuQWxsIElkZW50aXR5UHJvdmlkZXIuUmVhZFdyaXRlLkFsbCBNYWlsLlJlYWRXcml0ZSBNYWlsLlNlbmQgUGxhY2UuUmVhZC5BbGwgUG9sa
WN5LlJlYWQuQWxsIFJlcG9ydHMuUmVhZC5BbGwgU2VjdXJpdHlFdmVudHMuUmVhZC5BbGwgU2VydmljZUhlYWx0aC5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZ
S5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZVZpZXdwb2ludC5Xcml0ZSBUYXNrcy5SZWFkV3JpdGUgVGVhbS5DcmVhdGUgVGVhbU1lbWJlci5SZWFkV3JpdGUuQ
WxsIFRlYW1zQXBwLlJlYWRXcml0ZS5BbGwgVGVhbXNBcHBJbnN0YWxsYXRpb24uUmVhZFdyaXRlRm9yVXNlciBUZWFtU2V0dGluZ3MuUmVhZFdyaXRlLkFsb
CBUZWFtc1RhYi5SZWFkV3JpdGUuQWxsIFRlcm1TdG9yZS5SZWFkV3JpdGUuQWxsIFVzZXIuSW52aXRlLkFsbCBVc2VyLlJlYWRXcml0ZS5BbGwiLCJzaWQiO
iI1N2UyZWQyYy0wMzRlLTRmYWItYWRhNS02MzFmNTZhZDU1NzMiLCJzaWduaW5fc3RhdGUiOlsia21zaSJdLCJzdWIiOiJ5VWYtbGVDRXR5elBSNDJwRjYxN
HEtUFE2cm1KWlNkX0hNUnBURkl4QS1BIiwidGlkIjoiZGUzNDhiYzctMWFlYi00NDA2LThjYjMtOTdkYjAyMWNhZGI0IiwidW5pcXVlX25hbWUiOiJhZG1pb
kBuYWNoYW4zNjUub25taWNyb3NvZnQuY29tIiwidXBuIjoiYWRtaW5AbmFjaGFuMzY1Lm9ubWljcm9zb2Z0LmNvbSIsInV0aSI6IkZCTjYtaWRVZ2tPVkk1V
XV0dk1lQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjRhNWQ4ZjY1LTQxZGEtNGRlNC04OTY4LWUwMzViNjUzMzljZiIsImU2ZDFhMjNhLWRhMTEtNGJlNC05N
TcwLWJlZmM4NmQwNjdhNyIsIjE3MzE1Nzk3LTEwMmQtNDBiNC05M2UwLTQzMjA2MmNhY2ExOCIsIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0N
WUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdfQ.fLS1tR5wjOKibOWBZRAdzuhik53PVjN02o9BG48XthzMTHWQdoAiussdnx
64JGpS9h_vwMHXnZaiOZNWyKxRAKBgklFbciUiK20PDEBlIYgUJcSWdCLwghcfzebrPzpAQpsB7ykg5j3ITrKbUcsfbWBidEgjbwhQC28wjdJNzuQ8NFzxqz
TJ-jK2SeFL56t66i4lmo4nbapUblc0TXBVnACL8HD9l1ylu4R5aSc83Joq1_30j4GkwU8RHrhepDxgDkmgXodu4gMckUALs_DjepJjHs0VYwAdaYE-iQXdW6
m-OIIqhO73jffxtX66XeYOS03R9vZvOu2o-hIaWHnwFg still valid. Returning...
Request:
{
"url": "https://contoso.sharepoint.com/sites/SPDemo/_api/web/lists/getByTitle('Vendors')/items?$select=ID%2CTitle%2C
Company&&&",
"method": "get",
"headers": {
"common": {
"Accept": "application/json, text/plain, /"
},
"delete": {},
"get": {},
"head": {},
"post": {
"Content-Type": "application/x-www-form-urlencoded"
},
"put": {
"Content-Type": "application/x-www-form-urlencoded"
},
"patch": {
"Content-Type": "application/x-www-form-urlencoded"
},
"user-agent": "NONISV|SharePointPnP|CLIMicrosoft365/5.4.0",
"accept-encoding": "gzip, deflate",
"accept": "application/json;odata=nometadata",
"X-RequestDigest": "",
"authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI
6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL25hY2hhbjM2NS5zaGFyZXBvaW50LmNvbSIsImlzcyI6Imh0dHBzOi8vc3
RzLndpbmRvd3MubmV0L2RlMzQ4YmM3LTFhZWItNDQwNi04Y2IzLTk3ZGIwMjFjYWRiNC8iLCJpYXQiOjE2NTQ4NDQwNDcsIm5iZiI6MTY1NDg0NDA0NywiZX
hwIjoxNjU0ODQ5NzQ2LCJhY3IiOiIxIiwiYWlvIjoiQVRRQXkvOFRBQUFBblQ2WFovRXIxOWhuaXVoaUNaaW1ZWkdJR2M0Vmx3Z25Nc2dTY1BISks0eGNQT3
paNWU2a2J1bWFyOWVJTytCUSIsImFtciI6WyJwd2QiXSwiYXBwX2Rpc3BsYXluYW1lIjoiUG5QIE1hbmFnZW1lbnQgU2hlbGwiLCJhcHBpZCI6IjMxMzU5Yz
dmLWJkN2UtNDc1Yy04NmRiLWZkYjhjOTM3NTQ4ZSIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiTmFjaGFuIiwiZ2l2ZW5fbmFtZSI6Ik5hbmRkZW
VwIiwiaWR0eXAiOiJ1c2VyIiwiaXBhZGRyIjoiMjAuMjM5LjUxLjEyOCIsIm5hbWUiOiJOYW5kZGVlcCBOYWNoYW4iLCJvaWQiOiJlMTI1MWIxMC0xYmE0LT
Q5ZTMtYjM1YS05MzNlM2YyMTc3MmIiLCJwdWlkIjoiMTAwMzIwMDA2NTEzRTU4NCIsInJoIjoiMC5BVDRBeDRzMDN1c2FCa1NNczVmYkFoeXR0QU1BQUFBQU
FQRVB6Z0FBQUFBQUFBQS1BREUuIiwic2NwIjoiQWxsU2l0ZXMuRnVsbENvbnRyb2wgQXBwQ2F0YWxvZy5SZWFkV3JpdGUuQWxsIEF1ZGl0TG9nLlJlYWQuQW
xsIENoYW5uZWxNZW1iZXIuUmVhZFdyaXRlLkFsbCBDaGFubmVsTWVzc2FnZS5SZWFkLkFsbCBDaGFubmVsTWVzc2FnZS5TZW5kIENoYW5uZWxTZXR0aW5ncy
5SZWFkV3JpdGUuQWxsIENoYXQuUmVhZCBDaGF0LlJlYWRXcml0ZSBEaXJlY3RvcnkuQWNjZXNzQXNVc2VyLkFsbCBEaXJlY3RvcnkuUmVhZFdyaXRlLkFsbC
BHcm91cC5SZWFkV3JpdGUuQWxsIElkZW50aXR5UHJvdmlkZXIuUmVhZFdyaXRlLkFsbCBNYWlsLlJlYWRXcml0ZSBNYWlsLlNlbmQgUGxhY2UuUmVhZC5BbG
wgUG9saWN5LlJlYWQuQWxsIFJlcG9ydHMuUmVhZC5BbGwgU2VjdXJpdHlFdmVudHMuUmVhZC5BbGwgU2VydmljZUhlYWx0aC5SZWFkLkFsbCBTZXJ2aWNlTW
Vzc2FnZS5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZVZpZXdwb2ludC5Xcml0ZSBUYXNrcy5SZWFkV3JpdGUgVGVhbS5DcmVhdGUgVGVhbU1lbWJlci5SZWFkV3
JpdGUuQWxsIFRlYW1zQXBwLlJlYWRXcml0ZS5BbGwgVGVhbXNBcHBJbnN0YWxsYXRpb24uUmVhZFdyaXRlRm9yVXNlciBUZWFtU2V0dGluZ3MuUmVhZFdyaX
RlLkFsbCBUZWFtc1RhYi5SZWFkV3JpdGUuQWxsIFRlcm1TdG9yZS5SZWFkV3JpdGUuQWxsIFVzZXIuSW52aXRlLkFsbCBVc2VyLlJlYWRXcml0ZS5BbGwiLC
JzaWQiOiI1N2UyZWQyYy0wMzRlLTRmYWItYWRhNS02MzFmNTZhZDU1NzMiLCJzaWduaW5fc3RhdGUiOlsia21zaSJdLCJzdWIiOiJ5VWYtbGVDRXR5elBSND
JwRjYxNHEtUFE2cm1KWlNkX0hNUnBURkl4QS1BIiwidGlkIjoiZGUzNDhiYzctMWFlYi00NDA2LThjYjMtOTdkYjAyMWNhZGI0IiwidW5pcXVlX25hbWUiOi
JhZG1pbkBuYWNoYW4zNjUub25taWNyb3NvZnQuY29tIiwidXBuIjoiYWRtaW5AbmFjaGFuMzY1Lm9ubWljcm9zb2Z0LmNvbSIsInV0aSI6IkZCTjYtaWRVZ2
tPVkk1VXV0dk1lQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjRhNWQ4ZjY1LTQxZGEtNGRlNC04OTY4LWUwMzViNjUzMzljZiIsImU2ZDFhMjNhLWRhMTEtNG
JlNC05NTcwLWJlZmM4NmQwNjdhNyIsIjE3MzE1Nzk3LTEwMmQtNDBiNC05M2UwLTQzMjA2MmNhY2ExOCIsIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMj
E3NzE0NWUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdfQ.fLS1tR5wjOKibOWBZRAdzuhik53PVjN02o9BG48XthzMTHWQdoA
iussdnx64JGpS9h_vwMHXnZaiOZNWyKxRAKBgklFbciUiK20PDEBlIYgUJcSWdCLwghcfzebrPzpAQpsB7ykg5j3ITrKbUcsfbWBidEgjbwhQC28wjdJNzuQ
8NFzxqzTJ-jK2SeFL56t66i4lmo4nbapUblc0TXBVnACL8HD9l1ylu4R5aSc83Joq1_30j4GkwU8RHrhepDxgDkmgXodu4gMckUALs_DjepJjHs0VYwAdaYE
-iQXdW6m-OIIqhO73jffxtX66XeYOS03R9vZvOu2o-hIaWHnwFg"
},
"responseType": "json",
"decompress": true,
"data": ""
}
Request error:
{
"url": "https://contoso.sharepoint.com/sites/SPDemo/_api/web/lists/getByTitle('Vendors')/items?$select=ID%2CTitle%2C
Company&&&",
"status": 400,
"statusText": "Bad Request",
"headers": {
"cache-control": "private, max-age=0",
"transfer-encoding": "chunked",
"content-type": "application/json;odata=nometadata;streaming=true;charset=utf-8",
"expires": "Thu, 26 May 2022 08:21:38 GMT",
"last-modified": "Fri, 10 Jun 2022 08:21:38 GMT",
"vary": "Origin",
"server": "Microsoft-IIS/10.0",
"x-sharepointhealthscore": "1",
"x-sp-serverstate": "ReadOnly=0",
"dataserviceversion": "3.0",
"spclientservicerequestduration": "26",
"x-aspnet-version": "4.0.30319",
"x-databoundary": "None",
"x-1dscollectorurl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"x-ariacollectorurl": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"sprequestguid": "13ee45a0-d069-1000-263a-9cc5399d7b1e",
"request-id": "13ee45a0-d069-1000-263a-9cc5399d7b1e",
"ms-cv": "oEXuE2nQABAmOpzFOZ17Hg.0",
"strict-transport-security": "max-age=31536000",
"x-frame-options": "SAMEORIGIN",
"content-security-policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.mic
rosoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net
*.microsoftstream.com *.dynamics.com *.microsoft.com;",
"x-powered-by": "ASP.NET",
"microsoftsharepointteamservices": "16.0.0.22525",
"x-content-type-options": "nosniff",
"x-ms-invokeapp": "1; RequireReadOnly",
"p3p": "CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR U
NI"",
"date": "Fri, 10 Jun 2022 08:21:37 GMT",
"connection": "close"
},
"error": {
"odata.error": {
"code": "-1, Microsoft.SharePoint.SPException",
"message": {
"lang": "en-US",
"value": "The query to field 'Company' is not valid. The $select query string must specify the target fields and
the $expand query string must contains Company."
}
}
}
}
Error: The query to field 'Company' is not valid. The $select query string must specify the target fields and the $expan
d query string must contains Company.

PS C:\pnp\cli-microsoft365> m365 spo listitem get --listTitle "Vendors" --id 1 --webUrl https://contoso.sharepoint.com
/sites/SPDemo --properties "Title,Created,Company" --debug
Executing command spo listitem get with options {"options":{"listTitle":"Vendors","id":"1","webUrl":"https://contoso.s
harepoint.com/sites/SPDemo","properties":"Title,Created,Company","debug":true}}
Existing access token eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI6ImpTMV
hvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL25hY2hhbjM2NS5zaGFyZXBvaW50LmNvbSIsImlzcyI6Imh0dHBzOi8vc3RzLndpb
mRvd3MubmV0L2RlMzQ4YmM3LTFhZWItNDQwNi04Y2IzLTk3ZGIwMjFjYWRiNC8iLCJpYXQiOjE2NTQ4NDQwNDcsIm5iZiI6MTY1NDg0NDA0NywiZXhwIjoxN
jU0ODQ5NzQ2LCJhY3IiOiIxIiwiYWlvIjoiQVRRQXkvOFRBQUFBblQ2WFovRXIxOWhuaXVoaUNaaW1ZWkdJR2M0Vmx3Z25Nc2dTY1BISks0eGNQT3paNWU2a
2J1bWFyOWVJTytCUSIsImFtciI6WyJwd2QiXSwiYXBwX2Rpc3BsYXluYW1lIjoiUG5QIE1hbmFnZW1lbnQgU2hlbGwiLCJhcHBpZCI6IjMxMzU5YzdmLWJkN
2UtNDc1Yy04NmRiLWZkYjhjOTM3NTQ4ZSIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiTmFjaGFuIiwiZ2l2ZW5fbmFtZSI6Ik5hbmRkZWVwIiwia
WR0eXAiOiJ1c2VyIiwiaXBhZGRyIjoiMjAuMjM5LjUxLjEyOCIsIm5hbWUiOiJOYW5kZGVlcCBOYWNoYW4iLCJvaWQiOiJlMTI1MWIxMC0xYmE0LTQ5ZTMtY
jM1YS05MzNlM2YyMTc3MmIiLCJwdWlkIjoiMTAwMzIwMDA2NTEzRTU4NCIsInJoIjoiMC5BVDRBeDRzMDN1c2FCa1NNczVmYkFoeXR0QU1BQUFBQUFQRVB6Z
0FBQUFBQUFBQS1BREUuIiwic2NwIjoiQWxsU2l0ZXMuRnVsbENvbnRyb2wgQXBwQ2F0YWxvZy5SZWFkV3JpdGUuQWxsIEF1ZGl0TG9nLlJlYWQuQWxsIENoY
W5uZWxNZW1iZXIuUmVhZFdyaXRlLkFsbCBDaGFubmVsTWVzc2FnZS5SZWFkLkFsbCBDaGFubmVsTWVzc2FnZS5TZW5kIENoYW5uZWxTZXR0aW5ncy5SZWFkV
3JpdGUuQWxsIENoYXQuUmVhZCBDaGF0LlJlYWRXcml0ZSBEaXJlY3RvcnkuQWNjZXNzQXNVc2VyLkFsbCBEaXJlY3RvcnkuUmVhZFdyaXRlLkFsbCBHcm91c
C5SZWFkV3JpdGUuQWxsIElkZW50aXR5UHJvdmlkZXIuUmVhZFdyaXRlLkFsbCBNYWlsLlJlYWRXcml0ZSBNYWlsLlNlbmQgUGxhY2UuUmVhZC5BbGwgUG9sa
WN5LlJlYWQuQWxsIFJlcG9ydHMuUmVhZC5BbGwgU2VjdXJpdHlFdmVudHMuUmVhZC5BbGwgU2VydmljZUhlYWx0aC5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZ
S5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZVZpZXdwb2ludC5Xcml0ZSBUYXNrcy5SZWFkV3JpdGUgVGVhbS5DcmVhdGUgVGVhbU1lbWJlci5SZWFkV3JpdGUuQ
WxsIFRlYW1zQXBwLlJlYWRXcml0ZS5BbGwgVGVhbXNBcHBJbnN0YWxsYXRpb24uUmVhZFdyaXRlRm9yVXNlciBUZWFtU2V0dGluZ3MuUmVhZFdyaXRlLkFsb
CBUZWFtc1RhYi5SZWFkV3JpdGUuQWxsIFRlcm1TdG9yZS5SZWFkV3JpdGUuQWxsIFVzZXIuSW52aXRlLkFsbCBVc2VyLlJlYWRXcml0ZS5BbGwiLCJzaWQiO
iI1N2UyZWQyYy0wMzRlLTRmYWItYWRhNS02MzFmNTZhZDU1NzMiLCJzaWduaW5fc3RhdGUiOlsia21zaSJdLCJzdWIiOiJ5VWYtbGVDRXR5elBSNDJwRjYxN
HEtUFE2cm1KWlNkX0hNUnBURkl4QS1BIiwidGlkIjoiZGUzNDhiYzctMWFlYi00NDA2LThjYjMtOTdkYjAyMWNhZGI0IiwidW5pcXVlX25hbWUiOiJhZG1pb
kBuYWNoYW4zNjUub25taWNyb3NvZnQuY29tIiwidXBuIjoiYWRtaW5AbmFjaGFuMzY1Lm9ubWljcm9zb2Z0LmNvbSIsInV0aSI6IkZCTjYtaWRVZ2tPVkk1V
XV0dk1lQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjRhNWQ4ZjY1LTQxZGEtNGRlNC04OTY4LWUwMzViNjUzMzljZiIsImU2ZDFhMjNhLWRhMTEtNGJlNC05N
TcwLWJlZmM4NmQwNjdhNyIsIjE3MzE1Nzk3LTEwMmQtNDBiNC05M2UwLTQzMjA2MmNhY2ExOCIsIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0N
WUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdfQ.fLS1tR5wjOKibOWBZRAdzuhik53PVjN02o9BG48XthzMTHWQdoAiussdnx
64JGpS9h_vwMHXnZaiOZNWyKxRAKBgklFbciUiK20PDEBlIYgUJcSWdCLwghcfzebrPzpAQpsB7ykg5j3ITrKbUcsfbWBidEgjbwhQC28wjdJNzuQ8NFzxqz
TJ-jK2SeFL56t66i4lmo4nbapUblc0TXBVnACL8HD9l1ylu4R5aSc83Joq1_30j4GkwU8RHrhepDxgDkmgXodu4gMckUALs_DjepJjHs0VYwAdaYE-iQXdW6
m-OIIqhO73jffxtX66XeYOS03R9vZvOu2o-hIaWHnwFg still valid. Returning...
Request:
{
"url": "https://contoso.sharepoint.com/sites/SPDemo/_api/web/lists/getByTitle('Vendors')/items(1)?$select=Title%2CCr
eated%2CCompany",
"method": "get",
"headers": {
"common": {
"Accept": "application/json, text/plain, /"
},
"delete": {},
"get": {},
"head": {},
"post": {
"Content-Type": "application/x-www-form-urlencoded"
},
"put": {
"Content-Type": "application/x-www-form-urlencoded"
},
"patch": {
"Content-Type": "application/x-www-form-urlencoded"
},
"user-agent": "NONISV|SharePointPnP|CLIMicrosoft365/5.4.0",
"accept-encoding": "gzip, deflate",
"accept": "application/json;odata=nometadata",
"authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI
6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL25hY2hhbjM2NS5zaGFyZXBvaW50LmNvbSIsImlzcyI6Imh0dHBzOi8vc3
RzLndpbmRvd3MubmV0L2RlMzQ4YmM3LTFhZWItNDQwNi04Y2IzLTk3ZGIwMjFjYWRiNC8iLCJpYXQiOjE2NTQ4NDQwNDcsIm5iZiI6MTY1NDg0NDA0NywiZX
hwIjoxNjU0ODQ5NzQ2LCJhY3IiOiIxIiwiYWlvIjoiQVRRQXkvOFRBQUFBblQ2WFovRXIxOWhuaXVoaUNaaW1ZWkdJR2M0Vmx3Z25Nc2dTY1BISks0eGNQT3
paNWU2a2J1bWFyOWVJTytCUSIsImFtciI6WyJwd2QiXSwiYXBwX2Rpc3BsYXluYW1lIjoiUG5QIE1hbmFnZW1lbnQgU2hlbGwiLCJhcHBpZCI6IjMxMzU5Yz
dmLWJkN2UtNDc1Yy04NmRiLWZkYjhjOTM3NTQ4ZSIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiTmFjaGFuIiwiZ2l2ZW5fbmFtZSI6Ik5hbmRkZW
VwIiwiaWR0eXAiOiJ1c2VyIiwiaXBhZGRyIjoiMjAuMjM5LjUxLjEyOCIsIm5hbWUiOiJOYW5kZGVlcCBOYWNoYW4iLCJvaWQiOiJlMTI1MWIxMC0xYmE0LT
Q5ZTMtYjM1YS05MzNlM2YyMTc3MmIiLCJwdWlkIjoiMTAwMzIwMDA2NTEzRTU4NCIsInJoIjoiMC5BVDRBeDRzMDN1c2FCa1NNczVmYkFoeXR0QU1BQUFBQU
FQRVB6Z0FBQUFBQUFBQS1BREUuIiwic2NwIjoiQWxsU2l0ZXMuRnVsbENvbnRyb2wgQXBwQ2F0YWxvZy5SZWFkV3JpdGUuQWxsIEF1ZGl0TG9nLlJlYWQuQW
xsIENoYW5uZWxNZW1iZXIuUmVhZFdyaXRlLkFsbCBDaGFubmVsTWVzc2FnZS5SZWFkLkFsbCBDaGFubmVsTWVzc2FnZS5TZW5kIENoYW5uZWxTZXR0aW5ncy
5SZWFkV3JpdGUuQWxsIENoYXQuUmVhZCBDaGF0LlJlYWRXcml0ZSBEaXJlY3RvcnkuQWNjZXNzQXNVc2VyLkFsbCBEaXJlY3RvcnkuUmVhZFdyaXRlLkFsbC
BHcm91cC5SZWFkV3JpdGUuQWxsIElkZW50aXR5UHJvdmlkZXIuUmVhZFdyaXRlLkFsbCBNYWlsLlJlYWRXcml0ZSBNYWlsLlNlbmQgUGxhY2UuUmVhZC5BbG
wgUG9saWN5LlJlYWQuQWxsIFJlcG9ydHMuUmVhZC5BbGwgU2VjdXJpdHlFdmVudHMuUmVhZC5BbGwgU2VydmljZUhlYWx0aC5SZWFkLkFsbCBTZXJ2aWNlTW
Vzc2FnZS5SZWFkLkFsbCBTZXJ2aWNlTWVzc2FnZVZpZXdwb2ludC5Xcml0ZSBUYXNrcy5SZWFkV3JpdGUgVGVhbS5DcmVhdGUgVGVhbU1lbWJlci5SZWFkV3
JpdGUuQWxsIFRlYW1zQXBwLlJlYWRXcml0ZS5BbGwgVGVhbXNBcHBJbnN0YWxsYXRpb24uUmVhZFdyaXRlRm9yVXNlciBUZWFtU2V0dGluZ3MuUmVhZFdyaX
RlLkFsbCBUZWFtc1RhYi5SZWFkV3JpdGUuQWxsIFRlcm1TdG9yZS5SZWFkV3JpdGUuQWxsIFVzZXIuSW52aXRlLkFsbCBVc2VyLlJlYWRXcml0ZS5BbGwiLC
JzaWQiOiI1N2UyZWQyYy0wMzRlLTRmYWItYWRhNS02MzFmNTZhZDU1NzMiLCJzaWduaW5fc3RhdGUiOlsia21zaSJdLCJzdWIiOiJ5VWYtbGVDRXR5elBSND
JwRjYxNHEtUFE2cm1KWlNkX0hNUnBURkl4QS1BIiwidGlkIjoiZGUzNDhiYzctMWFlYi00NDA2LThjYjMtOTdkYjAyMWNhZGI0IiwidW5pcXVlX25hbWUiOi
JhZG1pbkBuYWNoYW4zNjUub25taWNyb3NvZnQuY29tIiwidXBuIjoiYWRtaW5AbmFjaGFuMzY1Lm9ubWljcm9zb2Z0LmNvbSIsInV0aSI6IkZCTjYtaWRVZ2
tPVkk1VXV0dk1lQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjRhNWQ4ZjY1LTQxZGEtNGRlNC04OTY4LWUwMzViNjUzMzljZiIsImU2ZDFhMjNhLWRhMTEtNG
JlNC05NTcwLWJlZmM4NmQwNjdhNyIsIjE3MzE1Nzk3LTEwMmQtNDBiNC05M2UwLTQzMjA2MmNhY2ExOCIsIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMj
E3NzE0NWUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdfQ.fLS1tR5wjOKibOWBZRAdzuhik53PVjN02o9BG48XthzMTHWQdoA
iussdnx64JGpS9h_vwMHXnZaiOZNWyKxRAKBgklFbciUiK20PDEBlIYgUJcSWdCLwghcfzebrPzpAQpsB7ykg5j3ITrKbUcsfbWBidEgjbwhQC28wjdJNzuQ
8NFzxqzTJ-jK2SeFL56t66i4lmo4nbapUblc0TXBVnACL8HD9l1ylu4R5aSc83Joq1_30j4GkwU8RHrhepDxgDkmgXodu4gMckUALs_DjepJjHs0VYwAdaYE
-iQXdW6m-OIIqhO73jffxtX66XeYOS03R9vZvOu2o-hIaWHnwFg"
},
"responseType": "json",
"decompress": true
}
Request error:
{
"url": "https://contoso.sharepoint.com/sites/SPDemo/_api/web/lists/getByTitle('Vendors')/items(1)?$select=Title%2CCr
eated%2CCompany",
"status": 400,
"statusText": "Bad Request",
"headers": {
"cache-control": "private, max-age=0",
"transfer-encoding": "chunked",
"content-type": "application/json;odata=nometadata;streaming=true;charset=utf-8",
"expires": "Thu, 26 May 2022 08:23:37 GMT",
"last-modified": "Fri, 10 Jun 2022 08:23:37 GMT",
"vary": "Origin",
"server": "Microsoft-IIS/10.0",
"x-sharepointhealthscore": "0",
"x-sp-serverstate": "ReadOnly=0",
"dataserviceversion": "3.0",
"spclientservicerequestduration": "42",
"x-aspnet-version": "4.0.30319",
"x-databoundary": "None",
"x-1dscollectorurl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"x-ariacollectorurl": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"sprequestguid": "30ee45a0-807e-1000-263a-96710996fbbd",
"request-id": "30ee45a0-807e-1000-263a-96710996fbbd",
"ms-cv": "oEXuMH6AABAmOpZxCZb7vQ.0",
"strict-transport-security": "max-age=31536000",
"x-frame-options": "SAMEORIGIN",
"content-security-policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.mic
rosoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net
*.microsoftstream.com *.dynamics.com *.microsoft.com;",
"x-powered-by": "ASP.NET",
"microsoftsharepointteamservices": "16.0.0.22525",
"x-content-type-options": "nosniff",
"x-ms-invokeapp": "1; RequireReadOnly",
"p3p": "CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR U
NI"",
"date": "Fri, 10 Jun 2022 08:23:36 GMT",
"connection": "close"
},
"error": {
"odata.error": {
"code": "-1, Microsoft.SharePoint.SPException",
"message": {
"lang": "en-US",
"value": "The query to field 'Company' is not valid. The $select query string must specify the target fields and
the $expand query string must contains Company."
}
}
}
}
Error: The query to field 'Company' is not valid. The $select query string must specify the target fields and the $expan
d query string must contains Company.

CLI for Microsoft 365 version

v5.3.0

nodejs version

16.13.0

Operating system (environment)

Windows

Shell

PowerShell

cli doctor

{
"os": {
"platform": "win32",
"version": "Windows Server 2016 Datacenter",
"release": "10.0.14393"
},
"cliVersion": "5.4.0",
"nodeVersion": "v16.13.0",
"cliAadAppId": "31359c7f-bd7e-475c-86db-fdb8c937548e",
"cliAadAppTenant": "common",
"authMode": "DeviceCode",
"cliEnvironment": "",
"cliConfig": {},
"roles": [],
"scopes": [
"AllSites.FullControl",
"AppCatalog.ReadWrite.All",
"AuditLog.Read.All",
"ChannelMember.ReadWrite.All",
"ChannelMessage.Read.All",
"ChannelMessage.Send",
"ChannelSettings.ReadWrite.All",
"Chat.Read",
"Chat.ReadWrite",
"Directory.AccessAsUser.All",
"Directory.ReadWrite.All",
"Group.ReadWrite.All",
"IdentityProvider.ReadWrite.All",
"Mail.ReadWrite",
"Mail.Send",
"Place.Read.All",
"Policy.Read.All",
"Reports.Read.All",
"SecurityEvents.Read.All",
"ServiceHealth.Read.All",
"ServiceMessage.Read.All",
"ServiceMessageViewpoint.Write",
"Tasks.ReadWrite",
"Team.Create",
"TeamMember.ReadWrite.All",
"TeamsApp.ReadWrite.All",
"TeamsAppInstallation.ReadWriteForUser",
"TeamSettings.ReadWrite.All",
"TeamsTab.ReadWrite.All",
"TermStore.ReadWrite.All",
"User.Invite.All",
"User.ReadWrite.All",
"profile",
"openid",
"email",
"AllSites.FullControl",
"AppCatalog.ReadWrite.All",
"AuditLog.Read.All",
"ChannelMember.ReadWrite.All",
"ChannelMessage.Read.All",
"ChannelMessage.Send",
"ChannelSettings.ReadWrite.All",
"Chat.Read",
"Chat.ReadWrite",
"Directory.AccessAsUser.All",
"Directory.ReadWrite.All",
"Group.ReadWrite.All",
"IdentityProvider.ReadWrite.All",
"Mail.ReadWrite",
"Mail.Send",
"Place.Read.All",
"Policy.Read.All",
"Reports.Read.All",
"SecurityEvents.Read.All",
"ServiceHealth.Read.All",
"ServiceMessage.Read.All",
"ServiceMessageViewpoint.Write",
"Tasks.ReadWrite",
"Team.Create",
"TeamMember.ReadWrite.All",
"TeamsApp.ReadWrite.All",
"TeamsAppInstallation.ReadWriteForUser",
"TeamSettings.ReadWrite.All",
"TeamsTab.ReadWrite.All",
"TermStore.ReadWrite.All",
"User.Invite.All",
"User.ReadWrite.All",
"AllSites.FullControl",
"AppCatalog.ReadWrite.All",
"AuditLog.Read.All",
"ChannelMember.ReadWrite.All",
"ChannelMessage.Read.All",
"ChannelMessage.Send",
"ChannelSettings.ReadWrite.All",
"Chat.Read",
"Chat.ReadWrite",
"Directory.AccessAsUser.All",
"Directory.ReadWrite.All",
"Group.ReadWrite.All",
"IdentityProvider.ReadWrite.All",
"Mail.ReadWrite",
"Mail.Send",
"Place.Read.All",
"Policy.Read.All",
"Reports.Read.All",
"SecurityEvents.Read.All",
"ServiceHealth.Read.All",
"ServiceMessage.Read.All",
"ServiceMessageViewpoint.Write",
"Tasks.ReadWrite",
"Team.Create",
"TeamMember.ReadWrite.All",
"TeamsApp.ReadWrite.All",
"TeamsAppInstallation.ReadWriteForUser",
"TeamSettings.ReadWrite.All",
"TeamsTab.ReadWrite.All",
"TermStore.ReadWrite.All",
"User.Invite.All",
"User.ReadWrite.All"
]
}

Additional Info

No response

Metadata

Metadata

Assignees

Labels

bugwork in progress

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions