Creating a new Microsoft Team for a Project Online Project
Part 1 of 2 for a blog post on Microsoft Flow creating Microsoft Teams for a Project Online projects: https://pwmather.wordpress.com/2019/06/12/create-a-microsoftteam-for-a-projectonline-project-using-microsoftflow-office365-microsoftgraph-ppm-workmanagement-powerplatform-azuread-collaboration-automation-part1/
Connecting Microsoft Project with Python
Hello, I'm stuck in the development of a system that automates Microsoft Project, I hope you can give me a clue where to go from here. In the company where I work we need to automate the creation and modification of tasks in Microsoft Project. We use Project Web App (PWA) in SharePoint. The thing is that due to technical requirements our system is based on Python so it would be great to be able to connect with Python to MS Project. I did it, I connect to MS Project Professional using PyWin32 and I managed to create projects, upload them to PWA, and create/modify the 100.000 tasks. Where is the problem? It is extremely slow and takes many hours to create/modify all the tasks, which makes it unfeasible and I need a faster solution. I think it is because I have connected using win32com and this slows down the work. I also think that VBA for Microsoft Project is not very fast. Does anyone know of a faster way to get me to connect to Project? Maybe directly accessing PWA from Python? But I haven't managed to do that. I would have to create my own Python API? Any other alternative you can think of would be appreciated. Thank you very much and hopefully we can do it. Darío. Pipeline TD
Accessing Project REST API throws error: Exception of type 'Microsoft.IdentityModel.Tokens.AudienceU
I am trying to access the Project Online REST API http://ServerName/ProjectServerName/_api/ProjectData/Projects More precisely my query is the following "https://" + sharepoint_url + "/sites/pwa/_api/ProjectServer/Projects('" + project_id + "')/Assignments('" + project_task_id + "')/Resource" Now what I am challenges with, is the right authentication. I am trying to impersonate two natural users, the application is registered in AAD and I also get a token. But I get either one of the two errors {"error_description":"Unsupported security token."} or {"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."} I am happy to provide further details, but I am a bit lost in the API jungle from Microsoft. Unfortunately it appears that Graph API does not (yet?) support Project Online. I was already following those guides here: https://docs.microsoft.com/de-de/azure/active-directory/develop/v2-oauth2-client-creds-grant-flow http://pratapreddypilaka.blogspot.com/2018/05/sharepoint-online-authentication-for.html No positive result. I do get tokens, but the errors remain.Project Online REST API for Timesheets
About a year ago I attempted to create an app that could be used to update Timesheets in Project Online. I could not find an API endpoint that would let me update Timesheets entries for a particular project and for a particular user during a defined date range. Another project has surfaced with similar goals. Is this now available today? If so can anyone point me to the endpoint with examples specifically for updating user Timesheets please? Thank you in advance for your help, Audrie
