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
10 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 ...
2
votes
1answer
3k views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed this to create app ...
2
votes
1answer
2k 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 ...
0
votes
0answers
6 views

Sharepoint 2016 Tasks List Extract to Excel with OData - Missing "assigned to" Columns

I'm new at this. I'm working with Sharepoint and Excel 2016. I'm extracting a tasks list and a schedule from Sharepoint by making a OData Data Feed connection. the link of the connection has this ...
0
votes
1answer
887 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?
1
vote
1answer
1k 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 ...
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 ...
25
votes
4answers
62k views

Expanding columns in lookup fields

Using the SharePoint 2013 REST API, Can I get more than one column from the lookup column by using the $select and $expand endpoints?
5
votes
2answers
1k views

REST API ItemCount on oData BCS List

I have a list generated from a BCS oData provider and I am attempting to get the number of items in the list so I can generate a $top on my request rather than bring back only the 100 item generic ...
7
votes
4answers
10k views

REST API + Expand Recurring Calendar Events?

Is there a way using the REST API (through javascript) to expand recurring calendar items? Or is there a helpful client side utility to assist with this?
1
vote
2answers
3k views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at http://sampletenant....
0
votes
1answer
154 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 ...
0
votes
1answer
381 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 ...
0
votes
0answers
39 views

Getting access denied when using this graph api "https://graph.microsoft.com/v1.0/me/insights/used"

Not sure if someone can guide me here. I can use all other endpoints apart from this one "https://graph.microsoft.com/v1.0/me/insights/used" The doco here I have tried everything and i'm 100%...
0
votes
1answer
57 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....
1
vote
0answers
106 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 ...
7
votes
3answers
9k views

SharePoint 2013 and anonymous access problem

We run into following problem: We have application, that makes authenticated calls to sharepoint 2013 REST services (PUT and GET). Everything works well, when anonymous access is turned off. But we ...
0
votes
0answers
11 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
53 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
23 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
136 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
222 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 ...
3
votes
1answer
521 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 ...
0
votes
0answers
232 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&$...
1
vote
1answer
249 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')/...
0
votes
1answer
103 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
81 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
1answer
473 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
79 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
422 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" ...
2
votes
1answer
264 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
119 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
225 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
54 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=...
3
votes
1answer
2k views

Authenticating to Office 365 vNext with Multi-Factor Authentication enabled

I am looking for any working examples of remote CSOM or SOAP OData calls against Office 365 with multi-factor authentication enabled. The available documentation is unclear on this scenario. I think ...
0
votes
1answer
31 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 ...
4
votes
2answers
4k views

REST Api Filtered odata returning error: list view threshold

Why does the first query runs ok and the second throws list view threshold error? Note that it's a regular SP.ListTemplateType.tasksWithTimelineAndHierarchy List with Id and PercentComplete as ...
1
vote
1answer
622 views

BCS create an item returns: The remote server returned an error: (500) Internal Server Error

I am using a SAP web service and I am using BCS to get the external data. However, when I try to create a new item via code I get this error: Stack trace: The remote server returned an error: (500) ...
1
vote
3answers
726 views

rest query orderby takes null as 0

I am making an ajax call to get the list data in SharePoint 2010 I am using orderby to sort based on a column http://PC:2010/site/_vti_bin/listdata.svc/listName?$select=ThumbnailImage,Created,...
4
votes
3answers
8k 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 ...
2
votes
0answers
60 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
vote
1answer
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 ...
0
votes
1answer
285 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
820 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
1k 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 ...
6
votes
6answers
6k views

Folder creation in Document library using listdata.svc

Do you have any tips how can I create a new folder in a document library using listdata.svc (OData REST interface of SharePoint 2010) from JavaScript? SP creates a new file instead of a folder. I can ...
5
votes
1answer
3k views

$inlinecount and $count missing in new OData API?

can anybody verify that in the new OData endpoint of SharePoint 2013 found at /_api/ does not implement the keywords $inlinecount and $count? ListData.svc has it implemented. Example: /_api/web/...
0
votes
1answer
60 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
2answers
807 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 ...
3
votes
1answer
465 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 ...