/Provision/Issue API

[Ben-Hodgkiss]

Overview

Following the Pipeline API workshop day, we have now identified and prioritised the different APIs that are required to remove the Providers team dependency on datasette.

This ticket is to create the /provision/issue/summary API. At the workshop, we identified the following criteria for this that can be found on this Google sheet.

Method	GET
Path	/provision/issue

Inputs

Required	Optional
organisation	issue_type
dataset	issue_field
	severity
	responsibility

Outputs

Existing	New
organisation	entity (if available)
dataset	value
issue_type	message
issue_field	mapped_fields
resource )
row_number
entry_number

Datasette Tables

• endpoint_dataset_resource_summary
• endpoint_dataset_issue_type_summary

Tech Approach

To be completed during Refinement.

Acceptance Criteria

• API created to query on the Endpoint Dataset Resource Summary and Endpoint Dataset Issue Type Summary tables
• Queries must filter on organisation and dataset
• Queries can filter on issue_type, issue_field, severity and responsibility
• Output includes organisation, dataset, issue_type, issue_field, resource, row_number, entry_number, entity (if available), value, message, mapped_fields

Resourcing & Dependencies

• Developer to attend the Providers Stand-Up on Tuesdays and Thursdays (they do not need to attend the Infra Stand-Up on these days).
• Providers to offer support including pair programming and PR reviewing.