IBAN generator updates:
The IBAN generator now replaces a value that is not a valid IBAN with a generated valid IBAN, instead of failing the row. This is enabled by default.
Added the following options to the IBAN generator: Replace Invalid Values, Country of the generated IBANs, and Also Replace NULL Values.
IBAN validation is now stricter. Values that were previously accepted as valid might now be treated as invalid and replaced.
IBAN columns that are a key, take part in a relationship, or have a unique index now use the masking algorithm that guarantees distinct values. Previously this could produce orphan rows in the destination, duplicate keys, or a failed insert, depending on the column and the type of job.
An IBAN written in lowercase or with spaces no longer fails the row.
Removed the deprecated workspace share “access level" / "role" API, which was superseded by permission sets.
Filtering or sorting workspaces by
rolenow returns a 400. Instead, usepermission_set(by name).The deprecated
accessLevel/receivedRolerequest fields are now inert. Instead, usepermissionSetId/receivedPermissionSetId.
Fixed an issue where users with a custom permission set were incorrectly shown as having no access to preset occurrences.
Agent support for document-based data - You can now use the Structural Agent to perform tasks related to document-based data. Document-based data includes JSON columns in relational data and document-based databases (currently MongoDB).
The supported tasks include:
- Enable and disable Document View.
- Read the assigned generators for document column and collection fields.
- Assign generators to document column and collection fields.
Note that you cannot use the Agent to create or edit generic path generators.
Structural now provides an MCP server to allow you to work with your workspaces directly from an MCP client.
Consistency for many generators, including the Name generator and the Address generator, now ignore whitespace when deciding consistency. This helps when these generators are applied to fixed width columns, such as char(40). This update does not affect other generators, such as the Character Scramble generator and Timestamp Shift generator.