Once you have set up the API within your environment or GraphiQL (if not please see this article - https://app.intercom.com/a/apps/wnmvofws/knowledge-hub/article/10816410).
The query filters on mortgage amount and a defined range of mortgage due dates.
query BalanceSheetLoans {
recorder_mortgage_v2(
where: {amount: {_gte: "2000000"}, mortgage_due_date: {_gte: "2024-04-30", _lte: "2048-02-25"}}
order_by: {recorder_id: asc}
) {
recorder_id
amount
mortgage_due_date
recorder_v2__recorder_id {
tax_assessor_v2__tax_assessor_id {
property_use_code_mapped
usa_owner_unmask_v2__tax_assessor_id {
owner_name
has_confidence
}
cherre_address__property_address {
display_address
}
}
}
}
}
If you have any further questions please reach out to us at Support@cherre.com