When you select a method that contains array-based elements, the Array Elements section allows you to specify the number of elements that can be mapped directly. For each array-based element in the method, you can do one of the following:
Leave the Array Elements field blank — Insight processes the field as an unlimited array. If you map the field as a a target, Insight uses a table-based Insert add_array approach.
Enter the number of array elements to process — If you specify the number of array elements, the field becomes a fixed-length array, which is no longer available as a target side table. You need to map to each array element specifically
Note: On the source side, setting an array size only affects the parameters passed in, for example, for a customer query definition.
XML example
In the XML example, a repeating section has several XML nodes:
Input section — In the Input section, the Name and InputValue node repeat for every field.
Return section — In the Return section, we have Name, InputValue, UpdateRule, and Output Value.
For more information, see the Passing An Array To An XML Method example.
Creating the Array
To map the array-based elements in Scribe Insight, you must create a similar structure and know the number of nodes to create (that is, the number of array elements).
For example, to use this array to cleanse Contact data, 30 separate fields are required. Using the XML example, you must specify 30 separate repeating nodes:
In the Scribe Workbench, click View > Connections. The Connection Manager dialog box appears.
Select the Web Service connection
and click Edit. The Connection
Settings dialog box appears.
Click the Connection
tab.
Click Change
Connection. The Connection Information dialog box appears.
If you are modifying a connection that is not used in a DTS, click Connection.
Verify Web Services is selected and click OK. The Web Service Connection Manager dialog box appears.
Select the Web Service you want to edit and click Edit. The Edit Web Service dialog box appears.
Click the Configuration tab.
Selectthe CleaseSYS method.
In Array Elements, enter 30 for the number of array elements for the Cleanser Input field in this method.
Click Close. You return to the Connection Information dialog box.
Click Cancel. You return to the Connection Manager.
If a Scribe Online message that the connection information has changed, do one of the following:
Click Yes to save your changes to the connection information in the local DTS and make them available to any other DTS that uses this connection, then click Cancel.
Click No to only save your changes to the connection information in the local DTS, but not make them available to any other DTS that uses this connection, then click Cancel.
Click Close.
In the Scribe Workbench, within the DTS, create an Execute step to that method. Insight provides the requested fields as an array containing the four iterated fields.
Now, when you connect using the Contract record from your source, Insight can pass in the values to this method and return the expected clean data.
