Update a sheet

PATCH

Updates Sheet

Path parameters

sheetIdstringRequired

ID of sheet

Request

This endpoint expects an object.

namestringOptional

The name of the Sheet.

slugstringOptional

The slug of the Sheet.

metadataanyOptional

Useful for any contextual metadata regarding the sheet. Store any valid json

Response

This endpoint returns an object

dataobject

A place to store tabular data

Errors

PATCH

1 curl -X PATCH https://api.x.flatfile.com/v1/sheets/us_sh_YOUR_ID \
2      -H "X-Disable-Hooks: true" \
3      -H "Authorization: Bearer <token>" \
4      -H "Content-Type: application/json" \
5      -d '{
6   "name": "New Sheet Name",
7   "metadata": {
8     "rowHeaders": [
9       6
10     ]
11   }
12 }'

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

Built with

1	curl -X PATCH https://api.x.flatfile.com/v1/sheets/us_sh_YOUR_ID \
2	-H "X-Disable-Hooks: true" \
3	-H "Authorization: Bearer <token>" \
4	-H "Content-Type: application/json" \
5	-d '{
6	"name": "New Sheet Name",
7	"metadata": {
8	"rowHeaders": [
9	6
10	]
11	}
12	}'

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