Release Notes

March 2025

We have updated our sync strategy for the APPROVAL table. We now capture updates for the APPROVAL table in every sync using the updated_at API parameter. Previously, we used the created_at parameter.

We have updated our sync strategy for the PURCHASE_ORDER table. We now capture updates for the PURCHASE_ORDER table in every sync using the last_updated_after and last_updated_before API parameters. Previously, we used the created_after and created_before parameters.

Effective March 26, 2025 we use a new March 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to support a feature enhancement.

41 total changes • 0 possible breaking changes

Table/column	Change type	New name
`AGREEMENT`
column	New Column	`amount`
column	New Column	`auto_renews`
column	New Column	`display_renewal_status`
column	New Column	`opt_out_date`
column	New Column	`renewal_workflow_id`
`AUDIT_LOG`
column	New Column	`data`
`INVOICE`
column	New Column	`payment_terms`
`PURCHASE_ORDER`
column	New Column	`agreement_number`
column	New Column	`amount_billed`
column	New Column	`category_category_type`
column	New Column	`category_id`
column	New Column	`category_name`
column	New Column	`category_status`
column	New Column	`created_at`
column	New Column	`created_by_id`
column	New Column	`end_date`
column	New Column	`external_id`
column	New Column	`location_id`
column	New Column	`payment_frequency`
column	New Column	`payment_method`
column	New Column	`payment_terms`
column	New Column	`requester_id`
column	New Column	`start_date`
column	New Column	`subcategory_category_type`
column	New Column	`subcategory_id`
column	New Column	`subcategory_name`
column	New Column	`subcategory_status`
column	New Column	`subcategory_type`
`PURCHASE_ORDER_ATTRIBUTE`
table	New Table	`PURCHASE_ORDER_ATTRIBUTE`
`PURCHASE_ORDER_LINE_ITEM_ATTRIBUTE`
table	New Table	`PURCHASE_ORDER_LINE_ITEM_ATTRIBUTE`
`REQUEST`
column	New Column	`link`
`REQUEST_ATTRIBUTE`
column	New Column	`integration_data_id`
column	New Column	`integration_data_key`
column	New Column	`integration_data_name`
column	New Column	`integration_data_type`
`REQUEST_PRICE_LINE_ITEM_ATTRIBUTE`
table	New Table	`REQUEST_PRICE_LINE_ITEM_ATTRIBUTE`
`USER_ATTRIBUTE`
table	New Table	`USER_ATTRIBUTE`
`VENDOR`
column	New Column	`duns_number`
column	New Column	`tax_id_number`
column	New Column	`vat_number`
`VENDOR_CREDIT`
column	New Column	`applied_invoices`

January 2025

We now sync all active users in the USERS table. Previously, we synced only deactivated users.

Effective January 10, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to enhance its usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`REQUEST`
column	New Column			`amount_usd`

December 2024

Lite connectors are now available for the following sources:

Effective December 19, 2024 we use a new December 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to fix a bug.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`VENDOR_EXTERNAL_DATA`
column	Primary Key Change	`id` 🔑	`id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.