Zip connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

This page has reference information for the managed Zip connector, including supported source tables and destination table schemas.

Supported source tables

The Zip connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode
`event_logs`	`id`	Audit-trail event logs for actions across your Zip instance, including the event type, timestamp, description, and acting user.	Incremental
`currencies`	`id`	Currencies configured in your Zip instance.	Full refresh only
`roles`	`id`	User roles defined in your Zip instance.	Full refresh only
`subsidiaries`	`id`	Subsidiaries configured in your Zip instance, including status and address details.	Full refresh only
`payment_terms`	`id`	Payment terms, including the net period in days and active status.	Full refresh only
`vendor_credits`	`id`	Vendor credits, including amounts, tax details, line items, and applied invoices.	Full refresh only
`agreements`	`id`	Vendor agreements, including amounts, dates, renewal details, and linked requests and purchase orders.	Full refresh only
`requests`	`id`	Procurement requests, including workflow, status, owner, vendor, and cycle-time details.	Full refresh only
`purchase_orders`	`id`	Purchase orders, including amounts, line items, vendor, and billing status.	Full refresh only
`vendors`	`id`	Vendor master records, including legal names, contacts, addresses, and risk details.	Full refresh only
`invoices`	`id`	Invoices, including amounts, dates, line items, approval status, and ERP sync status.	Full refresh only
`lookup_options`	`id`	Options that belong to custom lookup fields.	Full refresh only
`users`	`id`	Users in your Zip instance, including names, email addresses, roles, and groups.	Full refresh only
`payouts`	`id`	Payouts, including amounts, currencies, payment method types, and linked invoices.	Full refresh only
`gl_codes`	`id`	General ledger codes, including account numbers, types, and subsidiaries.	Full refresh only
`item_accounts`	`id`	Item accounts, including names, active status, and subsidiaries.	Full refresh only
`approvals`	`id`	Approval steps for procurement requests, including status, assignee, timing, and SLA details.	Full refresh only
`locations`	`id`	Locations configured in your Zip instance.	Full refresh only
`workflows`	`id`	Workflows configured in your Zip instance.	Full refresh only
`user_groups`	`id`	User groups defined in your Zip instance.	Full refresh only
`lookups`	`id`	Custom lookup field definitions, including integration and display settings.	Full refresh only
`amortization_schedules`	`id`	Amortization schedule records.	Full refresh only
`change_orders`	`id`	Purchase order change records.	Full refresh only
`expense_categories`	`id`	Expense category records.	Full refresh only
`comments`	`id`	Comments on procurement requests, including the comment text, commenter, and attachments.	Full refresh only
`fx_rates`	`id`	Foreign exchange rate records.	Full refresh only

The connector uses the timestamp field as the cursor for incremental ingestion of the event_logs table.

Destination table schemas

`event_logs`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`event_type`	`STRING`
`timestamp`	`BIGINT`
`accessed_from`	`STRING`
`user_ip_address`	`STRING`
`description`	`STRING`
`user`	`STRING`
`api_key`	`STRING`
`data`	`STRING`

`currencies`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`external_data`	`STRING`

`roles`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`subsidiaries`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`display_name`	`STRING`
`is_active`	`BOOLEAN`
`address`	`STRING`
`external_ids`	`STRING`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`payment_terms`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`net_period_in_days`	`BIGINT`
`is_active`	`BOOLEAN`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`vendor_credits`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`credit_id`	`STRING`
`credit_number`	`STRING`
`credit_date`	`STRING`
`amount`	`STRING`
`pre_tax_amount`	`STRING`
`tax_amount`	`STRING`
`currency`	`STRING`
`description`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`location`	`STRING`
`line_items`	`STRING`
`applied_invoices`	`STRING`
`external_id`	`STRING`
`external_data`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`

`agreements`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`execution_date`	`STRING`
`updated_at`	`BIGINT`
`name`	`STRING`
`agreement_number`	`BIGINT`
`amount`	`STRING`
`created_at`	`BIGINT`
`end_date`	`STRING`
`start_date`	`STRING`
`currency`	`STRING`
`agreement_status`	`STRING`
`attachments`	`STRING`
`subsidiaries`	`STRING`
`vendor`	`STRING`
`agreement_owner`	`STRING`
`department`	`STRING`
`categories`	`STRING`
`subcategories`	`STRING`
`renewal_alert_date`	`STRING`
`renewal_status`	`STRING`
`renewal_stakeholders`	`STRING`
`renewal_date`	`STRING`
`child_requests`	`STRING`
`cancellation_workflow_config`	`STRING`
`requests`	`STRING`
`attributes`	`STRING`
`status`	`STRING`
`auto_renews`	`BOOLEAN`
`original_request`	`STRING`
`purchase_orders`	`STRING`
`display_renewal_status`	`STRING`
`renewal_workflow`	`STRING`
`opt_out_date`	`STRING`
`renewal_stakeholder_queues`	`STRING`

`requests`

Field	Data type
`id`	`STRING`
`request_number`	`BIGINT`
`request_type`	`STRING`
`external_id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`vendor`	`STRING`
`vendors`	`STRING`
`workflow`	`STRING`
`category`	`STRING`
`subcategory`	`STRING`
`owner`	`STRING`
`creator`	`STRING`
`requester`	`STRING`
`purchase_order`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`completed_at`	`BIGINT`
`canceled_at`	`BIGINT`
`initiated_at`	`BIGINT`
`inactive_time`	`BIGINT`
`status`	`BIGINT`
`priority`	`BIGINT`
`price_detail`	`STRING`
`attachments`	`STRING`
`request_link`	`STRING`
`gl_code`	`STRING`
`item_account`	`STRING`
`location`	`STRING`
`engagement`	`STRING`
`amount_usd`	`STRING`
`renewal_source_request`	`STRING`
`previous_agreement_id`	`STRING`
`external_data`	`STRING`
`payment_terms`	`STRING`
`cycle_time_active_days`	`DOUBLE`
`cycle_time_total_days`	`DOUBLE`
`elapsed_time_active_days`	`DOUBLE`
`elapsed_time_total_days`	`DOUBLE`
`payment_method`	`STRING`
`is_existing_vendor`	`BOOLEAN`

`purchase_orders`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`version_number`	`BIGINT`
`currency`	`STRING`
`description`	`STRING`
`tsm_configuration`	`STRING`
`total_amount`	`STRING`
`source`	`BIGINT`
`po_number`	`STRING`
`vendor`	`STRING`
`subsidiary`	`STRING`
`original_request`	`STRING`
`line_items`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`amount_credited`	`STRING`
`advance_shipping_notices`	`STRING`
`tax_amount`	`STRING`
`amount_billed`	`STRING`
`start_date`	`STRING`
`created_by`	`STRING`
`change_orders`	`STRING`
`net_amount_billed`	`STRING`
`external_data`	`STRING`
`payment_method`	`STRING`
`requester`	`STRING`
`attributes`	`STRING`
`agreement_number`	`BIGINT`
`external_id`	`STRING`
`shipping_amount`	`STRING`
`invoices`	`STRING`
`misc_amount`	`STRING`
`end_date`	`STRING`
`payment_frequency`	`STRING`
`payment_terms`	`STRING`

`vendors`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`name`	`STRING`
`primary_phone_country`	`STRING`
`duns_number`	`STRING`
`primary_phone`	`STRING`
`tax_id_number`	`STRING`
`tax_id_type`	`STRING`
`legal_name`	`STRING`
`alternate_name`	`STRING`
`created_at`	`BIGINT`
`currency`	`STRING`
`alternate_name_usage`	`STRING`
`po_email`	`STRING`
`remittance_email`	`STRING`
`last_reviewed_at`	`STRING`
`vat_number`	`STRING`
`address`	`STRING`
`categories`	`STRING`
`owners`	`STRING`
`subsidiaries`	`STRING`
`currencies`	`STRING`
`department`	`STRING`
`contacts`	`STRING`
`description`	`STRING`
`risk`	`STRING`
`external_id`	`STRING`
`child_vendor_ids`	`STRING`
`tier`	`STRING`
`external_data`	`STRING`
`parent_vendor`	`STRING`
`updated_at`	`BIGINT`
`website_link`	`STRING`

`invoices`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`amount_usd`	`STRING`
`source`	`STRING`
`amount`	`STRING`
`flagged_for_coding`	`BOOLEAN`
`invoice_number`	`STRING`
`invoice_date`	`STRING`
`posting_date`	`STRING`
`currency`	`STRING`
`shipping_amount`	`STRING`
`pre_tax_amount`	`STRING`
`will_be_paid_offline`	`BOOLEAN`
`standard_tax_amount`	`STRING`
`description`	`STRING`
`tax_amount`	`STRING`
`due_date`	`BIGINT`
`created_at`	`BIGINT`
`invoice_id`	`STRING`
`invoice_upload_source`	`BIGINT`
`due_date_iso`	`STRING`
`misc_amount`	`STRING`
`withholding_tax_amount`	`STRING`
`flagged_for_coding_reason`	`STRING`
`subsidiary`	`STRING`
`payment_terms`	`STRING`
`line_items`	`STRING`
`posting_period`	`STRING`
`vendor`	`STRING`
`department`	`STRING`
`subcategory`	`STRING`
`location`	`STRING`
`category`	`STRING`
`payouts`	`STRING`
`bill_creator`	`STRING`
`external_data`	`STRING`
`erp_sync_status`	`BIGINT`
`payment_method`	`STRING`
`external_id`	`STRING`
`requesters`	`STRING`
`purchase_orders`	`STRING`
`invoice_url`	`STRING`
`status`	`STRING`
`approvals`	`STRING`
`approved_at`	`STRING`
`attachments`	`STRING`
`updated_at`	`BIGINT`
`erp_last_synced_at`	`STRING`
`applied_vendor_credits`	`STRING`
`erp_synced_at`	`STRING`
`assignee`	`STRING`
`erp_first_successfully_synced_at`	`STRING`

`lookup_options`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`show_in_zip`	`BOOLEAN`
`name`	`STRING`
`key`	`STRING`
`lookup`	`STRING`

`users`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`first_name`	`STRING`
`is_active`	`BOOLEAN`
`last_name`	`STRING`
`email`	`STRING`
`manager`	`STRING`
`subsidiary`	`STRING`
`department`	`STRING`
`roles`	`STRING`
`groups`	`STRING`
`external_data`	`STRING`
`attributes`	`STRING`
`sso_enforced`	`BOOLEAN`

`payouts`

Field	Data type
`id`	`STRING`
`created_at`	`BIGINT`
`updated_at`	`BIGINT`
`type`	`STRING`
`subsidiary`	`STRING`
`vendor`	`STRING`
`account`	`STRING`
`reference_id`	`STRING`
`currency`	`STRING`
`funding_currency`	`STRING`
`currency_object`	`STRING`
`funding_currency_object`	`STRING`
`invoices`	`STRING`
`paid_on_date`	`BIGINT`
`payment_provider_creation_time`	`STRING`
`reversed_on_date`	`STRING`
`amount`	`STRING`
`fx_rate`	`STRING`
`payment_method_type`	`STRING`
`external_data`	`STRING`
`fees`	`STRING`

`gl_codes`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`active`	`BOOLEAN`
`account_number`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`
`account_type`	`STRING`
`account_sub_type`	`STRING`
`source`	`STRING`
`currency`	`STRING`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

`item_accounts`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`active`	`BOOLEAN`
`subsidiaries`	`STRING`
`external_data`	`STRING`
`external_id`	`STRING`

`approvals`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`node_type`	`STRING`
`created_at`	`BIGINT`
`complete_time`	`BIGINT`
`start_time`	`BIGINT`
`due_date`	`BIGINT`
`updated_at`	`BIGINT`
`request`	`STRING`
`tasks`	`STRING`
`assignee`	`STRING`
`total_pause_time_seconds`	`BIGINT`
`stage`	`STRING`
`active_elapsed_seconds`	`BIGINT`
`name`	`STRING`
`active_duration_seconds`	`BIGINT`
`config_type`	`STRING`
`display_status`	`STRING`
`total_duration_seconds`	`BIGINT`
`total_elapsed_seconds`	`BIGINT`
`sla_hours`	`BIGINT`
`queue`	`STRING`

`locations`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`status`	`BIGINT`
`updated_at`	`BIGINT`
`name`	`STRING`
`created_at`	`BIGINT`
`external_data`	`STRING`

`workflows`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`status`	`BIGINT`

`user_groups`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`created_at`	`BIGINT`
`name`	`STRING`
`updated_at`	`BIGINT`

`lookups`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`integration_name`	`STRING`
`name`	`STRING`
`updated_at`	`BIGINT`
`settings_fields`	`STRING`
`integration_key`	`STRING`
`created_at`	`BIGINT`
`show_in_zip`	`BOOLEAN`
`filters`	`STRING`
`display_name_fields`	`STRING`

`amortization_schedules`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`change_orders`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`expense_categories`

Field	Data type
`id`	`STRING`
`type`	`STRING`

`comments`

Field	Data type
`id`	`STRING`
`type`	`STRING`
`deleted`	`STRING`
`external_url`	`STRING`
`updated_at`	`BIGINT`
`created_at`	`BIGINT`
`external_display_name`	`STRING`
`text_html`	`STRING`
`title`	`STRING`
`text`	`STRING`
`modified`	`STRING`
`private_comment_users`	`STRING`
`commenter`	`STRING`
`attachments`	`STRING`
`invoice`	`STRING`
`private_comment_queues`	`STRING`
`task`	`STRING`
`approval_request`	`STRING`
`comment_responses`	`STRING`

`fx_rates`

Field	Data type
`id`	`STRING`
`type`	`STRING`

Feedback

Was this page helpful?

Last updated on 2026-06-30

Zip connector reference

Supported source tables

Destination table schemas

event_logs

currencies

roles

subsidiaries

payment_terms

vendor_credits

agreements

requests

purchase_orders

vendors

invoices

lookup_options

users

payouts

gl_codes

item_accounts

approvals

locations

workflows

user_groups

lookups

amortization_schedules

change_orders

expense_categories

comments

fx_rates