1

I am trying to create a new sheet from an existing sheet using the Java API 2.0 for Smartsheet. The code I am using is as follows.

try{
Sheet sheet = smartsheet.sheetResources().getSheet(Id, null, null, null, null, null, null, null);
Sheet newSheet = smartsheet.sheetResources().createSheetInFolderFromTemplate(1441945445787524L, sheet, EnumSet.allOf(SheetTemplateInclusion.class));

When I run this I get an error saying "effectiveAttachmentOptions" was of unexpected type I had it working in API 1.1 but cannot figure it out in 2.0.

Kim Brandl
  • 13,125
  • 2
  • 16
  • 21
T A
  • 63
  • 1
  • 6

1 Answers1

2

Creating a new sheet from a template requires a sheet object limited to the following attributes:

  • name (required) - need not be unique
  • fromId (required) - the ID of the Template from which to create the Sheet

When you get a sheet using the 'getSheet()' method, the sheet contains 'effectiveAttachmentOptions' and other attributes which should not be part of the request. Instead, please use the sample code provided below:

Sheet sheet = new Sheet.CreateFromTemplateOrSheetBuilder().setFromId(sheetId).setName("New test sheet from template").build();

Sheet newSheetFromTemplate = smartsheet.sheetResources().createSheetInFolderFromTemplate(1441945445787524L, sheet, null);

For more information: http://smartsheet-platform.github.io/api-docs/#create-sheet-in-folder-from-template

Aditi Nioding
  • 51
  • 2