Get project list export

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 /public/v1/project-list-export

Headers

  • X-COMPANY-ID string Required

    The company's unique ID

Query parameters

  • includeMilestones boolean

    Default value is false.

  • filters array[string]
  • searchTerm string
  • sortByColumn string

    Values are ACTUAL_PROGRESS, AVERAGE_DURATION_VARIANCE, BASELINE_ACTUAL_PROGRESS, BASELINE_AVERAGE_DURATION_VARIANCE, BASELINE_CONTRACTUAL_END_DATE, BASELINE_CONTRACTUAL_FLOAT, BASELINE_COST_ACTUAL_PROGRESS, BASELINE_COST_EARNED, BASELINE_COST_PERFORMANCE_INDEX, BASELINE_COST_PLANNED, BASELINE_COST_PLANNED_PROGRESS, BASELINE_COST_REMAINING, BASELINE_DATA_DATE, BASELINE_DURATION, BASELINE_EARNED_DAYS, BASELINE_END_DATE, BASELINE_HEALTH, BASELINE_MANPOWER_ACTUAL, BASELINE_MANPOWER_ACTUAL_PROGRESS, BASELINE_MANPOWER_EARNED, BASELINE_MANPOWER_ESTIMATED, BASELINE_MANPOWER_PERFORMANCE_INDEX, BASELINE_MANPOWER_PLANNED, BASELINE_MANPOWER_PLANNED_PROGRESS, BASELINE_PLANNED_PROGRESS, BASELINE_PLANNED_RECOVERY, BASELINE_PREDICTED_END_DATE, BASELINE_SCHEDULE_QUALITY, BASELINE_SOURCE_END_DATE, BASELINE_SPI, CITY, COMPRESSION, CONTRACTUAL_END_DATE, CONTRACTUAL_END_DATE_VARIANCE, CONTRACTUAL_FLOAT, COST_ACTUAL_PROGRESS, COST_EARNED, COST_PERFORMANCE_INDEX, COST_PLANNED, COST_PLANNED_PROGRESS, COST_REMAINING, COUNTRY, CRITICAL_PATH_DELAY, CURRENT_END_DATE, DATA_DATE, DURATION, DURATION_VARIANCE, EARNED_DAYS, END_DATE_VARIANCE, HEALTH, HIT_RATE, MANPOWER_ACTUAL, MANPOWER_ACTUAL_PROGRESS, MANPOWER_EARNED, MANPOWER_ESTIMATED, MANPOWER_PERFORMANCE_INDEX, MANPOWER_PLANNED, MANPOWER_PLANNED_PROGRESS, MILESTONE, NAME, PLANNED_END_DATE, PLANNED_PROGRESS, PLANNED_RECOVERY, POSTAL_CODE, PREDICTED_END_DATE, PREVIOUS_ACTUAL_PROGRESS, PREVIOUS_AVERAGE_DURATION_VARIANCE, PREVIOUS_COMPRESSION, PREVIOUS_CONTRACTUAL_END_DATE, PREVIOUS_CONTRACTUAL_END_DATE_VARIANCE, PREVIOUS_CONTRACTUAL_FLOAT, PREVIOUS_COST_ACTUAL_PROGRESS, PREVIOUS_COST_EARNED, PREVIOUS_COST_PERFORMANCE_INDEX, PREVIOUS_COST_PLANNED, PREVIOUS_COST_PLANNED_PROGRESS, PREVIOUS_COST_REMAINING, PREVIOUS_CRITICAL_PATH_DELAY, PREVIOUS_DATA_DATE, PREVIOUS_DURATION, PREVIOUS_DURATION_VARIANCE, PREVIOUS_EARNED_DAYS, PREVIOUS_END_DATE, PREVIOUS_END_DATE_VARIANCE, PREVIOUS_HEALTH, PREVIOUS_HIT_RATE, PREVIOUS_MANPOWER_ACTUAL, PREVIOUS_MANPOWER_ACTUAL_PROGRESS, PREVIOUS_MANPOWER_EARNED, PREVIOUS_MANPOWER_ESTIMATED, PREVIOUS_MANPOWER_PERFORMANCE_INDEX, PREVIOUS_MANPOWER_PLANNED, PREVIOUS_MANPOWER_PLANNED_PROGRESS, PREVIOUS_PLANNED_PROGRESS, PREVIOUS_PLANNED_RECOVERY, PREVIOUS_PREDICTED_END_DATE, PREVIOUS_SCHEDULE_QUALITY, PREVIOUS_SOURCE_END_DATE, PREVIOUS_SPI, PROGRESS, QUALITY_PROFILE, SCHEDULE_QUALITY, SLIPPAGE, SOURCE_END_DATE, SPI, START_DATE, START_DATE_VARIANCE, or STATE.

  • sortDirection string

    Values are ASC or DESC.

  • projectMetricFilter string

    Values are PROJECTS_DELAYED, PROJECTS_ON_TRACK, PROJECTS_NEEDING_UPDATES, or PROJECTS_LOW_QUALITY.

  • projectListTableColumns array[string] Required

    Values are ACTUAL_PROGRESS, AVERAGE_DURATION_VARIANCE, BASELINE_ACTUAL_PROGRESS, BASELINE_AVERAGE_DURATION_VARIANCE, BASELINE_CONTRACTUAL_END_DATE, BASELINE_CONTRACTUAL_FLOAT, BASELINE_COST_ACTUAL_PROGRESS, BASELINE_COST_EARNED, BASELINE_COST_PERFORMANCE_INDEX, BASELINE_COST_PLANNED, BASELINE_COST_PLANNED_PROGRESS, BASELINE_COST_REMAINING, BASELINE_DATA_DATE, BASELINE_DURATION, BASELINE_EARNED_DAYS, BASELINE_END_DATE, BASELINE_HEALTH, BASELINE_MANPOWER_ACTUAL, BASELINE_MANPOWER_ACTUAL_PROGRESS, BASELINE_MANPOWER_EARNED, BASELINE_MANPOWER_ESTIMATED, BASELINE_MANPOWER_PERFORMANCE_INDEX, BASELINE_MANPOWER_PLANNED, BASELINE_MANPOWER_PLANNED_PROGRESS, BASELINE_PLANNED_PROGRESS, BASELINE_PLANNED_RECOVERY, BASELINE_PREDICTED_END_DATE, BASELINE_SCHEDULE_QUALITY, BASELINE_SOURCE_END_DATE, BASELINE_SPI, CITY, COMPRESSION, CONTRACTUAL_END_DATE, CONTRACTUAL_END_DATE_VARIANCE, CONTRACTUAL_FLOAT, COST_ACTUAL_PROGRESS, COST_EARNED, COST_PERFORMANCE_INDEX, COST_PLANNED, COST_PLANNED_PROGRESS, COST_REMAINING, COUNTRY, CRITICAL_PATH_DELAY, CURRENT_END_DATE, DATA_DATE, DURATION, DURATION_VARIANCE, EARNED_DAYS, END_DATE_VARIANCE, HEALTH, HIT_RATE, MANPOWER_ACTUAL, MANPOWER_ACTUAL_PROGRESS, MANPOWER_EARNED, MANPOWER_ESTIMATED, MANPOWER_PERFORMANCE_INDEX, MANPOWER_PLANNED, MANPOWER_PLANNED_PROGRESS, MILESTONE, NAME, PLANNED_END_DATE, PLANNED_PROGRESS, PLANNED_RECOVERY, POSTAL_CODE, PREDICTED_END_DATE, PREVIOUS_ACTUAL_PROGRESS, PREVIOUS_AVERAGE_DURATION_VARIANCE, PREVIOUS_COMPRESSION, PREVIOUS_CONTRACTUAL_END_DATE, PREVIOUS_CONTRACTUAL_END_DATE_VARIANCE, PREVIOUS_CONTRACTUAL_FLOAT, PREVIOUS_COST_ACTUAL_PROGRESS, PREVIOUS_COST_EARNED, PREVIOUS_COST_PERFORMANCE_INDEX, PREVIOUS_COST_PLANNED, PREVIOUS_COST_PLANNED_PROGRESS, PREVIOUS_COST_REMAINING, PREVIOUS_CRITICAL_PATH_DELAY, PREVIOUS_DATA_DATE, PREVIOUS_DURATION, PREVIOUS_DURATION_VARIANCE, PREVIOUS_EARNED_DAYS, PREVIOUS_END_DATE, PREVIOUS_END_DATE_VARIANCE, PREVIOUS_HEALTH, PREVIOUS_HIT_RATE, PREVIOUS_MANPOWER_ACTUAL, PREVIOUS_MANPOWER_ACTUAL_PROGRESS, PREVIOUS_MANPOWER_EARNED, PREVIOUS_MANPOWER_ESTIMATED, PREVIOUS_MANPOWER_PERFORMANCE_INDEX, PREVIOUS_MANPOWER_PLANNED, PREVIOUS_MANPOWER_PLANNED_PROGRESS, PREVIOUS_PLANNED_PROGRESS, PREVIOUS_PLANNED_RECOVERY, PREVIOUS_PREDICTED_END_DATE, PREVIOUS_SCHEDULE_QUALITY, PREVIOUS_SOURCE_END_DATE, PREVIOUS_SPI, PROGRESS, QUALITY_PROFILE, SCHEDULE_QUALITY, SLIPPAGE, SOURCE_END_DATE, SPI, START_DATE, START_DATE_VARIANCE, or STATE.

Responses

  • 200 application/vnd.ms-excel

    OK

GET /public/v1/project-list-export
curl \
 --request GET 'https://live.smartpmtech.com/public/v1/project-list-export?projectListTableColumns=ACTUAL_PROGRESS' \
 --header "X-API-KEY: $API_KEY" \
 --header "X-COMPANY-ID: string"