• application(required): string

  Applicable if the type of Datasource is ESSBASE. The Essbase application name.

• columns(required): object ColumnsType
• connection(required): string

  Connection used for this Datasource.

• cube(required): string

  Applicable if the type of Datasource is ESSBASE. The Essbase database name.

• customDelimiter: string

  Custom delimiter of the data records, if the value provided for delimiter is Custom.

• delimeter: string

  Delimiter of the data records, if Datasource type is DELIMITEDFILE. Delimiter can be Comma for CSV format or Tab for tab-separated format. To use a custom delimiter, use value Custom, and provide the delimiter as a value to customDelimiter.

• description(required): string

  Optional description of this Datasource.

• endRow: integer(int64)

  For a Datasource that is an Excel or text file, the ending row number.

• headerRow: integer(int64)

  For a Datasource that is an Excel or text file, the header row number. 0 if there is no header.

• headers: array headers
• ignoreErrorRecords: boolean
• links: array links
• name: string

  Datasource name. Must begin with a letter. Can contain only letters, underscore character, and digits.

• query(required): string

  Query associated with the Datasource. For example, a SQL query for an external database, or an MDX query for another Essbase cube. The query selects which data you want to make available in this Datasource.

• queryParameters: array queryParameters

  Parameter implementation details, if the Datasource query is parameterized. For example, if the query includes a ? placeholder for passing a parameter, as in the following query: select * from profit_data where year=?, then you need define the implementation details.

• sheet(required): string

  For a Datasource that is an Excel file, the worksheet name.

• skipHiddenRows: boolean
• startRow(required): integer(int64)

  Optional (default is 1 if not given). For a Datasource that is an Excel or text file, the starting data row number, excluding headerRow if one exists. For example, if headerRow is specified as 1 and startRow is specified as 10, the actual starting data row will be 11.

• type(required): string
  Allowed Values: [ "TEMPLATE", "EXCELFILE", "DB", "DELIMITEDFILE", "FIXEDWIDTHFILE", "BI", "ESSBASE", "JDBC", "SPARK", "MS_SQL", "MYSQL", "DB2", "ORACLE", "FILE" ]
• widths(required): array widths

{
    "type":"object",
    "required":[
        "application",
        "columns",
        "connection",
        "cube",
        "description",
        "query",
        "sheet",
        "startRow",
        "type",
        "widths"
    ],
    "properties":{
        "type":{
            "type":"string",
            "enum":[
                "TEMPLATE",
                "EXCELFILE",
                "DB",
                "DELIMITEDFILE",
                "FIXEDWIDTHFILE",
                "BI",
                "ESSBASE",
                "JDBC",
                "SPARK",
                "MS_SQL",
                "MYSQL",
                "DB2",
                "ORACLE",
                "FILE"
            ]
        },
        "connection":{
            "type":"string",
            "description":"<p>Connection used for this Datasource.</p>"
        },
        "description":{
            "type":"string",
            "description":"<p>Optional description of this Datasource.</p>"
        },
        "columns":{
            "$ref":"#/definitions/ColumnsType"
        },
        "name":{
            "type":"string",
            "description":"<p>Datasource name. Must begin with a letter. Can contain only letters, underscore character, and digits.</p>"
        },
        "ignoreErrorRecords":{
            "type":"boolean"
        },
        "delimeter":{
            "type":"string",
            "description":"<p>Delimiter of the data records, if Datasource <i>type</i> is <code>DELIMITEDFILE</code>. Delimiter can be <code>Comma</code> for CSV format or <code>Tab</code> for tab-separated format. To use a custom delimiter, use value <code>Custom</code>, and provide the delimiter as a value to <i>customDelimiter</i>.</p>",
            "xml":{
                "name":"delimiter"
            }
        },
        "customDelimiter":{
            "type":"string",
            "description":"<p>Custom delimiter of the data records, if the value provided for <i>delimiter</i> is <code>Custom</code>.</p>"
        },
        "query":{
            "type":"string",
            "description":"<p>Query associated with the Datasource. For example, a SQL query for an external database, or an MDX query for another Essbase cube. The query selects which data you want to make available in this Datasource.</p>"
        },
        "application":{
            "type":"string",
            "description":"<p>Applicable if the <i>type</i> of Datasource is ESSBASE. The Essbase application name.</p>"
        },
        "cube":{
            "type":"string",
            "description":"<p>Applicable if the <i>type</i> of Datasource is ESSBASE. The Essbase database name.</p>"
        },
        "startRow":{
            "type":"integer",
            "format":"int64",
            "description":"<p>Optional (default is 1 if not given). For a Datasource that is an Excel or text file, the starting data row number, excluding headerRow if one exists. For example, if headerRow is specified as 1 and startRow is specified as 10, the actual starting data row will be 11.</p>"
        },
        "endRow":{
            "type":"integer",
            "format":"int64",
            "description":"<p>For a Datasource that is an Excel or text file, the ending row number.</p>"
        },
        "headerRow":{
            "type":"integer",
            "format":"int64",
            "description":"<p>For a Datasource that is an Excel or text file, the header row number. 0 if there is no header.</p>"
        },
        "sheet":{
            "type":"string",
            "description":"<p>For a Datasource that is an Excel file, the worksheet name.</p>"
        },
        "skipHiddenRows":{
            "type":"boolean"
        },
        "widths":{
            "type":"array",
            "items":{
                "type":"integer",
                "format":"int64",
                "xml":{
                    "name":"widths"
                }
            }
        },
        "queryParameters":{
            "type":"array",
            "description":"<p>Parameter implementation details, if the Datasource query is parameterized. For example, if the query includes a <code>?</code> placeholder for passing a parameter, as in the following query: <code>select * from profit_data where year=?</code>, then you need define the implementation details.</p>",
            "items":{
                "xml":{
                    "name":"queryParameters"
                },
                "$ref":"#/definitions/QueryParamsInfo"
            }
        },
        "headers":{
            "type":"array",
            "items":{
                "xml":{
                    "name":"headers"
                },
                "$ref":"#/definitions/HeaderType"
            }
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        }
    },
    "xml":{
        "name":"datasource"
    }
}

• column(required): array Column

{
    "type":"object",
    "required":[
        "column"
    ],
    "properties":{
        "column":{
            "type":"array",
            "xml":{
                "name":"Column"
            },
            "items":{
                "xml":{
                    "name":"Column"
                },
                "$ref":"#/definitions/ColumnType"
            }
        }
    }
}

• Array of: object HeaderType

{
    "type":"array",
    "items":{
        "xml":{
            "name":"headers"
        },
        "$ref":"#/definitions/HeaderType"
    }
}

• Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

• Array of: object QueryParamsInfo

{
    "type":"array",
    "description":"<p>Parameter implementation details, if the Datasource query is parameterized. For example, if the query includes a <code>?</code> placeholder for passing a parameter, as in the following query: <code>select * from profit_data where year=?</code>, then you need define the implementation details.</p>",
    "items":{
        "xml":{
            "name":"queryParameters"
        },
        "$ref":"#/definitions/QueryParamsInfo"
    }
}

• Array of: integer(int64)

{
    "type":"array",
    "items":{
        "type":"integer",
        "format":"int64",
        "xml":{
            "name":"widths"
        }
    }
}

• Array of: object ColumnType

{
    "type":"array",
    "xml":{
        "name":"Column"
    },
    "items":{
        "xml":{
            "name":"Column"
        },
        "$ref":"#/definitions/ColumnType"
    }
}

• format: string
• index: integer(int32)
• name: string
• nullable: boolean
• system: boolean
• type: string
  Allowed Values: [ "STRING", "DOUBLE", "DATE", "TIMESTAMP", "LONG" ]

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string",
            "xml":{
                "attribute":true
            }
        },
        "type":{
            "type":"string",
            "xml":{
                "attribute":true
            },
            "enum":[
                "STRING",
                "DOUBLE",
                "DATE",
                "TIMESTAMP",
                "LONG"
            ]
        },
        "nullable":{
            "type":"boolean",
            "xml":{
                "attribute":true
            }
        },
        "format":{
            "type":"string",
            "xml":{
                "attribute":true
            }
        },
        "index":{
            "type":"integer",
            "format":"int32",
            "xml":{
                "attribute":true
            }
        },
        "system":{
            "type":"boolean",
            "xml":{
                "attribute":true
            }
        }
    }
}

• cell: string
• name: string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string",
            "xml":{
                "attribute":true
            }
        },
        "cell":{
            "type":"string",
            "xml":{
                "attribute":true
            }
        }
    }
}

• href: string
• method: string
• rel: string
• type: string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "method":{
            "type":"string"
        },
        "type":{
            "type":"string"
        }
    }
}

• defaultValue: string

  A fixed, default parameter value that the Datasource should use as a fallback in case the parameter has an invalid context at runtime. Example: Jan. Required only if the Datasource query is parameterized (it includes a ? placeholder for passing a parameter) AND the placeholder is not intended to reference a substitution variable nor a user-defined function developed in the external source.

• index: integer(int32)

  Ordinal index of the Datasource query parameter. For example, 1 for the first parameter, 2 for the second parameter, etc.

• name: string

  Optional name for the Datasource query parameter, meaningful for your use case. For example, instead of Param1 you can use param_G_month to indicate that the parameter uses a global variable for the current month, or you can rename it to param_appName_month to indicate that the parameter uses an application-level variable for the current month.

• required: boolean

  true if the Datasource query parameter is required, or false otherwise.

• subVariableName: string

  If useSubVariable is true, the name of an Essbase substitution variable.

• type: string
  Allowed Values: [ "STRING", "DOUBLE", "DATE", "TIMESTAMP", "LONG" ]

  Datatype of the Datasource query parameter.

• useSubVariable: boolean

  true if the Datasource query parameter references an Essbase substitution variable, or false otherwise.

{
    "type":"object",
    "properties":{
        "index":{
            "type":"integer",
            "format":"int32",
            "description":"<p>Ordinal index of the Datasource query parameter. For example, 1 for the first parameter, 2 for the second parameter, etc.</p>"
        },
        "name":{
            "type":"string",
            "description":"<p>Optional name for the Datasource query parameter, meaningful for your use case. For example, instead of Param1 you can use param_G_month to indicate that the parameter uses a global variable for the current month, or you can rename it to param_appName_month to indicate that the parameter uses an application-level variable for the current month.</p>"
        },
        "defaultValue":{
            "type":"string",
            "description":"<p>A fixed, default parameter value that the Datasource should use as a fallback in case the parameter has an invalid context at runtime. Example: <b>Jan</b>. Required only if the Datasource query is parameterized (it includes a <code>?</code> placeholder for passing a parameter) AND the placeholder is not intended to reference a substitution variable nor a user-defined function developed in the external source.</p>"
        },
        "required":{
            "type":"boolean",
            "description":"<p><b>true</b> if the Datasource query parameter is required, or <b>false</b> otherwise.</p>"
        },
        "useSubVariable":{
            "type":"boolean",
            "description":"<p><b>true</b> if the Datasource query parameter references an Essbase substitution variable, or <b>false</b> otherwise.</p>"
        },
        "subVariableName":{
            "type":"string",
            "description":"<p>If <i>useSubVariable</i> is <b>true</b>, the name of an Essbase substitution variable.</p>"
        },
        "type":{
            "type":"string",
            "description":"<p>Datatype of the Datasource query parameter.</p>",
            "enum":[
                "STRING",
                "DOUBLE",
                "DATE",
                "TIMESTAMP",
                "LONG"
            ]
        }
    }
}