Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Magento 2 (APIs)

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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
        interfaces magento 2

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Product Glossary
        • April
        • Essential Attributes and Supported Tables for Amazon Selling Partner
        • September
        • Essential Attributes and Supported Tables for Pinterest

        Table of Contents

        Snapshot Integrate Magento-2 with Daton Workflow

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand