gw_fct_setvisit - Giswater/giswater_dbmodel GitHub Wiki

Description

Set new visit values

Input example

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 [email protected].

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 [email protected].

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_setvisit - sucessfully inserted. HINT: None."
        }
      }
    }
  },
  "apiVersion": {
    "value": "3.5.003"
  },
  "body": {
    "feature": {
      "id": "972"
    },
    "data": {
      "geometry": {}
    }
  }
}

⚠️ **GitHub.com Fallback** ⚠️