The "importwellboregeometries" web service imports a CSV well bore geometry into the specified datasource.

A typical URL is http://myserver.mycompany.com:8080/INTGeoServer/api/ds/{datasourcetype}/v1/sources/{datasource}/wbgeometries/import with the POST method.

where

datasourcetype: type of a datasource, i.e. mongo, s3, etc.

datasource: unique id of a datasource

The following parameters are available:

• importoptions : a JSON object representing import options. The following parameters are available:

  • wellName: is the name of a well a well bore geometry must be imported to

  • geometryName: is the name of a being imported well bore geometry

  • overwrite: identifies whether an existing well bore geometry should be overwritten. This is an optional parameter. The default is false.

  • delimiter is the character delimiter, if not specified then "," will be used (does not work with 'whitespace and tab' option)

  • dataValuesRow is the 1 based index of row where data first appears

• columnmappings : a JSON array representing well head data. The following parameters are available:

  • columnIndex is the 1 based index of column

  • mappingID is the column mappings id.

  • type is the data type of a column: string, double, long or date. This is an optional paramter.

  • unit: is a unit of measurement of a column. This is an optional parameter.

• file: a file containing a being imported well bore geometry. This is required parameter.

All row and column indices start at 1.

An example import is shown below (pass multipart/form-data as Content-Type):

importoptions:

{

"wellName":"casingforivaap8836",

"geometryName":"goodcasing",

"overwrite":false,

"dataValuesRow":3,

"delimiter":","

}

columnmappings:

[

{

"mappingID":"Type",

"columnIndex":1,

"type":"String",

"unit":""

},

{

"mappingID":"MDTop",

"columnIndex":2,

"type":"Double",

"unit":"ft"

},

{

"mappingID":"MDBottom",

"columnIndex":3,

"type":"Double",

"unit":"ft"

},

{

"mappingID":"InnerDiameter",

"columnIndex":4,

"type":"Double",

"unit":"in"

},

{

"mappingID":"OuterDiameter",

"columnIndex":5,

"type":"Double",

"unit":"in"

},

{

"mappingID":"Torque",

"columnIndex":6,

"type":"String",

"unit":"lb/ft"

},

{

"mappingID":"TubingGrade",

"columnIndex":7,

"type":"String",

"unit":""

},

{

"mappingID":"Tubing Strength",

"columnIndex":8,

"type":"String",

"unit":"lb/ft"

},

{

"mappingID":"Source",

"columnIndex":9,

"type":"String",

"unit":""

},

{

"mappingID":"Description",

"columnIndex":10,

"type":"String",

"unit":""

}

]