Difference between revisions of "API: Extension Databases"

From Charitylog Manual
Jump to: navigation, search
(Multiple Record Extension Databases: Reading)
Line 6: Line 6:
  
 
=Making Extension Databases available to the API=
 
=Making Extension Databases available to the API=
You can choose which Extension Database fields are exposed to the API, by editing the field in the web application. Set "Allow collaborator API access?" to "Yes", at which point a "Name to share with collaborators" (field name) will be generated. You can then reference that extension database field in the API by the collaborator name.
+
This needs enabling in the web application. On the Extension Database record, set Allow API Access to Yes, and an API name will be generated. You might want to change this if you are working with multiple Charitylog instances and want to standardise things. Individual fields need enabling to, which can be done in the same way, or click Generate API Names on the fields list to enable them all at once.
 +
 
 +
 
 +
[[File:Extension_Database_Enable_API.png]]
  
  
Line 18: Line 21:
  
 
=Multiple Record Extension Databases: Reading=
 
=Multiple Record Extension Databases: Reading=
Multiple record extension databases work as their own entity. They need enabling in the web application. On the Extension Database record, set Allow API Access to Yes, and an API name will be generated. You might want to change this if you are working with multiple Charitylog instances and want to standardise things.
+
Multiple record extension databases work as their own entity.
 
 
[[File:Extension_Database_Enable_API.png]]
 
  
 
  [GET] https<nowiki/>://api.dizions.co.uk/v2/extension_database/wellcheck_notes
 
  [GET] https<nowiki/>://api.dizions.co.uk/v2/extension_database/wellcheck_notes

Revision as of 14:16, 22 April 2024

Go to API overview

Helpheader small.png

Making Extension Databases available to the API

This needs enabling in the web application. On the Extension Database record, set Allow API Access to Yes, and an API name will be generated. You might want to change this if you are working with multiple Charitylog instances and want to standardise things. Individual fields need enabling to, which can be done in the same way, or click Generate API Names on the fields list to enable them all at once.


Extension Database Enable API.png


Single Record Extension Database: Reading

For the API consumer, these are treated the same as the standard fields. For example, an API consumer selecting field/postcode;show_size;ethnicity does not need to know that postcode and ethinicity are standard fields, and shoe_size is an Extension Database field.

To see a full list of standard and single-record Extension Database fields, use the /clients/selectable_fields for Organisation & People-linked records, and the /referrals/selectable_fields for referral-linked records. Club&Clinic-linked Extension Databases are not currently available.

Single Record Extension Database: Writing

Because these are treated the same as the standard fields, they can be posted along with standard fields to /clients or /referrals. Club&Clinic-linked Extension Databases are not currently available.

Multiple Record Extension Databases: Reading

Multiple record extension databases work as their own entity.

[GET] https://api.dizions.co.uk/v2/extension_database/wellcheck_notes

To make things more efficient, you can specify which fields to select:

[GET] https://api.dizions.co.uk/v2/extension_database/wellcheck_notes/field/assessment_score;finances

Filters can be used in the same way as other requests. This gets all results for a particular referral:

[GET] https://api.dizions.co.uk/v2/extension_database/wellcheck_notes/referral/2289

Multiple Record Extension Databases: Creating

To create a new record you need to do a [PUT] request.

[PUT] https://api.dizions.co.uk/v2/extension_database/staff_disciplinary_13

Then add the body:

"referral": "2289",
"date_43": "2018-11-08",

The ID of the new record will be returned.

Multiple Record Extension Databases: Updating

To update a record you also need to supply the ID:

[POST] https://api.dizions.co.uk/v2/extension_database/wellcheck_notes_9/id/17

Then add the POST body in the same way as a PUT request.

Dictionaries

For Extension Database which are "Select From Option List" or "Radio buttons", there is a dictionary for each field, using the collaboration name displayed on each Extension Database Field:

[GET] https://api.dizions.co.uk/v2/dictionary/extension_database/INSERT_API_COLLABORATION_NAME_HERE