Smartsheet

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.

Integration with LogicHub

Connecting with Smartsheet

To connect to Smartsheet following details are required:

  • Label: 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.
  • API Key: The API Key to connect to the Smartsheet.

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

Inputs to this Action:

  • Connection: Choose a connection that you have created.
  • Start Time (Optional): Enter the value for the start time in ISO 8601 format (Default is Batch start time). Example: 2020-08-25T21:49:46-07:00.
  • End Time (Optional): Enter the value for end time in ISO 8601 format (Default is Batch end time). Example: 2020-08-26T21:49:46-07:00.
  • Max Count (Optional): Maximum number of events (per parent row) to return as a response to this call. Must be between 1 through 10,000 (inclusive). (Default is 10,000).

Output of Action:
json containing following items:

  • 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
}

Did this page help you?