• Creator
  • #2144816

    API/Flat File Integrations

    by bradyhann ·


    General question.
    Looking to integrate 2 systems. One supports API integration and will not do flat file, the other does flat file, and doesn’t support API.

    What can be done to bridge the gap without symmetry in their capabilities?

You are posting a reply to: API/Flat File Integrations

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    • #2418699

      Connection way

      by dmitry/help-with-em ·

      In reply to API/Flat File Integrations

      Try to use scheduled file that will connect to one system, than generate a file and ask second system to import it. Just a scheduled script or file that runs if file in directory has changes.

    • #4004470

      Reply To: API/Flat File Integrations

      by mobiosolutions ·

      In reply to API/Flat File Integrations

      What is a Flat-File?
      It is necessary to know a flat file to grasp how the integration works. A flat file records data in a straightforward manner. Commas or tabs separate fields. Flat files can be imported and utilized in large relational databases like Microsoft Access and FileMaker Pro. To understand how the integration works, you should have some knowledge about flat files.

      What is API Integration?
      An API enables a cloud-based software system to make a real-time and secure data connection to another. API integration is available with add-in applications in different accounting programs, including NetSuite and Salesforce.

      What is the Difference Between Flat-File Integration and API?
      Flat-file architectures utilize CSV files or other flat-file formats to transfer data sets (for a particular period or several records). Flat-file integration is ideal for paying batch files using SFTP (a secure file transfer protocol) because it works well to transfer batch files.

      Data is transmitted via an API feed API integration. An API connection allows two software applications to exchange information in real-time, but all platforms must support it. A flat-file integration is all that is required.

Viewing 1 reply thread