Questions tagged [odata]
OData is a standardized protocol for creating and consuming data APIs. OData builds on core protocols like HTTP and commonly accepted methodologies like REST. The result is a uniform way to expose full-featured data APIs.
149 questions
0 votes
1 answer
362 views
how to upload a file to a document library using OData in PowerShell with curl or Invoke-RestMethod
As I cannot use Pnp.PowerShell with a SharePoint-2019 on premise, AFAIK, I've been trying workd with OData instead, using curl (or PowerShell Invoke-RestMethod or falling back to JavaScript fetch if ...
- 13
0 votes
0 answers
75 views
Check if user has custom permission level using REST API via OData
I am currently have a custom permission level called 'Special Permission'. In my webpart, I want to detect if the current user is part of any SharePoint group that has 'Special Permission', and ...
- 286
1 vote
1 answer
2k views
Get Items returns no data
I just had a question about an issue I am facing: I am attempting to return some items from a SharePoint list for a flow on Power Automate. Currently, I'm attempting to retrieve the data for a ...
- 13
0 votes
0 answers
1k views
SharePoint REST api ODATA filter on nested array properties
I am trying to call SharePoint REST api with $expand and would like to filter on inner array object in the JSON. I tried few filter options but getting error for each of them. Error: The expression &...
- 1
0 votes
1 answer
1k views
Filter SharePoint list by multichoice column for exact match
If I run a query .../_api/web/lists(<GUID>)/items?$filter=Field eq 'Option1' then it returns all items containing Option1 in multi-choice Field including: [Option1], [Option1, Option2], [...
- 103
0 votes
1 answer
684 views
How to send a CAML Query with curl?
I've been using a CAML Query for getting all files in a document library in SharePoint 2013. I used PnP with PowerShell for this purpose, but as I would like to get all files on Linux. I think it's ...
- 103
0 votes
1 answer
198 views
How to determine if a RoleDefinition grants read access or not?
I have the role definitions like this: https://YOUR_TENANT.sharepoint.com/sites/YOUR_SITE/_api/web/roledefinitions So this will return something like: {_ObjectType_=SP.RoleDefinition, _ObjectIdentity_=...
0 votes
0 answers
216 views
ODATA Filter for lists/libraries using TemplateFeatureId guid property
24Hrs into learning about OData queries for a SP project that was dumped on me. I can get the data i need from _api/web/lists?$select=Title,TemplateFeatureId,Author&$expand=Author But I tried to ...
0 votes
1 answer
1k views
How to send email notification for list items that have expired or will expire in the next 30 days using OData Filter Query?
This started as a question, but I figured out the answer as I went, so just posting for reference. Desired Behaviour Use the OData Filter Query field in the SharePoint Get Items action in Power ...
- 264
0 votes
1 answer
1k views
What query to use ti get recent files from a particular document library - Graph Api
I'm wondering if anyone has had to do a similar thing to be able to get all recent files from a particular site collection of sharepoint library To get lists used i know i can use this - https://graph....
- 4,368
1 vote
0 answers
230 views
OData query to get a field values by column position in the list
So I want an OData query that allows me to get the field and its values by position in the viewable list. In the above picture, for example, I want the values in the "Title" column but that ...
- 13
1 vote
0 answers
398 views
Project Online OData Source - SSIS
I have an MS project online environment and I want to replicate all data from online to our SQL servers. I found this article to do this with VS2012. I'm using VS2019 and SSDT, SSIS, SSAS extensions, ...
- 1,737
0 votes
1 answer
725 views
How do I access Sharepoint list data from a custom spfx webpart?
I'm trying to get all list items from a list on the same domain as the client-side spfx web-part. It's a pretty basic call via the REST API, however the information being returned doesn't match that ...
0 votes
0 answers
714 views
SharePoint REST API - odata $expand is not working on a specific site
I am using SharePoint API to get list items. One of the fields is User Picker. The query looks like this: /_api/web/lists/getByTitle('Actions')/items?$select=AssignedTo/Id,AssignedTo/UserName&$...
- 66
0 votes
1 answer
480 views
Get country from people and groups field using rest API
I was able to get details from people and groups using rest api and with the help of the below link. https://ajaznusrat.wordpress.com/2012/06/21/using-the-sharepoint-user-type-field-people-or-group-in-...
- 1,473