ダウンロードしてすぐ実行

by arcesb | April 20, 2018


Receive cXML Orders and Insert into a SQLite Database


Receive and authenticate cXML requests, and map each incoming orders to a new record in SQLite.


フローのダウンロード

The Receive cXML Orders and Insert into a SQLite Database sample flow has pre-configured connectors for authenticating cXML requests received via an exposed API endpoint, extracting received orders and storing them in a local SQLite database.

The following connectors make up the core elements of the flow:

  • API Connector: Allows you to expose API endpoints where you can receive cXML and other such requests.
  • Map Connector: Uses a mapping designer and ArcScript to map data from one format to another.
  • SQLite Connector: Allows you to insert or retrieve the data in these documents to or from a SQLite database.

These connectors are configured to automatically move files from one connector to the next until the incoming cXML requests are transformed and inserted into SQLite. You can modify the automation settings for each connector in its Automation tab, or you can manually process each step in the workflow using the Send button in the connector's Input tab.

If you would like to use this sample flow in your workspace, please follow these instructions:

Importing Workspace

Create Workspace

First, navigate to the Flows tab and click on the cogwheel icon in the top right corner. Choose the Create Workspace option to create a new Workspace for this sample flow.

Import Workspace

Then, from the same cogwheel dropdown, click Import Workspace. In the resulting dialog, choose the downloaded sample flow cXMLreceiver.arcflow to import the relevant connectors and settings. You can choose to import the flow into any Workspace you like, but we recommend using separate Workspaces for distinct workflows.

Once you have successfully imported the sample flow, you can begin configuring the connectors to best suit your specific use case.

API Connector

Authenticate cXML Requests

Access the Public folder in the physical location of the API port, the default path for which is C:\Program Files\CData Arc\data\API\Public, and open the cXML.rst file with a text editor. In the file, there are comments that detail what needs to be edited to with your settings. Modify the password to one you have agreed with your partner. In the sample it is 'passw0rd-here'.

Processing and Response

Next, check to make sure that the correct file destination is set for where the cXML payload will be sent to for further processing. In the sample the destination is C:\Program Files\CData Arc\data\cXMLMapping\Send\input.xml. Note that for this example, cXMLMapping is the name of a configured Map Connector. You must also modify the response you will send to your partner. The sample sends the result to http://localhost:8888, but this should be configured for your trading partner's remote IP address and port.

The API port includes an example.xml file that can be used as the payload in a request to the application API.

SQLite Connector

Connect to SQLite Database & Test the Connection

Navigate to the Settings tab of the SQLite Connector. In order to establish a connection with your SQLite database, you must enter your Data Source information with its complete file path along with any information that is part of your connection string. Click the Test Connection button to verify that you can connect to your SQLite database from CData Arc.

Set up your Output Mapping

After successfully setting up and testing a connection, you can choose to query your SQLite database for information that will then be used to generate EDI documents. Exactly what data is queried is controlled by the Output Mapping configured in the SQLite Connector's settings. If you would like to execute all pre configured output mappings, navigate to the Output tab and click Receive to start retrieving Invoice, Items and Advance Shipment Notice data from the database.

Once you configure the SQLite and API Connectors, the sample flow is ready for use!

Receive cXML Orders and Insert into a SQLite Database


フローは起動しましたか?

おそらくReceive cXML Orders and Insert into a SQLite Database のフローをすでに設定して実行できていると思います。もし、なにか問題がありましたら、サポート あてにご連絡ください。