background

ProjectServer API Deep Dive + Task Calendar Scheduling Tricks


April 1, 2025

In This Issue:

Featured Article: Accessing the ProjectServer API in Power Query

Struggling to access all your Project Online data? The ProjectServer REST API might be your answer. In this comprehensive guide, you'll discover:

  • How to construct API URLs to retrieve project information
  • Step-by-step instructions for browser-based API testing
  • Power Query techniques for transforming raw API data
  • Practical code snippets ready for immediate implementation

This technical deep-dive is ideal preparation for Wednesday's live event on accessing local custom fields in Project Online!

Video Quick Tip:

Need to schedule tasks outside your standard work calendar? This short tutorial shows you how to:

  • Override default calendars for specific tasks with unique timing requirements
  • Apply weekend work schedules to fast-track critical activities
  • Configure the "scheduling ignores resource calendars" setting
  • Document your calendar exceptions with task notes

These task calendar techniques help create more accurate schedules when standard work times don't apply.

Live Event (4/2):

Join expert Eric Christoph as he reveals how to access and integrate local custom fields from Project Online into your reports and dashboards using the ProjectServer API.

What You'll Learn:

  • The key differences between ProjectData and ProjectServer APIs
  • Step-by-step extraction techniques for local custom field data
  • Practical Power BI and Power Query integration methods
  • Real-world applications to enhance your reporting capabilities

🗓️ Wednesday, April 2

🕛 12:00pm - 1:00pm EDT

📍 Live on Zoom

🏅 1 PMI PDU: Ways of Working

Register now to elevate your Project Online reporting capabilities!

P.S. Live events + on-demand replays are exclusive for MPUG members! Join today for just $14.75/month.

Upcoming Live Events

MPUG host live events with leading experts on Wednesdays from 12:00pm - 1:00pm ET! MPUG members get access to live events where you get direct access to industry leaders, actionable insights, hands-on training, and opportunities to earn PDU's.

Learn more and register for upcoming events:

4/2: Beyond ProjectData: Unlocking Local Custom Fields in Project Online with ProjectServer API | Learn More / Register Here

4/9: Q&A with Erik van Hurck - Recent Additions to Microsoft Planner and What They Can Do for You | Learn More / Register Here

4/16: Excel Power Hour #2 with Mike Thomas: Interactive Live Q&A | Learn More / Register Here

*OPEN TO ALL! NO MEMBERSHIP REQUIRED!* 4/23: Empowering Your PMO with Cutting-Edge Technology To Improve Processes and Decision-Making | Learn More / Register Here

PM Best Practice: Document Your API Integrations for Team Knowledge Transfer

When building custom reporting solutions like those covered in Eric's article, documentation is essential! Create a simple one-page reference that includes:

  1. The exact API endpoints being used
  2. Authentication requirements and where credentials are stored
  3. How often data refreshes and who maintains the connection
  4. Business context explaining why specific fields were selected

This documentation prevents reporting solutions from becoming "black boxes" that only one team member understands, ensuring continuity even when key personnel change roles.

Document and enjoy your week!

Share this newsletter on Socials

Follow MPUG for PM Tips + Training

View our Privacy Policy

1001 Woodward Ave Suite 500, Detroit, MI 48226
Unsubscribe · Preferences

background

Subscribe to MPUG