• surveys(optional): array surveys

{
    "type":"object",
    "properties":{
        "surveys":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/survey"
            }
        }
    }
}

• Array of: object survey

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

• columns(optional): array columns
• format(optional): object format
  DBMS_CLOUD.COPY_DATA formatting options
• objects(optional): array data_load_objects
• storage_link_name(optional): string
  Name of Cloud Storage Link

  Example: MY-BUCKET
• survey_name(optional): string
  Name of input data survey

  Example: SALES-SURVEY-20220605-112233-4567

{
    "type":"object",
    "properties":{
        "survey_name":{
            "$ref":"#/definitions/survey_name"
        },
        "objects":{
            "$ref":"#/definitions/data_load_objects"
        },
        "storage_link_name":{
            "$ref":"#/definitions/storage_link_name"
        },
        "format":{
            "$ref":"#/definitions/format"
        },
        "columns":{
            "$ref":"#/definitions/columns"
        }
    }
}

• Array of: object column

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/column"
    },
    "example":[
        {
            "column_name":"RECEIVED_DATE",
            "datatype":"DATE",
            "columnId":1,
            "format":"YYYY-MM-DD"
        },
        {
            "column_name":"UNITS",
            "datatype":"NUMBER",
            "columnId":2,
            "length":38
        }
    ]
}

[
    {
        "column_name":"RECEIVED_DATE",
        "datatype":"DATE",
        "columnId":1,
        "format":"YYYY-MM-DD"
    },
    {
        "column_name":"UNITS",
        "datatype":"NUMBER",
        "columnId":2,
        "length":38
    }
]

• Array of: object data_load_object

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/data_load_object"
    },
    "example":[
        {
            "object_name":"sales1976.csv"
        },
        {
            "object_name":"sales2009.csv"
        },
        {
            "object_name":"sales2013.csv"
        }
    ]
}

[
    {
        "object_name":"sales1976.csv"
    },
    {
        "object_name":"sales2009.csv"
    },
    {
        "object_name":"sales2013.csv"
    }
]

• column_name(optional): string
  Column name in table

  Example: UNITS
• columnId(optional): integer
  Column position in input file

  Example: 2
• datatype(optional): string
  Allowed Values: [ "VARCHAR2", "CLOB", "NUMBER", "INTEGER", "FLOAT", "BINARY_FLOAT", "BINARY_DOUBLE", "DATE", "TIMESTAMP", "TIMESTAMP WITH TIME ZONE", "TIMESTAMP WITH LOCAL TIME ZONE", "NVARCHAR2", "NCLOB" ]

  Data type of column

  Example: NUMBER
• format(optional): string
  Data format for certain column types

  Example: YYYY-MM-DD
• length(optional): integer
  Length or precision of column

  Example: 40

{
    "type":"object",
    "properties":{
        "column_name":{
            "$ref":"#/definitions/column_name"
        },
        "columnId":{
            "type":"integer",
            "example":2,
            "description":"Column position in input file"
        },
        "datatype":{
            "type":"string",
            "example":"NUMBER",
            "description":"Data type of column",
            "enum":[
                "VARCHAR2",
                "CLOB",
                "NUMBER",
                "INTEGER",
                "FLOAT",
                "BINARY_FLOAT",
                "BINARY_DOUBLE",
                "DATE",
                "TIMESTAMP",
                "TIMESTAMP WITH TIME ZONE",
                "TIMESTAMP WITH LOCAL TIME ZONE",
                "NVARCHAR2",
                "NCLOB"
            ]
        },
        "length":{
            "type":"integer",
            "example":40,
            "description":"Length or precision of column"
        },
        "format":{
            "type":"string",
            "example":"YYYY-MM-DD",
            "description":"Data format for certain column types"
        }
    }
}

• object_name(optional): string
  Name of object to load

  Example: sales.csv

{
    "type":"object",
    "properties":{
        "object_name":{
            "type":"string",
            "description":"Name of object to load",
            "example":"sales.csv"
        }
    }
}