Question

Smartsheet Integration

  • 22 March 2021
  • 6 replies
  • 75 views

Hello peeps.

I have been asked to test the Smartsheet integration and just wondered is it possible to test on a trial account or do I need to sign up to a Smartsheet plan? 

Also the information on the integration with Smartsheet seems sparse, if anyone has any extra detailed information it would be really cool if you could share that with me.

Many thanks

Carl


6 replies

Carl, I too am evaluating this integration on behalf of a client.  You need access to Smartsheet Developer Tools to implement this integration which I believe requires a paid Smartsheet license. https://developers.smartsheet.com/register/

I’ve also searched for additional information such as a configuration and users guide, including asking Acumatica Support; it apparently doesn’t exist.  A video posted by Doug Johnson on YouTube provides a nice overview but doesn’t provide the details I’ve needed.

 

Hello,

If you connect with a SmartSheet sales person, they can give you access to a trial licence that can connect to Acumatica. The challenge is that the connector is supported by the community so there’s little support or documentation. Doug’s video and the information on GitHub are enough to get you started but there’s information missing.

Sébastien

Hi, is anyone on here trying the integration with 2021 R1?

 

I’ve raised an issue on GitHub for the project as the install generates an error. @Doug Johnson kindly reminded me that as a community project support has to come from the community itself, so wondering if any of my colleagues have come across this issue or have a fix for it:-

(excerpt from compilation follows ...)


Validating Binary Files

Referenced field missing: action from PX.Objects.PM.ProjectEntry

smartsheet-csharp-sdk.dll Failed to resolve type reference: RestSharp.Extensions.MonoHttp.HttpUtility declared in RestSharp, Version=100.0.0.0, Culture=neutral, PublicKeyToken=598062e77f915f75

smartsheet-csharp-sdk.dll Failed to resolve method reference: System.String RestSharp.Extensions.MonoHttp.HttpUtility::UrlEncode(System.String,System.Text.Encoding) declared in RestSharp, Version=100.0.0.0, Culture=neutral, PublicKeyToken=598062e77f915f75

Validation failed.

 

Interestingly the customisation “Validates” fine when using the “Validate Highlighted Project” from the “Validations” menu of screen SM204505

 

Any thoughts welcomed ...

Userlevel 6
Badge

As @GrahamMartin mentioned, this product is currently supported by the community. That said, we do intend to upgrade the customization project to support the 2021 R1 release. Timeframe for this will be provided as soon as possible.

@GrahamMartin  We’re still evaluating it with 2020 R2, haven’t tried it yet with 2021 R1.

Userlevel 6
Badge

@GrahamMartin  @JohnBeiler61 

The SmartSheet integration software on GitHub was updated 2 days ago. https://github.com/Acumatica/Acumatica-Smartsheet

The latest version works with 2021 R1. I was easily able to install and sync projects on my local instance. 

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved