Skip to content

gw_fct_setinsert

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

Description

Function that inserts files and features.

Input example

SELECT gw_fct_setinsert($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"feature":{"featureType":"file", "tableName":"om_visit_event_photo", "id":13, "idName": "id"}, 
"data":{"deviceTrace":{"xcoord":8597877, "ycoord":5346534, "compass":123},
"fields":{"visit_id":13,"hash":"testhash","fextension":"png","
filetype":"Image","value":"urltest","text":"file1"}}}$$)	

Output example

{
  "status": "Accepted",
  "message": {
    "status": "Accepted",
    "message": {
      "level": 3,
      "text": "Message passed successfully"
    },
    "version": "3.5.003",
    "body": {
      "form": {},
      "data": {
        "info": {
          "level": 3,
          "status": "Accepted",
          "message": "Function: gw_fct_setinsert - sucessfully inserted. HINT: None."
        }
      }
    }
  },
  "version": {
    "value": "3.5.003"
  },
  "body": {
    "feature": {
      "tableName": "om_visit_event_photo",
      "id": "17483"
    }
  }
}
Clone this wiki locally