Duplicate a workbook
This endpoint lets you duplicate an existing workbook. The workbook copy can be placed in a different folder from the original workbook, potentially with a different name and description. This is useful for creating workbook templates or backups.
Usage notes
-
The
workbookIdin the URL specifies the original workbook to be copied. Retrieve the workbookId by calling the /v2/workbooks endpoint. -
The
destinationFolderIdin the request body specifies where to place the new workbook.- To use the “My Documents” folder for a specific user as the destination folder, call the /v2/members/{memberId} endpoint and use the
homeFolderIdincluded in the response. - Retrieve the folderId of all folders by calling the /v2/files endpoint and reviewing the
idfield in the response for files with atypeoffolder.
- To use the “My Documents” folder for a specific user as the destination folder, call the /v2/members/{memberId} endpoint and use the
Usage scenarios
- Reuse: Use an existing workbook as a baseline for a “one-off” purpose instead of a template.
- Template creation: Create a copy of a workbook to serve as a template for future projects.
- Backup: Make a backup of a workbook before making significant changes. Version tagging is also a useful way to accomplish this.
Best practices
- Always verify that the destination folder has the correct permissions set to avoid access issues.
- When using as a template, ensure that all data connections are correctly configured to prevent data leaks or errors.
Copying saved views
- Set
copyBookmarkstoallto copy every saved view (formerly called a bookmark) applied to the source workbook. This is available to admins only. - Set
copyBookmarkstoaccessibleto copy personal saved views and those shared with the user initiating the operation. - Ownership of all copied saved views transfers to the user initiating the copy operation.
Authentication
OAuth authentication of the form <token>.
Path parameters
Request
If set to all (available to admins only), every saved view (formerly called a bookmark) applied to the workbook is copied. If set to accessible, only personal saved views and those shared with the user initiating the operation are copied. Ownership of all saved views in the duplicate workbook transfers to the user initiating the operation. If not set, saved views are not copied.
Response
For a workbook deployed to a tenant organization by a deployment policy with a version tag, the urlId of the original source workbook in the parent organization. Only present when includeTaggedSourceUrlId=true is included in the request.

