Dela via


Project Online

Project Online is a flexible online solution for project portfolio management (PPM) and everyday work from Microsoft. Delivered through Office 365, Project Online enables organizations to get started quickly with powerful project management capabilities to plan, prioritize, and manage projects and project portfolio investments-from almost anywhere on almost any device.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions
Power Automate Standard All Power Automate regions
Power Apps Standard All Power Apps regions
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://products.office.com/project/project-management-software

To use this integration, you will need access to an account with access to a Project Online site. To make a connection, select Sign In. You will be prompted to provide your Microsoft login, follow the remainder of the screens to create a connection.

Each of the operations require the root site URL to the Project Online site. In most cases this URL can be found in browser address bar when navigating to your Project Online site. URL should belong to sharepoint.com domain and should be PWA (Project Web App) type. If you are using Project Online through https://project.microsoft.com/ site, please visit Settings->My PWA site in order to obtain valid PWA url. E.g. https://sampletenant.sharepoint.com/teams/sampleteam

You're now ready to start using this integration.

Known issues and limitations

  1. The 'Resource Name' property is not returned for Project Online tasks since it is not returned by backend service's REST API itself.
  2. All triggers can return up to 10 items per single run. If more data is available and this is a V2 trigger, the trigger will run again without delay.

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Checkin and publish project

Check in and publish an existing project in your site.

Checkout project

Checks out an existing project in your site.

Create new resource

Creates an Enterprise Resource in your Project Online site.

Creates new project

Creates a new project in your project online site.

Creates new task

Creates a new task in you project.

Get project summary task

Gets the project summary task for a given project.

List project

Lists a project by Id in your project online site.

List projects

Lists the projects in your project online site.

Lists tasks

Lists the published tasks in a project.

Checkin and publish project

Check in and publish an existing project in your site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to checkin.

Returns

response
object

Checkout project

Checks out an existing project in your site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to checkout.

Returns

response
object

Create new resource

Creates an Enterprise Resource in your Project Online site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Resource name
Name True string

The name of the new resource to create

Is resource in budget
IsBudget boolean

Is resource accounted for in the budget

Is resource generic
IsGeneric boolean

Is resource generic

Is resource inactive
IsInactive boolean

Is resource inactive

Returns

Project Online Enterprise Resource Model

Creates new project

Creates a new project in your project online site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project name
Name True string

Name of the new project to create

Project description
Description string

Description of the new project to create

Project start date
Start date-time

Start date of the new project

Returns

Project Online Project Model

Body
Project

Creates new task

Creates a new task in you project.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to add the task to.

Task name
Name True string

Name of the new task to create

Task notes
Notes string

Notes to put on the new task

Task start date
Start date-time

Start date of the task

Task duration
Duration string

Duration of the task. For example (1h, 2d, or 3w)

Returns

Project online server task

Body
Task

Get project summary task

Gets the project summary task for a given project.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to fetch

Returns

Project online server task

Body
Task

List project

Lists a project by Id in your project online site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to fetch

Select Query
$select string

OData select query for the columns to be returned. Example: Id, Name

Returns

Project Online Project Model

Body
Project

List projects

Lists the projects in your project online site.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Returns

Project online list projects response model

Lists tasks

Lists the published tasks in a project.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Project Id
project_id True string

The unique id of the project to fetch tasks.

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. Id eq 'task-guid').

Select Query
$select string

OData select query for the columns to be returned. Example: Id, Name

Returns

Project online list tasks response model

Triggers

When a new project is created

Triggers a flow whenever a new project is created.

When a new project is created (V2) (Preview)

Triggers a flow whenever a new project is created.

When a new resource is created

Triggers a new flow when a new resource is created.

When a new resource is created (V2) (Preview)

Triggers a new flow when a new resource is created.

When a new task is created

Triggers a flow when a new task is created.

When a new task is created (V2) (Preview)

Triggers a flow when a new task is created.

When a project is published

Triggers a flow whenever a project is published.

When a project is published (V2) (Preview)

Triggers a flow whenever a project is published.

When a new project is created

Triggers a flow whenever a new project is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Returns

Project Online on new project response model.

When a new project is created (V2) (Preview)

Triggers a flow whenever a new project is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Select Query
$select True string

OData select query for the columns to be returned.

Returns

Project Online on new project response model.

When a new resource is created

Triggers a new flow when a new resource is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Returns

Project Online on new resource response model.

When a new resource is created (V2) (Preview)

Triggers a new flow when a new resource is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Select Query
$select True string

OData select query for the columns to be returned.

Returns

Project Online on new resource response model.

When a new task is created

Triggers a flow when a new task is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Returns

Project online on new task response model

When a new task is created (V2) (Preview)

Triggers a flow when a new task is created.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Select Query
$select True string

OData select query for the columns to be returned.

Returns

Project online on new task response model

When a project is published

Triggers a flow whenever a project is published.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Returns

Project Online on new project response model.

When a project is published (V2) (Preview)

Triggers a flow whenever a project is published.

Parameters

Name Key Required Type Description
Root Site URL
siteUrl True uri

Root site url of your project site (Example: https://sampletenant.sharepoint.com/teams/sampleteam ).

Select Query
$select True string

OData select query for the columns to be returned.

Returns

Project Online on new project response model.

Definitions

TriggerProjectsWrapper

Project Online on new project response model.

Name Path Type Description
Returned projects
value array of TriggerProject

The list of trigger projects returned.

TriggerProject

Project Online Project Model

Name Path Type Description
Project Start Date
ProjectStartDate date-time

The datetime the approved project started.

Project End Date
ProjectFinishDate date-time

The datetime the approved project finished.

Created Date
ProjectCreatedDate date-time

The datetime the project was created.

Project Id
ProjectId string

The unique Id of the project.

Last Modified Date
ProjectModifiedDate date-time

The datetime the project was last saved.

Project Type
ProjectType integer

The type of the project.

Project Name
ProjectName string

The name of the project.

Last Published Date
ProjectLastPublishedDate date-time

The datetime the project was last published.

Project Owner
ProjectOwnerName string

The owner of the project.

Project Percent Completed
ProjectPercentCompleted integer

The percentage completed of the project.

Project Percent Work Completed
ProjectPercentWorkCompleted integer

The percentage of work completed of the project.

Project Overtime Cost
ProjectOvertimeCost string

The overtime cost of the project.

Project Overtime Work
ProjectOvertimeWork string

The overtime work of the project.

TriggerResourcesWrapper

Project Online on new resource response model.

Name Path Type Description
Returned resources
value array of TriggerResource

The list of trigger resources returned.

TriggerResource

Resource Online resource model.

Name Path Type Description
Resource Id
ResourceId string

The unique Id of the resource.

Base Calendar
ResourceBaseCalendar string

The base calendar type of the resource.

Resource booking type
ResourceBookingType integer

Booking type of the resource

Can resource level
ResourceCanLevel boolean

Can the resource level

Resource cost per use
ResourceCostPerUse string

Cost per use of the resource

Resource create date
ResourceCreatedDate date-time

Create date of the resource

Resource earliest available from
ResourceEarliestAvailableFrom date-time

Earliest availability date of the resource

Resource email
ResourceEmailAddress string

Email address of the resource

Resource initials
ResourceInitials string

Initals of the resource

Is resource activew
ResourceIsActive boolean

Is the new resource active

Is resource generic
ResourceIsGeneric boolean

Is the new resource generic

Resource latest available to
ResourceLatestAvailableTo date-time

Lastest date for which the resource is available

Resource last modified date
ResourceModifiedDate date-time

Last modification date of the resource

Resource name
ResourceName string

Name of the resource

Resource status name
ResourceStatsuName string

Status name of the resource

Resource type
ResourceType integer

Type of resource

Resource type description
TypeDescription string

Description for the type of resource

Resource type name
TypeName string

Type name of the resource

TriggerTasksWrapper

Project online on new task response model

Name Path Type Description
Returned tasks
value array of TriggerTask

The list of trigger tasks returned

TriggerTask

Task Online Task Model

Name Path Type Description
Project id
ProjectId string

Id of the project which the task is created in

Task id
TaskId string

Id of the new task

Project name
ProjectName string

Name of the project which the task is created in

Task name
TaskName string

Name of the new task

Task created date
TaskCreatedDate date-time

Created date of the new task

Task last modified date
TaskModifieddate date-time

Last modified date of the new task

Task start date
TaskStartDate date-time

Starting date of the new task

Task finish date
TaskFinishDate date-time

Finishing date of the new task

Task summary
TaskPriority integer

Priority of the new task

Task is active
TaskIsActive boolean

Whether the task is still active

Project

Project Online Project Model

Name Path Type Description
Approved start date
ApprovedStart date-time

Approved project start time

Approved end date
ApprovedEnd date-time

Approved project end time

Checked out date
CheckedOutDate date-time

Time which the project is checked out

Checkout description
CheckOutDescription string

Description which the project is checked out with

Checkout id
CheckOutId string

Id of the project checkout

Created date
CreatedDate date-time

Created date of the project

Project id
Id string

Id of the project

Is checked out
IsCheckedOut boolean

True if the project is currently checked out

Last published date
ProjectLastPublishedDate date-time

Last published date of the project

Last published date
LastPublishedDate date-time

Last published date of the project

Last saved date
LastSavedDate date-time

Last date the project is saved

Optimizer decision
OptimizerDecision integer

Project optimizer decision number

Planner decision
PlannerDecision integer

Project planner decision number

Project type
ProjectType integer

The type of the project

Project name
Name string

The name of the project

Project identifier
ProjectIdentifier string

Project identifier

Win proj version
WinprojVersion string

Project version

ProjectsWrapper

Project online list projects response model

Name Path Type Description
Returned projects
value array of Project

The list of projects returned

EnterpriseResource

Project Online Enterprise Resource Model

Name Path Type Description
Can resource level
CanLevel boolean

Can resource level

Resource code
Code string

Resource code

Resource cost accrual
CostAccrual integer

Resource cost accrual

Resource cost center
CostCenter string

Resource cost center

Resource created time
Created date-time

Resource created time

Default booking type
DefaultBookingType integer

Resource default booking type

Email
Email string

Resource email address

External id
ExternalId string

Resource external id

Resource group
Group string

Group which resource belongs in

Hire date
HireDate date-time

Hired date of the resource

Resource id
Id string

Resource id

Resouce initials
Initials string

Resource initials

Is resource active
IsActive boolean

Is resource active

Is budget
IsBudget boolean

Is resource cost budgeted

Is checked out
IsCheckedOut boolean

Is resource checked out

Is generic
IsGeneric boolean

Is resource generic

Is team
IsTeam boolean

Is resource part of the team

Material label
MaterialLabel string

Resource material label

Last modified
Modified date-time

Time which the resource is last modified

Resource name
Name string

Resource name

Resource phonetics
Phonetics string

Phonetic pronunciation of the resource

Resource type
ResourceType integer

Resource type

Termination date
TerminationDate date-time

Resource termination date

TasksWrapper

Project online list tasks response model

Name Path Type Description
Returned tasks
value array of Task

The list of tasks returned

Task

Project online server task

Name Path Type Description
Task created date
Created date-time

The created date of the task

Task last modified date
Modified date-time

The last modified date of the task

Task start date
Start date-time

The start date of the task

Task finish date
Finish date-time

The finished date of the task

Task Scheduled Start Date
ScheduledStart date-time

The scheduled start date of the task

Task Scheduled Finish Date
ScheduledFinish date-time

The scheduled finish date of the task

Task name
Name string

The name of the task

Task id
Id string

The id of the task

Task priority
Priority integer

The priority level of the task

Task percent complete
PercentComplete integer

Percent of task complete

Task notes
Notes string

Description notes about the task

Task contact
Contact string

Contact address for the task

Is Milestone Task
IsMilestone boolean

Indicates if the task is a milestone

object

This is the type 'object'.