7,673 questions
0
votes
0
answers
17
views
Re-Using schema across two projects in NODEJS SAPUI5 CAP FIORI
I am new to nodejs sapui5 fiori cap applications and I am trying to create two applications that use the same database schema, they are connected to the same database as it is part of a multi-step ...
- 386
1
vote
0
answers
25
views
How to get the context of a parent oDataService in an enhancement implementation?
We have a standard Fiori Application that is calling a pretty complex standard oDataService.
We have an enhancement implementation (ZCL_MYENHANCEMENT) that is called as part of the backend call from ...
- 197
0
votes
0
answers
17
views
The Data Services Request version '3.0, 3.0' cannot be parsed
We randomly (2-3 times a day) get the following error in 2 of our Fiori applications during the first GET calls (one of which is a simple $count). These apps are used hundreds of times per day, but ...
- 33
0
votes
0
answers
26
views
403 forbidden error while updating sharepoint list item using SPHttp client
Here I am trying to update the SharePoint list item using the SPHttps client, It is giving me the 403 forbidden error but I'm the global administrator of that site and have full control on the list.
...
0
votes
1
answer
41
views
Unable to Implement OData in Azure Function App for Excel Integration
I have working odata app service which I am currently using to get data to excel and power BI, but I want to implement the odata in azure function app v4 but I could not get the response in function ...
- 1
0
votes
1
answer
74
views
OData routing causing exception with versioned API endpoints
I have inherited a .NET 6 Web API project utilising OData and the Asp.Versioning packages. The versioning functionality was not 100% correct, and now that the project is required for more regular ...
0
votes
0
answers
24
views
SAPUI5 and OData: Passing user input value to import parameter of Function module
Fairly new to SAPUI5 and OData.
As a proof of concept exercise, I have created an SAPUI5 application via vscode that is calling an OData service (OData 2.0) from a SAP backend
The OData service has ...
- 23
0
votes
1
answer
59
views
Unable to Fetch Data from Custom Analytics Views in Azure DevOps API
I am trying to retrieve data from a specific Analytics View in Azure DevOps using Python. I am able to list all available views, including custom shared/private views, but I cannot fetch the actual ...
- 45
0
votes
0
answers
33
views
FetchXML query: How to search within a linked entity’s name field?
I’m working with a FetchXML query to retrieve data from Microsoft Dynamics CRM, and I need to filter the results based on a search term that should match fields from both the main entity and a linked ...
0
votes
0
answers
27
views
Potential issue with DateTimeOffset deserialization using Olingo for Java
I'm encountering an issue with the Olingo library when deserializing JSON payloads into OData entities, specifically with properties of type Edm.DateTimeOffset.
Here is the method we are using for ...
0
votes
0
answers
39
views
ASP.NET Core 6 Web API OData $expand command not working with EF Core 6 IQueryable with projection
I have an OData enabled API endpoint that retrieves data from an entity that has a one-to-many relationship with another entity. If the client wants the child entities included in the API response, ...
- 1
1
vote
0
answers
52
views
Implementing a dynamic $search using OData in ASP.net
I am trying to implement search algorhytm using OData. Ideally I want to take the user query, compare it to every string or GUID and give each entry a score, then sort the results and return them. (...
- 780
0
votes
1
answer
36
views
OData custom function returning a POCO with an entity fails to serialize
I'm stuck in .NET Framework 4.5 and an older OData (currently 7.8.2) version.
I have a few entities with "typical" OData controllers working fine as IQueryable returning some AR / AP ...
- 11
1
vote
1
answer
122
views
Fiori App Not Starting Locally with npm start
I'm trying to develop a simple SAP Fiori List Report application with SAP Fiori Tools and VSCode. My app consumes an OData service published in the SAP system.
When I try to start my application ...
0
votes
1
answer
22
views
OData v4 multiple level $expand
I'm trying to figure out how multiple level $expand option with "path" expand item is working.
I understand that the following request returns expand Trips from Russel's friends.
http://...
- 2,000
0
votes
0
answers
34
views
SAP SF Employee Central get text values for external codes
How do I get SAP SF Employee Central texts for codes?
In our project we read data from SAP SF (Success Factors) Employee Central via ODATA. We read the ODATA API Objects via f"https://{...
- 14.5k
0
votes
0
answers
37
views
Column Header text is not binding with custom model
In component.ts file inside constructor() or init() setting custom model like
this.getModel('customModel').setData({
"customColumn": "Column Title",
"...
- 2,274
0
votes
1
answer
60
views
LINQ Expression could not be translated when Using OData Framework with DTOs
I am new to Odata as well as EntityFramework, And I am trying to use OData with DTOs. My Entity Model have been defined something like
public Orders
{
public String OrderId{get; set;}
public ...
0
votes
1
answer
52
views
How to pass ODataQueryOptions to Mediator while allowing input for OData queries only in Swagger?
I'm using OData with ASP.NET Core and Mediator to handle filtering, sorting, etc. of my Person entities. In my controller, I have the following code:
[HttpGet]
public async Task<IActionResult> ...
- 37
0
votes
3
answers
121
views
How can I filter via Get-MgAuditLogDirectoryAudit (through the Microsoft Entra Audit Logs) for a specific IP address?
How can I filter for a specific IP address through the Microsoft Entra Audit logs?
I tried following two PowerShell commands:
Get-MgAuditLogDirectoryAudit -All -Property * -Filter "initiatedBy/...
- 617
1
vote
0
answers
34
views
using oData4 to pass a variable *by reference* when calling a code unit in Microsoft Dynamics Business Central
I am converting our code to communicate with Business Central using oData rather than SOAP to call pages, code units etc.
I am struggling with code units that require passing a parameter by reference -...
- 149
1
vote
1
answer
45
views
The path template 'X' on the action 'X' in controller 'X' is not a valid OData path template. Resource not found for the segment 'X'
I have been Googling and using Chat GPT and cannot figure out how to get rid of the above warning. Here is my code:
var builder = new ODataConventionModelBuilder();
builder.EntitySet<...
- 750
0
votes
1
answer
53
views
OData expand query does not provide the expected flat table
I am trying to retrieve data from an OData source ;
in this source there are related data that I tried to expand :
https://myurl.com/odata/Reporting/v1/SupplierOfferRows?$expand=Item&$select=ID,...
- 351
0
votes
0
answers
25
views
D365 Create multiple new ECO products
I need to create multiple products in an ECO header using OData. These products should appear with ChangeType "New" and Impact "New product". Using the UI that is possible without ...
- 28
0
votes
0
answers
23
views
How to Get Individual Responses for Each Insert in ODataBatch Execution Using Simple.OData.V4.Client?
I am using the Simple.OData.V4.Client library (version 6.0.1) to insert multiple accounts in a batch operation. Here’s the code I currently use:
var batch = new ODataBatch(client);
var ...
- 11
0
votes
0
answers
14
views
Pyodata multiple condition filtering
CAPACITY_PLAN = service.entity_sets.CAPACITY_PLAN.get_entities().select('NAME,DATE,CAPACITY')
CAPACITY_PLAN = CAPACITY_PLAN.filter((CAPACITY_PLAN.DATE >= (datetime.datetime(((datetime.datetime....
1
vote
1
answer
61
views
PowerBI Azure-Devops: query not showing links (as shown in Msft sample query)
When I try to use the Microsoft learning example to retrieve Devops workitmes and related items, only the parent shows up. No attributes concerning Linked workitems are shown.
Used code is the exact ...
- 19
1
vote
0
answers
23
views
OData The request matched multiple endpoints. Matches when Delete request
I'm implementing an OData controller in an ASP.NET Core project, and I've added a new HttpDelete endpoint to delete a person by their ID. However, when I send a DELETE request to the endpoint, I get ...
- 11
0
votes
0
answers
47
views
Update NavigationProperty in SAPUI5 with OData V4 Model (with ASP.NET backend)
I'm using SAPUI5 with an OData V4 Model with ASP.NET as a backend.
I have Reservations which have a stauses. I need a functionality that the user can change the Status of a Reservation. All statuses ...
0
votes
0
answers
26
views
Using OAuth2 in ODataV4 / getting Token asynchronously
I've got an OData connected service for V4 generated through a metadata file.
Since the service requires OAuth2, I have to obtain the token asynchronously from a web server before sent any message.
In ...
0
votes
0
answers
12
views
Isssue with Accessing Nested OData Feed Outside Power BI – Nested Data Null in Browser/API Call
I am having trouble accessing nested data in a oData feed via anything other than PowerBi.
I have an OData feed, which I am opening via OData.Feed in PowerBi, opening https://xxxx/reports/api/v2.0/...
0
votes
0
answers
65
views
How to Mock a Batch Response from an OData DataServiceContext
I am in the process of writing unit tests for a .NET FW 4.8 project that connects to an API using the OData.net library. The project uses a DataServiceContext to send batch requests and receive ...
- 13
0
votes
0
answers
105
views
Dynamics 365 Delta Link expiration and Delta Token structure
I have successfully setup Dynamics 365 to allow change tracking for a specific table.
On each request, the API returns the delta link to retrieve the subsequent changes. The delta link contains the ...
- 338
0
votes
0
answers
48
views
Group and Count records by owner with OData in Dataverse
I want to count records grouped by owner, e.g. to answer the question: How many tasks are owned by which user?
I tried this and failed:
https://org82a557aa.crm4.dynamics.com/api/data/v9.0/...
- 268
0
votes
0
answers
18
views
cdata connect (OData) stored proc error "code": "consumSpRS"
Using CData Connect to expose Oracle STORED proc, I just get a java exception for which I cannot find any fixes for.
*[ODATA][2024-11-07T04:38:30.065Z][ERROR] rssbus.RSBException: [rsb:load_operation] ...
- 872
0
votes
0
answers
253
views
How to expand all entities in an OData GET request in SAP SuccessFactors
I'm using the Postman app to make a GET request to an OData service. I have more than 100 entities in my OData model, and instead of specifying each one individually, I want to expand all of them in a ...
0
votes
1
answer
128
views
When OData apply ODataQueryOptions<T> in .NET 8?
Help me understand when Odata applies query parameters to IQueryable?
The task is as follows: it is necessary to get the result of the query execution to the database before sending it to the client.
...
0
votes
1
answer
96
views
How to filter a ComplexTypeCollection field in Azure Search to find records containing specific text?
I'm using Azure Search and have an index with a field of type ComplexTypeCollection called ComplexField. Each item in ComplexField has a text property called TextProperty.
I would like to know how to ...
1
vote
0
answers
26
views
In odata V4 filter empty array
Url:odata/Machines?$expand=item
Output is like:
[
{
"id": 2,
"item": [
{
"id": 9,
"prod_order_id": 9,
},
]
},
{
"id": 1,
"item": []
},
]
In ...
- 25
0
votes
1
answer
43
views
Connecting to OData API iteratively each time with a different URL in Fabric
I am trying to connect to OData API from Fabric, I wanted to call different URLs iteratively passed dynamically to the OData and as a result we receive tables. Among them we wanted to select few ...
0
votes
1
answer
82
views
SAP Odata ABAP standard stack calls
I tried to debug the ABAP stack of an OData service, and I see there is this call which is taking more time which is called as "Load MPC class" same with all the DPC and DPC_EXT classes, ...
0
votes
0
answers
41
views
Can't serialize properly using a Custom ODataResourceSerializer when using $select or $expand
I created a custom OData Resource Serializer as part of the migration into dotnet core 8 and OData 9
This was mainly to maintain out previous syntax and support Geometry type from SQL spatial and NTS.
...
- 67
2
votes
0
answers
36
views
Cannot convert between Data entity and Domain entity IQueryable with Automapper for OData endpoint
I am trying to convert my data entity IQueryable to domain entity IQueryable in my repository class. The Find() method is used by OData to apply filters. The problem is, when I send an OData query ...
- 21
0
votes
1
answer
150
views
How to get error message for submitBatch with OData V4 in SAPUI5
When creating new entities in SAPUI5 using submitBatch for a OData V4 service, messages can be read using getMessages() for the bound context. This will however not return any technical messages.
For ...
- 63
0
votes
0
answers
70
views
.Net 8 Nullable String Parameter set to "Microsoft.OData.ODataNullValue" instead of null
Recently migrated our project from .NET6 to .NET 8. During the process we also migrated our ODATA 7 from 8
Microsoft.AspNetCore.OData from "7.5.12" to "8.1.0"
I'm trying to keep ...
1
vote
0
answers
57
views
Getting Error when trying to access Dell redfish api via .net OData Client
I am trying to use the ODataClient lib (https://github.com/OData/odata.net/tree/main). But when I am connecting to the iDrac (Redfish) I am getting following error.
...
- 1,401
0
votes
1
answer
84
views
Filter using child fields to return parent with non-empty nodes
I am trying to fetch nested json structure using filters inside $expand on entities at more than one level. The Odata(OData v4.0) query looks as follows:
https://{{context-path}}/Workers?$select=...
0
votes
0
answers
54
views
Microsoft D365 OData Invalid URL with entity that has composite key
I'm attempting to use OData to retrieve and/or delete specific records in the BillOfMaterialsVersionsV4 entity. The following defines the composite key:
<Key>
<PropertyRef Name="...
- 2,813
0
votes
0
answers
227
views
SAP Odata Metadata Cache
As we know, we clear the metadata of OData services after every deployment or release. Clearing the metadata cache using a few standard UI5 programs has been very helpful. However, we are experiencing ...
0
votes
0
answers
58
views
Batch call in chunks to post data in bulk in Fiori
I am trying to upload an excel with having ~3000 line items. To upload that, I am trying to have a batch call and posting data in chunks of 100 line items. The batch calls are getting successful. The ...
- 23