Get audit_report List
GET /obp/dynamic-entity/banks/ogcr/audit_report
OBPv4.0.0-dynamicEntity_getaudit_reportList_ogcr Roles: CanGetDynamicEntityRecord_audit_report(per bank) _Audit_report(ogcr)Dynamic-EntityDynamic
Get audit_report List.
Audit report is the outcome of the audit conducted by certification bodies. This Dynamic Entity is part of OGCR.
Property List:
- audit_report_id: (uu)id of the audit report
- audit_report_summary: Short human-readable summary of audit scope, approach, and conclusion.
- operator_id: Operator’s legal name
- group_manager_legal_name: For group certification: group manager name
- group_manager_address: For group certification: group manager address
- group_activity_operator_list: For group certification: list of carbon farming activities under scope (operators’ names and addresses)
- activity_id: Internal identifier for the activity entity
- certification_scope: Scope of certification
- certification_scheme_id: Methodology(ies) the scheme applies (identifier + version).
- certification_methodology_legal_reference: Legal reference for certification methodology
- activity_plan_id: Reference number of the activity plan
- monitoring_plan_id: Reference number of the monitoring plan
- permanent_net_carbon_removal_benefit: Expected/verified amount of permanent net carbon removal benefit (in Co2e Tonnes)
- carbon_farming_net_soil_emission_reduction_benefit: Expected/verified amount of temporary net carbon removal benefit (in Co2e Tonnes)
- carbon_storage_temporary_net_carbon_removal_benefit: Expected/verified amount of net soil emission reduction benefit (in Co2e Tonnes)
- sustainability_co_benefits: Sustainability co-benefits associated with the activity
- certification_body_id: Legal or trading name of the certification body
- audit_team_composition: Composition of the audit team
- national_accreditation_body: National accreditation body and scope/date of accreditation (or recognition authority and scope/date)
- accreditation_scope: Accreditation scope
- accreditation_date: Accreditation date
- national_recognition_authority: National recognition authority
- recognition_scope: Recognition scope
- recognition_date: Recognition date
- audit_date: Date of the audit
- audit_itinerary: Audit itinerary and duration (split onsite/remote where relevant)
- audit_duration_onsite: Duration spent on-site
- audit_duration_remote: Duration spent remotely
- sites_audited: Sites audited
- audit_method_risk_assessment: Audit method, risk assessment
- audit_method_sampling_basis: Audit method, sampling basis
- audit_method_stakeholder_consultation: Audit method, stakeholder consultation
- other_certification_schemes_or_standards_certified: Certification of other certification schemes or standards
- ghg_data_type: GHG data type
- audit_report_issue_location: Place of issuance of the audit report
- audit_report_issue_date: Date of issuance of the audit report
- certificate_valid_from_date: Certificate valid from date
- certificate_valid_to_date: Certificate valid to date
- date_certified: Date certified (if applicable)
- issuing_party_signature_or_stamp: Stamp and/or signature of issuing party
MethodRouting settings example:
<details>
{
"is_bank_id_exact_match":false,
"method_name":"dynamicEntityProcess",
"connector_name":"rest_vMar2019",
"bank_id_pattern":".*",
"parameters":[
{
"key":"entityName",
"value":"audit_report"
}
{
"key":"url",
"value":"http://mydomain.com/xxx"
}
]
}
</details>
User Authentication is Required. The User must be logged in. The Application must also be authenticated.
Filtering, sorting and pagination on the list endpoint:
Queryable (declared indexed) fields: activity_id, activity_plan_id, audit_report_id, certification_scheme_id, monitoring_plan_id, operator_id.
- Filter:
?obp_filter[FIELD]=OP:VALUE. Operators:eq,ne,in,lt,gt,le,ge,between,like,is_null,not_set.in/betweentake comma-separated values;is_null/not_settake no value. Repeat the same key to AND several constraints on one field. e.g.?obp_filter[status]=eq:active&obp_filter[amount]=between:10,100or?obp_filter[closed_date]=not_set - Legacy filter (still supported): bare field parameters, e.g.
?name=James%20Brown&number=123.456&number=11.11filters byname == "James Brown" && (number == 123.456 || number == 11.11). - Sort:
?obp_sort_by=FIELD[,FIELD2]&obp_sort_direction=ASC|DESC. - Paginate:
?obp_limit=20&obp_offset=40.
Filtering, sorting, pagination and is_null / not_set work on every deployment (no special backend required).
One-hop joins (EXISTS / NOT EXISTS) — filter this entity by a condition on a related entity linked through a declared reference: field:
?obp_exists[RelatedEntity]— keep rows that have at least one related RelatedEntity.?obp_exists[RelatedEntity]=filter[FIELD]=eq:VALUE— ...that have at least one matching the predicate.?obp_not_exists[RelatedEntity]— keep rows with NO related RelatedEntity at all.?obp_not_exists[RelatedEntity]=filter[FIELD]=eq:VALUE— ...with no related RelatedEntity matching the predicate (this includes rows that have no related RelatedEntity).- If two entities are linked by more than one reference, disambiguate the edge with
via:, e.g.?obp_exists[RelatedEntity]=via:buyer_ref;filter[status]=eq:signed.
The nested filter[...] reuses the operator grammar above. Mind the distinction: obp_not_exists[X]=filter[flag]=eq:true (no related X with flag=true — includes rows with no X) is not the same as obp_exists[X]=filter[flag]=ne:true (has a related X with flag≠true — excludes rows with no X).
Only a field typed reference:<Entity> and declared indexed: true forms a join edge; a plain string field holding ids is not joinable.
This entity's reference fields (each usable as a one-hop join edge to its target entity): activity_id → activity, activity_plan_id → activity_plan, certification_scheme_id → certification_scheme, monitoring_plan_id → monitoring_plan, operator_id → operator.
Joins require the SQL projection backend (dynamic_entity.indexing.backend=auto on Postgres or SQL Server) with the involved fields indexed and ready. On an in-memory deployment a join query returns 400 (OBP-09022); while an index is still building it returns 409. The plain filter / sort / paginate / is_null / not_set features above do not need the projection backend.
Example success response
{
"bank_id": "ogcr",
"audit_report_list": [
{
"audit_report_id": "string",
"audit_report_summary": "Audit confirmed conformance to methodology X for monitoring period FY2027; no major non-conformities.",
"operator_id": "op_05OFWI037022",
"group_manager_legal_name": "Green Fields Cooperative GmbH",
"group_manager_address": "Hauptstrasse 12, 15230 Frankfurt (Oder), Germany",
"group_activity_operator_list": "[{\"operator\": \"Oderbruch Farms GmbH\", \"address\": \"Dorfstrasse 4, 15324 Letschin, Germany\"}]",
"activity_id": "a_05OFWI037022",
"certification_scope": "Carbon farming activity a_05OFWI037022, 120 ha across 14 parcels, monitoring period 2027 to 2031",
"certification_scheme_id": "{\"id\": \"crcf_agri_mineral_soils\", \"version\": \"1.0\"}",
"certification_methodology_legal_reference": "Methodology crcf_agri_mineral_soils version 1.0, adopted under Article 8 of Regulation (EU) 2024/3012",
"activity_plan_id": "ap_01HZY3...",
"monitoring_plan_id": "mp_01HZYW...",
"permanent_net_carbon_removal_benefit": 6.5,
"carbon_farming_temporary_net_carbon_removal_benefit": 6.5,
"carbon_farming_net_soil_emission_reduction_benefit": 6.5,
"carbon_storage_temporary_net_carbon_removal_benefit": 6.5,
"sustainability_co_benefits": "Biodiversity and soil health (Article 7(1)(f))",
"certification_body_id": "DNV Business Assurance Germany GmbH",
"audit_team_composition": "Lead auditor, one soil science expert, one auditor in training",
"national_accreditation_body": "DAkkS (Germany), accredited for carbon farming certification audits since 1 March 2025",
"accreditation_scope": "Verification and certification of carbon farming activities under Regulation (EU) 2024/3012",
"accreditation_date": "2025-03-01",
"national_recognition_authority": "Not applicable (accredited body)",
"recognition_scope": "Not applicable (accredited body)",
"recognition_date": "2026-05-24",
"audit_date": "2026-12-15",
"audit_itinerary": "Day 1 on-site: farm and parcels A to C. Day 2 on-site: records review. Day 3 remote: closing meeting",
"audit_duration_onsite": "2 days",
"audit_duration_remote": "1 day",
"sites_audited": "Oderbruch Farms GmbH headquarters and 4 of 14 parcels",
"audit_method_risk_assessment": "Risk-based: more sampling on parcels with a large claimed benefit",
"audit_method_sampling_basis": "Random sample of 30% of parcels plus all parcels above 10 ha",
"audit_method_stakeholder_consultation": "Interviews with the operator, the farm advisor and two neighbouring landowners",
"other_certification_schemes_or_standards_certified": "string",
"ghg_data_type": "Measured (soil sampling), with modelled values for unsampled parcels",
"audit_report_issue_location": "Hamburg, Germany",
"audit_report_issue_date": "2026-12-20",
"certificate_valid_from_date": "2027-01-01",
"certificate_valid_to_date": "2031-12-31",
"date_certified": "2026-12-25",
"issuing_party_signature_or_stamp": "Signed and stamped by the lead auditor, DNV Business Assurance Germany GmbH"
}
]
}Possible errors (3)
- OBP-20001: User not logged in. Authentication is required!
- OBP-20006: User is missing one or more roles:
- OBP-50000: Unknown Error.