nowcerts_claim_getList
Retrieve and filter insurance claims from NowCerts using customizable OData queries to search by claim ID, policy number, status, insured information, date ranges, and location criteria.
Instructions
Get claims from NowCerts using OData query parameters.
IMPORTANT: By default, results are ordered by 'changeDate desc' (most recently changed first).
ID FIELD NAMING:
Claim's own ID: "databaseId" (the claim's primary UUID)
Link to insured: "insuredDatabaseId" (UUID of the insured/prospect)
Common $filter examples:
Search by claim ID: "databaseId eq '7c8b37f8-e4d0-42f9-a7d0-ffefd163f657'"
Search by claim number: "contains(claimNumber, '12345')" or "claimNumber eq '789456'"
Search by policy number: "contains(policyNumber, 'POL123')"
By status: "status eq 'Open'" or "status eq 'Closed'" or "status eq 'Submitted_To_Carrier'"
Search by insured ID: "insuredDatabaseId eq 'ed37f103-ca80-e6da-fa7a-abdfc4b8a7b3'"
Search by insured name: "contains(insuredFirstName, 'John') or contains(insuredLastName, 'Smith')"
Search by insured email: "contains(insuredEmail, 'test@example.com')"
Search by commercial name: "contains(insuredCommercialName, 'ACME')"
By loss date range: "dateOfLossAndTime ge 2024-01-01T00:00:00Z and dateOfLossAndTime le 2024-12-31T00:00:00Z"
By city/state: "city eq 'Nashville' and state eq 'TN'"
Open claims: "status eq 'Open'"
Recent claims: "changeDate ge 2024-01-01T00:00:00Z"
Pagination examples:
Open claims: $filter=status eq 'Open'&$top=100&$skip=0&$orderby=dateOfLossAndTime desc&$count=true
By insured: $filter=insuredDatabaseId eq 'guid-here'&$top=50&$skip=0&$orderby=changeDate desc&$count=true
Available fields: databaseId (primary key), claimNumber, status, street, city, state, zipCode, county, dateOfLossAndTime, describeLocation, policeOrFireDepartment, reportNumber, additionalComments, descriptionOfLossAndDamage, insuredDatabaseId, insuredEmail, insuredFirstName, insuredLastName, insuredCommercialName, policyNumber, changeDate, createDate, dateAndAmount (list)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| $count | No | Include total count in response. Set to true to get @odata.count field. | |
| $filter | No | OData filter expression (optional). Can be combined with other parameters. | |
| $orderby | No | Field to order by. Default: 'changeDate desc'. Example: 'ClaimDate desc' | |
| $select | No | Comma-separated list of columns to return (optional) | |
| $skip | No | Number of records to skip (offset). Example: 0 | |
| $top | No | Number of records to return (limit). Example: 100 |