Get gantt chart export excel

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL

https://developers.smartpm.com/mcp

Standard setup for AI tools providing an mcp.json file

mcp.json
{
  "SmartPM Public API MCP server": {
    "url": "https://developers.smartpm.com/mcp"
  }
}

Close
GET /projects/{projectId}/scenarios/{scenarioId}/gantt-xlsx

Headers

  • X-COMPANY-ID string Required

    The company's unique ID

Path parameters

  • projectId integer(int64) Required
  • scenarioId integer(int64) Required

Query parameters

  • columns array[string] Required

    Values are ACTIVITY_ID, ACTIVITY_NAME, ACTUAL_DURATION, BLENDED_START_DATE, BLENDED_END_DATE, ACTUAL_START_DATE, ACTUAL_END_DATE, LATE_START_DATE, LATE_END_DATE, PERCENT_COMPLETE, DURATION_PERCENT_COMPLETE, PHYSICAL_PERCENT_COMPLETE, DURATION_VARIANCE, UNITS_PERCENT_COMPLETE, TOTAL_FLOAT, FREE_FLOAT, PLANNED_START_DATE, PLANNED_END_DATE, PLANNED_DURATION, DURATION, REMAINING_DURATION, START_DATE, END_DATE, NATIVE_FLOAT_TOTAL, IN_LONGEST_PATH, SOURCE_START_DATE, SOURCE_END_DATE, ROLLED_BACK_REMAINING_DURATION, SOURCE_ACTUAL_START_DATE, SOURCE_ACTUAL_END_DATE, BASELINE_START_DATE, BASELINE_END_DATE, BASELINE_DURATION, PLANNED_BUDGET, PLANNED_MANPOWER, BASELINE_FLOAT, BASELINE_NATIVE_FLOAT, or FLOAT_VARIANCE.

  • ganttStructure string Required

    Values are WBS, ACTIVITY_CODE, or NONE.

  • dataDate string Required
  • sortBy string Required

    Values are ACTIVITY_ID, ACTIVITY_NAME, ACTUAL_DURATION, BLENDED_START_DATE, BLENDED_END_DATE, ACTUAL_START_DATE, ACTUAL_END_DATE, LATE_START_DATE, LATE_END_DATE, PERCENT_COMPLETE, DURATION_PERCENT_COMPLETE, PHYSICAL_PERCENT_COMPLETE, DURATION_VARIANCE, UNITS_PERCENT_COMPLETE, TOTAL_FLOAT, FREE_FLOAT, PLANNED_START_DATE, PLANNED_END_DATE, PLANNED_DURATION, DURATION, REMAINING_DURATION, START_DATE, END_DATE, NATIVE_FLOAT_TOTAL, IN_LONGEST_PATH, SOURCE_START_DATE, SOURCE_END_DATE, ROLLED_BACK_REMAINING_DURATION, SOURCE_ACTUAL_START_DATE, SOURCE_ACTUAL_END_DATE, BASELINE_START_DATE, BASELINE_END_DATE, BASELINE_DURATION, PLANNED_BUDGET, PLANNED_MANPOWER, BASELINE_FLOAT, BASELINE_NATIVE_FLOAT, or FLOAT_VARIANCE.

  • SD string Required

    Values are ASC or DESC.

  • ACTS array[integer(int64)]
  • CIDS array[string]
  • filterId array[integer(int64)]
  • ST string
  • additionalActivityIds array[integer(int64)]
  • includeDeleted boolean

Responses

  • 200 application/vnd.ms-excel

    OK

GET /projects/{projectId}/scenarios/{scenarioId}/gantt-xlsx
curl \
 --request GET 'https://live.smartpmtech.com/projects/{projectId}/scenarios/{scenarioId}/gantt-xlsx?columns=ACTIVITY_ID&ganttStructure=WBS&dataDate=string&sortBy=ACTIVITY_ID&SD=ASC' \
 --header "X-API-KEY: $API_KEY" \
 --header "X-COMPANY-ID: string"