SAPB1 – XML (Magic xpi 4.5)
To configure the SAPB1 connector with an XML interface, follow these steps:
-
Define an SAPB1 resource in the Settings dialog box's Resources section. This allows you to create the required connections to SAP databases. For more information on how to do this, click here. You cannot continue with the next step until you have done this.
-
Drag the SAPB1 connector into the flow area. When you do this, the Properties pane for the connector opens.
-
In the Setting section, select the required Resource Name from the drop-down list.
-
In the Setting section, select the XML interface.
-
Double-click or right-click on the connector and select Configuration from the context menu to open the SAPB1 Configuration dialog box. It contains the following fields:
|
|
|
|
Connection
|
|
Resource Name
|
This read-only field displays the name of the SAPB1 resource or dynamic resource that you defined in the Settings dialog box's Resources section and selected for this connector.
|
|
Keep Session Open
|
Select the check box to indicate whether you want the connection to the SAP Business One database to remain open after the operation is completed.
|
|
Operation
|
|
Operation
|
From the drop-down list, select the operation to be executed. The available operations are:
-
Query
-
Add
-
Update
-
Delete
-
Cancel
-
Close
|
|
Object Type
|
When you are using the XML interface, the following object types are enabled:
Click  to open the Data Object List or User Tables List. Select the SAP Business One data object on which to execute the operation.
|
|
New Object Key
|
This is available for the Add operation only. When you add a new object to SAP Business One, a new object key is created. With some objects, SAP Business One sets this key internally. This can be problematic if you want to query or update the new object, and you do not have its object key.
Click to select an Alpha variable that can hold the last object key added to SAP Business One.
|
|
Advanced Query Options
|
|
XML Export Type
|
Select one of the following from the drop-down list to enter the XML Export Type used in the transaction:
-
0.AllNodes
-
1.ValidNodesOnly
-
2.NodesAsProperties
-
3.ExportImportMode
The default is 3.ExportImportMode, which only supports read/write fields.
|
Note:
|
This option is available for the Query operation only. All other operations support the 3.ExportImportMode only.
|
|
|
Store Result In
|
Select, from the drop-down list, where you want to store the results:
|
Note:
|
This option is available for the Query operation only. All other operations support the 3.ExportImportMode only.
|
|
|
Query Status
|
Select one of the following from the drop-down list:
-
Empty XML
-
Variable
-
As Error
|
Note:
|
This option is available for the Query operation only. All other operations support the 3.ExportImportMode only.
|
|
|
Multi Operation Error Behavior
|
|
Error Behavior
|
If an error occurs during multiple operations, and you have defined an error flow to handle the error, the XML that was created is passed to that error flow. To determine what happens if an error occurs, select one of the following from the drop-down list:
|
|
Note:
|
You can click Refresh XSD to refresh the current object's schema. This is available only when you select a data object.
During Add or Update operations in User Table systems, fields — such as Object, UserSign, Series, Period, Transfered, CreateDate, CreateTime and DataSource — that are maintained by the SAPB1 application are read-only (not updateable) by the user.
|
-
Click OK to complete the process. If a schema does not exist, the required information is retrieved from the server and a schema is created. The configuration information is saved, and the Data Mapper window opens with the selected schema as the Destination. You should define the data required to complete the desired operation in SAPB1.
-
Alternatively, you can click Cancel to exit the SAPB1 Configuration dialog box without saving your settings or modifications.
