Magento 2 (APIs)
Magento 2 ETL connector for data replication
Last updated
Magento 2 ETL connector for data replication
Last updated
Replication Key: updated_at date Suggested Replication Frequency | 1 hr
Sign in to Daton
Select Magento-2 from the Integrations page
Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later
You will be redirected to the second page where you need to provide the Domain Name and an Access Token for your Magento-2
Select the required tables from the available list of tables
Then select all required fields for each table
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
DirectoryCountryInformationAcquirerV1
Purpose: Get all countries and regions information for the store.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CatalogProductAttributeTypesListV1
Purpose: Retrieve list of product attribute types
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CatalogProductLinkTypeListV1
Purpose: Retrieve information about available product link types
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CatalogProductTypeListV1
Purpose: Retrieve available product types
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CustomerAddressMetadataV1
Purpose: Get all attribute metadata.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
DirectoryCurrencyInformationAcquirerV1
Purpose: Get currency information for the store.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
InventoryApiSourceRepositoryV1
Purpose: Find Sources by SearchCriteria SearchCriteria is not required because load all stocks is useful case.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
StoreGroupRepositoryV1
Purpose: Retrieve list of all groups.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
StoreStoreRepositoryV1
Purpose: Retrieve list of all stores
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
StoreWebsiteRepositoryV1
Purpose: Retrieve list of all websites
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CatalogProductCustomOptionTypeListV1
Purpose: Get custom option types
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
CatalogCategoryListV1
Purpose: Get category list
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
SalesOrderItemRepositoryV1
Purpose: Lists order items
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key-Based Replication
Replication Key: updated_at
Fields
SalesCreditmemoRepositoryV1
Purpose: Lists credit memos
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key-Based Replication
Replication Key: updated_at
Fields
SalesInvoiceRepositoryV1
Purpose: Lists invoices
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key-Based Replication
Replication Key: updated_at
Fields
##SalesOrderRepositoryV1
Purpose: Lists orders
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key-Based Replication
Replication Key: updated_at
Fields
##SalesRuleCouponRepositoryV1
Purpose: Retrieve a coupon
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##SalesRuleRuleRepositoryV1
Purpose: Retrieve sales rules
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##SalesShipmentRepositoryV1
Purpose: Lists shipments
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key Based Replication
Replication Key: updated_at
Fields
##SalesTransactionRepositoryV1
Purpose: Lists transactions
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key Based Replication
Replication Key: updated_at
Fields
##CatalogAttributeSetRepositoryV1
Purpose: Retrieve list of Attribute Sets
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##CatalogCategoryAttributeRepositoryV1
Purpose: Retrieve all attributes for entity type
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##CatalogProductAttributeGroupRepositoryV1
Purpose: Retrieve list of attribute groups
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##CatalogProductAttributeRepositoryV1
Purpose: Retrieve all attributes for entity type
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields
##CatalogProductRepositoryV1
Purpose: Get product list
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key Based Replication
Replication Key: updated_at
Fields
##CustomerCustomerRepositoryV1
Purpose: Get customer by Customer ID.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Key Based Replication
Replication Key: updated_at
Fields
##CustomerGroupManagementV1
Purpose: Get default customer group.
Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/
Replication: Full Replication
Replication Key: N/A
Fields