| POST | /{Workspace}/IntegrationDataTableDDL |
|---|
export class MetadataItem
{
public Name: string;
public Datatype: string;
public Length: string;
public Label: string;
public constructor(init?: Partial<MetadataItem>) { (Object as any).assign(this, init); }
}
export class IntegrationDataTable
{
public Name: string;
public Columns: MetadataItem[];
public Rows: string[][];
public constructor(init?: Partial<IntegrationDataTable>) { (Object as any).assign(this, init); }
}
/** @description Generates the database DDL for a given integration data table. Database types supported: SQLServer */
export class IntegrationDataTableDDL
{
public Workspace: string;
public DatabaseType: string;
public DataTable: IntegrationDataTable;
public DDL: string;
public constructor(init?: Partial<IntegrationDataTableDDL>) { (Object as any).assign(this, init); }
}
TypeScript IntegrationDataTableDDL DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /{Workspace}/IntegrationDataTableDDL HTTP/1.1
Host: dev.fieldsquared.com
Accept: application/xml
Content-Type: application/xml
Content-Length: length
<IntegrationDataTableDDL xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Field2Office.API.Model.Integration">
<DDL>String</DDL>
<DataTable xmlns:d2p1="http://schemas.datacontract.org/2004/07/Field2Office.DomainObjects.Model">
<d2p1:Columns xmlns:d3p1="http://schemas.datacontract.org/2004/07/Field2Office.DomainObjects.Model.Rules">
<d3p1:MetadataItem>
<d3p1:Datatype>String</d3p1:Datatype>
<d3p1:Length>String</d3p1:Length>
<d3p1:Name>String</d3p1:Name>
</d3p1:MetadataItem>
</d2p1:Columns>
<d2p1:Name>String</d2p1:Name>
<d2p1:Rows xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:ArrayOfstring>
<d3p1:string>String</d3p1:string>
</d3p1:ArrayOfstring>
</d2p1:Rows>
</DataTable>
<DatabaseType>String</DatabaseType>
<Workspace>String</Workspace>
</IntegrationDataTableDDL>