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.

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

ODATA custom data

I am fairly new to using Project online queries for ODATA but have had quite a bit of success in getting the information I need except for custom data fields. If I do the extract for RISKS for ...
1
vote
0answers
29 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 ...
0
votes
0answers
16 views

Call Azure Web API with External Content Type Sharepoint Online

I want to call the Azure Web API (OData) with an External Content Type (BDC Model) in Sharepoint Online, but I'm stuck trying to figure out if this is even possible since I can't find a way to handle ...
1
vote
0answers
47 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, ...
0
votes
1answer
80 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
0answers
140 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&$...
0
votes
0answers
81 views

Filter expanded properties with the REST API

I am trying to query a folder recursively for files that were created after a certain date. I am able to find the files by expanding file properties however I am unable to filter against the expanded ...
0
votes
1answer
43 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-...
0
votes
1answer
56 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/...
0
votes
0answers
21 views

Use $search to search for words inside a multi line text (application credentials)

In my scenario, I need to search for items in a document library using the Graph API. This items have certain properties which are multi line text columns and are correctly configured as "Managed ...
1
vote
1answer
272 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&...
0
votes
1answer
46 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://...
0
votes
0answers
153 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" ...
0
votes
0answers
19 views

_api/search/query return 0 results always

I have a problem with my response i always getting 0 results. Its happen not only in my api response, but also if i searching directly in sharepoint. This is the api: http://myweb/_api/search/query?...
0
votes
1answer
84 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
2answers
164 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-...
0
votes
0answers
43 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=...
2
votes
1answer
1k 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 ...
2
votes
1answer
214 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 ...
0
votes
1answer
24 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 ...
1
vote
1answer
158 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')/...
2
votes
0answers
54 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 ...
0
votes
1answer
217 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
1answer
590 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(...
2
votes
1answer
755 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 ...
0
votes
1answer
317 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
vote
0answers
84 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 ...
0
votes
1answer
46 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 ...
1
vote
1answer
2k 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 ...
0
votes
2answers
680 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
1answer
45 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
2answers
445 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
1answer
3k 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=...
1
vote
0answers
89 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?
1
vote
0answers
102 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 ...
0
votes
1answer
5k 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
1answer
413 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 ...
1
vote
2answers
598 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')...
0
votes
1answer
792 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 ...
4
votes
2answers
125 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 ...
0
votes
1answer
740 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 ...
0
votes
1answer
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
0answers
188 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 ...
0
votes
1answer
109 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 ...
1
vote
1answer
2k 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
1answer
415 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 ...
0
votes
3answers
307 views

Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig

I've already tried powershell to reset the throttle value as well as disabled it completely: This disables a throttling rule. Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false ...
2
votes
1answer
900 views

Column 'ServerRedirectedEmbedUrl' does not exist. Rest odata SPOnline

I'm trying to get documents from a document library where ServerRedirectedEmbedUrl not equal empty, I'm trying something like this: https://my-sharepoint/sites/mysite/_api/lists/getbytitle('Documents'...
1
vote
0answers
575 views

Cannot orderby descending in SP2010 REST

Using orderby in an SP2010 Rest call (listdata.svc) doesn't seem to work. Irrelevant of the selected field (Id, Modified... etc), I can't sort in descending order (desc) the return using desc using ...
1
vote
0answers
32 views

In ODATA resource path I want to order by InvoiceNo in ascending order. Without using sorting method in query only using order by how it's solved? [closed]

Invoice number:1,2,3,10,11,21,22,31,13 My query is: resourcePath = [NSString stringWithFormat:@"SSInvoices?$Orderby=InvoiceNo asc &$filter=SoldToID eq '%@'", [[NSUserDefaults ...