Zip Lite Private Preview
Zip operates an Intake-to-Pay platform for any employee to initiate a purchase or vendor request
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | AGREEMENT , CURRENCY , DEPARTMENT , GL_ACCOUNT , LOCATION , LOOKUP , LOOKUP_OPTION , ROLE , SUBSIDIARY , USER_GROUP , USERS , VENDOR ,VENDOR_CREDIT , and WORKFLOW tables. |
History mode | ||
Custom data | check | PAYMENT_METHOD table. |
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | check | AUDIT_LOG , INVOICE , PURCHASE_ORDER , and REQUEST tables and their child tables. |
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Zip setup guide to connect Zip with your destination using Fivetran connectors.
Sync overview
We incrementally sync the following tables and their child tables to capture new records:
APPROVAL
AUDIT_LOG
INVOICE
PURCHASE_ORDER
REQUEST
VENDOR
We also re-import the VENDOR
table once a week to capture deletes.
We also re-import the following tables and their child tables to capture updates and deletes:
AGREEMENT
CURRENCY
DEPARTMENT
GL_ACCOUNT
LOCATION
LOOKUP
LOOKUP_OPTION
ROLE
SUBSIDIARY
USER_GROUP
USERS
VENDOR_CREDIT
WORKFLOW
Schema information
This schema applies to all Zip connectors.
Explore Zip schema ERD