Example0

Get the current account

Update the current account

Accounts

Create an action

Create several actions

Get an action

Update an action

Delete an action

Actions

List agents

Agent Response

Error Response

Create an agent

Get an agent

List agent versions for an agent

Revert to a specific agent version

List Agent Roles

Assign Role to Agent

Remove Role from Agent

Get logs for an agent

Get an agent log

Get all agent logs in your environment

Get all executions in your environment

Delete an agent

Agents

List apps

Get an app

Update an app

Create an app

Delete an app

Get constraints

Create constraint

Get constraint by ID

Update constraint

Delete constraint

Apps

Number of prompts to return in a page (default 7)

Based on pageSize, which page of prompts to return

List prompts

Get a prompt

Update a prompt

Create a prompt

Delete a prompts

Assistant

Get a commit version

Completes a commit version. This marks the commit as complete and acknowledges that the changes have been applied to the sheet.

Complete a commit version

ID of the commit version to re-emit a commit:created event for

Replay a commit version

Commits

Returns all data retention policies on an account matching a filter for environmentId

The associated Environment ID of the policy.

List data retention policies

Add a new data retention policy to the space

Create a data retention policy

Get a data retention policy

Update a data retention policy

Delete a data retention policy

Data Retention Policies

List documents

Create a document

Get a document

updates a single document, for only the body and title

Update a document

Delete a document

Documents

Returns all entitlements matching a filter for resourceId

The associated Resource ID for the entitlements.

List entitlements

Entitlements

Number of environments to return in a page (default 10)

Based on pageSize, which page of environments to return

List environments

Create an environment

Get a token which can be used to subscribe to events for this environment

Get environment subscription credentials

Get an environment

Updates a single environment, to change the name for example

Update an environment

Delete an environment

Environments

Event topics that the Flatfile Platform emits.

Number of results to return in a page (default 10)

Based on pageSize, which page of results to return

List events

Create an event

Get an event

Acknowledge an event

Get a token which can be used to subscribe to events for this space

The resource ID of the event stream (space or environment id)

Get subscription credentials

Events

Number of files to return in a page (default 20)

Based on pageSize, which page of files to return

The storage mode of file to fetch, defaults to "import"

List files

CreateFileRequest

Upload a file

Get a file

Delete a file

Update a file, to change the workbook id for example

Update a file

Download a file

Files

List guests

Guests are only there to upload, edit, and download files and perform their tasks in a specific Space.

Create a guest

Get a guest

Delete a guest

Updates a single guest, for example to change name or email

Update a guest

Get guest token

List Guest Roles

Assign Role to Guest

Remove Role from Guest

Guests can be created as a named guest on the Space or there’s a global link that will let anonymous guests into the space.

Invite guests

Guests

When provided, only jobs for the given environment will be returned

When provided, only jobs for the given space will be returned

When provided, only jobs for the given workbook will be returned

When provided, only jobs for the given file will be returned

When provided, only jobs that are parts of the given job will be returned

Number of jobs to return in a page (default 20)

Based on pageSize, which page of jobs to return

Sort direction - asc (ascending) or desc (descending)

When true, only top-level jobs will be returned unless a parentId is specified

List jobs

Create a job

Get a job

Update a job

Delete a job

Execute a job

Get a job's execution plan

Replace a job's plan

Update one or more individual fields on a job's execution plan

Update a job's plan

Acknowledge a job

Acknowledge a job outcome and return the job

Acknowledge a job outcome

Complete a job

Fail a job

Cancel a job

Retry a failed job

Preview a mutation

Split a job

Jobs

Creates a list of mapping rules based on two provided schemas

Create a mapping between two schemas

Deletes all history for the authenticated user

Delete all history for the authenticated user

Number of programs to return in a page (default 10)

Based on pageSize, which page of records to return

List mapping programs

Get a mapping program

Update a mapping program

Delete a mapping program

Add mapping rules to a program

Deletes multiple mapping rules from a program

Delete multiple mapping rules

List mapping rules

Get a mapping rule

Update a mapping rule

Updates a list of mapping rules in a program

Update a list of mapping rules

Delete a mapping rule

Mapping

Returns records from a sheet in a workbook

The Record Ids param (ids) is a list of record ids that can be passed to several record endpoints allowing the user to identify specific records to INCLUDE in the query, or specific records to EXCLUDE, depending on whether or not filters are being applied. When passing a query param that filters the record dataset, such as 'searchValue', or a 'filter' of 'valid' | 'error' | 'all', the 'ids' param will EXCLUDE those records from the filtered results. For basic queries that do not filter the dataset, passing record ids in the 'ids' param will limit the dataset to INCLUDE just those specific records. Maximum of 100 allowed.

Number of records to return in a page (default 10,000)

Based on pageSize, which page of records to return (Note - numbers start at 1)

The length of the record result set, returned as counts.total

If true, linked records will be included in the results. Defaults to false.

Include error messages, defaults to false.

A list of field keys to include in the response. If not provided, all fields will be included.

if "for" is provided, the query parameters will be pulled from the event payload

An FFQL query used to filter the result set

Get records

Updates existing records in a workbook sheet

Update records

Insert records

A list of record IDs to delete. Maximum of 100 allowed.

Delete records

Searches for all values that match the 'find' value (globally or for a specific field via 'fieldKey') and replaces them with the 'replace' value. Wrap 'find' value in double quotes for exact match (""). Returns a commitId for the updated records

The Record Ids param (ids) is a list of record ids that can be passed to several record endpoints allowing the user to identify specific records to INCLUDE in the query, or specific records to EXCLUDE, depending on whether or not filters are being applied. When passing a query param that filters the record dataset, such as 'searchValue', or a 'filter' of 'valid' | 'error' | 'all', the 'ids' param will EXCLUDE those records from the filtered results. For basic queries that do not filter the dataset, passing record ids in the 'ids' param will limit the dataset to INCLUDE just those specific records

Finds and replaces field values matching search criteria


Records

List roles

Roles

Fetch all secrets for a given environmentId and optionally apply space overrides

1	curl -X POST https://api.x.flatfile.com/v1/apps \
2	-H "X-Disable-Hooks: true" \
3	-H "Authorization: Bearer <token>" \
4	-H "Content-Type: application/json" \
5	-d '{
6	"name": "Nightly Data Loads",
7	"namespace": "nightly-data",
8	"type": "CUSTOM",
9	"entity": "Sync",
10	"entityPlural": "Syncs",
11	"icon": "<svg xmlns=\"http://www.w3.org/2000/svg\" fill=\"currentColor\" class=\"bi bi-bar-chart-fill\" viewBox=\"0 0 16 16\">\n <path d=\"M1 11a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v3a1 1 0 0 1-1 1H2a1 1 0 0 1-1-1zm5-4a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v7a1 1 0 0 1-1 1H7a1 1 0 0 1-1-1zm5-5a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v12a1 1 0 0 1-1 1h-2a1 1 0 0 1-1-1z\"/>\n</svg>",
12	"metadata": {
13	"foo": "bar"
14	}
15	}'

1	{
2	"data": {
3	"id": "us_app_YOUR_ID",
4	"name": "Nightly Data Loads",
5	"namespace": "nightly-data",
6	"type": "CUSTOM",
7	"entity": "Sync",
8	"entityPlural": "Syncs",
9	"icon": "<svg xmlns=\"http://www.w3.org/2000/svg\" fill=\"currentColor\" class=\"bi bi-bar-chart-fill\" viewBox=\"0 0 16 16\">\n <path d=\"M1 11a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v3a1 1 0 0 1-1 1H2a1 1 0 0 1-1-1zm5-4a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v7a1 1 0 0 1-1 1H7a1 1 0 0 1-1-1zm5-5a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1v12a1 1 0 0 1-1 1h-2a1 1 0 0 1-1-1z\"/>\n</svg>",
10	"metadata": {
11	"foo": "bar"
12	},
13	"environmentFilters": {
14	"type": [
15	"PROD",
16	"DEV"
17	],
18	"exclude_ids": [
19	"us_env_123456"
20	]
21	},
22	"createdAt": "2023-10-30T16:59:45.735Z",
23	"updatedAt": "2023-10-30T16:59:45.735Z",
24	"deletedAt": null,
25	"activatedAt": null
26	}
27	}