Loader Connection Datasources

/api/repositories/{repository}/loaderconnections/{loaderconnection}/datasources

Parameter	Type	Purpose
repository	string	the name of the Repository
loaderconnection	string	the ID of the loader connection

Get

GET /api/repositories/(string: repository)/loaderconnections/(int: loaderconnection)/datasources

Lists the datasources of the Loader Connection

GET /api/repositories/jupiter/loaderconnections/1/datasources HTTP/1.1
Accept: application/json

Response Code	Reason
200	No error
500	Server error

The response will be a Standard Response, with a list of loader connections in the corresponding Repository.

The columns array will contain the list of columns for each data row.

Human Name	Column Name	Description
Filename	Filename	Name of the datasource
Size	Size	Size of the datasource

The size column is applicable only to flat-file loader connections.

The rows array will contain the list of datasources of the corresponding Loader Connection:

"rows": [
{
    "dataRow": [
        "sample.dat",
        "12500"
    ]
}

If there are no datasources in the Loader Connection, rows will be an empty string.

Post

POST /api/repositories/(string: repository)/loaderconnections/(int: loaderconnection)/datasources

Get the list of datasources in a Loader Connection which matches the criteria passed in the post body

POST /api/repositories/jupiter/loaderconnections/1/datasources HTTP/1.1
Content-Type: application/json

{
    "command": "get",
    "data": {
        "filter": "d*",
        "username": "uname",
        "password": "passwd"
    }
}

Response Code	Reason
204	No error
400	Invalid data passed with request
500	Server error

The request packet must contain the command and data elements. The options element is not required.

The response will be as described for all datasources.

Show Data Schemas

GET /api/repositories/(string: repository)/loaderconnections/(int: loaderconnection)/dataschemas

Lists the datasources of the Loader Connection where username and password is not required

GET /api/repositories/jupiter/loaderconnections/1/dataschemas HTTP/1.1
Accept: application/json

Response Code	Reason
200	No error
500	Server error

POST /api/repositories/(string: repository)/loaderconnections/(int: loaderconnection)/dataschemas

Get the list of dataschemas in a Loader Connection which requires username and password

POST /api/repositories/jupiter/loaderconnections/1/dataschemas HTTP/1.1
Content-Type: application/json

{
    "command": "get",
    "data": {
        "username": "uname",
        "password": "passwd"
    }
}

Response Code	Reason
204	No error
400	Invalid data passed with request
500	Server error

The request packet must contain the command and data elements. The options element is not required.

The response for get and post will be a Standard Response, with a list of dataschemas in the corresponding Loader Connection.

The columns array will contain the list of columns for each data row.

Human Name	Column Name	Description
Filename	Filename	Name of the datasource
Size	Size	Size of the datasource

The size column is applicable only to flat-file loader connections.

The rows array will contain the list of dataschemas of the corresponding Loader Connection:

"rows": [
{
    "dataRow": [
        "e3.ddx",
        "12738"
    ]
}

If there are no dataschemas in the Loader Connection, rows will be an empty string.

Show Schema Preview

POST /api/repositories/(string: repository)/loaderconnections/(int: loaderconnection)/dataschemas

Get the preview of dataschemafile

POST /api/repositories/jupiter/loaderconnections/1/dataschemas HTTP/1.1
Content-Type: application/json

{
    "command": "preview",
    "data": {
        "username": "uname",
        "password": "passwd",
        "filename":"filename"
    }
}

filename is the mandatory parameter

Response Code	Reason
204	No error
400	Invalid data passed with request
500	Server error

The request packet must contain the command and data elements. The options element is not required.

The response will be the preview of the schema file