Magento 2 (APIs)
Magento 2 ETL connector for data replication

Snapshot

Features
Details
Release Status
Released
Source API Version
v1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Magento-2 Domain Name Magento-2 Access Token
Replication Type
Full Replication Key Based Incremental
Replication Key: updated_at date Suggested Replication Frequency | 1 hr
##Tables/APIs Supported
DirectoryCountryInformationAcquirerV1
CatalogProductAttributeTypesListV1
CatalogProductLinkTypeListV1
CatalogProductTypeListV1
CustomerAddressMetadataV1
DirectoryCurrencyInformationAcquirerV1
InventoryApiSourceRepositoryV1
StoreGroupRepositoryV1
StoreStoreRepositoryV1
StoreWebsiteRepositoryV1
CatalogProductCustomOptionTypeListV1
CatalogCategoryListV1
SalesOrderItemRepositoryV1
SalesCreditmemoRepositoryV1
SalesInvoiceRepositoryV1
SalesOrderRepositoryV1
SalesRuleCouponRepositoryV1
SalesRuleRuleRepositoryV1
SalesShipmentRepositoryV1
SalesTransactionRepositoryV1
CatalogAttributeSetRepositoryV1
CatalogCategoryAttributeRepositoryV1
CatalogProductAttributeGroupRepositoryV1
CatalogProductAttributeRepositoryV1
CatalogProductRepositoryV1
CustomerCustomerRepositoryV1
CustomerGroupManagementV1

Integrate Magento-2 with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Magento-2 from Integrations page
  3. 3.
    Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
  4. 4.
    You will be redirected to second page where you need to provide the Domain Name and and Access Token for your Magento-2.
  5. 5.
    Select required tables from the available list of tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 1.
    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
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

TABLES

DirectoryCountryInformationAcquirerV1
Purpose: Get all countries and regions information for the store.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
id
INTEGER
two_letter_abbreviation
STRING
three_letter_abbreviation
STRING
full_name_locale
STRING
full_name_english
STRING
available_regions
RECORD
CatalogProductAttributeTypesListV1
Purpose: Retrieve list of product attribute types
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
value
STRING
label
STRING
CatalogProductLinkTypeListV1
Purpose: Retrieve information about available product link types
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
code
STRING
name
STRING
CatalogProductTypeListV1
Purpose: Retrieve available product types
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
name
STRING
label
STRING
CustomerAddressMetadataV1
Purpose: Get all attribute metadata.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
frontend_input
STRING
input_filter
STRING
store_label
STRING
validation_rules
RECORD
multiline_count
INTEGER
visible
BOOLEAN
required
BOOLEAN
data_model
STRING
options
RECORD
frontend_class
STRING
user_defined
BOOLEAN
sort_order
INTEGER
frontend_label
STRING
note
STRING
system
BOOLEAN
backend_type
STRING
is_used_in_grid
BOOLEAN
is_visible_in_grid
BOOLEAN
is_filterable_in_grid
BOOLEAN
DirectoryCurrencyInformationAcquirerV1
Purpose: Get currency information for the store.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
base_currency_code
STRING
base_currency_symbol
STRING
default_display_currency_code
STRING
default_display_currency_symbol
STRING
available_currency_codes
STRING
exchange_rates
RECORD
InventoryApiSourceRepositoryV1
Purpose: Find Sources by SearchCriteria SearchCriteria is not required because load all stocks is useful case.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
search_criteria
RECORD
total_count
INTEGER
StoreGroupRepositoryV1
Purpose: Retrieve list of all groups.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
id
INTEGER
website_id
INTEGER
root_category_id
INTEGER
default_store_id
INTEGER
name
STRING
code
STRING
StoreStoreRepositoryV1
Purpose: Retrieve list of all stores
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
id
INTEGER
code
STRING
name
STRING
website_id
INTEGER
store_group_id
INTEGER
is_active
INTEGER
StoreWebsiteRepositoryV1
Purpose: Retrieve list of all websites
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
id
INTEGER
code
STRING
name
STRING
default_group_id
INTEGER
CatalogProductCustomOptionTypeListV1
Purpose: Get custom option types
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
label
STRING
code
STRING
group
STRING
CatalogCategoryListV1
Purpose: Get category list
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
search_criteria
RECORD
total_count
INTEGER
SalesOrderItemRepositoryV1
Purpose: Lists order items
Replication: Key-Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
search_criteria
RECORD
total_count
INTEGER
SalesCreditmemoRepositoryV1
Purpose: Lists credit memos
Replication: Key-Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
search_criteria
RECORD
total_count
INTEGER
SalesInvoiceRepositoryV1
Purpose: Lists invoices
Replication: Key-Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##SalesOrderRepositoryV1
Purpose: Lists orders
Replication: Key-Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##SalesRuleCouponRepositoryV1
Purpose: Retrieve a coupon
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##SalesRuleRuleRepositoryV1
Purpose: Retrieve sales rules
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##SalesShipmentRepositoryV1
Purpose: Lists shipments
Replication: Key Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##SalesTransactionRepositoryV1
Purpose: Lists transactions
Replication: Key Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##CatalogAttributeSetRepositoryV1
Purpose: Retrieve list of Attribute Sets
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##CatalogCategoryAttributeRepositoryV1
Purpose: Retrieve all attributes for entity type
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##CatalogProductAttributeGroupRepositoryV1
Purpose: Retrieve list of attribute groups
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##CatalogProductAttributeRepositoryV1
Purpose: Retrieve all attributes for entity type
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
items
RECORD
##CatalogProductRepositoryV1
Purpose: Get product list
Replication: Key Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##CustomerCustomerRepositoryV1
Purpose: Get customer by Customer ID.
Replication: Key Based Replication
Replication Key: updated_at
Fields
Name
Target Datatype
items
RECORD
##CustomerGroupManagementV1
Purpose: Get default customer group.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
id
INTEGER
code
STRING
tax_class_id
INTEGER
tax_class_name
STRING
Last modified 3yr ago