Platform

​

Reference Filter in Sheet Blueprints

​

Agent Drawer Behavior

​

Chat Tool Repetition

​

Mapping Rule Preview Fix

​

Snapshot Before Run All

​

Smarter Chat Interface

​

Enhanced Mapping Rules in Preview

​

Fixed Deployment Modal Error

​

”Ask in Chat” Column Context Fix

​

Snapshot Before Transformation Program

​

Stability improvements for event subscriptions

​

Spurious toast notifications fixed

​

Comments tray icon, Filter collections, and Toolbar counts are themed

• Field-specific instructions: Store instructions for specific combinations of fields
• Automatic matching: Instructions are automatically matched to sheets with similar field structures
• Metadata support: Add custom metadata to instructions for additional context
• Full CRUD operations: Create, read, update, and delete instructions through a RESTful API

​

Create Instructions

POST /v1/instructions

{
  "instructions": "Map the 'email' field to the customer's primary email address.",
  "fieldKeys": ["first", "last", "email", "subscribed", "phone"],
  "metadata": {
    "category": "customer-data"
  }
}

​

Get Instructions by Sheet ID

GET /v1/instructions/sheet/:sheetId

​

Update Instructions

PATCH /v1/instructions/:instructionId

​

Delete Instructions

DELETE /v1/instructions/:instructionId

​

How It Works

​

Example Usage

// Create instructions for customer data fields
fetch('https://api.flatfile.com/v1/instructions?environmentId=us_env_123&scope=us_acc_456', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer your_secret_key',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    instructions: "Map the 'email' field to the customer's primary email address. The 'first' and 'last' fields should be mapped to the customer's first and last name.",
    fieldKeys: ["first", "last", "email", "subscribed", "phone"],
    metadata: {
      category: "customer-data",
      importance: "high"
    }
  })
})
.then(response => response.json())
.then(data => console.log('Instructions created:', data));

• The collaborator input is now automatically hidden in the Data Clip create modal when there are no space guests
• Similarly, the collaborator section is hidden in the share modal when no guests are available
• This provides a cleaner interface by only showing relevant options based on the current space context

• Support for the FFQL is operator with values of error and valid
• Ability to create complex filters targeting specific fields with validation issues
• User-friendly interface for building advanced filter queries
• Seamless integration with existing filtering capabilities

• The guestAuthentication array field has been replaced with a new guestLinkUrl string field in the DataClip model
• When updating a DataClip with sharedLink set to “unrestricted”, a guest link with a permanent access token is generated
• When updating a DataClip with sharedLink set to “restricted”, a direct sheet URL is generated without a token
• The system now properly handles existing guest links to prevent unnecessary regeneration
• The URL format has been improved for better usability and security

• Maintains data consistency across transformation previews
• Preserves record relationships and references
• Improves transformation accuracy by maintaining original record IDs

• Working with data that has established relationships between records
• Performing multiple transformations where maintaining record identity is important
• Integrating with systems that rely on consistent record identifiers

// Example of creating a transformation job with keepRecordIds
const transformationJobResponse = await HTTPService.createJob({
  type: "workbook",
  operation: "transform",
  source: workbookId,
  destination: destinationWorkbookId,
  config: {
    destinationSheetId: destinationSheetId,
  },
  input: {
    programId: "your-program-id",
    version: "v2",
    keepRecordIds: true, // Set to true to preserve record IDs
  },
});

• Users can now add new rows by hovering over row dividers in the index column
• An “Insert row” button appears when hovering between rows
• Clicking the button adds a new row at the selected position
• The feature provides a more intuitive way to add data at specific positions in a table

• Spanish (es-419)
• Malay (ms)
• Dutch (nl)
• Polish (pl)
• Swedish (sv)
• Thai (th)
• Chinese Traditional (zh-hant)
• Chinese Traditional Hong Kong (zh-hant-HK)

• properly escape field keys containing special characters like periods
• correctly apply the error state and appropriate error messages when duplicate values are encountered for fields with a unique constraint
• handle cases where all initially added records have invalid (duplicate) values for fields with a unique constraint

• Record order is now maintained when inserting records
• When using the Flatfile API to add records, the order of those records will now be preserved keeping the original sequence as provided

• Fixed form validation issues
• Improved error handling
• Enhanced user feedback

​

Actions Resource

​

Agent Versioning

​

Token Refresh

​

Sheet & Cell Updates

​

Job Metadata

• view gives developers the ability to manipulate the Sheet’s view on completion of a Job - Giving control over things like applying a filter or hiding a column
• download gives developers the ability to include file details (such as a fileName and URL), which are then used to trigger a download to the user’s browser on completion of the job

​

Saving and Sharing Custom Views

• Added a “Views” dropdown in the Sheet toolbar to manage and apply saved views.
• Added a “Save View” modal that allows users to name and save the current Sheet filters/sorting as a view.
• Users can copy a sharable link with the view settings applied.
• Saved views are grouped into “My Views” and “All Views” sections.
• Added backend APIs to create, update, and delete saved views.
• Added new React hooks and components to support the saved views functionality.
• Updated translations for the new UI elements related to saved views.

• JobOutcomeNextFileObject Stores individual file information with an ID and optional label.
• JobOutcomeNextFiles Handles multiple files, including an array of JobOutcomeNextFileObject instances and an optional label.