Duplicate Set Columns

Create DuplicateSetColumn

Creates a new DuplicateSetColumn

SecurityapiKeyAuth and bearerAuth
Request
path Parameters
duplicateSetKey
required
integer <int32>

DuplicateSet Key

header Parameters
vbasoftware-database
required
string

Target database

Request Body schema:
required
duplicateSet_Key
required
integer <int32>
duplicateColumn_Key
required
integer <int32>
entry_Date
string <date-time>
entry_User
string or null <= 20 characters
hard_Duplicate
required
boolean
soft_Duplicate
required
boolean
update_Date
string <date-time>
update_User
string or null <= 20 characters
Responses
200

Success

401

Unauthorized

post/duplicate-sets/{duplicateSetKey}/columns
Request samples
{
  • "duplicateSet_Key": 0,
  • "duplicateColumn_Key": 0,
  • "entry_Date": "2019-08-24T14:15:22Z",
  • "entry_User": "string",
  • "hard_Duplicate": true,
  • "soft_Duplicate": true,
  • "update_Date": "2019-08-24T14:15:22Z",
  • "update_User": "string"
}
Response samples
{
  • "data": {
    },
  • "error": {
    },
  • "debug": {
    }
}

List DuplicateSetColumn

Lists all DuplicateSetColumn for the given duplicateSetKey

SecurityapiKeyAuth and bearerAuth
Request
path Parameters
duplicateSetKey
required
integer <int32>

DuplicateSet Key

query Parameters
page
integer <int32>
Default: 1

Page

pageSize
integer <int32>
Default: 100

Page Size

sortBy
string

Comma separated string to sort by. Each sort field can be followed by :asc or :desc to specify sort direction, ascending is default. E.g., 'Property1:desc,Property2:asc,Property3:asc' sorts Property1 in descending order, Property2 in ascending, and Property3 in ascending.

header Parameters
vbasoftware-database
required
string

Target database

Responses
200

Success

401

Unauthorized

get/duplicate-sets/{duplicateSetKey}/columns
Request samples 
Response samples 
No sample
Get DuplicateSetColumn
Gets DuplicateSetColumn


SecurityapiKeyAuth and bearerAuth 
Request 
path Parameters
duplicateSetKey
required
integer <int32> 
DuplicateSet Key


 
duplicateColumnKey
required
integer <int32> 
DuplicateColumn Key


 
header Parameters
vbasoftware-database
required
string
Target database


 
Responses 
200
Success


401
Unauthorized


get/duplicate-sets/{duplicateSetKey}/columns/{duplicateColumnKey}
Request samples 
Response samples 
No sample
Update DuplicateSetColumn
Updates a specific DuplicateSetColumn.


SecurityapiKeyAuth and bearerAuth 
Request 
path Parameters
duplicateSetKey
required
integer <int32> 
DuplicateSet Key


 
duplicateColumnKey
required
integer <int32> 
DuplicateColumn Key


 
header Parameters
vbasoftware-database
required
string
Target database


 
Request Body schema: 
required
duplicateSet_Key
required
integer <int32> 
 
duplicateColumn_Key
required
integer <int32> 
 
entry_Date
string <date-time> 
 
entry_User
string or null  <= 20 characters 
 
hard_Duplicate
required
boolean
 
soft_Duplicate
required
boolean
 
update_Date
string <date-time> 
 
update_User
string or null  <= 20 characters 
 
Responses 
200
Success


401
Unauthorized


put/duplicate-sets/{duplicateSetKey}/columns/{duplicateColumnKey}
Request samples 
{
  • "duplicateSet_Key": 0,
  • "duplicateColumn_Key": 0,
  • "entry_Date": "2019-08-24T14:15:22Z",
  • "entry_User": "string",
  • "hard_Duplicate": true,
  • "soft_Duplicate": true,
  • "update_Date": "2019-08-24T14:15:22Z",
  • "update_User": "string"
}
Response samples 
{
  • "data": {
    },
  • "error": {
    },
  • "debug": {
    }
}
Delete DuplicateSetColumn
Deletes an DuplicateSetColumn


SecurityapiKeyAuth and bearerAuth 
Request 
path Parameters
duplicateSetKey
required
integer <int32> 
DuplicateSet Key


 
duplicateColumnKey
required
integer <int32> 
DuplicateColumn Key


 
header Parameters
vbasoftware-database
required
string
Target database


 
Responses 
204
Success


401
Unauthorized


delete/duplicate-sets/{duplicateSetKey}/columns/{duplicateColumnKey}
Request samples 
Create or Update Batch DuplicateSetColumn
Create or Update multiple DuplicateSetColumn at once.  If the entity exists, it will be updated.  If the entity does not exist, it will be created.


SecurityapiKeyAuth and bearerAuth 
Request 
path Parameters
duplicateSetKey
required
integer <int32> 
DuplicateSet Key


 
header Parameters
vbasoftware-database
required
string
Target database


 
Request Body schema: 
required
 Array 
duplicateSet_Key
required
integer <int32> 
 
duplicateColumn_Key
required
integer <int32> 
 
entry_Date
string <date-time> 
 
entry_User
string or null  <= 20 characters 
 
hard_Duplicate
required
boolean
 
soft_Duplicate
required
boolean
 
update_Date
string <date-time> 
 
update_User
string or null  <= 20 characters 
 
Responses 
207
Success


401
Unauthorized


put/duplicate-sets/{duplicateSetKey}/columns-batch
Request samples 
[
  • {
    }
]
Response samples 
{
  • "data": [
    ],
  • "error": {
    },
  • "debug": {
    }
}