Custom Query Definitions

Creates a new custom query definition record that does not already exist.

This method will auto-generate an ID and create a new custom query definition. If an ID is specified for the custom query definition, an error will be thrown.

Request

Security:

knox-authorizer

path Parameters

tenantId

required

string

The id of the tenant being accessed.

Request Body schema: application/json

The custom query definition that you would like to be saved.

id required	string (ID) /^[\w\|-]+$/ The unique, string identifier of this custom query definition
application required	string (Application)
name required	string (Name) The name of the custom query definition
description	string (Description)
required	object (Definition) The query definition
is_active	boolean (Is Active) Whether or not this custom query definition is active
	Array of objects (Custom Field Values)
sys_deleted_by_id	string (Sys Deleted By) The ID of the user that deleted (or last tried to delete) this object
sys_version	number <float> (Sys Version) A number representing the version of this record in the database
sys_created_at required	string <date-time> (Sys Created At) The date/time that this record was created, expressed in ISO-8601 date format
sys_last_modified_at required	string <date-time> (Sys Last Modified At) The date/time that this record record was last modified, expressed in ISO-8601 date format
sys_created_by_id required	string (Sys Created By) The ID of the user that created this record
sys_last_modified_by_id required	string (Sys Last Modified By) The ID of the user that last modified this record
sys_external_id	string (Sys External) The ID that a record has from an external system or data import
sys_locked	boolean (Sys Locked) If set, this record is locked and cannot be changed via the API
sys_bulk_load_pk	string (Sys Bulk Load Pk) If this record was loaded via bulk, the tenant and key of the bulk load process used as a partition key
sys_bulk_load_at	string (Sys Bulk Load At) If this record was loaded via bulk, the timestamp when the record was processed
sys_bulk_load_id	string (Sys Bulk Load) If this record was loaded via bulk, the ID of the bulk load process
sys_bulk_load_record_no	number <float> (Sys Bulk Load Record No) If this record was loaded via bulk, the record number in the source file
sys_bulk_load_source_file	string (Sys Bulk Load Source File) If this record was loaded via bulk, the source file
sys_last_bulk_data_operation_id	string (Sys Last Bulk Data Operation) If this record was last touched by a bulk data operation, the ID of that operation
sys_last_bulk_data_operation_sys_version	string (Sys Last Bulk Data Operation Sys Version) If this record was last touched by a bulk data operation, the sys_version at the time of that operation
sys_directive	string (Sys Directive) Means for passing directive information into an object processing logic
sys_calculated_field_error	string (Sys Calculated Field Error) The error associated with the calculated field
sys_snapshot_base_version	number <float> (Sys Snapshot Base Version) The version to use as a base when creating a configuration snapshot; if not set, 1 is used. Helpful when creating a sandbox
sys_has_files_in_s3	boolean (Sys Has Files In S3) If true, this record has files in S3. If false, it doesnt, so no need to hit S3 upon deletion
sys_configuration_snapshot_id	string (Sys Configuration Snapshot) If a snapshot was restored/applies to this record, the ID of the snapshot
sys_last_security_context	object (Sys Last Security Context) The security context of the last insert, modify, or delete performed on this item
	Array of objects

Responses

200The custom query definition was saved successfully.

400The custom query definition you supplied was invalid.

401Unauthorized.

403Forbidden.

404The resource could not be found

409The custom query definition could not be saved because it refers to/depends on a non-existent object.

429Limit exceeded... unable to add custom query definition based on tenant limits.

500General server error.

post/customQueryDefinitions/{tenantId}

Request samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Response samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Gets all of the custom query definitions in the system.

This method will scan all custom query definitions and and return them to the caller.

Request

Security:

knox-authorizer

path Parameters

tenantId

required

string

The id of the tenant being accessed.

query Parameters

fields	string The fields that you want to retrieve; if omitted, the entire object is returned.
exclusiveStartKey	string The start key, if you're making a subsequent request

Responses

200The custom query definitionswere retrieved successfully.

400The request was invalid.

401Unauthorized.

403Forbidden.

404The resource could not be found

429Limit exceeded... unable to add contact role based on tenant limits.

500General server error.

get/customQueryDefinitions/{tenantId}

Request samples

curl
JavaScript
C#
PHP
Python

curl -i -X GET \
  'https://platform.api.756794052567.rhythmsoftware.com/customQueryDefinitions/:tenantId?fields=string&exclusiveStartKey=string' \
  -H 'Authorization: YOUR_API_KEY_HERE'

Response samples

application/json

[{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}
]

Returns a custom query definition from the system by its ID.

This method will look up a custom query definition by the specified ID and return it back.

Request

Security:

knox-authorizer

path Parameters

tenantId required	string The id of the tenant being accessed.
id required	string The ID of the custom query definition to return.

query Parameters

fields	string The fields that you want to retrieve; if omitted, the entire object is returned.
consistentRead	string Indicates the API should force a consistent read on the data source.

Responses

200The custom query definition was retrieved successfully.

400The request was not valid.

401Unauthorized.

403Forbidden.

404The custom query definition could not be found.

429Limit exceeded... unable to retrieve custom query definition based on tenant limits.

500General server error.

get/customQueryDefinitions/{tenantId}/{id}

Request samples

curl
JavaScript
C#
PHP
Python

curl -i -X GET \
  'https://platform.api.756794052567.rhythmsoftware.com/customQueryDefinitions/:tenantId/:id?fields=string&consistentRead=string' \
  -H 'Authorization: YOUR_API_KEY_HERE'

Response samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Updates a custom query definition with the specified ID.

This method will update an existing custom query definition with the specified ID.

Request

Security:

knox-authorizer

path Parameters

tenantId required	string The id of the tenant being accessed.
id required	string The ID of the custom query definition to update.

Request Body schema: application/json

The updated custom query definition that will be saved.

id required	string (ID) /^[\w\|-]+$/ The unique, string identifier of this custom query definition
application required	string (Application)
name required	string (Name) The name of the custom query definition
description	string (Description)
required	object (Definition) The query definition
is_active	boolean (Is Active) Whether or not this custom query definition is active
	Array of objects (Custom Field Values)
sys_deleted_by_id	string (Sys Deleted By) The ID of the user that deleted (or last tried to delete) this object
sys_version	number <float> (Sys Version) A number representing the version of this record in the database
sys_created_at required	string <date-time> (Sys Created At) The date/time that this record was created, expressed in ISO-8601 date format
sys_last_modified_at required	string <date-time> (Sys Last Modified At) The date/time that this record record was last modified, expressed in ISO-8601 date format
sys_created_by_id required	string (Sys Created By) The ID of the user that created this record
sys_last_modified_by_id required	string (Sys Last Modified By) The ID of the user that last modified this record
sys_external_id	string (Sys External) The ID that a record has from an external system or data import
sys_locked	boolean (Sys Locked) If set, this record is locked and cannot be changed via the API
sys_bulk_load_pk	string (Sys Bulk Load Pk) If this record was loaded via bulk, the tenant and key of the bulk load process used as a partition key
sys_bulk_load_at	string (Sys Bulk Load At) If this record was loaded via bulk, the timestamp when the record was processed
sys_bulk_load_id	string (Sys Bulk Load) If this record was loaded via bulk, the ID of the bulk load process
sys_bulk_load_record_no	number <float> (Sys Bulk Load Record No) If this record was loaded via bulk, the record number in the source file
sys_bulk_load_source_file	string (Sys Bulk Load Source File) If this record was loaded via bulk, the source file
sys_last_bulk_data_operation_id	string (Sys Last Bulk Data Operation) If this record was last touched by a bulk data operation, the ID of that operation
sys_last_bulk_data_operation_sys_version	string (Sys Last Bulk Data Operation Sys Version) If this record was last touched by a bulk data operation, the sys_version at the time of that operation
sys_directive	string (Sys Directive) Means for passing directive information into an object processing logic
sys_calculated_field_error	string (Sys Calculated Field Error) The error associated with the calculated field
sys_snapshot_base_version	number <float> (Sys Snapshot Base Version) The version to use as a base when creating a configuration snapshot; if not set, 1 is used. Helpful when creating a sandbox
sys_has_files_in_s3	boolean (Sys Has Files In S3) If true, this record has files in S3. If false, it doesnt, so no need to hit S3 upon deletion
sys_configuration_snapshot_id	string (Sys Configuration Snapshot) If a snapshot was restored/applies to this record, the ID of the snapshot
sys_last_security_context	object (Sys Last Security Context) The security context of the last insert, modify, or delete performed on this item
	Array of objects

Responses

200The custom query definition was updated successfully.

400The custom query definition supplied was not valid.

401Unauthorized.

403Forbidden.

404The custom query definition could not be found.

409The custom query definition could not be saved because it refers to/depends on a non-existent object.

429Limit exceeded... unable to retrieve custom query definition based on tenant limits.

500General server error.

put/customQueryDefinitions/{tenantId}/{id}

Request samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Response samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Partially updates a custom query definition with the specified ID.

This method will patch an existing custom query definition with the specified ID, using the HTTP PATCH specification.

Request

Security:

knox-authorizer

path Parameters

tenantId required	string The id of the tenant being accessed.
id required	string The ID of the custom query definition to patch.

Request Body schema: application/json

The patch directives conforming to RFC 6902.

Array

op required	string (Op) The operation Enum: "add" "remove" "replace" "move" "copy" "test"
path required	string (Path) The JSON path
value	string (Value) The updated value

Responses

200The custom query definition was patched successfully.

400The JSON patch directive you supplied was not valid.

401Unauthorized.

403Forbidden.

404The custom query definition could not be found.

409The custom query definition could not be saved because it refers to/depends on a non-existent object.

429Limit exceeded... unable to retrieve custom query definition based on tenant limits.

500General server error.

patch/customQueryDefinitions/{tenantId}/{id}

Request samples

application/json

[{"op": "add",
"path": "string",
"value": "string"
}
]

Response samples

application/json

{"id": "string",
"application": "string",
"name": "string",
"description": "string",
"definition": {"id": "string",
"name": "string",
"description": "string",
"primary_table": "string",
"context": {"required": true,
"service": "string",
"field": "string",
"display_name": "string",
"help_text": "string"
},
"perform_custom_resolution_logic": true,
"common_table_expressions": [{"alias": "string",
"sql": "string"
}
],
"services": [{"service": "string",
"table": "string",
"table_alias": "string",
"group_name": "string",
"id_column": "string",
"join_fragment": "string",
"hints": { }
}
],
"fields": [{"table_alias": "string",
"database_column": "string",
"custom_sql": "string",
"group_name": "string",
"name": "string",
"label": "string",
"type": "string",
"reference_service": "string",
"acceptable_values": [{"label": "string",
"value": "string"
}
],
"service": "string"
}
],
"default_output_fields": [{"name": "string",
"label": "string",
"applies_when_context": "is given"
}
],
"default_sort_fields": [{"name": "string",
"descending": true,
"applies_when_context": "is given"
}
]
},
"is_active": true,
"custom_field_values": [{"custom_field_id": "string",
"string_value": "string",
"numeric_value": 0,
"boolean_value": true,
"file_url_value": "string",
"list_value": ["string"
],
"table_value": [{ }
]
}
],
"sys_deleted_by_id": "string",
"sys_version": 0,
"sys_created_at": "2019-08-24T14:15:22Z",
"sys_last_modified_at": "2019-08-24T14:15:22Z",
"sys_created_by_id": "string",
"sys_last_modified_by_id": "string",
"sys_external_id": "string",
"sys_locked": true,
"sys_bulk_load_pk": "string",
"sys_bulk_load_at": "string",
"sys_bulk_load_id": "string",
"sys_bulk_load_record_no": 0,
"sys_bulk_load_source_file": "string",
"sys_last_bulk_data_operation_id": "string",
"sys_last_bulk_data_operation_sys_version": "string",
"sys_directive": "string",
"sys_calculated_field_error": "string",
"sys_snapshot_base_version": 0,
"sys_has_files_in_s3": true,
"sys_configuration_snapshot_id": "string",
"sys_last_security_context": { },
"sys_calculated_field_errors": [{"field": "string",
"error": "string"
}
]
}

Returns a custom query definition from the system by its ID.

This method will delete a custom query definition with the specified ID.

Request

Security:

knox-authorizer

path Parameters

tenantId required	string The id of the tenant being accessed.
id required	string The ID of the custom query definition to delete.

Responses

200The custom query definition was deleted successfully.

400The request was not valid.

401Unauthorized.

403Forbidden.

404The custom query definition could not be found.

409The custom query definition could not be deleted because other objects refers to/depends on this one.

429Limit exceeded... unable to delete custom query definition based on tenant limits.

500General server error.

delete/customQueryDefinitions/{tenantId}/{id}

Request samples

curl
JavaScript
C#
PHP
Python

curl -i -X DELETE \
  https://platform.api.756794052567.rhythmsoftware.com/customQueryDefinitions/:tenantId/:id \
  -H 'Authorization: YOUR_API_KEY_HERE'

Response samples

application/json

"string"

Execute Batch Operations

TAllows you to perform up to 100 parallel patch/delete operations

Request

Security:

knox-authorizer

path Parameters

tenantId

required

string

The id of the tenant being accessed.

Request Body schema: application/json

The batch request

Array of objects

Responses

200Request completed successfully.

400The request was not valid.

401Unauthorized.

403Forbidden.

404The custom query definition could not be found.

429Limit exceeded... unable to retrieve custom query definition based on tenant limits.

500General server error.

post/customQueryDefinitions/{tenantId}/batch

Request samples

application/json

{"operations": [{"operation": "create",
"id": "string",
"patch_directives": [{"op": "add",
"path": "string",
"value": "string"
}
],
"object": { }
}
]
}

Response samples

application/json

{"success_count": 0,
"error_count": 0,
"results": [{"operation": "create",
"id": "string",
"outcome": "success",
"error_message": "string",
"object": { }
}
]
}