CRMS-01 Download Table Data SERVICE-26315

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.

{
    "metainfo": {},
    "parameter": [
      {
        "name" : "table_name",
        "value" : "gras.d_animal_unit",
        "description" : "Table name"
      },
      {
        "name" : "database",
        "value" : "conservation_resources",
        "description" : "Database name"
      },
      {
        "name" : "ip_address",
        "value" : "129.82.20.129",
        "description" : "Database IP address"
      },
      {
        "name" : "port",
        "value" : "1433",
        "description" : "Database TCP/IP port"
      },
      {
        "name" : "user",
        "value" : "********",
        "description" : "Database user"
      },
      {
        "name" : "password",
        "value" : "********",
        "description" : "Database password"
      }
    ]
}

{
  "metainfo": {
    "status": "Finished",
    "suid": "51cf34c2-2091-11e7-a1cd-0fffc915842b",
    "cloud_node": "10.2.228.74",
    "tstamp": "2017-04-13 15:36:57",
    "service_url": "http://localhost:8080/csip-crms/d/crms/gettabledata/1.0",
    "request_ip": "0:0:0:0:0:0:0:1",
    "csip-crms.version": "$version: 0.1.57 a1cb1271c15d 2017-02-23 rob.streetman, built at 2017-04-13 15:36 by robert$",
    "csip.version": "$version: 2.1.164 a2df74c719f6 2017-02-20 od, built at 2017-04-05 14:45 by robert$",
    "cpu_time": 322,
    "expiration_date": "2017-04-13 15:37:27"
  },
  "parameter": [
    {
      "name": "table_name",
      "value": "gras.d_animal_unit",
      "description": "Table name"
    },
    {
      "name": "database",
      "value": "conservation_resources",
      "description": "Database name"
    },
    {
      "name": "ip_address",
      "value": "129.82.20.129",
      "description": "Database IP address"
    },
    {
      "name": "port",
      "value": "1433",
      "description": "Database TCP/IP port"
    },
    {
      "name": "user",
      "value": "*********",
      "description": "Database user"
    },
    {
      "name": "password",
      "value": "********",
      "description": "Database password"
    }
  ],
  "result": [
    {
      "name": "table_schema",
      "value": "gras",
      "description": "Table schema."
    },
    {
      "name": "table_name",
      "value": "d_animal_unit",
      "description": "Table name."
    },
    {
      "name": "column_number",
      "value": 11,
      "description": "Number of columns in table."
    },
    {
      "name": "column_list",
      "value": [
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_unit_id",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "int",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_kind",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "varchar(50)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_class",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "varchar(50)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_gender",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "varchar(50)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_growth_category",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "varchar(50)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_default_AUE",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "numeric(18,10)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_avg_dailyIntake_pct_bodyWeight",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "numeric(18,10)",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NOT NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "end_date",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "date",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "start_date",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "date",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "last_change_date",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "date",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        },
        {
          "name": "column_desc",
          "value": [
            {
              "name": "column_name",
              "value": "animal_default_gestation_period_days",
              "description": "Column name."
            },
            {
              "name": "column_type",
              "value": "int",
              "description": "Column type."
            },
            {
              "name": "nullable",
              "value": "NULL",
              "description": "Column accepts null values."
            }
          ],
          "description": "Column description."
        }
      ],
      "description": "List of columns in table."
    },
    {
      "name": "gras.d_animal_unit.csv",
      "value": "http://localhost:8080/csip-crms/q/51cf34c2-2091-11e7-a1cd-0fffc915842b/gras.d_animal_unit.csv"
    }
  ]
}

(the file to convert)

(the converted file)

Tracker:	Services	Priority:	Normal	Status:	Partly completed
Submitted by:	rob.streetmanSep 30 2016 15:53	Modified by:	JRCarlsonMar 27 2020 13:17	Type:	Data
Path:	m/dataupdate/listtables	Context:	csip-crms	Version:	1.0
Endpoints:	http://csip.engr.colostate.edu:8092/csip-crms/d/crms/gettabledata/1.0
Maintainers:	rob.streetman
Website:	--	Apps:	--
Test Status:	--	Last Tested:	--	Test Count:	--
Test Success Rate:	--	Failed Tests:	--

New	Sep 30 2016 15:53
Submit	by rob.streetman

Partly completed	Mar 27 2020 13:17
	by JRCarlson

CRMS-01 Download Table Data[SERVICE-26315]