x QBOS REST API documentation for CABEREAV

QBOS REST API documentation (CABEREAV)

(return to Main Document)

Introduction

The CABEREAV API allows client applications to maintain CABEREAV data record sets.

Audience

This developer's guide is intended for software developers needing a technical reference for using the QBOS REST API. The information you find in this guide is written by software engineering, and is authoritative on how the API behaves.

Additional resources, information about this guide

Occasionally, we make a mistake in this documentation, or unknowingly break a feature that you depend on. If this has happened to you, we apologize! You can help us fix the issue by contacting us at: pkajaani@qbos.com. We appreciate your help.

Getting Started

To place any request in a QBOS API application from a third party application you need to first authenticate your user account and set/calculate values for the following request headers: x-qbos-id, x-qbos-nonce, x-qbos-date-utc, x-qbos-hash-version, x-qbos-auth

See details in Authentication Documentation.

Custom resource vs. standard resource URI format

Custom resource (a.k.a applet) URI contains the resource vendor id in place of "/o/" in the standard object URI. Compare: .../v1/o/...with .../v1/{vendor_id}/...

CABEREAV properties

Properties prefixed with '_' (underscore) are read-only properties. i.e. POST and PUT processing will ignore these properties.

Name Type Max
Length
Numeric Required
For POST
Filterable Default Description
_client_Id bigint Yes NULL This is the Data Org Id.
_owner_Id bigint Yes Yes NULL This is the user id of the record owner. Defaults to the creatorOpid.
_creator_Opid bigint Yes Yes NULL This is the user id of the original record submitter.
_create_Date datetime No {timestamp}   Not enterable upon Insert. System sets this date upon record creation.
status_id int Yes Yes 5567 The status id of the record. Taken from the Life Cycle statuses in ADS.
_status_Change_Date datetime No NULL Not enterable. System sets this date whenever the statusid is changed.
Loss_financial_security nvarchar 20 Yes NULL This property is populated by a Type 2 Value List.
Click here for the appropriate API and sample of value options for this column.
Loss_financial_security_explain nvarchar 100 Yes NULL
Family_communication_style nvarchar 20 Yes NULL This property is populated by a Type 2 Value List.
Click here for the appropriate API and sample of value options for this column.
Family_communication_style_explain nvarchar 100 Yes NULL
Bereavement_risk nvarchar 20 Yes NULL This property is populated by a Type 2 Value List.
Click here for the appropriate API and sample of value options for this column.
History_of_substance_abuse nvarchar 20 Yes NULL
History_of_etoh_abuse nvarchar 20 Yes NULL
History_of_mental_illness nvarchar 20 Yes NULL
Children_in_patient_home nvarchar 20 Yes NULL
History_of_substance_abuse_explain nvarchar 100 Yes NULL
History_of_etoh_abuse_explain nvarchar 100 Yes NULL
History_of_mental_illness_explain nvarchar 100 Yes NULL
Children_in_patient_home_explain nvarchar 100 Yes NULL
Children_involved_with_care nvarchar 20 Yes NULL
Children_involved_with_care_explain nvarchar 100 Yes NULL
Is_declined bit Yes Yes NULL This property is populated by a Type 1 Value List.
Click here for the appropriate API and sample of value options for this column.

CABEREAV Relationships

Parent and Child relations to CABEREAV.

Note that the only Required status on relationships that affect a POST of an object are on the parent relations. A Required status on a child relation is only meaningful when POSTing the child object.

Linking during POST: a custom object record can be linked to a parent or child record (custom or standard) during POST by including (in the payload) the realtion id paired with the parent or child object record being linked to. For example: { "REl_2933" : 1832 }      Multiple links may be created in the same POST.

Relation Id Cardinality
(Parent-to-Child)
Required
For POST
Links Up To Is Unary?*
REL_2952 1-1 Yes CA_Assessment
REL_3074 1-Many Comprehensive_Assessment
Parent Relations

CABEREAV

Child Relations
Relation Id Cardinality
(Parent-to-Child)
Required
**on POST of child
Links Down To  
REL_2933 1-Many Yes** Bereavement_Available_Support  
REL_2935 1-Many Yes** Bereavement_PU  
REL_3234 1-Many Yes** Beareavement_CH  
REL_2991 1-Many CP_POC_Issue  
REL_2990 1-1 Notes  
REL_2932 1-Many Assessment_Issue  
 



Read CABEREAV by id:

GET https:/.../v1/517090/CABEREAV/{id}

Response codes:

  • 200 - OK
  • 404 - Not found or user does not have permission to access resources of this type.
  • 400 - Client error
  • 500 - Server error

Response data: GET https:/.../v1/517090/CABEREAV/15
Unauthorized request.

Read CABEREAV by parent id:

GET https:/.../v1/517090/{parent_relation_id}/{parent_id}/links/CABEREAV[?{filter}]

Response codes:

  • 400 - Client error
  • 500 - Server error
  • 404 - Not found or user does not have permission to access resources of this type.
  • 200 - OK

Response data: GET https:/.../v1/517090/2952/10/links/CABEREAV
Unauthorized request.

Read CABEREAV by filter:

GET https:/.../v1/517090/CABEREAV[?{filter}]

Response codes:

  • 200 - OK
  • 400 - Client error
  • 404 - Not found or user does not have permission to access resources of this type.
  • 500 - Server error

Response data: GET https:/.../v1/517090/CABEREAV?id=15
Unauthorized request.

Create CABEREAV:

POST https:/.../v1/517090/CABEREAV

Request data [See properties]:

Response codes:

Update CABEREAV:

PUT https:/.../v1/517090/CABEREAV/{id}

Request data [See properties]:

Response codes:

  • 200 - OK Content returned [See response data]
  • 204 - OK No content
  • 400 - Client error
  • 404 - Not found
  • 500 - Server error

Delete CABEREAV:

DELETE https:/.../v1/517090/CABEREAV/{id}

The "id" in JSON payload is required to match the {id} in the URI to ensure that deletion requests are intended and safe

Response codes:

  • 204 - OK
  • 400 - Client error
  • 404 - Not found
  • 500 - Server error

Create Link for CABEREAV:

POST https:/.../v1/517090/{relation_id}/{link_to_id}/links/CABEREAV/{id}


{relation_id} can indicate either a parent or a child relation.

Response codes:

  • 204 - OK
  • 400 - Client error
  • 404 - Not found
  • 500 - Server error

Delete Link for CABEREAV:

DELETE https:/.../v1/517090/{parent_relation_id}/{parent_id}/links/CABEREAV/{id}


Deleting a link from CABEREAV down to a child object must be explicitly indicated by negating the relation id:

DELETE https:/.../v1/517090/{-child_relation_id}/{child_id}/links/CABEREAV/{id}

Response codes:

  • 204 - OK
  • 400 - Client error
  • 404 - Not found
  • 500 - Server error