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.

  • Pulse

    • Daton

      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

      • How to Integrate Bubble with Daton

      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