Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. API for download XLS file with Time tracked report

API for download XLS file with Time tracked report

Added by M V over 1 year ago

Hello,
I send last week's reports (with XLS attachment) of activities to my customers every Sunday. It's manual and annoying work.
I want to automate it using API.

Now I'm using https://xxx/cost_reports/12 from a web browser with custom-defined filters and clicking on the button "Export XLS".
Can I do it via API? I read https://www.openproject.org/docs/api/endpoints/, but I cannot see any usable endpoint.

Thanks for your help.


Replies (1)

RE: API for download XLS file with Time tracked report - Added by Jan H over 1 year ago

The API returns JSON. You would have to build your own service or script to transform the JSON data to your needs. Languages such as Python or R might do the trick for you.

  • (1 - 1/1)
Loading...