Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Anvyl connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Anvyl connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the TikTok Business connector:
- Order Collections
- Milestone Orders
- Orders
- Order Items
Order Collections
Purpose: This API gives all the the meta data about different order collections present in it. Order collections are grouped orders according to split shipments, assemblies, or etc.
Source API Documentation: https://developer.anvyl.com/reference/getv1teamsteamidordercollections
Replication: Full Replication
Replication Key: N/A
Fields
Name |
Data Type |
|---|---|
id |
NUMERIC |
type |
STRING |
name |
STRING |
purchase_orders |
RECORD |
team |
RECORD |
Milestone Orders
Purpose: This API is used to fetch the list of milestones associated with an order using pagination
Source API Documentation: https://developer.anvyl.com/reference/getv1teamsteamidpurchaseordersorderidmilestones
Replication: Key-Based Replication
Fields
Name |
Data Type |
|---|---|
created_at |
TIMESTAMP |
updated_at |
TIMESTAMP |
id |
NUMERIC |
type |
STRING |
status |
STRING |
Orders
Purpose: This API retrieves the all existing purchase orders by using pagination
Source API Documentation: https://developer.anvyl.com/reference/getv1teamsteamidpurchaseorders
Replication: Key-Based Replication
Replication Key: updated_at
Fields
Name |
Data Type |
|---|---|
created_at |
TIMESTAMP |
updated_at |
TIMESTAMP |
id |
NUMERIC |
status |
STRING |
currency |
STRING |
incoterms |
STRING |
note |
STRING |
team |
RECORD |
order_number |
STRING |
payment_terms |
STRING |
supplier |
RECORD |
shipping_method |
STRING |
issued_at |
DATE |
last_issued_at |
DATE |
ships_on |
DATE |
delivered_on |
DATE |
ships_to |
RECORD |
seller_address_line1 |
STRING |
seller_city |
STRING |
seller_country |
STRING |
seller_postal_code |
STRING |
seller_state |
STRING |
seller_address_line2 |
STRING |
name |
STRING |
Order Items
Purpose: This API gets associated order items using pagination
Source API Documentation: https://developer.anvyl.com/reference/getv1teamsteamidpurchaseordersorderidorderitems
Replication: Key Based Replication
Fields
Name |
Data Type |
|---|---|
id |
NUMERIC |
part |
RECORD |
name |
STRING |
quantity |
STRING |
unit_price_micros |
STRING |
| unit_of_measure | STRING |