Skip to Content
0
Aug 13, 2022 at 06:16 PM

C4C ODATA REPORT NOT RETURNING RECORDS

417 Views

C4C ODATA REPORT NOT RETURNING RECORDS

Hello, we followed the steps to configure a custom visits report and expose it through ODATA services; but is not returning any information, just a blank row.

User configuration

We created a new business user C4CODATA1Q and give it permission to the following work centers:

  • Analysis
  • Business Analytics
  • Visits

c4c-odata-01.jpg

c4c-odata-02.jpg

Report configuration

We created a new report in the Business Analytics work center and assigned it to the Visits work center.

c4c-odata-03.jpg

Then we generated the ODATA URL for the report and try to access over ODATA source feed in POWER BI using the C4CDATA1Q.

c4c-odata-04.jpg

We only get one empty row of data.

c4c-odata-05.jpg

If we test the same report login in to C4C with the same C4CODATA1Q user; we get information with no problem.

c4c-odata-06.jpg


Is there any missing configuration or permission to be assigned for the ODATA report access??

Thanks a lot.

Daniel Gordillo

Attachments

c4c-odata-01.jpg (220.7 kB)
c4c-odata-02.jpg (276.8 kB)
c4c-odata-03.jpg (224.2 kB)
c4c-odata-04.jpg (360.4 kB)
c4c-odata-05.jpg (305.9 kB)
c4c-odata-06.jpg (170.1 kB)