Project workflows: How the "Send an HTTP request to SharePoint" connector can help you

%3CLINGO-SUB%20id%3D%22lingo-sub-217812%22%20slang%3D%22en-US%22%3EProject%20workflows%3A%20How%20the%20%22Send%20an%20HTTP%20request%20to%20SharePoint%22%20connector%20can%20help%20you%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217812%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Logic%20Apps%20and%20Flow%20feature%20a%20%22Send%20an%20HTTP%20request%20to%20SharePoint%22%20connector.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38046i49BE24D27BF1A6A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SharePoinTHTTPRequest.png%22%20title%3D%22SharePoinTHTTPRequest.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESharePoint%20HTTP%20connector%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20helps%20a%20lot%20as%20it%20does%20the%20authentication%20against%20SharePoint%20for%20you%20and%20allows%20you%20to%20use%20the%20full%20REST%20API%26nbsp%3B%20of%20Project%20Online.%3C%2FP%3E%3CP%3EThe%20current%20Project%20Online%20connectors%20are%20limited%20and%20after%20two%20years%20still%20in%20preview.%20So%20with%20the%20HTTP%20connector%20you%20will%20have%20a%20lot%20of%20new%20possibilities%20to%20manipulate%20Project%20Online%20without%20writing%20too%20much%20code.%3C%2FP%3E%3CP%3EAn%20intro%20to%20basic%20REST%20operations%20on%20Project%20Online%20can%20be%20found%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-REST-Basic-Operations%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-REST-Basic-Operations%3C%2FA%3E%3C%2FP%3E%3CP%3ELink%20to%20the%20REST%20API%20documentation%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fjj712612.aspx%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fjj712612.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20on%20how%20to%20change%20the%20project%20description%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20637px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38048i28A9B0E174EBF252%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ChangeProjectDescription.png%22%20title%3D%22ChangeProjectDescription.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EChange%20project%20description%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20fun%20building%20your%20workflows!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-485023%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20workflows%3A%20How%20the%20%22Send%20an%20HTTP%20request%20to%20SharePoint%22%20connector%20can%20help%20you%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485023%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20update%20a%20project%20custom%20field%20you%20can%20use%20a%20similar%20REST%20endpoint%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110591i7DD9A150613E2F23%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22UpdateCustomField.png%22%20title%3D%22UpdateCustomField.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EUpdate%20custom%20field%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDont%20forget%20to%20check%20out%20you%20project%20before%20and%20check%20it%20in%20later%20on%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110590iD89B542D7AB11D7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22CheckoutProject.png%22%20title%3D%22CheckoutProject.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ECheckout%20Project%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20609px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110589i38589D0A5684403A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PublishProject.png%22%20title%3D%22PublishProject.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPublish%20project%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Azure Logic Apps and Flow feature a "Send an HTTP request to SharePoint" connector.SharePoint HTTP connectorSharePoint HTTP connector

 

This helps a lot as it does the authentication against SharePoint for you and allows you to use the full REST API  of Project Online.

The current Project Online connectors are limited and after two years still in preview. So with the HTTP connector you will have a lot of new possibilities to manipulate Project Online without writing too much code.

An intro to basic REST operations on Project Online can be found here:

https://github.com/OfficeDev/Project-REST-Basic-Operations

Link to the REST API documentation:

https://msdn.microsoft.com/en-us/library/office/jj712612.aspx

 

An example on how to change the project description:

Change project descriptionChange project description

 

Have fun building your workflows!

1 Reply
Highlighted

To update a project custom field you can use a similar REST endpoint:

Update custom fieldUpdate custom field

 

Dont forget to check out you project before and check it in later on:Checkout ProjectCheckout ProjectPublish projectPublish project