Objects

Folder Object

id	number Folder Id.
favorite	boolean (Deprecated) Returned only if the user has marked the folder as a favorite in their "Home" tab (value = true).
	Array of objects Folders contained in folder.
name	string Folder name.
permalink	string URL that represents a direct link to the folder in Smartsheet.
	Array of objects Reports contained in folder.
	Array of objects Sheets contained in folder.
	Array of objects Dashboards contained in folder.
	Array of objects Templates contained in folder.
{"id": 0,
"favorite": true,
"folders": [{"id": 0,
"favorite": true,
"folders": [{ }
],
"name": "string",
"permalink": "string",
"reports": [{"scope": {"sheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": null,
"name": null
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [ ],
"createdAt": null,
"createdBy": { },
"discussionId": null,
"id": null,
"modifiedAt": null,
"text": null
}
],
"commentAttachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"cells": [{"columnId": null,
"columnType": null,
"conditionalFormat": null,
"displayValue": null,
"format": null,
"formula": null,
"hyperlink": null,
"image": null,
"linkInFromCell": null,
"linksOutToCells": [ ],
"objectValue": null,
"overrideValidation": null,
"strict": null,
"value": null
}
],
"columns": [{"autoNumberFormat": null,
"contactOptions": [ ],
"description": null,
"format": null,
"formula": null,
"hidden": null,
"id": null,
"index": null,
"locked": null,
"lockedForUser": null,
"options": [ ],
"primary": null,
"symbol": null,
"systemColumnType": null,
"tags": [ ],
"title": null,
"type": null,
"validation": null,
"version": null,
"width": null
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": null,
"name": null
},
"isCompleted": true,
"attachments": [null
],
"discussions": [null
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": null,
"name": null
},
"objectValue": {"objectType": null
},
"options": [null
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"workspaces": [{"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
]
},
"sourceSheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": "string",
"name": "string"
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussionId": 0,
"id": 0,
"modifiedAt": "2019-08-24T14:15:22Z",
"text": "string"
}
],
"commentAttachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cells": [{"columnId": 0,
"columnType": "string",
"conditionalFormat": "string",
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"linkInFromCell": {"columnId": null,
"rowId": null,
"sheetId": null,
"sheetName": null,
"status": null
},
"linksOutToCells": [null
],
"objectValue": {"objectType": null
},
"overrideValidation": true,
"strict": true,
"value": "string"
}
],
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"isCompleted": true,
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [{"email": null,
"name": null
}
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string"
},
"image": {"altText": "string",
"height": 0,
"id": "string",
"width": 0
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"objectValue": {"objectType": "ABSTRACT_DATETIME"
},
"options": ["string"
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"isSummaryReport": true,
"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [null
],
"cells": [null
],
"columns": [null
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussions": [null
],
"proof": {"id": null,
"originalId": null,
"name": null,
"proofType": null,
"proofRequestUrl": null,
"version": null,
"lastUpdatedAt": null,
"lastUpdatedBy": null,
"isCompleted": null,
"attachments": [ ],
"discussions": [ ]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": null,
"name": null
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": null,
"contactOptions": [ ],
"createdAt": null,
"createdBy": { },
"displayValue": null,
"format": null,
"formula": null,
"hyperlink": null,
"image": null,
"index": null,
"locked": null,
"lockedForUser": null,
"modifiedAt": null,
"modifiedBy": { },
"objectValue": null,
"options": [ ],
"symbol": null,
"title": null,
"type": null,
"validation": null
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"sheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [null
],
"cells": [null
],
"columns": [null
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussions": [null
],
"proof": {"id": null,
"originalId": null,
"name": null,
"proofType": null,
"proofRequestUrl": null,
"version": null,
"lastUpdatedAt": null,
"lastUpdatedBy": null,
"isCompleted": null,
"attachments": [ ],
"discussions": [ ]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": null,
"name": null
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": null,
"contactOptions": [ ],
"createdAt": null,
"createdBy": { },
"displayValue": null,
"format": null,
"formula": null,
"hyperlink": null,
"image": null,
"index": null,
"locked": null,
"lockedForUser": null,
"modifiedAt": null,
"modifiedBy": { },
"objectValue": null,
"options": [ ],
"symbol": null,
"title": null,
"type": null,
"validation": null
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"sights": [{"backgroundColor": "string",
"defaultWidgetBackgroundColor": "string",
"columnCount": 0,
"favorite": true,
"source": {"id": 0,
"type": "string"
},
"widgets": [{"id": 0,
"type": "CHART",
"contents": {"type": "CHART",
"reportId": 0,
"sheetId": 0,
"axes": [{"location": "BOTTOM",
"title": "string",
"titleInfo": {"type": "ABSTRACT_DATE_TIME"
},
"axisTitleFont": "Arial",
"axisLabelFormat": ",,,,,,,,36,,,,,,,,",
"axisLabelFont": "Arial",
"includeZero": true
}
],
"hyperlink": {"interactionType": "DISTI_COPY",
"folderId": 0,
"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string",
"workspaceId": 0
},
"includedColumnIds": [0
],
"legend": {"location": "BOTTOM",
"legendFormat": ",,1,1,,,,,,,,,,,,,",
"legendFont": "Arial"
},
"selectionRanges": [{"sourceColumnId1": 0,
"sourceColumnId2": 0,
"sourceRowId1": 0,
"sourceRowId2": 0
}
],
"series": [{"title": "string",
"titleInfo": {"type": "ABSTRACT_DATE_TIME"
},
"seriesTitleFormat": "string",
"seriesType": "AREA",
"dataLabels": {"labelType": "NONE"
},
"tooltips": {"labelType": "NONE"
},
"lineType": "CURVED",
"holeSize": 0,
"isFilled": true,
"isHalf": true,
"isStacked": true,
"xFormat": ",,1,1,,,,,,,,,,,,,",
"yFormat": ",,1,1,,,,,,,,,,,,,",
"color": "string",
"axisLocationX": "BOTTOM",
"axisLocationY": "BOTTOM",
"yColumnInfo": {"type": "ABSTRACT_DATE_TIME"
},
"xColumnInfo": {"type": "ABSTRACT_DATE_TIME"
},
"seriesSelectionOrder": "COLUMNS",
"seriesData": [{"x": null,
"y": null,
"xFormat": null,
"yFormat": null,
"color": null
}
],
"selectionRanges": [{"sourceColumnId1": null,
"sourceColumnId2": null,
"sourceRowId1": null,
"sourceRowId2": null
}
]
}
],
"verticalGridLines": {"lineStyle": "SOLID"
},
"horizontalGridLines": {"lineStyle": "SOLID"
}
},
"height": 0,
"showTitle": true,
"showTitleIcon": true,
"title": "string",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"titleFont": "Arial",
"version": 0,
"viewMode": 1,
"width": 0,
"xPosition": 0,
"yPosition": 0
}
],
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
},
"createdAt": "2019-08-24T14:15:22Z",
"modifiedAt": "2019-08-24T14:15:22Z",
"id": 0,
"accessLevel": "ADMIN",
"permalink": "string",
"name": "string"
}
],
"templates": [{"id": 0,
"type": "report",
"accessLevel": "ADMIN",
"blank": true,
"categories": ["string"
],
"description": "string",
"globalTemplate": "BLANK_SHEET",
"image": "string",
"largeImage": "string",
"locale": "ar_AE",
"name": "Awesome Project Template",
"tags": ["string"
]
}
]
}
],
"name": "string",
"permalink": "string",
"reports": [{"scope": {"sheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": null,
"name": null
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [ ],
"createdAt": null,
"createdBy": { },
"discussionId": null,
"id": null,
"modifiedAt": null,
"text": null
}
],
"commentAttachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"cells": [{"columnId": null,
"columnType": null,
"conditionalFormat": null,
"displayValue": null,
"format": null,
"formula": null,
"hyperlink": null,
"image": null,
"linkInFromCell": null,
"linksOutToCells": [ ],
"objectValue": null,
"overrideValidation": null,
"strict": null,
"value": null
}
],
"columns": [{"autoNumberFormat": null,
"contactOptions": [ ],
"description": null,
"format": null,
"formula": null,
"hidden": null,
"id": null,
"index": null,
"locked": null,
"lockedForUser": null,
"options": [ ],
"primary": null,
"symbol": null,
"systemColumnType": null,
"tags": [ ],
"title": null,
"type": null,
"validation": null,
"version": null,
"width": null
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": null,
"name": null
},
"isCompleted": true,
"attachments": [null
],
"discussions": [null
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": null,
"name": null
},
"objectValue": {"objectType": null
},
"options": [null
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"workspaces": [{"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
]
},
"sourceSheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": "string",
"name": "string"
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussionId": 0,
"id": 0,
"modifiedAt": "2019-08-24T14:15:22Z",
"text": "string"
}
],
"commentAttachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cells": [{"columnId": 0,
"columnType": "string",
"conditionalFormat": "string",
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"linkInFromCell": {"columnId": null,
"rowId": null,
"sheetId": null,
"sheetName": null,
"status": null
},
"linksOutToCells": [null
],
"objectValue": {"objectType": null
},
"overrideValidation": true,
"strict": true,
"value": "string"
}
],
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"isCompleted": true,
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [{"email": null,
"name": null
}
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string"
},
"image": {"altText": "string",
"height": 0,
"id": "string",
"width": 0
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"objectValue": {"objectType": "ABSTRACT_DATETIME"
},
"options": ["string"
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"isSummaryReport": true,
"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": "string",
"name": "string"
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussionId": 0,
"id": 0,
"modifiedAt": "2019-08-24T14:15:22Z",
"text": "string"
}
],
"commentAttachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cells": [{"columnId": 0,
"columnType": "string",
"conditionalFormat": "string",
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"linkInFromCell": {"columnId": null,
"rowId": null,
"sheetId": null,
"sheetName": null,
"status": null
},
"linksOutToCells": [null
],
"objectValue": {"objectType": null
},
"overrideValidation": true,
"strict": true,
"value": "string"
}
],
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"isCompleted": true,
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [{"email": null,
"name": null
}
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string"
},
"image": {"altText": "string",
"height": 0,
"id": "string",
"width": 0
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"objectValue": {"objectType": "ABSTRACT_DATETIME"
},
"options": ["string"
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"sheets": [{"id": 0,
"fromId": 0,
"ownerId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cellImageUploadEnabled": true,
"columns": [{"autoNumberFormat": {"fill": "string",
"prefix": "string",
"startingNumber": 0,
"suffix": "string"
},
"contactOptions": [{"email": "string",
"name": "string"
}
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": ["string"
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": ["CALENDAR_END_DATE"
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"createdAt": "2019-08-24T14:15:22Z",
"crossSheetReferences": [{"endColumnId": 0,
"endRowId": 0,
"id": 0,
"name": "string",
"startColumnId": 0,
"startRowId": 0,
"status": "BLOCKED",
"sourceSheetId": 0
}
],
"dependenciesEnabled": true,
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [{"attachments": [null
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"discussionId": 0,
"id": 0,
"modifiedAt": "2019-08-24T14:15:22Z",
"text": "string"
}
],
"commentAttachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"commentCount": 0,
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"effectiveAttachmentOptions": ["string"
],
"favorite": true,
"ganttEnabled": true,
"hasSummaryFields": true,
"isMultiPicklistEnabled": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"name": "string",
"owner": "string",
"permalink": "string",
"projectSettings": {"lengthOfDay": 1,
"nonWorkingDays": ["2019-08-24"
],
"workingDays": ["MONDAY"
]
},
"readOnly": true,
"resourceManagementEnabled": true,
"resourceManagementType": "NONE",
"rows": [{"id": 0,
"sheetId": 0,
"siblingId": 0,
"accessLevel": "ADMIN",
"attachments": [{"id": 0,
"parentId": 0,
"attachmentType": "BOX_COM",
"attachmentSubType": "DOCUMENT",
"mimeType": "PNG",
"parentType": "COMMENT",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": null,
"name": null
},
"name": "string",
"sizeInKb": 0,
"url": "string",
"urlExpiresInMillis": 0
}
],
"cells": [{"columnId": 0,
"columnType": "string",
"conditionalFormat": "string",
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": null,
"sheetId": null,
"sightId": null,
"url": null
},
"image": {"altText": null,
"height": null,
"id": null,
"width": null
},
"linkInFromCell": {"columnId": null,
"rowId": null,
"sheetId": null,
"sheetName": null,
"status": null
},
"linksOutToCells": [null
],
"objectValue": {"objectType": null
},
"overrideValidation": true,
"strict": true,
"value": "string"
}
],
"columns": [{"autoNumberFormat": {"fill": null,
"prefix": null,
"startingNumber": null,
"suffix": null
},
"contactOptions": [null
],
"description": "string",
"format": "string",
"formula": "string",
"hidden": true,
"id": 0,
"index": 0,
"locked": true,
"lockedForUser": true,
"options": [null
],
"primary": true,
"symbol": "string",
"systemColumnType": "AUTO_NUMBER",
"tags": [null
],
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true,
"version": 0,
"width": 0
}
],
"conditionalFormat": ",,1,1,,,,,,,,,,,,,",
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"discussions": [{"accessLevel": "ADMIN",
"id": 0,
"comments": [null
],
"commentAttachments": [null
],
"commentCount": 0,
"createdBy": {"email": null,
"name": null
},
"lastCommentedAt": "2019-08-24T14:15:22Z",
"lastCommentedUser": {"email": null,
"name": null
},
"parentId": 0,
"parentType": "ROW",
"readOnly": true,
"title": "string"
}
],
"proof": {"id": 0,
"originalId": 0,
"name": "string",
"proofType": "DOCUMENT",
"proofRequestUrl": "string",
"version": 0,
"lastUpdatedAt": "2019-08-24T14:15:22Z",
"lastUpdatedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"isCompleted": true,
"attachments": [{"id": null,
"parentId": null,
"attachmentType": null,
"attachmentSubType": null,
"mimeType": null,
"parentType": null,
"createdAt": null,
"createdBy": null,
"name": null,
"sizeInKb": null,
"url": null,
"urlExpiresInMillis": null
}
],
"discussions": [{"accessLevel": null,
"id": null,
"comments": [ ],
"commentAttachments": [ ],
"commentCount": null,
"createdBy": null,
"lastCommentedAt": null,
"lastCommentedUser": null,
"parentId": null,
"parentType": null,
"readOnly": null,
"title": null
}
]
},
"expanded": true,
"filteredOut": true,
"format": ",,1,1,,,,,,,,,,,,,",
"inCriticalPath": true,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"permaLink": "string",
"rowNumber": 1,
"version": 0
}
],
"showParentRowsForFilters": true,
"source": {"id": 0,
"type": "string"
},
"summary": {"fields": [{"id": 0,
"contactOptions": [{"email": null,
"name": null
}
],
"createdAt": "2019-08-24T14:15:22Z",
"createdBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string"
},
"image": {"altText": "string",
"height": 0,
"id": "string",
"width": 0
},
"index": 0,
"locked": true,
"lockedForUser": true,
"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"objectValue": {"objectType": "ABSTRACT_DATETIME"
},
"options": ["string"
],
"symbol": "string",
"title": "string",
"type": "ABSTRACT_DATETIME",
"validation": true
}
]
},
"totalRowCount": 0,
"userPermissions": {"summaryPermissions": "ADMIN"
},
"userSettings": {"criticalPathEnabled": true,
"displaySummaryTasks": true
},
"version": 0,
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
}
}
],
"sights": [{"backgroundColor": "string",
"defaultWidgetBackgroundColor": "string",
"columnCount": 0,
"favorite": true,
"source": {"id": 0,
"type": "string"
},
"widgets": [{"id": 0,
"type": "CHART",
"contents": {"type": "CHART",
"reportId": 0,
"sheetId": 0,
"axes": [{"location": "BOTTOM",
"title": "string",
"titleInfo": {"type": "ABSTRACT_DATE_TIME"
},
"axisTitleFont": "Arial",
"axisLabelFormat": ",,,,,,,,36,,,,,,,,",
"axisLabelFont": "Arial",
"includeZero": true
}
],
"hyperlink": {"interactionType": "DISTI_COPY",
"folderId": 0,
"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string",
"workspaceId": 0
},
"includedColumnIds": [0
],
"legend": {"location": "BOTTOM",
"legendFormat": ",,1,1,,,,,,,,,,,,,",
"legendFont": "Arial"
},
"selectionRanges": [{"sourceColumnId1": 0,
"sourceColumnId2": 0,
"sourceRowId1": 0,
"sourceRowId2": 0
}
],
"series": [{"title": "string",
"titleInfo": {"type": "ABSTRACT_DATE_TIME"
},
"seriesTitleFormat": "string",
"seriesType": "AREA",
"dataLabels": {"labelType": "NONE"
},
"tooltips": {"labelType": "NONE"
},
"lineType": "CURVED",
"holeSize": 0,
"isFilled": true,
"isHalf": true,
"isStacked": true,
"xFormat": ",,1,1,,,,,,,,,,,,,",
"yFormat": ",,1,1,,,,,,,,,,,,,",
"color": "string",
"axisLocationX": "BOTTOM",
"axisLocationY": "BOTTOM",
"yColumnInfo": {"type": "ABSTRACT_DATE_TIME"
},
"xColumnInfo": {"type": "ABSTRACT_DATE_TIME"
},
"seriesSelectionOrder": "COLUMNS",
"seriesData": [{"x": null,
"y": null,
"xFormat": null,
"yFormat": null,
"color": null
}
],
"selectionRanges": [{"sourceColumnId1": null,
"sourceColumnId2": null,
"sourceRowId1": null,
"sourceRowId2": null
}
]
}
],
"verticalGridLines": {"lineStyle": "SOLID"
},
"horizontalGridLines": {"lineStyle": "SOLID"
}
},
"height": 0,
"showTitle": true,
"showTitleIcon": true,
"title": "string",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"titleFont": "Arial",
"version": 0,
"viewMode": 1,
"width": 0,
"xPosition": 0,
"yPosition": 0
}
],
"workspace": {"id": 0,
"name": "string",
"accessLevel": "ADMIN",
"permalink": "string"
},
"createdAt": "2019-08-24T14:15:22Z",
"modifiedAt": "2019-08-24T14:15:22Z",
"id": 0,
"accessLevel": "ADMIN",
"permalink": "string",
"name": "string"
}
],
"templates": [{"id": 0,
"type": "report",
"accessLevel": "ADMIN",
"blank": true,
"categories": ["string"
],
"description": "string",
"globalTemplate": "BLANK_SHEET",
"image": "string",
"largeImage": "string",
"locale": "ar_AE",
"name": "Awesome Project Template",
"tags": ["string"
]
}
]
}
➔ Next to Methods