How to download canvas reports using REST api

[former_member833839]

I want to extract employee data from SFSF using REST api.
I have read the rest api reference from SAP but could not figure it out.
It seems that the report is extracting items from several tables, but the only table that I am currently able to download with the api is the table that is the source of the report.
For example, emp_job,per_personal, etc.(Now using url is "https://api10.successfactors.com/odata/v2/{entity})

Also, the canvas report is downloaded manually, and I think I can download it using REST api, but I don't know how to do that.
Any answers would be appreciated.

Thank you very much.

[nlgro02343]

I'm reading 2 very different things here as Canvas and REST API are completely unrelated. First things first, a canvas report is just a report that you generate, this is not to be read via an API in my knowledge. Technically you can schedule a canvas report to an SFTP (as described here 2850967 - Scheduling Canvas Reports via Report Distributor to Export with XLSX Format (sap.com)), and then pick it up from there, but often times the format is not desirable.

The Rest (also known as Odata or Restfull) API is commonly used to read a specific entity (i.e. PerPerson) and to potentially use Navs to navigate from a starting entity (such as PerPerson) to other entities (i.e. employmentNav --> EmpEmployment, jobInfoNav --> EmpJob) to other entities. This may seem slightly similar to canvas in the way it builds up data, but it's actually not. With Canvas reports you can apply different date filterings on the extra entities, for REST data, you will only get data that's applicable for today's date in the Nav Entities (hence it's a lot less powerful). Additionally, you can for instance apply more filterings and calculated columns in Canvas, which you cannot with the REST API.