-
Notifications
You must be signed in to change notification settings - Fork 33
gw_fct_setvisit
Daniel Marín edited this page Jul 8, 2026
·
2 revisions
Set new visit values
SELECT gw_fct_setvisit($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},
"feature":{"featureType":"visit", "tableName":"ve_visit_arc_insp", "id":null, "idName":"visit_id"},
"data":{"fields":{"class_id":6, "arc_id":"2001", "visitcat_id":1, "ext_code":"testcode",
"sediments_arc":10, "desperfectes_arc":1, "neteja_arc":3},
"deviceTrace":{"xcoord":8597877, "ycoord":5346534, "compass":123}}}$$)Common input parameters: (client, form, feature)
Specific input parameters: (data)
We always work with names as much autodocumented as possible. If you feel some else please request it to info@giswater.org.
Common output parameters: (status, message, version)
Specific output parameters: (body)
We always work with names as much autodocumented as possible. If you feel some else please request it to info@giswater.org.
{
"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_setvisit - sucessfully inserted. HINT: None."
}
}
}
},
"apiVersion": {
"value": "3.5.003"
},
"body": {
"feature": {
"id": "972"
},
"data": {
"geometry": {}
}
}
}

