Get gantt chart export excel v2

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"