Get should start should finish report excel 1

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}/should-start-finish-xlsx

Headers

  • X-COMPANY-ID string Required

    The company's unique ID

Path parameters

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

Query parameters

  • startDate string Required
  • finishDate string Required
  • ganttStructure string

    Values are WBS, ACTIVITY_CODE, or NONE.

  • filterId array[integer(int64)]
  • sortBy string

    Values are ACTIVITYID, NAME, STARTINGSTARTDATE, STARTINGFINISHDATE, STARTINGPERCENTCOMPLETE, STARTINGTOTALFLOAT, ENDINGSTARTDATE, ENDINGFINISHDATE, ENDINGPERCENTCOMPLETE, ENDINGTOTALFLOAT, VARIANCESTARTDATE, VARIANCEFINISHDATE, VARIANCEPERCENTCOMPLETE, or VARIANCETOTALFLOAT.

  • sortDirection string

    Values are ASC or DESC.

  • activityCodeTypes array[integer(int64)]
  • collapsedIds array[string]
  • filterWindow boolean
  • filter array[string]

    Values are STARTED_ON_TIME, STARTED_LATE, DID_NOT_START, FINISHED_ON_TIME, FINISHED_LATE, DID_NOT_FINISH, SHOULD_HAVE_STARTED, or SHOULD_HAVE_FINISHED.

Responses

  • 200 application/vnd.ms-excel

    OK

GET /projects/{projectId}/scenarios/{scenarioId}/should-start-finish-xlsx
curl \
 --request GET 'https://live.smartpmtech.com/projects/{projectId}/scenarios/{scenarioId}/should-start-finish-xlsx?startDate=string&finishDate=string' \
 --header "X-API-KEY: $API_KEY" \
 --header "X-COMPANY-ID: string"