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. Sign in to Daton

2. Select Magento-2 from the Integrations page

3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later

4. You will be redirected to the second page where you need to provide the Domain Name and an Access Token for your Magento-2

5. Select the required tables from the available list of tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

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. Users would be able to edit/pause/re-activate/delete integration anytime

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.

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

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

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Full Replication

Replication Key: N/A

Fields

Name	Target Datatype
value	STRING
label	STRING

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

Name	Target Datatype
code	STRING
name	STRING

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

Name	Target Datatype
name	STRING
label	STRING

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

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
is_searchable_in_grid	BOOLEAN
attribute_code	STRING

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

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.

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

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.

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

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

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

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

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

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

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Full Replication

Replication Key: N/A

Fields

Name	Target Datatype
label	STRING
code	STRING
group	STRING

CatalogCategoryListV1

Purpose: Get category list

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Full Replication

Replication Key: N/A

Fields

Name	Target Datatype
items	RECORD
search_criteria	RECORD
total_count	INTEGER

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

Name	Target Datatype
items	RECORD
search_criteria	RECORD
total_count	INTEGER

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

Name	Target Datatype
items	RECORD
search_criteria	RECORD
total_count	INTEGER

SalesInvoiceRepositoryV1

Purpose: Lists invoices

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Key-Based Replication

Replication Key: updated_at

Fields

Name	Target Datatype
items	RECORD

##SalesOrderRepositoryV1

Purpose: Lists orders

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Key-Based Replication

Replication Key: updated_at

Fields

Name	Target Datatype
items	RECORD

##SalesRuleCouponRepositoryV1

Purpose: Retrieve a coupon

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Full Replication

Replication Key: N/A

Fields

Name	Target Datatype
items	RECORD

##SalesRuleRuleRepositoryV1

Purpose: Retrieve sales rules

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Full Replication

Replication Key: N/A

Fields

Name	Target Datatype
items	RECORD

##SalesShipmentRepositoryV1

Purpose: Lists shipments

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Key Based Replication

Replication Key: updated_at

Fields

Name	Target Datatype
items	RECORD

##SalesTransactionRepositoryV1

Purpose: Lists transactions

Source API Documentation https://devdocs.magento.com/swagger/index_23.html#/

Replication: Key Based Replication

Replication Key: updated_at

Fields

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
items	RECORD

##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

Name	Target Datatype
id	INTEGER
code	STRING
tax_class_id	INTEGER
tax_class_name	STRING