Perform multiple CRUD-like operations in a single transaction

POST 
/data-batch

Each step takes either 'DataReadParams' (for Read) or the corresponding arguments of the single-operation endpoints (for Create, Update, Delete, Undelete, Map, Unmap) . See request body schema.

Request

application/json

Body

required

steps

object[]

required

Possible values: <= 25

Array [

oneOf

MOD1

op stringrequired

as stringrequired

result boolean

entity stringrequired

readParams

object

required

pagination

object

Pagination settings control how much data from a result is fetched

offset integer

The offset the result starts at

Default value: 0

pageAtId integer

Selects the page with the given id in the result, given a limit (= page size)

inflate integer

Adds a number of items before the start offset and after the limit (for pagination use)

limit integer

The maximum number of result rows

order

object[]

Controls the ordering of the result

Array [

oneOf

MOD1

order stringrequired

Ordering by a pre-defined value sequence - the partial ordering of the given values in the result is preserved

column stringrequired

The name of the column to order by

seq number[]required

MOD2

column stringrequired

The name of the column to order by

order stringrequired

Either 'asc'ending or 'desc'ending order for the given column

Possible values: [asc, desc]

]

includeTotalCount boolean

Includes the total result count if pagination options were given

filter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

computedColumns string[]

List of computed columns to include (by default includes all)

id integer

Only return the entity with the given id, returns one or none

ids integer[]

Only return the entities with the given ids

map

object

Map expression to expand properties or relationships with other entities

oneOf

MapJoin

entities

object

The list of entity names which are part of the mapping (for mapping relationship tables)

oneOf

MOD1

string

MOD2

Array [

string

]

entity string

The entity name (for direct mapping via a foreign key)

ids

object

A list of id tuples to filter by

oneOf

FkIdsNullable

Entity ids for mapped entities, e.g. testcase_id (also allows null as value)

property name*

object

oneOf

MOD1

integer

MOD2

string

MOD2

Array [

property name*

object

oneOf

MOD1

integer

MOD2

string

]

inverse boolean

Inverts the result to retrieve non-mapped entities

Default value: false

filter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

resultFilter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

countOnly boolean

Only returns a count instead of a list of entities

Default value: false

idOnly boolean

Only retrieves entity ids, omitting all other columns

Default value: false

optional boolean

Indicates that the mapping is optional and may be 'null' in the result

Default value: false

includeDeleted boolean

Includes deleted member entities in the mapping search result

Default value: false

omitLargeValues boolean

Omits 'large' column/prop values (if available)

Default value: false

omit boolean

Omit the mapping result from result entities - For intermediate nested mappings

result string

The entity to use as the result instead of the mapping relationship entity data

resultIncludeMapping boolean

Also includes mapping even if result entity is specified

Default value: false

map

object

Nested mapping starting from one of the member entities of this mapping

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

]

MOD2

Array [

entities

object

The list of entity names which are part of the mapping (for mapping relationship tables)

oneOf

MOD1

string

MOD2

Array [

string

]

entity string

The entity name (for direct mapping via a foreign key)

ids

object

A list of id tuples to filter by

oneOf

FkIdsNullable

Entity ids for mapped entities, e.g. testcase_id (also allows null as value)

property name*

object

oneOf

MOD1

integer

MOD2

string

MOD2

Array [

property name*

object

oneOf

MOD1

integer

MOD2

string

]

inverse boolean

Inverts the result to retrieve non-mapped entities

Default value: false

filter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

resultFilter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

countOnly boolean

Only returns a count instead of a list of entities

Default value: false

idOnly boolean

Only retrieves entity ids, omitting all other columns

Default value: false

optional boolean

Indicates that the mapping is optional and may be 'null' in the result

Default value: false

includeDeleted boolean

Includes deleted member entities in the mapping search result

Default value: false

omitLargeValues boolean

Omits 'large' column/prop values (if available)

Default value: false

omit boolean

Omit the mapping result from result entities - For intermediate nested mappings

result string

The entity to use as the result instead of the mapping relationship entity data

resultIncludeMapping boolean

Also includes mapping even if result entity is specified

Default value: false

map

object

Nested mapping starting from one of the member entities of this mapping

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

]

]

includeDeleted boolean

Includes soft-deleted entities in the result (if applicable)

omitLargeValues boolean

Omits 'large' column/prop values (if available)

Default value: true

omitForbidden boolean

Omits entities which are not allowed to be read rather than return an error

Default value: false

asOf string

Perform a history query given the asOf timestamp (if available)

idOnly boolean

Only returns ids in the result, omitting all other properties

countOnly boolean

Returns only the length of the result list instead of the result list itself

label string

MOD2

op stringrequired

as string

result boolean

entity stringrequired

inputData

object[]

required

Array [

id integerrequired

The unique entity id

]

MOD3

op stringrequired

as string

force boolean

result boolean

entity stringrequired

inputData

object[]

Array [

id integerrequired

The unique entity id

]

MOD4

op stringrequired

as string

from string

result boolean

entity stringrequired

inputData

object[]

Array [

id integerrequired

The unique entity id

]

MOD5

op stringrequired

from string

entity stringrequired

inputData

object[]

Array [

id integerrequired

The unique entity id

]

MOD6

op stringrequired

mapOp stringrequired

as string

from string[]

result boolean

sourceEntity stringrequired

entities string[]required

inputData

object[]

Array [

id integerrequired

The unique entity id

]

mappings

object[]

required

Array [

ids

object

required

Entity ids for mapped entities, e.g. testcase_id

property name* integer

newIds

object

Entity ids for mapped entities, e.g. testcase_id

property name* integer

mapped

object

object

]

MOD7

oneOf

MOD1

op stringrequired

as stringrequired

result boolean

opts

params

object

required

tables

object

required

property name*

object

oneOf

MOD1

string

MOD2

Array [

string

]

columns

object

property name*

object

object

aggr

object

required

property name*

object

property name*

object

oneOf

MOD1

string

Possible values: [count, count_distinct, sum, min, max, avg, maxGroup, minGroup]

MOD2

Array [

string

Possible values: [count, count_distinct, sum, min, max, avg, maxGroup, minGroup]

]

groupAggrOn string

groupLimit integer

Possible values: >= 1

group

object

property name*

object

object

order

object

property name*

object

object

alias

object

property name*

object

object

optionalTables string[]

filter

object

Filter/search terms

and

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

or

object

oneOf

ByKeys

Filter/search terms

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

MOD2

Array [

and

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

or

object

oneOf

MOD2

Array [

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

]

]

property name*

object

oneOf

MOD1

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

MOD2

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

object

required

The target value(s) or pattern

oneOf

ByKeysValue

Any basic JSON value (string, number, boolean, null)

oneOf

MOD1

string

MOD2

number

MOD3

boolean

MOD2

Array [

oneOf

MOD1

string

MOD2

number

MOD3

boolean

]

col

MOD3

op stringrequired

The comparison/matching operation to perform on the value: eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree

Possible values: [eq, not_eq, like, not_like, in, not_in, like_in, not_like_in, gt, lt, lte, gte, range, has_any, has_all, has_none, in_subtree]

value

col stringrequired

The target column/prop name (instead of fixed value)

time

object

from

object

required

oneOf

MOD1

string

DurationSpec

years number

months number

days number

hours number

minutes number

seconds number

to

object

required

oneOf

MOD1

string

DurationSpec

years number

months number

days number

hours number

minutes number

seconds number

MOD3

string

steps

object

required

oneOf

MOD1

integer

DurationSpec

years number

months number

days number

hours number

minutes number

seconds number

asOf string

projectId integer

withComputed boolean

includeDeleted boolean

limit integer

Possible values: >= 1

offset integer

label string

MOD2

op stringrequired

as stringrequired

result boolean

params

object

required

template stringrequired

ids integer[]required

params

object

object

includeDeleted boolean

MOD3

op stringrequired

params

object

required

projectId integerrequired

bucket

object

required

schema

object[]

required

Array [

type stringrequired

Possible values: [entity, mapping]

name stringrequired

]

items array[]required

Possible values: >= 2

]

Responses

200

Returns 'DataBatchResult'

application/json

Schema

Schema

object

Example (from schema)

{}

4XX

The request failed because invalid request parameters or data were supplied or access was denied.

application/json

Schema

Schema

code string
The error code describing the general error category.
Example: API_INVALID_INPUT_DATA
status integer

The HTTP status code.

message stringrequired

The actual error message describing the error in more detail.

reqid string

The request id for following up on specific errors.

Example (from schema)

{
  "code": "API_INVALID_INPUT_DATA",
  "status": 0,
  "message": "string",
  "reqid": "string"
}

5XX

The request failed because an error occurred during processing of the request.

application/json

Schema

Schema

code string
The error code describing the general error category.
Example: API_INVALID_INPUT_DATA
status integer

The HTTP status code.

message stringrequired

The actual error message describing the error in more detail.

reqid string

The request id for following up on specific errors.

Example (from schema)

{
  "code": "API_INVALID_INPUT_DATA",
  "status": 0,
  "message": "string",
  "reqid": "string"
}

Loading...