Smartsheet Integration

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.

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 ...

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

In case anyone gets the following error when going to either “Project Preferences” or trying to access Projects screen PM3010PL after publishing Smartsheet integration, the fix is simple (at least in my case).

"We're sorry! An error has occurred while processing your request. A report has been generated for our technical staff to investigate the problem. Please try to repeat your request later. Thank you for understanding."

Reviewing the trace shows this:-

Error: | The type initializer for 'ListPMTaskAttribute' threw an exception.

The fix is to make sure you have a project and a task available when you publish the integration. Sounds obvious now of course but took me days to work out ...

Hi All,
Had a bit of an issue getting Smartsheet to “GET SMARTSHEET TOKEN” from the profile screen
Revision 21R1

We had loaded up the Smartsheet customisation, created the App Profile in Smartsheet using our URL and App redirect URL as specified in the README on GitHub, loaded up the App Client Id and App Secret in the Project Preferences and got to the point where we need to GET SMARTSHEET TOKEN from a profile setting.  Clicking opens the GET SMARTSHEET TOKEN opened the app.smartsheet.com/b/authorize… page where we clicked Allow and at that point got the following;

The URL that was loading up when the GET SMARTSHEET TOKEN button was pressed was;

https://app.smartsheet.com/b/authorize?formName=fn_authorize&formAction=fa_loadAuthorize&response_type=code&client_id=XXXXXXXX&scope=ADMIN_SHEETS%2CADMIN_WORKSPACES%2CADMIN_USERS%2CCREATE_SHEETS%2CREAD_SHEETS%2CREAD_USERS%2CWRITE_SHEETS%2C+DELETE_SHEETS&state=ACUMATICA%2Cdjoyce

Looking at the Trace the redirect had the following;

https://app.smartsheet.com/b/authorize?response_type=code&client_id=XXXXXXXX&scope=ADMIN_SHEETS,ADMIN_WORKSPACES,ADMIN_USERS,CREATE_SHEETS,READ_SHEETS,READ_USERS,WRITE_SHEETS, DELETE_SHEETS&state=ACUMATICA,djoyce@<Our Domain Name>.com,<Tenant>

So the final part of the redirect URL including the @…. did not appear to being loaded when the GET SMARTSHEET TOKEN was clicked.  To get Smartsheet to connect we took the URL from the Trace and loaded this in a separate browser window and then pressed Allow
All Connected :)

Maybe this has been addressed in the latest revision 21R2? This might help someone else in the future.