Resource Management integrations and API (2024)

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Resource Management'sjob is to help you make informed operational decisions by visualizing information that matters across your projects and people. Our software might have complementary or overlapping data with your CRM solution, HR software, or finance tools. Together, your software suite can help draw a robust picture of important insights across your company.

Integrate Resource Management with APIs

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing Administrators can set up integrations with the Resource Management API.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

With the Resource Management API, you can retrieve and add data to the Resource Management database.

Using our API requires someone on your team to write the code to make the integration, or you can hire someone to do the integration for you.

Looking for technical details? Review our API documentation.

For more information on other ways you can get data into or out of Resource Management, check below for more details:

  • Zapier
  • Export to QuickBooks
  • Calendar Subscriptions

Connect applications with Zapier integration

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing Admins can pull the API token needed to create zaps.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Zapier is a popular third-party tool that allows you to connect Resource Management with thousands of other applications, saving you time and keeping your data accurate and up-to-date. Zapier enables you to connect Resource Management with other tools in your workflow without looking at a single line of code.

Resource Management has several Actions and Triggers with Zapier. These allow you to send and receive information between Resource Management and your other applications. Browse Zapier to see what you can map from Resource Management to your organization’s workflows.

Zapier Actions + Triggers

Actions are used to writedata to Resource Management. Triggers send data to other tools when something happens in Resource Management.

Some examples of Actions and Triggers:

  • Create a project when a lead is converted in Salesforce

  • Create Resource Management time entries from new Harvest timesheets

  • Set up a Resource Management user when you add a new team member to your CRM tool

  • Send a Slack notification when an assignment is updated

  • Create a Trello board when a new project is created

  • Update your Google or Outlook calendar when you’re staffed on that new project

When you connect an action with a trigger, you get a "zap." Zaps can be as few as two steps, but you can add levels of complexity to your Zap, depending on your needs.

Check out some Zap Templates to give you some ideas, but they only represent a sample of what’s possible.

Contact Resource Management support if you want more information about using Zapier and Resource Management to streamline your operational workflow.

Where to find Resource Management API documentation

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Account owners can manage which Resourcing Admins have access to the API Token.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Developers working with the API will need to review the API documentation for more information.

We’re happy to answer questions about integration options. If you want more hands-on assistance, contact your account representative to discuss having our consulting services team help you build something.

Things to know

  • API access is not enabled for trials. Reach out to your CSM to enable it.
  • The account owner can hide the API token and choose which Resourcing Admins are able to see it. Reach out to your account owner for the API token if it’s not shown in Account Settings.

Contact support If you need additional assistance.

Enable calendar subscriptions

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing admins can enable calendar subscriptions for the account.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Calendar subscriptions sync one direction, from Resource Management to your calendar. Any changes you make on your calendar will not be reflected in Resource Management.

The subscription URL automatically populates the calendar with your assignments from seven days in the past through thirty days in the future.

Assignments will populate to your calendar as private, all-day events that don’t block any time on your calendar. Calendar events include the following information from Resource Management:

  • Project name
  • Phase name
  • Assignment (work item) name
  • Assignment dates
  • Client name
  • Allocation
  • Assignment description
  • Count of assignment subtasks (completed, remaining, and total)

Enable calendar subscriptions

  1. Select the Settings button in the top right corner

  2. Select Account Settings from the drop-down list

  3. Scroll to the bottom of the Account Settings page to find the option to enable or disable calendar subscriptions.

Once a Resourcing Administrator has enabled calendar subscriptions for the account, team members can enable calendar subscriptions individually.

  1. Select the Settings button in the top right corner

  2. Select My Preferences in the drop-down list.

  3. Click the Enable button generates a calendar subscription URL.

Team members can use this URL to automatically sync their Resource Management assignments with their calendar clients, such as Google Calendar, Outlook.com, or Apple iCloud. The URL is public. If you share this link with someone else, they can view your Resource Management assignments. If you think you may have accidentally shared this link with someone who should not have access, you can easily generate a new link by clicking the Reset URL button. If you reset your URL, you must reconnect your preferred client with the new URL.

Adding your calendar subscription to your preferred calendar

To add your Resource Management calendar subscription to your personal calendar, copy your subscription URL and use the steps outlined below for your calendar client.

Export to QuickBooks

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, and Project Editors can create reports. The projects visible will vary by permission level. For example, Project Editors will only be able to see the projects they own.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Create a report

Create a report that includes the data you want to export. Forexample, you can create a report called October Invoicing; customize your settings as needed. You can create and export reports on projects, phases, vacation time, or whatever data you want to use in QuickBooks.

At the top of the screen, click Analytics and then apply the following settings:

  • View: hours
  • Time frame: custom date range (October 1 - October 31)
  • First group by: project (showing all projects in this time frame)
  • Then group by: team member (showing all the hours worked by all people in your company within this time frame).

Save reports to your personal page or analytics page to easily access them in the future.

Export your data

Select Export on the upper right and select Export Time Entries for QuickBooks. This will save a .IIF file, the QuickBooks specific file containing all your Resource Management data. Save this file in an easy-to-find place.

Open QuickBooks

  1. Open QuickBooks. Make sure you have all of your employees with attached bill rates in the system. This is likely already set up if you’re using QuickBooks for accounting and payroll.
  2. Navigate to File > Utilities > Import > Import .IIF file
  3. Select the project you want to invoice. Click Create Invoice at the bottom of the page.
  4. Your invoice should pull bill rates set up in QuickBooks and align them with hours recorded in Resource Management.

QuickBooks data mapping

The .IFF file you download from Resource Management won’t need additional formatting for import into QuickBooks. However, make sure the data between QuickBooks and Resource Management is properly matched, and you understand where the data fields are mapped to QuickBooks.

Spelling and spacing of all your items must be exactly the same between the two systems.

QuickBooks data is mapped to Resource Management as follows:

  • Quickbooks: customer = Resource Management: client
  • Quickbooks: job = Resource Management: project
  • Quickbooks: employee = Resource Management: people
  • Quickbooks: service item or item = Resource Management: task category
  • Quickbooks: notes or description = Resource Management: notes
  • Quickbooks: rate = Resource Management: bill rate

Integration comparison

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing Administrators can set up integrations with the Resource Management API.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

There are multiple solutions to integrations. Here's a breakdown of the capabilities, implementation challenges, and costs of each method:

Exports

Use this option when you want to get data out of Resource Management. Export to .CSV to pull sets of data into Excel or another spreadsheet program.

Learn how to export data from reports.

Zapier

Zapier offers a subset of the full API through an easy-to-use point and click interface. Using Zapier does not require a software engineer to write custom code for your integration, so it can be less expensive and faster to execute than using the API. Zapier doesn't allow the robust integrations possible with our API, but is great for simple actions between tools such as creating a project or adding an assignment.

It may be the application you’re trying to integrate with isn't connected to the Zapier platform. Check the Zapier website before committing to this type of integration. Also, depending on your usage, you might need a monthly subscription to the Zapier service.

API

This is the most robust, flexible, and challenging solution to implement. This option provides the most capability for integration but requires web development skills in order to implement it effectively.

Compare integration methods

This chart gives a brief overview and comparison of the capabilities of each integration method in comparison to the website.

  • Full: All features and functionality available
  • Partial: Offers a subset of full features. See full documentation for details.
  • Read-only: Can only view records

Web appAPIZapierExports
UsersFullPartialPartialRead-only
Placeholder resourcesFullFullNoneRead-only
ProjectsFullFullPartialRead-only
Leave typesFullFullNoneRead-only
Time entriesFullFullPartialRead-only
AssignmentsFullFullPartialRead-only
Bill ratesFullFullNoneRead-only
Time + expense approvalsFullFullNoneRead-only
HolidaysFullPartialNoneRead-only
Custom fieldsFullFullNoneRead-only
ReportsFullFullNoneRead-only

Integration FAQs

APPLIES TO

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

Resourcing Administrators can set up integrations with the Resource Management API.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Frequently asked questions

I need help building my integration. What should I do?

If you’re looking for more hands-on assistance, contact your account representative to discuss the possibility of having Smartsheet's consulting services team help you build something.

Will you be building more Zapier Zaps?

Yes. Smartsheet is working on more templates in Zapier to allow for more complex Zapier integrations. Let us know which Zapier templates you'd find more helpful.

Does the Resource Management API support webhooks?

Resource Management does support webhooks. You can read about in our API documentation.

Can I access Resource Management reports data via the API?

Yes. The Reports API is perhaps one of the most powerful endpoints, as it allows you to pull all the data from Resource Management reports. This includes calculations such as utilization %. Learn more about reports API.

Can I update bill rates using the API?

The API actually allows more functionality than the Resource Management UI. For example, teams often want to update project bill rates based on annual salary increases or project rate increases. If you need to update all of your bill rates part-way through a project, you can use the API to add bill rate start and end dates to more quickly make this change.

Resource Management integrations and API (2024)
Top Articles
Reyna - Valorant Agent Guide
Large Print Cryptograms 2 PDF, Epub Download
Kreme Delite Menu
Walgreens Pharmqcy
Directions To Franklin Mills Mall
Windcrest Little League Baseball
What is Mercantilism?
Mcfarland Usa 123Movies
Davante Adams Wikipedia
Comcast Xfinity Outage in Kipton, Ohio
Xm Tennis Channel
shopping.drugsourceinc.com/imperial | Imperial Health TX AZ
Tight Tiny Teen Scouts 5
Evangeline Downs Racetrack Entries
U/Apprenhensive_You8924
Epro Warrant Search
Spider-Man: Across The Spider-Verse Showtimes Near Marcus Bay Park Cinema
Copart Atlanta South Ga
Conan Exiles Sorcery Guide – How To Learn, Cast & Unlock Spells
Somewhere In Queens Showtimes Near The Maple Theater
Optum Urgent Care - Nutley Photos
Bjerrum difference plots - Big Chemical Encyclopedia
Sec Baseball Tournament Score
Reser Funeral Home Obituaries
Hannaford Weekly Flyer Manchester Nh
Bfsfcu Truecar
Darktide Terrifying Barrage
R/Mp5
Tokioof
What Is The Lineup For Nascar Race Today
Eero Optimize For Conferencing And Gaming
Flaky Fish Meat Rdr2
One Credit Songs On Touchtunes 2022
Tamil Play.com
Ark Unlock All Skins Command
Chs.mywork
D3 Boards
Mohave County Jobs Craigslist
Linda Sublette Actress
South Bend Tribune Online
Nba Props Covers
How I Passed the AZ-900 Microsoft Azure Fundamentals Exam
Poe Self Chill
Rs3 Nature Spirit Quick Guide
Marcel Boom X
Haunted Mansion Showtimes Near Millstone 14
Yosemite Sam Hood Ornament
York Racecourse | Racecourses.net
Oak Hill, Blue Owl Lead Record Finastra Private Credit Loan
Makes A Successful Catch Maybe Crossword Clue
Where and How to Watch Sound of Freedom | Angel Studios
Costco Tire Promo Code Michelin 2022
Latest Posts
Article information

Author: Corie Satterfield

Last Updated:

Views: 6800

Rating: 4.1 / 5 (42 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.