Is it possible for me to import data from Acumatica using Appsheet?

  • 8 February 2023
  • 2 replies

Userlevel 3
Badge +1

Hi All,

I have apps I made particularly in Appsheet. There are data from some transactions I want to connect with, like from SO, the client, their orders, etc. Is that possible?

Thank you for any information or ideas!


Best answer by ed.goodman 8 February 2023, 18:16

View original

2 replies

Userlevel 5
Badge +2

Here is a link to the help documentation where that excerpt appears.

Userlevel 5
Badge +2

Hello @paula012 

Here are the data providers Acumatica supports at the present time.

Provider Type The type of provider, such as the following:
  • File providers that you use to access data in external files:
    • CSV Provider (PX.DataSync.CSVSYProvider): For import from and export to files in CSV format. For details about creation of CSV providers, see To Create a CSV Data Provider.
    • Excel Provider (PX.DataSync.ExcelSYProvider): For import from and export to Excel spreadsheets. For more information about creation of Excel providers, see To Create an Excel Data Provider.
    • XML Provider (PX.DataSync.XMLSYProvider): For import from and export to files in XML format. For details about XML providers, see To Create an XML Data Provider.
  • Providers that are preconfigured for importing data from and exporting data to external systems:
    • Salesforce Provider (PX.DataSync.SFSYProvider): For import from and export to SalesForce CRM by using the Simple Object Access Protocol (SOAP).
    • Salesforse Sync (PX.Salesforce.SalesforceProvider): For real-time synchronization of data between Acumatica ERP and Salesforce. For more information, see Setting Up Synchronization with Salesforce.
    • MS SQL Provider (PX.DataSync.MSSqlSYProvider): For import from and export to Microsoft SQL Server.
    • HubSpot Provider (PX.DataSync.HubSpot.HSSYProvider): For exporting leads to HubSpot for nurturing and importing leads to Acumatica ERP for processing. Find more information in Integration with HubSpot: General Information.
    • HubSpot Enhanced (PX.DataSync.HubSpot.HubSpotProvider): For synchronization of data between Acumatica ERP and HubSpot. This data provider supports the use of the OAuth protocol for authorization in HubSpot. For details, see Integration with HubSpot: Enhanced HubSpot Data Provider.
  • Providers for exporting payment data to external payment systems:
    • ACH Provider (PX.DataSync.ACHProvider): For exporting data for processing in the Automated Clearing House (ACH) system.
    • ACH Download Provider (PX.DataSync.ACHPDownloadrovider): For exporting data for processing in the Automated Clearing House (ACH) system, with the ability to create prenotes.
    • Giro Payment Provider (PX.DataSync.Banks.GIROPaymentProvider): For exporting data for processing in giro-based payment systems.
    • CPA 005 Provider (PX.Objects.Localizations.CA.DataSync.CPA005ExportProvider): For exporting data for processing in the Electronic Funds Transfer (EFT) system (used in the Canadian localization).
  • Business Process Provider (PX.DataSync.BusinessProcessSYProvider): For business process monitoring in Acumatica ERP. You generally do not create data providers of this type manually. The system creates providers of this type automatically when you click Create Subscriber > Import Scenario on the table toolbar of the Subscribers tab of the Business Events (SM302050) form. For details, see Business Events: Import Scenarios.
  • Provider for importing data from generic inquiries (PX.DataSync.GenericInquirySYDataProvider): The data provider type to use a generic inquiry as the data provider for an import scenario.

The Tax ProviderTax Provider CSV, and Tax Zip Provider built-in types are obsolete. They were used to import data from the Avalara data files, but Avalara no longer supplies these files. Integration with Avalara is done through the Avalara AvaTax SOAP API.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved