Data Model file structure
The Data Model file is an XML file that contains the structure of the Data M model, including each field's name, data type, and any number of detail
tables and nested tables.
Example: promotional data<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<datamodel schemaVersion="1.0.0.3" name="Generic Address Block" version="1" xmlns="https://www.objectiflune.com/connectschemas/DataModelConfig" xsi:schemaLocation="https://www.objectiflune.com/connectschemas/DataModelConfig https://www.objectiflune.com/connectschemas/DataModelConfig/1_0_0_3.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<field type="string" name="Name" required="true"/>
<field type="string" name="Organization" required="true"/>
<field type="string" name="Address1" required="true"/>
<field type="string" name="Address2" required="true"/>
<field type="string" name="Address3" required="true"/>
<field type="string" name="City" required="true"/>
<field type="string" name="StateOrProvince" required="true"/>
<field type="string" name="Country" required="true"/>
<field type="string" name="ZipOrPostalCode" required="true"/>
<field type="string" name="Extra1" required="true"/>
<field type="string" name="Extra2" required="true"/>
</datamodel>
Example: transactional details, in a simple invoice format<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<datamodel schemaVersion="1.0.0.3" name=" Invoice" version="1" xmlns="https://www.objectiflune.com/connectschemas/DataModelConfig" xsi:schemaLocation="https://www.objectiflune.com/connectschemas/DataModelConfig https://www.objectiflune.com/connectschemas/DataModelConfig/1_0_0_3.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<field type="string" name="ID" required="true"/>
<field type="string" name="Gender" required="true"/>
<field type="string" name="LastName" required="true"/>
<field type="string" name="FirstName" required="true"/>
<field type="string" name="Address1" required="true"/>
<field type="string" name="Address2" required="true"/>
<field type="string" name="City" required="true"/>
<field type="string" name="State" required="true"/>
<field type="string" name="Country" required="true"/>
<field type="string" name="ZipCode" required="true"/>
<field type="string" name="Title" required="true"/>
<field type="string" name="Company" required="true"/>
<field type="string" name="Phone2" required="true"/>
<field type="string" name="Email" required="true"/>
<field type="string" name="Language" required="true"/>
<field type="string" name="Number" required="true"/>
<field type="datetime" name="Date" required="true"/>
<field type="datetime" name="DueDate" required="true"/>
<field type="string" name="Rep" required="true"/>
<field type="currency" name="SubTotal" required="true"/>
<field type="currency" name="TaxTotal" required="true"/>
<field type="currency" name="Total" required="true"/>
<table name="detail">
<field type="string" name="Number2" required="true"/>
<field type="string" name="Description" required="true"/>
<field type="currency" name="UnitPrice" required="true"/>
<field type="integer" name="Ordered" required="true"/>
<field type="integer" name="Shipped" required="true"/>
<field type="integer" name="BackOrder" required="true"/>
<field type="currency" name="Total2" required="true"/>
</table>
</datamodel>
Example: nested tables (one table into another)<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<datamodel schemaVersion="1.0.0.3" name="Nested Table Example" version="1" xmlns="https://www.objectiflune.com/connectschemas/DataModelConfig" xsi:schemaLocation="https://www.objectiflune.com/connectschemas/DataModelConfig https://www.objectiflune.com/connectschemas/DataModelConfig/1_0_0_3.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<field type="string" name="RecordField" required="true"/>
<table name="details">
<field type="string" name="DetailsTableField" required="true"/>
<table name="nestedtable">
<field type="string" name="NestedTableField" required="true"/>
</table>
</table>
</datamodel>
Example: default values
Default values can be added to any field with the defaultValue
attribute: <field type="string" name="RecordField" required="true" defaultValue="My Default Value">
|