Embedded Files
The "welltablecolumns" web service provides information about the values of an individual well table
A typical URL is http://myserver.mycompany.com:8080/INTGeoServer/api/ds/{datasourcetype}/v1/sources/{datasource}/welltables/{welltableuniqueid}/columns with the GET method.
where
datasourcetype: type of a datasource, i.e. mongo, s3, etc.
datasource: a unique id of a datasource
welltableuniqueid: a unique if of a well table
Here is an example response. This response has been formatted to improve readability.
{
"from": {
"actor": "akka://DefaultActorSystemControllerActorSystem:FindWellTableColumnsJsonActor:StartWellTableColumnsResponseEvent for FindWellTableColumnsRequest:FindWellTableColumnsRequest{klass=AbstractWellTableFrameFinder, sourceName=c9db3458-6698-49d9-ae8f-f407ce26ae2e, sourceType=mongo, tableUniqueId=b6472ec7-cc01-47f0-aa05-bbca09f51d84, columnIndices=[]}"
},
"data": {
"id": "b6472ec7-cc01-47f0-aa05-bbca09f51d84",
"content": {
"name": "TimeLog",
"columnNames": [
"Start Date (DateTime)",
"Cum Duration",
"End Date (DateTime)",
"Activity Type",
"Activity Code",
"Ops Category",
"Start Depth",
"End Depth",
"Borehole",
"Comment\r"
],
"columnTypes": [
"DateTime",
"Time",
"DateTime",
"String",
"String",
"String",
"String",
"String",
"String",
"String"
],
"columnUnits": [
"ms",
"ms",
"ms",
"",
"",
"",
"",
"",
"",
""
],
"columnNullValues": [
9223372036854775807,
9223372036854775807,
9223372036854775807,
null,
null,
null,
null,
null,
null,
null
],
"values": [
(skipped for the sake of brievity)
],
"rowCount": 286
},
"links": [
{
"rel": "self",
"relEntity": "v1/schema/int/table",
"href": "/ivaap/api/ds/mongo/v1/sources/c9db3458-6698-49d9-ae8f-f407ce26ae2e/welltables/b6472ec7-cc01-47f0-aa05-bbca09f51d84",
"children": false,
"hasProjectEntityChildren": false,
"isProjectEntity": false
},
{
"rel": "Table",
"name": "Table",
"relEntity": "v1/schema/int/table",
"href": "/ivaap/api/ds/mongo/v1/sources/c9db3458-6698-49d9-ae8f-f407ce26ae2e/welltables/b6472ec7-cc01-47f0-aa05-bbca09f51d84",
"children": false,
"hasProjectEntityChildren": false,
"isProjectEntity": true
}
]
}
}
The id entry is a unique id of a well table.
In content section
name is the name of a well table
columnNames is a collection of all column names of a well table
columnTypes is a collection of data types of each column
columnUnits is a collection of all column units of measurement
columnNullValues is a collection of values specifying null values for each column
values is a collection of data for each column
The links section provides HATEOAS links to the "Well Table Data Web Service (v3)" service.
If the specified welltableuniqueid doesn't match a valid well table, no JSON response will be provided. The HTTP response will only show a "InvalidUniqueId" (error 404) in its headers.
Report abuse