Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
1answer
20 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 ...
0
votes
0answers
9 views

How can I upload information in PowerBI from Sharepoint lists of more than 5000 items?

We have a list that has exceeded the threshold of 5000 items. We want to do operations with PowerBI with the elements of that list but we are not able to load the information due to the threshold of ...
1
vote
1answer
36 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')/...
1
vote
0answers
36 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
65 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
157 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(...
1
vote
1answer
52 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
89 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
44 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
36 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 ...
0
votes
0answers
36 views

Its possible to get the odata of project using sharepoint workflow?

I am trying to do a http call to project odata _api/ProjectData/Projects, but when I run the workflow I always get access denied, even using app step. Here is an error bellow: {"error": {"code": "- ...
0
votes
0answers
14 views

Add controller to SharePoint 2013 farm solution

I am trying to create an Odata service for SharePoint 2013 farm solution. I tried installing Simple.OData.Client via script manager but I do not see any option to add the controller. I tried the ...
1
vote
1answer
947 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
320 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
44 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
244 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
1k 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
69 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
96 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
3k 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
0answers
265 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
460 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
598 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
107 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
464 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
1k 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
176 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
92 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
948 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
296 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
258 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
595 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
473 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
31 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 ...
2
votes
1answer
9k views

REST API Getting Fields from an Lookup List

I have a REST query that looks like this /_api/lists/getbytitle('MainList')/items?$select=Title,LookupField/Id,LookupField/Title&$expand=LookupField That works fine. But when I try to pull ...
8
votes
2answers
3k views

Why can I not filter it inside my REST API end point

Inside my Projects list, I have a lookup column named ProgrammeRevissionId that is referenced to my Dept list. When I define the following REST call: http://.../_api/web/lists/getbytitle('Projects')/...
0
votes
2answers
45 views

Two part question concerning AJAX / OData

So in a custom .aspx form, I use an AJAX call to get current list item data. When I copy "MYSITE" into my browser, I get a page that looks like a blank RSS feed. Any idea as to why this is? The code ...
4
votes
3answers
4k views

Sharepoint REST api - Recursively fetch all folders in a document library -

I have a set of folders say Folder1 containing Folder2 and Folder3. Folder3 contains Folder4, Folder5 and Folder6. When i use the OData expand parameter - $expand=Folders/Folders i get only details ...
1
vote
1answer
587 views

OData Query Options for SPO List Attachments

I am using SSIS with an OData source to pull SharePoint Online 2013 List data into a SQL table. I'd like to filter on the Attachments boolean but can not figure out how to query it. I saw that an ...
2
votes
1answer
396 views

Failed to create list item for external list using REST API POST

I've AN OData API, which I'm consuming in SharePoint via BCS and External List. I already have the Get and Update functionality working using REST API to external list. But when I try to add an item ...
1
vote
1answer
5k views

Get data from SharePoint Folder using Power BI

Can I show image and meta data details from SharePoint online asset library in PowerBI report, I tried to use SharePoint Folder as data connection but I got this error : Unable to connect : ...
0
votes
1answer
607 views

Sharepoint 2010 List Lookup values in ODATA

It's a common case that you use lookups in your list. When using ODATA, Is it possible to include the actual value of the lookup instead of the (other) SharePoint list item ID?
0
votes
1answer
155 views

New oData Feed in PWA

Is there a way to create a new oData feed in PWA? I would like to build a new custom list that has similar properties to the issues/risk lists in that it would have its own oData feed. Thanks!
1
vote
2answers
156 views

SharePoint 2013 custom list attachment link

I am creating custom form in jQuery and HTML5. I am using rest api for getting data. I am fetching attachment also and generating dynamic string with HTML code with jQuery. Every thing goes fine it ...
0
votes
1answer
447 views

Convert CAML queries to OData Filters

Is it possible to convert complex CAML query to OData filters so that I can use them in REST APIs? Some CAML queries have nested condition and multiple values to be passed in IN operator. Also, ...
1
vote
0answers
246 views

How can I filter a REST query when the field's name is translated?

I have the following query : /_api/Web/Lists/GetByTitle('Discussions list')/Items?$filter=ContentType eq 'Discussion'" This works perfectly while my profile is set to English. When I'm set to ...
4
votes
1answer
2k views

Rest filter startswith(ContentTypeId,'0x0101') not working

This is driving me crazy, but I think it's an issue on my sharepoint online. Why the heck this is not working? /_api/web/lists/getByTitle('Documents')/items/?$filter=startswith(ContentTypeId, '...
0
votes
1answer
240 views

SharePoint Rest API and Javascript Issue

I am using SharePoint 2013 Enterprise. I have 3 List. Now I am creating custom form which fully in jQuery and javascript. From the 3 list, 2 list works as detail so I have two tables where we can add ...
1
vote
1answer
2k views

Uploading File with rest api and HTML5 api

I am using SharePoint 2013 on premise. I am trying to upload file to the custom list from custom webpart purely jQuery and javascript. In my form I have hyperlink, when I click on it, it will open ...
5
votes
1answer
3k views

Sharepoint REST Api OData Version?

Can anyone tell what is odata version used by SharePoint REST Api? I am asking because I tried to run the Nested Filter in Expand supported by OData V4. http://www.odata.org/getting-started/basic-...