|
|
Edit
|
4 |
|
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.¶ | ¶ | [{Table¶ | ¶ | |__Request__ |__Response__¶ | ¶ | |(text-align:left;vertical-align:top;)¶ | {{{¶ | {¶ | "metainfo": {},¶ | "parameter": [¶ | {¶ | "name" : "table_name",¶ | "value" : "ssurgo.mucropyld",¶ | "description" : "Table name"¶ | }¶ | ]¶ | }¶ | ¶ | }}}¶ | |(text-align:left;vertical-align:top)¶ | {{{¶ | {¶ | "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)¶ | ¶ | ¶ | }] | Show diff |
|
|