Custom report data not available through SAP ODATA service

[prateekkr]

Hello,

I'm using the following link to get the report data -

https://myXXXXXX.crm.ondemand.com/sap/byd/odata/cc_sales_analytics.svc/RPRPZA9689DXXXXXXXXXXBBQueryR...

Although, the standard report is available through the same link but custom one is having issues.

We have a custom report which should be retrievable through standard odata service. I'm getting an error saying :

{"error":{"code":"00145E5B1CC71EE0ACBD33E944B1819D","message":{"lang":"en","value":"Report RPRPZAXX689XXXD9E5F5XXX8CBB not found"}}}

[VinitaSinha · Accepted solution]

Hi,

Have you checked if your report is available in the standard WoC (I'm assuming its the standard Sales WoC) - Eg

https://my3xxxxx.crm.ondemand.com/sap/byd/odata/cod_sales_wcf_analytics.svc

If it is available, it should be first listed here, then you can use the Report ID to execute and get the data. Ensure that the reports is in an assigned state

Later, you could try executing like

https://my3xxxxx.crm.ondemand.com/sap/byd/odata/cod_sales_wcf_analytics.svc/RPCODOPPU_Q0018QueryResu... (Use your custom Report ID)

Cheers !

Vinita