Creating new sheet using Java API - Unable to create child tasks

abhishaik.srivastava94476

I am trying to create a smartsheet using Java API that fills data in parent/child task format. I tried couple of options, but I was getting exception. I am not sure if it is possible.

So, I tried another option, where I created the sheet and then re-read the sheet and tried to indent the rows using following code - 

// Indent child Rows

        List<Row> rows = checkPointSheetData.getSheet().getRows();

        SmartsheetUtility smartsheetUtility = new SmartsheetUtility();

        List<Row> indentedRows = new ArrayList<>();

        for(Row taskRow : rows) {

            try {

                WorkItemData workItemData = smartsheetUtility.getWorkItemData(taskRow, null, checkPointSheetData.getSheet().getColumns(),

                        checkPointSheetData.getColumnMap().get(SmartSheetAppConstants.SMARTSHEET_COL_TASK_NAME));     // WorkItemData is a POJO class contains the row data of smartsheet

                if(workItemData.getTaskName() != null && !workItemData.getTaskName().startsWith(getCheckPointPattern())) {

                    Row newRow = new Row(taskRow.getId());

                    newRow.setIndent(1);

                    indentedRows.add(newRow);

                    

                    checkPointSheetData.getSmartsheet().sheetResources().rowResources().updateRows(getCheckPointSheetId(), indentedRows);

                }

                

            } catch (ParseException parseException) {

                APPLOGGER.error(parseException.getMessage(), parseException);

            }

        }

While running above code I am getting exception - 

2019-07-15 10:54:00 WARN  DefaultHttpClient:153 - {request:{command:'PUT https://api.smartsheet.com/2.0/sheets/1134696521328516/rows',headers:{'Accept-Encoding':'gzip,deflate','Authorization':'Bearer ****wll2','Connection':'Keep-Alive','Content-Length':'36','Content-Type':'application/json','Host':'api.smartsheet.com','User-Agent':'Smartsheet Java SDK/2.2.9/smartsheet-sdk-java-2.2.9.jar!com.smartsheet.api.SmartsheetFactory/Windows 10 Java HotSpot(TM) 64-Bit Server VM Oracle Corporation 1.8.0_151',},body:'[{"id":3407430094219140,"indent":1}]'},response:{status:'HTTP/1.1 404 Not Found',headers:{'Connection':'Keep-Alive','Content-Type':'application/json;charset=UTF-8','Date':'Mon, 15 Jul 2019 05:23:58 GMT','Keep-Alive':'timeout=5, max=27','Vary':'Accept-Encoding',},body:'{

  "errorCode" : 1006,

  "message" : "Not Found",

  "refId" : "15bj685inr0r1",

  "detail" : {

    "index" : 0,

    "rowId" : 3407430094219140

  }

}'}}

2019-07-15 10:54:00 ERROR IdentifyCheckPointGoals:124 - Not Found

com.smartsheet.api.ResourceNotFoundException: Not Found

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

    at com.smartsheet.api.internal.AbstractResources$ErrorCode.getException(AbstractResources.java:148)

    at com.smartsheet.api.internal.AbstractResources.handleError(AbstractResources.java:895)

    at com.smartsheet.api.internal.AbstractResources.putAndReceiveList(AbstractResources.java:746)

    at com.smartsheet.api.internal.SheetRowResourcesImpl.updateRows(SheetRowResourcesImpl.java:252)

    at com.smartsheet.main.IdentifyCheckPointGoals.updateCheckPointGoalSheet(IdentifyCheckPointGoals.java:281)

    at com.smartsheet.main.IdentifyCheckPointGoals.updateCheckPointGoals(IdentifyCheckPointGoals.java:149)

    at com.smartsheet.main.IdentifyCheckPointGoals.main(IdentifyCheckPointGoals.java:121)

 

Can anyone please help me here to understand how I can establish parent/child task while creating a new smartsheet ?

KevinFansler

You can have a sheet that ultimately has hierarchy; however, the flow would be to create the sheet first > then add the rows with the data > and then update the rows to create the hierarchy. So doing it all in one action is why there is a problem. Both the sheet and the rows have to exist first as you'll need sheetId and rowIds to carry out the request.