Duplicate a sheet | Flatfile

1 import requests 2 3 url = "https://api.x.flatfile.com/v1/sheets/us_sh_YOUR_ID/duplicate" 4 5 payload = { 6 "name": "Copy of Contacts", 7 "slug": "contacts-copy" 8 } 9 headers = { 10 "X-Disable-Hooks": "true", 11 "Authorization": "Bearer <token>", 12 "Content-Type": "application/json" 13 } 14 15 response = requests.post(url, json=payload, headers=headers) 16 17 print(response.json())

1 { 2 "data": { 3 "id": "us_sh_YOUR_ID", 4 "workbookId": "us_wb_YOUR_ID", 5 "name": "Contacts", 6 "slug": "contacts", 7 "config": { 8 "name": "Contacts", 9 "fields": [ 10 { 11 "type": "string", 12 "key": "firstName", 13 "label": "First Name" 14 }, 15 { 16 "type": "string", 17 "key": "lastName", 18 "label": "Last Name" 19 }, 20 { 21 "type": "string", 22 "key": "email", 23 "label": "Email" 24 } 25 ], 26 "slug": "contacts", 27 "mappingConfidenceThreshold": 0.5 28 }, 29 "updatedAt": "2021-08-31T18:00:00Z", 30 "createdAt": "2021-08-31T18:00:00Z", 31 "metadata": { 32 "rowHeaders": [ 33 4 34 ] 35 } 36 } 37 }

Creates a copy of a sheet including all its data within the same workbook

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

sheetIdstringRequired

ID of sheet to duplicate

Request

This endpoint expects an object.

namestringOptional

Custom name for the duplicated sheet. Defaults to “Copy of [original name]”

slugstringOptional

Custom slug for the duplicated sheet. Defaults to “[original slug]-copy-[timestamp]”

Response

This endpoint returns an object.

dataobject

A place to store tabular data

Authentication

Path parameters

Headers

Request

Response

Errors