Smartsheet is a software as a service offering for collaboration and work management. Smartsheet used to assign tasks, track project progress, manage calendars, share documents, and manage other work, using a tabular user interface.

Connect Smartsheet with LogicHub

1. Navigate to Automations > Integrations.
2. Search for Smartsheet.
3. Click Details, then the + icon. Enter the required information in the following fields.
   • Label: Enter a connection name.
   • Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
   • Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
   • Remote Agent: Run this integration using the LogicHub Remote Agent.
   • API Key: The API Key to connect to the Smartsheet.
4. After you've entered all the details, click Connect.

Actions for Smartsheet

Get Events

Gets events that are occurring in your Smartsheet organization account. Examples of events are creation, update, load, and delete of sheets, reports, dashboards, attachments, users, etc.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

A JSON object containing multiple rows of result:

• has_error: True/False
• error: message/null
• result: List of events.

{
    "action": "CREATE",
    "additionalDetails": {
      "sheetName": "New Sheet1",
      "sourceGlobalTemplateId": "7881304550205316",
      "sourceType": "global_template"
    },
    "error": null,
    "eventId": "2.1.qivo1GGKR9_f3GrWaiJhAiFFnhhbIBtFbZOdepKU6fU",
    "eventTimestamp": "2020-09-09T13:03:35Z",
    "has_error": false,
    "objectId": 6712391871293316,
    "objectType": "SHEET",
    "requestUserId": 4797306638755716,
    "source": "WEB_APP",
    "userId": 4797306638755716
}

Release Notes

• v3.0.0 - Updated architecture to support IO via filesystem