You are not logged in. Click here to log in.

Application Lifecycle Management
Login
 Projects
 Reports
 Wiki
 Documents
 Trackers
 SCM Repositories
Last ModifiedRecently Visited Items
Search In Project
Search inClear
anonymous
 CRMS-01 Download Table Data#26315/v5
Tags:  not added yet

CRMS-01 Download Table Data[SERVICE-26315]

Tracker: Services Priority: NormalNormal Status: New
Submitted by: rob.streetmanSep 30 2016 15:53 Modified by: rob.streetmanOct 04 2016 17:09 Type:
Data
Path: m/dataupdate/listtables Context: csip-crms Version: 1.0
Endpoints: http:/http://csip.engr.colostate.edu:8092/csip-crms/m/crms/gettabledata/1.0
Maintainers:
rob.streetman
Website: -- Apps:
--
Test Status:
--
Last Tested: -- Test Count: --
Test Success Rate: -- Failed Tests: --
Traceability
Loading…
Description
Service accepts the name of a table in the data store, and returns a CSV file of column names, column types, column constraints, and table data.

Request Response 
  {
    "metainfo": {},
    "parameter": [
      {
        "name" : "table_name",
        "value" : "ssurgo.mucropyld",
        "description" : "Table name"
      }
    ]
}


{
    "metainfo": {
        "status": "Finished",
        "suid": "6958047c-8753-11e6-ab76-3b090d13f41e",
        "cloud_node": "10.2.228.74",
        "tstamp": "2016-09-30 15:18:20",
        "service_url": "http://localhost:8080/csip-crms/m/dataupdate/listtables/1.0",
        "request_ip": "0:0:0:0:0:0:0:1",
        "csip-crms.version": "$version: abort: no repository found in '/home/robert/NetBeansProjects/csip-crms' (.hg not found)!, built at 2016-09-30 15:17 by robert$",
        "csip.version": "$version: 2.1.97 30953ed8a942 2016-08-15 od, built at 2016-09-30 15:17 by robert$",
        "cpu_time": 1717,
        "expiration_date": "2016-09-30 15:18:51"
    },
    "parameter": [
        {
            "name": "table_name",
            "value": "ssurgo.mucropyld",
            "description": "Table name"
        }
    ],
    "result": [
        {
            "name": "table_schema",
            "value": "ssurgo",
            "description": "Table schema."
        },
        {
            "name": "table_name",
            "value": "mucropyld",
            "description": "Table name."
        },
        {
            "name": "column_list",
            "value": [
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "cropname",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "varchar",
                            "description": "Column type."
                        },
                        {
                            "name": "length",
                            "value": "508",
                            "description": "Character Length."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "yldunits",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "varchar",
                            "description": "Column type."
                        },
                        {
                            "name": "length",
                            "value": "508",
                            "description": "Character Length."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "nonirryield_l",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "nonirryield_r",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "nonirryield_h",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "irryield_l",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "irryield_r",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "irryield_h",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "numeric",
                            "description": "Column type."
                        },
                        {
                            "name": "precision",
                            "value": "18",
                            "description": "Numeric precision."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "mukey",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "varchar",
                            "description": "Column type."
                        },
                        {
                            "name": "length",
                            "value": "60",
                            "description": "Character Length."
                        },
                        {
                            "name": "primary_key",
                            "value": true,
                            "description": "Column is primary key."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                },
                {
                    "name": "column_desc",
                    "value": [
                        {
                            "name": "column_name",
                            "value": "mucrpyldkey",
                            "description": "Column name."
                        },
                        {
                            "name": "column_type",
                            "value": "varchar",
                            "description": "Column type."
                        },
                        {
                            "name": "length",
                            "value": "60",
                            "description": "Character Length."
                        },
                        {
                            "name": "column_null",
                            "value": "YES",
                            "description": "Column nullable."
                        }
                    ],
                    "description": "Column description"
                }
            ],
            "description": "List of columns in table."
        },
        {
            "name": "ssurgo.mucropyld.csv",
            "value": "http://localhost:8080/csip-crms/q/6958047c-8753-11e6-ab76-3b090d13f41e/ssurgo.mucropyld.csv"
        }
    ]
}
Files to attach:
(the file to convert)		 Files to fetch:
(the converted file)

Details
Comments & Attachments
Associations
Children
SCM Commits
History (5)
Baselines
All (5)