Anvyl
Anvyl, ETL connector for data replication
Last updated
Anvyl, ETL connector for data replication
Last updated
| Features | Details |
|---|---|
Sign in to Daton
Select Anvyl from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
In the next step you will be asked to enter Anvyl Team ID and API key
Post successful authentication you will be prompted to choose required tables from the list
Then select all required fields
Submit the integration
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
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
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
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
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 |
|---|---|
| Name | Data Type |
|---|---|
| Name | Data Type |
|---|---|
| Name | Data Type |
|---|---|
Release Status
Released
Source API Version
v1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Team ID
Access Token
Replication Type
Key Based Replication, Full Replication
Replication Key
Updated_at
Suggested Replication Frequency
1 hour
Order_Collections
Milestone_Orders
Orders
Order_Items
id
NUMERIC
type
STRING
name
STRING
purchase_orders
RECORD
team
RECORD
created_at
TIMESTAMP
updated_at
TIMESTAMP
id
NUMERIC
type
STRING
status
STRING
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
id
NUMERIC
part
RECORD
name
STRING
quantity
STRING
unit_price_micros
STRING
unit_of_measure
STRING