gw_fct_setcsv - Giswater/giswater_dbmodel GitHub Wiki


Description

Function, which organizes data imported by python from csv file to temp_csv table.

Input example

SELECT gw_fct_setcsv($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, 
"values":[{"fid": 236, "csv1": "113961", "csv2": "38", "csv3": "50"},
{"fid": 236, "csv1": "113961", "csv2": "38", "csv3": "50"}]}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Copy done successfully"
  },
  "version": "3.5.002",
  "body": {
    "form": {},
    "data": {}
  }
}