ExecuteOdata function SAP Cloud Application Studio

[former_member197479]

Some months ago, I created an entry in my blogs regarding the SAP Platinum Engineering Libraries where I explain my personal experience dealing with those libraries, after raising an incident to SAP asking for an specific function, I would like to know if someone has been able to work around it.

The so-called function name is Odata.ExecuteOData() which is supposed to execute a report's Odata feed, however, again, not even SAP came up with ideas about it, and they ended up suggesting to ask the community.

It receives two parameters, 1. Report (Which is a text) and 2. Filter.

Needless to say, I tried a lot of different ways and no one worked

Here some examples of what I tried:

Report: ID of Report in ByD
Filter: OData syntaxis of filter

Report: URL of report in SAP ByD
Filter: OData syntaxis of filter

Report: Name of Report in SAP
Filter: OData syntaxis of filter

Report: Name of Datasource in SAP
Filter: OData syntaxis of filter

So, I would appreciate if someone made it work, please share your experience and I'll be forever grateful.

Please find attached a screen capture of the library

____________________________________________________________

[Hanumath]

Melvin,

Even I am looking forward to this to work in the studio. Let's wait and see if someone responds on this.

Rgeards

Hanu

[former_member273288]

Hi Melvin,

Is this released for public use. you might want to check this by logging an incident. I had a similar query on the UserUtils API, but found out that it was not meant for public use and can only be used from within SAP. Please let us know if you hear more about this.

Thanks

Asif

[former_member587388]

Hi melvin.hidalgo.

I noticed on OData queries (generated with the feature "Build OData Queries"), the ReportID has the prefix RP.

For example, for report Z05674894, the OData consumingURL is https://myXXXXX.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPZ05674894QueryResults

I assume RP is for report. Maybe you can try adding the prefix on the first parameter.

Hope it helps.