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.
148
questions
0
votes
0
answers
22
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
255
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
590
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
514
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],
[...
- 101
0
votes
1
answer
404
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
145
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
123
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
910
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 ...
- 214
0
votes
1
answer
781
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,232
1
vote
0
answers
156
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
272
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
468
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
520
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
378
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,453
0
votes
1
answer
138
views
Sharepoint REST API - Filter by Negative Number
I'm trying to filter by a negative number but it only seems to work with zero or positive. Does anyone know how to fix this? My query is below:
spUrl + '/SitePages/checklist.aspx?filter=ChecklistID/...
1
vote
1
answer
938
views
OData Query for Azure Data Factory SPO List Connector Doesn't Return Expected Results
I am trying to run an OData query via a SharePoint Online List connector in Azure Data Factory, here is my query:
$select=Id, ProjectId, Project/Id, Project/Title&$expand=Project
"Project&...
- 111
0
votes
1
answer
205
views
Excel import OData feed URL from SharePoint 2016 get 401 error
I want to establish an OData datafeed in Excel 2013 to connect to a SharePoint 2016 list.
In the Excel, data tab -> from other source -> from OData datafeed. Then I input our SP2016 url:
https://...
- 4,065
0
votes
0
answers
1k
views
Unable to select nested array in JSON object with Microsoft Graph
Given the following Graph call response of https://graph.microsoft.com/beta/sites/root:/sites/[siteTitle]:/lists/[listId]/Columns, how can I only return/select down to the array "choices" ...
- 563
0
votes
1
answer
150
views
Unable to retrieve data from multi-select “Choice” SharePoint control using listdata.svc
I'm able to connect to a SharePoint 2019 list using the listdata.svc service.
Problem is, if the control for a column is of the "Choice" variety, with multiple selections allowed, the data stored in ...
4
votes
2
answers
545
views
How to get details of editor of SharePoint site file?
I am working on SharePoint notifications using webhooks. I tried the following POST request.
https://xxxxx.sharepoint.com/_api/SP.AppContextSite(@target)/web/lists('2c955ea0-28h4-4f84-a8b5-...
- 143
0
votes
0
answers
101
views
Identify Parent Tasks
I'm retrieving Tasks associated with a Project via the OData query.
https://XXX.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=Id eq guid'xxxx'&$select=Id,Name,StartDate&$expand=...
- 123
2
votes
1
answer
4k
views
Multiple $filter in OData query
Here is my OData query:
https://XXX.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=Id eq guid'xxxx'&$select=Id,Name,StartDate&$expand=Tasks&$select=Tasks/Id,Tasks/Name
I ...
- 123
2
votes
1
answer
437
views
How to order by modified (desc) and remove duplicate results in SPO List Datatable
Below is a working datatable for my SPO list called Companies. There are some duplicates in this list, but I want all of the duplicates removed. I have attempted the solutions on the DT site, but ...
- 123
0
votes
1
answer
34
views
Sharepoint Foundation REST interface, updating an object fails
I'm using the REST interface detailed here -https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ff521587(v%3Doffice.14)
As a proof of concept, I'm trying to access an ...
- 101
1
vote
1
answer
374
views
Change Sharepoint task parent id via REST
I'm trying to move a subtask from one parent to another. I could change the tasks name with such a PATCH query:
PATCH /sites/PWA/_api/ProjectServer/Projects('4b951130-e0b9-e911-910f-001dd8b71c8d')/...
- 21
2
votes
0
answers
86
views
Odata query returns 401
I'm working with the SharePoint 2016 OnPremis OData Rest Api. The filter parameter is defined followings:
$filter=Art/Value eq 'aString' and year(Received) eq 2019
Art is a choice value and Received ...
- 1,189
0
votes
1
answer
439
views
PWA Workflow gets Access Denied for API Call to get Assignments
I have a SPD 2013 Workflow on our PWA site that has been working fine for 6 months.
My colleague has left the business and Admin have disabled his 365 account.
Suddenly, the Workflow is failing and ...
0
votes
1
answer
1k
views
Reading Sharepoint List in SPFx - ForEach not working
I have no idea how to read Sharepoint List Data in SPFx one by one.
JavaSript console returns me an error: Uncaught (in promise) TypeError: item.forEach is not a function.
private ReadAllCountries(...
- 3
2
votes
1
answer
3k
views
Is there a limit of conditions count for oData query using $filter?
I have a long $filter query like ID eq 1 or ID eq 2 or ID eq 33 or ID eq ... and it works like a charm when we have up to 159 conditions joined by or.
But, when I add one more condition (started from ...
- 23
0
votes
1
answer
528
views
ODATA: Unable to expand Attachments from SharepointOnline
My objective is to use SSIS with an ODATA source to connect to a Sharepoint Online list. My aim is to extract the ServerRelativeUrl for the attachments of all items within the list.
I'm as yet unable ...
- 1
1
vote
0
answers
181
views
Replacing the SSIS SharePoint List Source
Hi I've been trying at this now for a day or so but it's proving really difficult.
I've got a basic SSIS package which essentially queries some SharePoint lists (lists with files) and drags out the ...
- 187
0
votes
1
answer
117
views
sharepoint rest api sitecollections
I use the following API
https://.sharepoint.com/_api/search/query?querytext='(contentclass=STS_Site)'&rowlimit=500
for getting the site collection, but it seems to miss site collections.
for ...
- 41
1
vote
1
answer
3k
views
Sharepoint 2013 REST API GetFolderByServerRelativeUrl will not return the Author details
I looked over other answers that was having the same problem, but those answers don't seem to resolve this problem. How can I get the request to include the Author name? Although, this request returns ...
- 43
0
votes
2
answers
1k
views
CAML Query vs Odata Query string operators
For getting SharePoint list values through rest. I came through two solutions
writing CAML Query in the body of AJAX call
Odata query selector operators(eq: select,expand) in the url
...
0
votes
1
answer
77
views
When calling SharePoint REST OData api, what is the biggest value allowed by $top?
I am making calls to get all sub-sites of a site collection using:
${siteCollectionUrl}/_api/site/rootWeb/webinfos
But there are 1000's of them. So I need to get them in pages using the $top and $...
0
votes
2
answers
560
views
Downloading data from over 90 SharePoint Team sub-sites
I`m working on a reporting project that mainly uses data sourced from 6 different lists replicated on over 90 SharePoint Online sub-sites handled by a global team in my organization. These sites are ...
0
votes
1
answer
6k
views
System.UnauthorizedAccessException Access Denied REST
Wondering if anyone can help me please, I have some REST code getting all the webs for a site collection, this looks like below:
url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/webs?$select=...
- 646
1
vote
0
answers
104
views
Get filtered projects list by applying filters on its fields SharePoint Online CSOM
How to get filtered projects list by applying filters on its fields SharePoint Online CSOM.(by using OData or something?)
can it be possible using OData?
- 323
1
vote
0
answers
104
views
Accessing SharePoint online data in SQL server using Odata feed
I tried accessing data from SharePoint's project web app using admin account(with full control) in excel using Odata feed. I was successful.
But when I tried to replicate the same thing with Sql ...
- 2,406
0
votes
1
answer
9k
views
How to get items from a SharePoint List by list URL path using Javascript REST API?
Using JavaScript REST API, we can get a list by URL path. Thus:
http://vmdevsharepoint:12345/_api/web/lists/
Concatenating with this:
?$expand=RootFolder&$filter=RootFolder/ServerRe...
3
votes
1
answer
764
views
What is the purpose of "EntityPropertyName" property of field?
I am getting all list fields using REST API, In result, I found there is "EntityPropertyName" property for each field.
For some fields, it shows exactly same value as "InternalName" property But for ...
- 3,085
1
vote
2
answers
893
views
How to add aliases in SharePoint rest query?
I need a REST query to get field values in a SharePoint list. Internal name of the List is People and it has Id, Title, ShortName and Age columns. So REST Query is
_api/web/lists/GetByTitle('People')...
- 111
0
votes
1
answer
1k
views
Error while Refreshing Excel data using connection with SharePoint Online List
We have created a SharePoint list with 50000+ items in it which has different views.
We exported the same SharePoint list using Export to Excel functionality.
After that we created a dashboard on ...
- 521
4
votes
2
answers
134
views
Filter list with REST
I'm trying to filter a lookup column on my list using rest
this is the column on my list
it's a look up (connected to another list)
and my rest on the list
My query should get all the items that ...
- 73
0
votes
1
answer
1k
views
OData $expand not working for User Field in SharePoint App
I am trying to use the OData $expand query option to fetch the Title of a SharePoint User Field. The field name is, Author (Created By). However, on using the $expand option, I am getting the ...
- 215
0
votes
1
answer
2k
views
How to filter data where a field contains a something with OData
I'm trying to filter all the data using OData where the FileRef constains let's say '/sites/my_site/myfolder'for this I tried something like: $filter=substringof('/sites/my_site/myfolder', FileRef) ...
1
vote
0
answers
192
views
Connect from external list from different site collections via OData in SP Online
I am using SharePoint Online and I have followed the steps of the tutorial:
But the OData service url was the list of the second site collection.
https://myTenant.sharepoint.com/sites/Site ...
- 291
0
votes
1
answer
147
views
Sharepoint dll for querying an ODATA API
I would like to call an ODATA service from a Sharepoint add-in, I am following the tutorial here:
https://www.tutorialspoint.com/sharepoint/sharepoint_data.htm
I have installed the Sharepoint Client ...
- 103
1
vote
1
answer
3k
views
Use REST odata webservice to update a task's custom field in Project server
I've figured out how to update a Task's basic fields via the OData Rest service using POST (X-HTTP-Method=MERGE):
/ProjectServer/Projects('{#project}')/Draft/Tasks('{#Id}')
The post content is a ...
3
votes
1
answer
545
views
Using the OData endpoint to update or insert assignment in Project Server 2013 On Premise
Objective
Connect to Project Server 2013 in order to update an existing assignment of a resource to a task or create a new assignment for the resource in case it (the resource) is not assigned to the ...
- 135