Get projects (Excel)

post

https://{customerSubdomain}.smenso.cloud/skyisland/api/reports/projects/excel

Generates an Excel file with project data based on the selected view, filters, and optional body configuration. Use this endpoint to create portfolio reports that can be shared or further processed in Excel. The headers and globalProjectsFilter let you control which columns and projects are included.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Retrieve a view GUID

To export data, you must first create a list view with the desired columns/fields. This view determines which fields will be provided via the GET service and thus can be retrieved through the API.

Steps:

To retrieve the API URL from a saved project list view, open the dropdown menu for view
Click on the ´share´ icon.
In the displayed dialog, go to the API link section and click Copy.

Query Params

view

string

Identifier of a saved view or layout configuration that controls which columns and sorting are used in the report.

lang

string

Language code used for localized column names and texts in the report (for example de or en).

headers

string

Comma-separated list of column keys that should be included in the export; leave empty to use the default column set.

globalProjectsFilter

string

One of these values: all, active, archived or templates.

includeTagsInArchived

boolean

Include flavors in archived project.

Body Params

Headers

timezone

string

Defaults to Europe/Berlin

IANA time zone identifier that is used to format all date and time values in the report (for example Europe/Berlin).

content-type

string

enum

Defaults to application/json-patch+json

Generated from available request content types

Allowed:

Responses

200

401

Unauthorized

403

Forbidden