-
Notifications
You must be signed in to change notification settings - Fork 11
gw_fct_setinsert
Edgar Fuste edited this page Nov 2, 2021
·
1 revision
Function that inserts files and features.
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"}}}$$)
{
"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"
}
}
}