| POST | /{Workspace}/IntegrationDataTableDDL |
|---|
import java.math.*;
import java.util.*;
import net.servicestack.client.*;
public class dtos
{
/**
* Generates the database DDL for a given integration data table. Database types supported: SQLServer
*/
public static class IntegrationDataTableDDL
{
public String Workspace = null;
public String DatabaseType = null;
public IntegrationDataTable DataTable = null;
public String DDL = null;
public String getWorkspace() { return Workspace; }
public IntegrationDataTableDDL setWorkspace(String value) { this.Workspace = value; return this; }
public String getDatabaseType() { return DatabaseType; }
public IntegrationDataTableDDL setDatabaseType(String value) { this.DatabaseType = value; return this; }
public IntegrationDataTable getDataTable() { return DataTable; }
public IntegrationDataTableDDL setDataTable(IntegrationDataTable value) { this.DataTable = value; return this; }
public String getDdl() { return DDL; }
public IntegrationDataTableDDL setDdl(String value) { this.DDL = value; return this; }
}
public static class IntegrationDataTable
{
public String Name = null;
public ArrayList<MetadataItem> Columns = null;
public ArrayList<ArrayList<String>> Rows = null;
public String getName() { return Name; }
public IntegrationDataTable setName(String value) { this.Name = value; return this; }
public ArrayList<MetadataItem> getColumns() { return Columns; }
public IntegrationDataTable setColumns(ArrayList<MetadataItem> value) { this.Columns = value; return this; }
public ArrayList<ArrayList<String>> getRows() { return Rows; }
public IntegrationDataTable setRows(ArrayList<ArrayList<String>> value) { this.Rows = value; return this; }
}
public static class MetadataItem
{
public String Name = null;
public String Datatype = null;
public String Length = null;
public String Label = null;
public String getName() { return Name; }
public MetadataItem setName(String value) { this.Name = value; return this; }
public String getDatatype() { return Datatype; }
public MetadataItem setDatatype(String value) { this.Datatype = value; return this; }
public String getLength() { return Length; }
public MetadataItem setLength(String value) { this.Length = value; return this; }
public String getLabel() { return Label; }
public MetadataItem setLabel(String value) { this.Label = value; return this; }
}
}
Java IntegrationDataTableDDL DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
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: text/csv
Content-Type: text/csv
Content-Length: length
{"Workspace":"String","DatabaseType":"String","DataTable":{"Name":"String","Columns":[{"Name":"String","Datatype":"String","Length":"String"}],"Rows":[["String"]]},"DDL":"String"}