Endpoints

Prescription fills

POST/v0/prescription-fills/browse

Browse prescription fills

Queries the prescription fills on the patients visible to the caller. Read-only. Uses the shared browse syntax described in Browsing tables and returns the { table, aggregate, total } envelope as JSON, or the selected columns as CSV when you send Accept: text/csv. Until clinical data has finished loading after a service restart, the call returns 500 rather than an empty table; retry shortly.

Request bodyapplication/json

Optional parameters

selectobject
select.prescriptionFillobject
Which of the prescription fill's columns to return.
select.prescriptionFill.refboolean
Reference for this prescription dispensing record in the current output. It can change when clinical data is reprocessed.
select.prescriptionFill.ndcboolean
National Drug Code identifying the dispensed product. Stored as an 11-digit normalized code without dashes. Preserve as text.
select.prescriptionFill.rxCuiboolean
RxNorm concept identifier associated with the drug, when the product can be resolved in the reference data.
select.prescriptionFill.drugLabelboolean
Drug label supplied with the prescription data.
select.prescriptionFill.prescriptionNumberboolean
Prescription number assigned by the source pharmacy or prescription system. Preserve as text.
select.prescriptionFill.fillNumberboolean
Fill sequence for the prescription. Zero means the original fill; one or greater means a refill.
select.prescriptionFill.daysSupplyboolean
Number of days the dispensed quantity is expected to cover, as reported by the source.
select.prescriptionFill.quantityDispensedboolean
Quantity dispensed for this fill. The unit depends on the drug or product; there is no separate quantity-unit field.
select.prescriptionFill.strengthboolean
Drug strength or dosage text supplied with the prescription record.
select.prescriptionFill.totalRefillsAllowedboolean
Total number of refills authorized for the prescription, as reported by the source.
select.prescriptionFill.fcraDisputeboolean
Source-reported Fair Credit Reporting Act (FCRA) dispute flag associated with the prescription record. Blank means no flag was supplied.
select.prescriptionFill.fillDateboolean
Date the prescription was filled or refilled.
select.prescriptionFill.createdAtboolean
Timestamp when the prescription-fill data was recorded in the platform. This is separate from the fill date.
select.prescriptionFill.companyIdboolean
Platform identifier for the customer organization associated with the record.
select.prescriptionFill.projectIdboolean
Platform identifier for the project containing the patient and record.
select.prescriptionFill.patientIdboolean
Platform identifier for the patient associated with the record. Use with the company and project identifiers to identify the patient scope.
select.prescriptionFill.visitRefboolean
Reference to the visit associated with this dispensing event. The reference may change when the data is reprocessed.
select.prescriptionFill.siteIdboolean
Platform reference for the dispensing pharmacy associated with the prescription fill.
select.prescriptionFill.prescriberPractitionerIdboolean
Platform practitioner reference for the prescribing provider, when that provider is resolved.
select.drugobject & object
Which of the joined drug's columns to return. Absent when the row has no drug.
select.companyobject & object
Which of the joined company's columns to return. Absent when the row has no company.
select.projectobject & object
Which of the joined project's columns to return. Absent when the row has no project.
select.patientobject & object
Which of the joined patient's columns to return. Absent when the row has no patient.
select.visitobject & object
Which of the joined visit's columns to return. Absent when the row has no visit.
select.siteobject & object
Which of the joined site's columns to return. Absent when the row has no site.
select.prescriberobject & object
Which of the joined prescriber's columns to return. Absent when the row has no prescriber.
whereobject
where.prescriptionFillobject
Filters on the prescription fill's columns.
where.prescriptionFill.refobject | object | object | object | object | object | object | string[]
Reference for this prescription dispensing record in the current output. It can change when clinical data is reprocessed.
where.prescriptionFill.ndcobject | object | object | object | object | object | object | string[]
National Drug Code identifying the dispensed product. Stored as an 11-digit normalized code without dashes. Preserve as text.
where.prescriptionFill.rxCuiobject | object | object | object | object | object | object | string[]
RxNorm concept identifier associated with the drug, when the product can be resolved in the reference data.
where.prescriptionFill.drugLabelobject | object | object | object | object | object | object | string[]
Drug label supplied with the prescription data.
where.prescriptionFill.prescriptionNumberobject | object | object | object | object | object | object | string[]
Prescription number assigned by the source pharmacy or prescription system. Preserve as text.
where.prescriptionFill.fillNumberobject | object | object | object | object | object | object | object | string[]
Fill sequence for the prescription. Zero means the original fill; one or greater means a refill.
where.prescriptionFill.daysSupplyobject | object | object | object | object | object | object | object | string[]
Number of days the dispensed quantity is expected to cover, as reported by the source.
where.prescriptionFill.quantityDispensedobject | object | object | object | object | object | object | object | string[]
Quantity dispensed for this fill. The unit depends on the drug or product; there is no separate quantity-unit field.
where.prescriptionFill.strengthobject | object | object | object | object | object | object | string[]
Drug strength or dosage text supplied with the prescription record.
where.prescriptionFill.totalRefillsAllowedobject | object | object | object | object | object | object | object | string[]
Total number of refills authorized for the prescription, as reported by the source.
where.prescriptionFill.fcraDisputeobject | object | object | object | string[]
Source-reported Fair Credit Reporting Act (FCRA) dispute flag associated with the prescription record. Blank means no flag was supplied.
where.prescriptionFill.fillDateobject | object | object | object | object | object | object | object | string[]
Date the prescription was filled or refilled.
where.prescriptionFill.createdAtobject | object | object | object | object | object | object | object | string[]
Timestamp when the prescription-fill data was recorded in the platform. This is separate from the fill date.
where.prescriptionFill.companyIdobject | object | object | object | object | object | object | object | string[]
Platform identifier for the customer organization associated with the record.
where.prescriptionFill.projectIdobject | object | object | object | object | object | object | string[]
Platform identifier for the project containing the patient and record.
where.prescriptionFill.patientIdobject | object | object | object | object | object | object | string[]
Platform identifier for the patient associated with the record. Use with the company and project identifiers to identify the patient scope.
where.prescriptionFill.visitRefobject | object | object | object | object | object | object | string[]
Reference to the visit associated with this dispensing event. The reference may change when the data is reprocessed.
where.prescriptionFill.siteIdobject | object | object | object | object | object | object | string[]
Platform reference for the dispensing pharmacy associated with the prescription fill.
where.prescriptionFill.prescriberPractitionerIdobject | object | object | object | object | object | object | string[]
Platform practitioner reference for the prescribing provider, when that provider is resolved.
where.drugstring | object & object
Filters on the joined drug's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a drug.
where.companystring | object & object
Filters on the joined company's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a company.
where.projectstring | object & object
Filters on the joined project's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a project.
where.patientstring | object & object
Filters on the joined patient's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a patient.
where.visitstring | object & object
Filters on the joined visit's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a visit.
where.sitestring | object & object
Filters on the joined site's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a site.
where.prescriberstring | object & object
Filters on the joined prescriber's columns. `isNull` or `isNotNull` in place of the filters matches the rows without or with a prescriber.
aggregateobject
aggregate.prescriptionFillobject
aggregate.prescriptionFill.countboolean
When true, return the number of rows that match the filter.
aggregate.prescriptionFill.sumobject
Numeric columns to total across the rows that match the filter.
aggregate.prescriptionFill.avgobject
Numeric columns to average across the rows that match the filter.
aggregate.prescriptionFill.minobject
Numeric columns to find the smallest value of across the rows that match the filter.
aggregate.prescriptionFill.maxobject
Numeric columns to find the largest value of across the rows that match the filter.
aggregate.drugobject & object
aggregate.companyobject & object
aggregate.projectobject & object
aggregate.patientobject & object
aggregate.visitobject & object
aggregate.siteobject & object
aggregate.prescriberobject & object
orderByobject | object | object | object | object | object | object | object[]
searchstring
takeinteger
skipinteger

ReturnsTyped browse response for PrescriptionFillBrowseResponse

Conditional attributes

tableobject[]
table[].prescriptionFillobject
The prescription fill's columns, as selected by the request.
table[].prescriptionFill.refstring
Reference for this prescription dispensing record in the current output. It can change when clinical data is reprocessed.
table[].prescriptionFill.idstringDeprecated
Legacy alias of `ref`; prefer `ref`.
table[].prescriptionFill.ndcstring
National Drug Code identifying the dispensed product. Stored as an 11-digit normalized code without dashes. Preserve as text.
table[].prescriptionFill.rxCuistring
RxNorm concept identifier associated with the drug, when the product can be resolved in the reference data.
table[].prescriptionFill.drugLabelstring
Drug label supplied with the prescription data.
table[].prescriptionFill.prescriptionNumberstring
Prescription number assigned by the source pharmacy or prescription system. Preserve as text.
table[].prescriptionFill.fillNumberinteger
Fill sequence for the prescription. Zero means the original fill; one or greater means a refill.
table[].prescriptionFill.daysSupplyinteger
Number of days the dispensed quantity is expected to cover, as reported by the source.
table[].prescriptionFill.quantityDispensedstring
Quantity dispensed for this fill. The unit depends on the drug or product; there is no separate quantity-unit field.
table[].prescriptionFill.strengthstring
Drug strength or dosage text supplied with the prescription record.
table[].prescriptionFill.totalRefillsAllowedinteger
Total number of refills authorized for the prescription, as reported by the source.
table[].prescriptionFill.fcraDisputeboolean
Source-reported Fair Credit Reporting Act (FCRA) dispute flag associated with the prescription record. Blank means no flag was supplied.
table[].prescriptionFill.fillDatestring
Date the prescription was filled or refilled.
table[].prescriptionFill.createdAtstring
Timestamp when the prescription-fill data was recorded in the platform. This is separate from the fill date.
table[].prescriptionFill.companyIdinteger
Platform identifier for the customer organization associated with the record.
The numeric id of the company (tenant) a resource belongs to.
table[].prescriptionFill.projectIdstring
Platform identifier for the project containing the patient and record.
table[].prescriptionFill.patientIdstring
Platform identifier for the patient associated with the record. Use with the company and project identifiers to identify the patient scope.
table[].prescriptionFill.visitRefstring
Reference to the visit associated with this dispensing event. The reference may change when the data is reprocessed.
table[].prescriptionFill.visitIdstringDeprecated
Legacy alias of `visitRef`; prefer `visitRef`.
table[].prescriptionFill.siteIdstring
Platform reference for the dispensing pharmacy associated with the prescription fill.
table[].prescriptionFill.prescriberPractitionerIdstring
Platform practitioner reference for the prescribing provider, when that provider is resolved.
table[].drugobject & object
The joined drug's columns, as selected by the request. Absent when the row has no drug.
table[].companyobject & object & object & object
The joined company's columns, as selected by the request. Absent when the row has no company.
table[].projectobject & object & object
The joined project's columns, as selected by the request. Absent when the row has no project.
table[].patientobject & object & object
The joined patient's columns, as selected by the request. Absent when the row has no patient.
table[].visitobject & object & object
The joined visit's columns, as selected by the request. Absent when the row has no visit.
table[].siteobject & object
The joined site's columns, as selected by the request. Absent when the row has no site.
table[].prescriberobject & object
The joined prescriber's columns, as selected by the request. Absent when the row has no prescriber.
aggregateobject
aggregate.prescriptionFillobject
aggregate.prescriptionFill.countinteger
Number of rows that match the filter. Present when `count` was requested.
aggregate.prescriptionFill.sumobject
Total of each requested numeric column across the rows that match the filter.
aggregate.prescriptionFill.avgobject
Average of each requested numeric column across the rows that match the filter.
aggregate.prescriptionFill.minobject
Smallest value of each requested numeric column across the rows that match the filter.
aggregate.prescriptionFill.maxobject
Largest value of each requested numeric column across the rows that match the filter.
aggregate.drugobject & object
aggregate.companyobject & object
aggregate.projectobject & object
aggregate.patientobject & object
aggregate.visitobject & object
aggregate.siteobject & object
aggregate.prescriberobject & object
totalinteger

Errors

400401500

Request

curl

curl https://api.hermeshealth.ai/v0/prescription-fills/browse \
  -X POST \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "select": {
    "prescriptionFill": {
      "ref": true,
      "ndc": true,
      "rxCui": true,
      "drugLabel": true,
      "prescriptionNumber": true,
      "fillNumber": true,
      "daysSupply": true,
      "quantityDispensed": true,
      "strength": true,
      "totalRefillsAllowed": true,
      "fcraDispute": true,
      "fillDate": true,
      "createdAt": true,
      "companyId": true,
      "projectId": true,
      "patientId": true,
      "visitRef": true,
      "siteId": true,
      "prescriberPractitionerId": true
    },
    "drug": {
      "ndc": true,
      "rxCui": true,
      "name": true,
      "doseForm": true,
      "ingredient": true,
      "therapeuticClass": true,
      "strength": true,
      "suppress": true
    },
    "company": {
      "link": true,
      "id": true,
      "name": true,
      "tier": true,
      "domains": true,
      "subdomain": true,
      "defaultRole": true,
      "requestStatusWebhook": true,
      "visitsWebhook": true,
      "patientNoteWebhook": true,
      "requestNoteWebhook": true,
      "authorizationStatusWebhook": true,
      "sandboxRequestStatusWebhook": true,
      "sandboxVisitsWebhook": true,
      "sandboxPatientNoteWebhook": true,
      "sandboxRequestNoteWebhook": true,
      "sandboxAuthorizationStatusWebhook": true,
      "purposeCoveredOperations": true,
      "purposeCoveredPayment": true,
      "purposeCoveredTreatment": true,
      "purposeIndividualAccess": true,
      "purposeInsuranceLife": true,
      "purposeInsuranceOther": true,
      "purposeLegalDefense": true,
      "purposeLegalMedicalMalpractice": true,
      "purposeLegalPlaintiff": true,
      "purposeResearchClinicalTrials": true,
      "purposeResearchPatientRegistries": true,
      "defaultPurpose": true,
      "authorizationPdfEnabled": true,
      "ial2TokensEnabled": true,
      "feeOcr": true,
      "feeSiteFinder": true,
      "feeAuthCheck": true,
      "feeRecordRequest": true,
      "feeInNetworkRequest": true,
      "feeSiteSonarHit": true,
      "feeSiteSonarNoHit": true,
      "feePatientHistoryHit": true,
      "feePatientHistoryNoHit": true,
      "feePatientHistoriesPlus": true,
      "feeChat": true,
      "feeAiResearcher": true,
      "stripeCustomerId": true,
      "createdAt": true,
      "lastWrite": true,
      "whiteLabel": true,
      "patientHistoriesEnabled": true,
      "siteSonarEnabled": true,
      "ehrSearchEnabled": true,
      "recordRequestEnabled": true,
      "inNetworkRequestEnabled": true,
      "preferInNetwork": true,
      "accentColor": true,
      "styledLinks": true,
      "roi": true,
      "clinicalDataVendor": true,
      "deliveryFormalName": true,
      "deliveryRequesterName": true,
      "deliveryPhone": true,
      "deliveryFaxNumber": true,
      "deliveryRecordsEmail": true,
      "deliveryMailingAddressLine1": true,
      "deliveryMailingAddressLine2": true,
      "deliveryMailingAddressCity": true,
      "deliveryMailingAddressState": true,
      "deliveryMailingAddressZip": true,
      "deliveryEmailSender": true,
      "deliveryEmailCc": true,
      "deliveryEmailSignature": true,
      "deliveryEmailSmtpHost": true,
      "userCount": true,
      "userLastLogin": true,
      "projectCount": true,
      "patientCount": true,
      "patientActiveCount": true,
      "requestCount": true,
      "visitCount": true,
      "feeUninvoicedAmount": true,
      "feeTotalNonCanceledAmount": true,
      "feeLastInvoiceDate": true,
      "creditBalance": true,
      "billingEmail": true
    },
    "project": {
      "id": true,
      "companyId": true,
      "name": true,
      "description": true,
      "status": true,
      "purpose": true,
      "createdAt": true,
      "updatedAt": true,
      "selfServe": true,
      "link": true,
      "patientCount": true,
      "patientCompletedCount": true,
      "requestCount": true,
      "recordRequestCount": true,
      "ccdaRequestCount": true,
      "visitCount": true,
      "representationLetterExists": true,
      "representationLetterDownloadUrl": true,
      "requestLetterExists": true,
      "requestLetterDownloadUrl": true
    },
    "patient": {
      "id": true,
      "firstName": true,
      "lastName": true,
      "alternateLastNames": true,
      "dateOfBirth": true,
      "sex": true,
      "zipCodes": true,
      "mobile": true,
      "email": true,
      "createdAt": true,
      "updatedAt": true,
      "authorizationStatus": true,
      "searchLevel": true,
      "siteSonar": true,
      "patientHistories": true,
      "ehrSearch": true,
      "searchStatus": true,
      "latestSubmissionErrored": true,
      "ownerUserId": true,
      "companyId": true,
      "projectId": true,
      "userId": true,
      "link": true,
      "visitCount": true,
      "requestCount": true,
      "recordRequestCount": true,
      "ccdaRequestCount": true,
      "requestCompletedOrCanceledCount": true,
      "feeTotal": true,
      "lastSonarRunAt": true,
      "lastHistoriesRunAt": true,
      "lastEhrRunAt": true,
      "diagnosisCount": true,
      "procedureCount": true,
      "prescriptionFillCount": true,
      "labResultCount": true,
      "authorizationExists": true,
      "authorizationDownloadUrl": true
    },
    "visit": {
      "ref": true,
      "encounterType": true,
      "claimType": true,
      "earliestServiceDate": true,
      "latestServiceDate": true,
      "memberId": true,
      "createdAt": true,
      "dataSources": true,
      "ehrDiscovered": true,
      "companyId": true,
      "projectId": true,
      "patientId": true,
      "subjectSiteKey": true,
      "attendingProviderId": true,
      "renderingProviderId": true,
      "operatingProviderId": true,
      "payorId": true,
      "procedureCount": true,
      "diagnosisCount": true,
      "prescriptionFillCount": true
    },
    "site": {
      "id": true,
      "name": true,
      "npis": true,
      "isFacility": true,
      "inNetwork": true,
      "hasEmbedding": true,
      "recordRequestCount": true,
      "visitCount": true,
      "taxId": true,
      "updatedAt": true,
      "addressLine1": true,
      "addressLine2": true,
      "city": true,
      "state": true,
      "zip": true,
      "formattedAddress": true,
      "latitude": true,
      "longitude": true,
      "phone": true,
      "mainFax": true,
      "email": true,
      "systemName": true,
      "primarySpecialty": true,
      "researchFinished": true,
      "liteResearchFinished": true,
      "placeId": true,
      "addressHash": true,
      "website": true,
      "acceptsEsignature": true,
      "googlePlacesName": true,
      "fingerprintedAt": true,
      "dedupConsideredAt": true,
      "dataSources": true,
      "npiEnumerationDate": true,
      "npiDeactivationReason": true,
      "npiDeactivationDate": true,
      "npiReactivationDate": true,
      "googleMapsUrl": true,
      "medicalDepartmentId": true,
      "facilityBillingDepartmentId": true,
      "physicianBillingDepartmentId": true,
      "imagingBillingDepartmentId": true,
      "emergencyRoomBillingDepartmentId": true,
      "anesthesiologyBillingDepartmentId": true,
      "imagingDepartmentId": true,
      "link": true
    },
    "prescriber": {
      "id": true,
      "name": true,
      "primarySpecialty": true,
      "addressLine1": true,
      "city": true,
      "state": true,
      "zip": true,
      "link": true
    }
  },
  "where": {
    "prescriptionFill": {
      "ref": [
        "..."
      ],
      "ndc": [
        "..."
      ],
      "rxCui": [
        "..."
      ],
      "drugLabel": [
        "..."
      ],
      "prescriptionNumber": [
        "..."
      ],
      "fillNumber": [
        "..."
      ],
      "daysSupply": [
        "..."
      ],
      "quantityDispensed": [
        "..."
      ],
      "strength": [
        "..."
      ],
      "totalRefillsAllowed": [
        "..."
      ],
      "fcraDispute": [
        "..."
      ],
      "fillDate": [
        "..."
      ],
      "createdAt": [
        "..."
      ],
      "companyId": [
        "..."
      ],
      "projectId": [
        "..."
      ],
      "patientId": [
        "..."
      ],
      "visitRef": [
        "..."
      ],
      "siteId": [
        "..."
      ],
      "prescriberPractitionerId": [
        "..."
      ]
    },
    "drug": "isNull",
    "company": "isNull",
    "project": "isNull",
    "patient": "isNull",
    "visit": "isNull",
    "site": "isNull",
    "prescriber": "isNull"
  },
  "aggregate": {
    "prescriptionFill": {
      "count": true,
      "sum": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "avg": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "min": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "max": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      }
    },
    "drug": {
      "count": true,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    },
    "company": {
      "count": true,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    },
    "project": {
      "count": true,
      "sum": {
        "companyId": "..."
      },
      "avg": {
        "companyId": "..."
      },
      "min": {
        "companyId": "..."
      },
      "max": {
        "companyId": "..."
      }
    },
    "patient": {
      "count": true,
      "sum": {
        "companyId": "..."
      },
      "avg": {
        "companyId": "..."
      },
      "min": {
        "companyId": "..."
      },
      "max": {
        "companyId": "..."
      }
    },
    "visit": {
      "count": true,
      "sum": {
        "claimType": "...",
        "companyId": "..."
      },
      "avg": {
        "claimType": "...",
        "companyId": "..."
      },
      "min": {
        "claimType": "...",
        "companyId": "..."
      },
      "max": {
        "claimType": "...",
        "companyId": "..."
      }
    },
    "site": {
      "count": true,
      "sum": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "avg": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "min": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "max": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      }
    },
    "prescriber": {
      "count": true,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    }
  },
  "orderBy": [
    {
      "prescriptionFill": {
        "ref": "..."
      }
    }
  ],
  "search": "string",
  "take": 0,
  "skip": 0
}'

import requests

response = requests.post(
    "https://api.hermeshealth.ai/v0/prescription-fills/browse",
    headers={"Authorization": "Bearer YOUR_API_KEY"},
    json={
        "select": {
            "prescriptionFill": {
                "ref": True,
                "ndc": True,
                "rxCui": True,
                "drugLabel": True,
                "prescriptionNumber": True,
                "fillNumber": True,
                "daysSupply": True,
                "quantityDispensed": True,
                "strength": True,
                "totalRefillsAllowed": True,
                "fcraDispute": True,
                "fillDate": True,
                "createdAt": True,
                "companyId": True,
                "projectId": True,
                "patientId": True,
                "visitRef": True,
                "siteId": True,
                "prescriberPractitionerId": True,
            },
            "drug": {
                "ndc": True,
                "rxCui": True,
                "name": True,
                "doseForm": True,
                "ingredient": True,
                "therapeuticClass": True,
                "strength": True,
                "suppress": True,
            },
            "company": {
                "link": True,
                "id": True,
                "name": True,
                "tier": True,
                "domains": True,
                "subdomain": True,
                "defaultRole": True,
                "requestStatusWebhook": True,
                "visitsWebhook": True,
                "patientNoteWebhook": True,
                "requestNoteWebhook": True,
                "authorizationStatusWebhook": True,
                "sandboxRequestStatusWebhook": True,
                "sandboxVisitsWebhook": True,
                "sandboxPatientNoteWebhook": True,
                "sandboxRequestNoteWebhook": True,
                "sandboxAuthorizationStatusWebhook": True,
                "purposeCoveredOperations": True,
                "purposeCoveredPayment": True,
                "purposeCoveredTreatment": True,
                "purposeIndividualAccess": True,
                "purposeInsuranceLife": True,
                "purposeInsuranceOther": True,
                "purposeLegalDefense": True,
                "purposeLegalMedicalMalpractice": True,
                "purposeLegalPlaintiff": True,
                "purposeResearchClinicalTrials": True,
                "purposeResearchPatientRegistries": True,
                "defaultPurpose": True,
                "authorizationPdfEnabled": True,
                "ial2TokensEnabled": True,
                "feeOcr": True,
                "feeSiteFinder": True,
                "feeAuthCheck": True,
                "feeRecordRequest": True,
                "feeInNetworkRequest": True,
                "feeSiteSonarHit": True,
                "feeSiteSonarNoHit": True,
                "feePatientHistoryHit": True,
                "feePatientHistoryNoHit": True,
                "feePatientHistoriesPlus": True,
                "feeChat": True,
                "feeAiResearcher": True,
                "stripeCustomerId": True,
                "createdAt": True,
                "lastWrite": True,
                "whiteLabel": True,
                "patientHistoriesEnabled": True,
                "siteSonarEnabled": True,
                "ehrSearchEnabled": True,
                "recordRequestEnabled": True,
                "inNetworkRequestEnabled": True,
                "preferInNetwork": True,
                "accentColor": True,
                "styledLinks": True,
                "roi": True,
                "clinicalDataVendor": True,
                "deliveryFormalName": True,
                "deliveryRequesterName": True,
                "deliveryPhone": True,
                "deliveryFaxNumber": True,
                "deliveryRecordsEmail": True,
                "deliveryMailingAddressLine1": True,
                "deliveryMailingAddressLine2": True,
                "deliveryMailingAddressCity": True,
                "deliveryMailingAddressState": True,
                "deliveryMailingAddressZip": True,
                "deliveryEmailSender": True,
                "deliveryEmailCc": True,
                "deliveryEmailSignature": True,
                "deliveryEmailSmtpHost": True,
                "userCount": True,
                "userLastLogin": True,
                "projectCount": True,
                "patientCount": True,
                "patientActiveCount": True,
                "requestCount": True,
                "visitCount": True,
                "feeUninvoicedAmount": True,
                "feeTotalNonCanceledAmount": True,
                "feeLastInvoiceDate": True,
                "creditBalance": True,
                "billingEmail": True,
            },
            "project": {
                "id": True,
                "companyId": True,
                "name": True,
                "description": True,
                "status": True,
                "purpose": True,
                "createdAt": True,
                "updatedAt": True,
                "selfServe": True,
                "link": True,
                "patientCount": True,
                "patientCompletedCount": True,
                "requestCount": True,
                "recordRequestCount": True,
                "ccdaRequestCount": True,
                "visitCount": True,
                "representationLetterExists": True,
                "representationLetterDownloadUrl": True,
                "requestLetterExists": True,
                "requestLetterDownloadUrl": True,
            },
            "patient": {
                "id": True,
                "firstName": True,
                "lastName": True,
                "alternateLastNames": True,
                "dateOfBirth": True,
                "sex": True,
                "zipCodes": True,
                "mobile": True,
                "email": True,
                "createdAt": True,
                "updatedAt": True,
                "authorizationStatus": True,
                "searchLevel": True,
                "siteSonar": True,
                "patientHistories": True,
                "ehrSearch": True,
                "searchStatus": True,
                "latestSubmissionErrored": True,
                "ownerUserId": True,
                "companyId": True,
                "projectId": True,
                "userId": True,
                "link": True,
                "visitCount": True,
                "requestCount": True,
                "recordRequestCount": True,
                "ccdaRequestCount": True,
                "requestCompletedOrCanceledCount": True,
                "feeTotal": True,
                "lastSonarRunAt": True,
                "lastHistoriesRunAt": True,
                "lastEhrRunAt": True,
                "diagnosisCount": True,
                "procedureCount": True,
                "prescriptionFillCount": True,
                "labResultCount": True,
                "authorizationExists": True,
                "authorizationDownloadUrl": True,
            },
            "visit": {
                "ref": True,
                "encounterType": True,
                "claimType": True,
                "earliestServiceDate": True,
                "latestServiceDate": True,
                "memberId": True,
                "createdAt": True,
                "dataSources": True,
                "ehrDiscovered": True,
                "companyId": True,
                "projectId": True,
                "patientId": True,
                "subjectSiteKey": True,
                "attendingProviderId": True,
                "renderingProviderId": True,
                "operatingProviderId": True,
                "payorId": True,
                "procedureCount": True,
                "diagnosisCount": True,
                "prescriptionFillCount": True,
            },
            "site": {
                "id": True,
                "name": True,
                "npis": True,
                "isFacility": True,
                "inNetwork": True,
                "hasEmbedding": True,
                "recordRequestCount": True,
                "visitCount": True,
                "taxId": True,
                "updatedAt": True,
                "addressLine1": True,
                "addressLine2": True,
                "city": True,
                "state": True,
                "zip": True,
                "formattedAddress": True,
                "latitude": True,
                "longitude": True,
                "phone": True,
                "mainFax": True,
                "email": True,
                "systemName": True,
                "primarySpecialty": True,
                "researchFinished": True,
                "liteResearchFinished": True,
                "placeId": True,
                "addressHash": True,
                "website": True,
                "acceptsEsignature": True,
                "googlePlacesName": True,
                "fingerprintedAt": True,
                "dedupConsideredAt": True,
                "dataSources": True,
                "npiEnumerationDate": True,
                "npiDeactivationReason": True,
                "npiDeactivationDate": True,
                "npiReactivationDate": True,
                "googleMapsUrl": True,
                "medicalDepartmentId": True,
                "facilityBillingDepartmentId": True,
                "physicianBillingDepartmentId": True,
                "imagingBillingDepartmentId": True,
                "emergencyRoomBillingDepartmentId": True,
                "anesthesiologyBillingDepartmentId": True,
                "imagingDepartmentId": True,
                "link": True,
            },
            "prescriber": {
                "id": True,
                "name": True,
                "primarySpecialty": True,
                "addressLine1": True,
                "city": True,
                "state": True,
                "zip": True,
                "link": True,
            },
        },
        "where": {
            "prescriptionFill": {
                "ref": [
                    "...",
                ],
                "ndc": [
                    "...",
                ],
                "rxCui": [
                    "...",
                ],
                "drugLabel": [
                    "...",
                ],
                "prescriptionNumber": [
                    "...",
                ],
                "fillNumber": [
                    "...",
                ],
                "daysSupply": [
                    "...",
                ],
                "quantityDispensed": [
                    "...",
                ],
                "strength": [
                    "...",
                ],
                "totalRefillsAllowed": [
                    "...",
                ],
                "fcraDispute": [
                    "...",
                ],
                "fillDate": [
                    "...",
                ],
                "createdAt": [
                    "...",
                ],
                "companyId": [
                    "...",
                ],
                "projectId": [
                    "...",
                ],
                "patientId": [
                    "...",
                ],
                "visitRef": [
                    "...",
                ],
                "siteId": [
                    "...",
                ],
                "prescriberPractitionerId": [
                    "...",
                ],
            },
            "drug": "isNull",
            "company": "isNull",
            "project": "isNull",
            "patient": "isNull",
            "visit": "isNull",
            "site": "isNull",
            "prescriber": "isNull",
        },
        "aggregate": {
            "prescriptionFill": {
                "count": True,
                "sum": {
                    "fillNumber": "...",
                    "daysSupply": "...",
                    "quantityDispensed": "...",
                    "totalRefillsAllowed": "...",
                    "companyId": "...",
                },
                "avg": {
                    "fillNumber": "...",
                    "daysSupply": "...",
                    "quantityDispensed": "...",
                    "totalRefillsAllowed": "...",
                    "companyId": "...",
                },
                "min": {
                    "fillNumber": "...",
                    "daysSupply": "...",
                    "quantityDispensed": "...",
                    "totalRefillsAllowed": "...",
                    "companyId": "...",
                },
                "max": {
                    "fillNumber": "...",
                    "daysSupply": "...",
                    "quantityDispensed": "...",
                    "totalRefillsAllowed": "...",
                    "companyId": "...",
                },
            },
            "drug": {
                "count": True,
                "sum": {},
                "avg": {},
                "min": {},
                "max": {},
            },
            "company": {
                "count": True,
                "sum": {},
                "avg": {},
                "min": {},
                "max": {},
            },
            "project": {
                "count": True,
                "sum": {
                    "companyId": "...",
                },
                "avg": {
                    "companyId": "...",
                },
                "min": {
                    "companyId": "...",
                },
                "max": {
                    "companyId": "...",
                },
            },
            "patient": {
                "count": True,
                "sum": {
                    "companyId": "...",
                },
                "avg": {
                    "companyId": "...",
                },
                "min": {
                    "companyId": "...",
                },
                "max": {
                    "companyId": "...",
                },
            },
            "visit": {
                "count": True,
                "sum": {
                    "claimType": "...",
                    "companyId": "...",
                },
                "avg": {
                    "claimType": "...",
                    "companyId": "...",
                },
                "min": {
                    "claimType": "...",
                    "companyId": "...",
                },
                "max": {
                    "claimType": "...",
                    "companyId": "...",
                },
            },
            "site": {
                "count": True,
                "sum": {
                    "recordRequestCount": "...",
                    "visitCount": "...",
                    "addressHash": "...",
                },
                "avg": {
                    "recordRequestCount": "...",
                    "visitCount": "...",
                    "addressHash": "...",
                },
                "min": {
                    "recordRequestCount": "...",
                    "visitCount": "...",
                    "addressHash": "...",
                },
                "max": {
                    "recordRequestCount": "...",
                    "visitCount": "...",
                    "addressHash": "...",
                },
            },
            "prescriber": {
                "count": True,
                "sum": {},
                "avg": {},
                "min": {},
                "max": {},
            },
        },
        "orderBy": [
            {
                "prescriptionFill": {
                    "ref": "...",
                },
            },
        ],
        "search": "string",
        "take": 0,
        "skip": 0,
    },
)
response.raise_for_status()
print(response.json())

const response = await fetch("https://api.hermeshealth.ai/v0/prescription-fills/browse", {
    method: "POST",
    headers: {
        Authorization: "Bearer YOUR_API_KEY",
        "Content-Type": "application/json",
    },
    body: JSON.stringify({
      "select": {
        "prescriptionFill": {
          "ref": true,
          "ndc": true,
          "rxCui": true,
          "drugLabel": true,
          "prescriptionNumber": true,
          "fillNumber": true,
          "daysSupply": true,
          "quantityDispensed": true,
          "strength": true,
          "totalRefillsAllowed": true,
          "fcraDispute": true,
          "fillDate": true,
          "createdAt": true,
          "companyId": true,
          "projectId": true,
          "patientId": true,
          "visitRef": true,
          "siteId": true,
          "prescriberPractitionerId": true
        },
        "drug": {
          "ndc": true,
          "rxCui": true,
          "name": true,
          "doseForm": true,
          "ingredient": true,
          "therapeuticClass": true,
          "strength": true,
          "suppress": true
        },
        "company": {
          "link": true,
          "id": true,
          "name": true,
          "tier": true,
          "domains": true,
          "subdomain": true,
          "defaultRole": true,
          "requestStatusWebhook": true,
          "visitsWebhook": true,
          "patientNoteWebhook": true,
          "requestNoteWebhook": true,
          "authorizationStatusWebhook": true,
          "sandboxRequestStatusWebhook": true,
          "sandboxVisitsWebhook": true,
          "sandboxPatientNoteWebhook": true,
          "sandboxRequestNoteWebhook": true,
          "sandboxAuthorizationStatusWebhook": true,
          "purposeCoveredOperations": true,
          "purposeCoveredPayment": true,
          "purposeCoveredTreatment": true,
          "purposeIndividualAccess": true,
          "purposeInsuranceLife": true,
          "purposeInsuranceOther": true,
          "purposeLegalDefense": true,
          "purposeLegalMedicalMalpractice": true,
          "purposeLegalPlaintiff": true,
          "purposeResearchClinicalTrials": true,
          "purposeResearchPatientRegistries": true,
          "defaultPurpose": true,
          "authorizationPdfEnabled": true,
          "ial2TokensEnabled": true,
          "feeOcr": true,
          "feeSiteFinder": true,
          "feeAuthCheck": true,
          "feeRecordRequest": true,
          "feeInNetworkRequest": true,
          "feeSiteSonarHit": true,
          "feeSiteSonarNoHit": true,
          "feePatientHistoryHit": true,
          "feePatientHistoryNoHit": true,
          "feePatientHistoriesPlus": true,
          "feeChat": true,
          "feeAiResearcher": true,
          "stripeCustomerId": true,
          "createdAt": true,
          "lastWrite": true,
          "whiteLabel": true,
          "patientHistoriesEnabled": true,
          "siteSonarEnabled": true,
          "ehrSearchEnabled": true,
          "recordRequestEnabled": true,
          "inNetworkRequestEnabled": true,
          "preferInNetwork": true,
          "accentColor": true,
          "styledLinks": true,
          "roi": true,
          "clinicalDataVendor": true,
          "deliveryFormalName": true,
          "deliveryRequesterName": true,
          "deliveryPhone": true,
          "deliveryFaxNumber": true,
          "deliveryRecordsEmail": true,
          "deliveryMailingAddressLine1": true,
          "deliveryMailingAddressLine2": true,
          "deliveryMailingAddressCity": true,
          "deliveryMailingAddressState": true,
          "deliveryMailingAddressZip": true,
          "deliveryEmailSender": true,
          "deliveryEmailCc": true,
          "deliveryEmailSignature": true,
          "deliveryEmailSmtpHost": true,
          "userCount": true,
          "userLastLogin": true,
          "projectCount": true,
          "patientCount": true,
          "patientActiveCount": true,
          "requestCount": true,
          "visitCount": true,
          "feeUninvoicedAmount": true,
          "feeTotalNonCanceledAmount": true,
          "feeLastInvoiceDate": true,
          "creditBalance": true,
          "billingEmail": true
        },
        "project": {
          "id": true,
          "companyId": true,
          "name": true,
          "description": true,
          "status": true,
          "purpose": true,
          "createdAt": true,
          "updatedAt": true,
          "selfServe": true,
          "link": true,
          "patientCount": true,
          "patientCompletedCount": true,
          "requestCount": true,
          "recordRequestCount": true,
          "ccdaRequestCount": true,
          "visitCount": true,
          "representationLetterExists": true,
          "representationLetterDownloadUrl": true,
          "requestLetterExists": true,
          "requestLetterDownloadUrl": true
        },
        "patient": {
          "id": true,
          "firstName": true,
          "lastName": true,
          "alternateLastNames": true,
          "dateOfBirth": true,
          "sex": true,
          "zipCodes": true,
          "mobile": true,
          "email": true,
          "createdAt": true,
          "updatedAt": true,
          "authorizationStatus": true,
          "searchLevel": true,
          "siteSonar": true,
          "patientHistories": true,
          "ehrSearch": true,
          "searchStatus": true,
          "latestSubmissionErrored": true,
          "ownerUserId": true,
          "companyId": true,
          "projectId": true,
          "userId": true,
          "link": true,
          "visitCount": true,
          "requestCount": true,
          "recordRequestCount": true,
          "ccdaRequestCount": true,
          "requestCompletedOrCanceledCount": true,
          "feeTotal": true,
          "lastSonarRunAt": true,
          "lastHistoriesRunAt": true,
          "lastEhrRunAt": true,
          "diagnosisCount": true,
          "procedureCount": true,
          "prescriptionFillCount": true,
          "labResultCount": true,
          "authorizationExists": true,
          "authorizationDownloadUrl": true
        },
        "visit": {
          "ref": true,
          "encounterType": true,
          "claimType": true,
          "earliestServiceDate": true,
          "latestServiceDate": true,
          "memberId": true,
          "createdAt": true,
          "dataSources": true,
          "ehrDiscovered": true,
          "companyId": true,
          "projectId": true,
          "patientId": true,
          "subjectSiteKey": true,
          "attendingProviderId": true,
          "renderingProviderId": true,
          "operatingProviderId": true,
          "payorId": true,
          "procedureCount": true,
          "diagnosisCount": true,
          "prescriptionFillCount": true
        },
        "site": {
          "id": true,
          "name": true,
          "npis": true,
          "isFacility": true,
          "inNetwork": true,
          "hasEmbedding": true,
          "recordRequestCount": true,
          "visitCount": true,
          "taxId": true,
          "updatedAt": true,
          "addressLine1": true,
          "addressLine2": true,
          "city": true,
          "state": true,
          "zip": true,
          "formattedAddress": true,
          "latitude": true,
          "longitude": true,
          "phone": true,
          "mainFax": true,
          "email": true,
          "systemName": true,
          "primarySpecialty": true,
          "researchFinished": true,
          "liteResearchFinished": true,
          "placeId": true,
          "addressHash": true,
          "website": true,
          "acceptsEsignature": true,
          "googlePlacesName": true,
          "fingerprintedAt": true,
          "dedupConsideredAt": true,
          "dataSources": true,
          "npiEnumerationDate": true,
          "npiDeactivationReason": true,
          "npiDeactivationDate": true,
          "npiReactivationDate": true,
          "googleMapsUrl": true,
          "medicalDepartmentId": true,
          "facilityBillingDepartmentId": true,
          "physicianBillingDepartmentId": true,
          "imagingBillingDepartmentId": true,
          "emergencyRoomBillingDepartmentId": true,
          "anesthesiologyBillingDepartmentId": true,
          "imagingDepartmentId": true,
          "link": true
        },
        "prescriber": {
          "id": true,
          "name": true,
          "primarySpecialty": true,
          "addressLine1": true,
          "city": true,
          "state": true,
          "zip": true,
          "link": true
        }
      },
      "where": {
        "prescriptionFill": {
          "ref": [
            "..."
          ],
          "ndc": [
            "..."
          ],
          "rxCui": [
            "..."
          ],
          "drugLabel": [
            "..."
          ],
          "prescriptionNumber": [
            "..."
          ],
          "fillNumber": [
            "..."
          ],
          "daysSupply": [
            "..."
          ],
          "quantityDispensed": [
            "..."
          ],
          "strength": [
            "..."
          ],
          "totalRefillsAllowed": [
            "..."
          ],
          "fcraDispute": [
            "..."
          ],
          "fillDate": [
            "..."
          ],
          "createdAt": [
            "..."
          ],
          "companyId": [
            "..."
          ],
          "projectId": [
            "..."
          ],
          "patientId": [
            "..."
          ],
          "visitRef": [
            "..."
          ],
          "siteId": [
            "..."
          ],
          "prescriberPractitionerId": [
            "..."
          ]
        },
        "drug": "isNull",
        "company": "isNull",
        "project": "isNull",
        "patient": "isNull",
        "visit": "isNull",
        "site": "isNull",
        "prescriber": "isNull"
      },
      "aggregate": {
        "prescriptionFill": {
          "count": true,
          "sum": {
            "fillNumber": "...",
            "daysSupply": "...",
            "quantityDispensed": "...",
            "totalRefillsAllowed": "...",
            "companyId": "..."
          },
          "avg": {
            "fillNumber": "...",
            "daysSupply": "...",
            "quantityDispensed": "...",
            "totalRefillsAllowed": "...",
            "companyId": "..."
          },
          "min": {
            "fillNumber": "...",
            "daysSupply": "...",
            "quantityDispensed": "...",
            "totalRefillsAllowed": "...",
            "companyId": "..."
          },
          "max": {
            "fillNumber": "...",
            "daysSupply": "...",
            "quantityDispensed": "...",
            "totalRefillsAllowed": "...",
            "companyId": "..."
          }
        },
        "drug": {
          "count": true,
          "sum": {},
          "avg": {},
          "min": {},
          "max": {}
        },
        "company": {
          "count": true,
          "sum": {},
          "avg": {},
          "min": {},
          "max": {}
        },
        "project": {
          "count": true,
          "sum": {
            "companyId": "..."
          },
          "avg": {
            "companyId": "..."
          },
          "min": {
            "companyId": "..."
          },
          "max": {
            "companyId": "..."
          }
        },
        "patient": {
          "count": true,
          "sum": {
            "companyId": "..."
          },
          "avg": {
            "companyId": "..."
          },
          "min": {
            "companyId": "..."
          },
          "max": {
            "companyId": "..."
          }
        },
        "visit": {
          "count": true,
          "sum": {
            "claimType": "...",
            "companyId": "..."
          },
          "avg": {
            "claimType": "...",
            "companyId": "..."
          },
          "min": {
            "claimType": "...",
            "companyId": "..."
          },
          "max": {
            "claimType": "...",
            "companyId": "..."
          }
        },
        "site": {
          "count": true,
          "sum": {
            "recordRequestCount": "...",
            "visitCount": "...",
            "addressHash": "..."
          },
          "avg": {
            "recordRequestCount": "...",
            "visitCount": "...",
            "addressHash": "..."
          },
          "min": {
            "recordRequestCount": "...",
            "visitCount": "...",
            "addressHash": "..."
          },
          "max": {
            "recordRequestCount": "...",
            "visitCount": "...",
            "addressHash": "..."
          }
        },
        "prescriber": {
          "count": true,
          "sum": {},
          "avg": {},
          "min": {},
          "max": {}
        }
      },
      "orderBy": [
        {
          "prescriptionFill": {
            "ref": "..."
          }
        }
      ],
      "search": "string",
      "take": 0,
      "skip": 0
    }),
});
if (!response.ok) throw new Error(`Request failed: ${response.status}`);
const data = await response.json();

Response

json

{
  "table": [
    {
      "prescriptionFill": {
        "ref": "...",
        "id": "...",
        "ndc": "...",
        "rxCui": "...",
        "drugLabel": "...",
        "prescriptionNumber": "...",
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "strength": "...",
        "totalRefillsAllowed": "...",
        "fcraDispute": "...",
        "fillDate": "...",
        "createdAt": "...",
        "companyId": "...",
        "projectId": "...",
        "patientId": "...",
        "visitRef": "...",
        "visitId": "...",
        "siteId": "...",
        "prescriberPractitionerId": "..."
      },
      "drug": {
        "ndc": "...",
        "rxCui": "...",
        "name": "...",
        "doseForm": "...",
        "ingredient": "...",
        "therapeuticClass": "...",
        "strength": "...",
        "suppress": "..."
      },
      "company": {
        "id": "...",
        "name": "...",
        "tier": "...",
        "domains": "...",
        "subdomain": "...",
        "defaultRole": "...",
        "requestStatusWebhook": "...",
        "visitsWebhook": "...",
        "patientNoteWebhook": "...",
        "requestNoteWebhook": "...",
        "authorizationStatusWebhook": "...",
        "sandboxRequestStatusWebhook": "...",
        "sandboxVisitsWebhook": "...",
        "sandboxPatientNoteWebhook": "...",
        "sandboxRequestNoteWebhook": "...",
        "sandboxAuthorizationStatusWebhook": "...",
        "purposeCoveredOperations": "...",
        "purposeCoveredPayment": "...",
        "purposeCoveredTreatment": "...",
        "purposeIndividualAccess": "...",
        "purposeInsuranceLife": "...",
        "purposeInsuranceOther": "...",
        "purposeLegalDefense": "...",
        "purposeLegalMedicalMalpractice": "...",
        "purposeLegalPlaintiff": "...",
        "purposeResearchClinicalTrials": "...",
        "purposeResearchPatientRegistries": "...",
        "defaultPurpose": "...",
        "authorizationPdfEnabled": "...",
        "ial2TokensEnabled": "...",
        "feeOcr": "...",
        "feeSiteFinder": "...",
        "feeAuthCheck": "...",
        "feeRecordRequest": "...",
        "feeInNetworkRequest": "...",
        "feeSiteSonarHit": "...",
        "feeSiteSonarNoHit": "...",
        "feePatientHistoryHit": "...",
        "feePatientHistoryNoHit": "...",
        "feePatientHistoriesPlus": "...",
        "feeChat": "...",
        "feeAiResearcher": "...",
        "stripeCustomerId": "...",
        "createdAt": "...",
        "lastWrite": "...",
        "whiteLabel": "...",
        "patientHistoriesEnabled": "...",
        "siteSonarEnabled": "...",
        "ehrSearchEnabled": "...",
        "recordRequestEnabled": "...",
        "inNetworkRequestEnabled": "...",
        "preferInNetwork": "...",
        "accentColor": "...",
        "styledLinks": "...",
        "roi": "...",
        "clinicalDataVendor": "...",
        "deliveryFormalName": "...",
        "deliveryRequesterName": "...",
        "deliveryPhone": "...",
        "deliveryFaxNumber": "...",
        "deliveryRecordsEmail": "...",
        "deliveryMailingAddressLine1": "...",
        "deliveryMailingAddressLine2": "...",
        "deliveryMailingAddressCity": "...",
        "deliveryMailingAddressState": "...",
        "deliveryMailingAddressZip": "...",
        "deliveryEmailSender": "...",
        "deliveryEmailCc": "...",
        "deliveryEmailSignature": "...",
        "deliveryEmailSmtpHost": "..."
      },
      "project": {
        "patientCount": "...",
        "patientCompletedCount": "...",
        "requestCount": "...",
        "recordRequestCount": "...",
        "ccdaRequestCount": "...",
        "visitCount": "...",
        "representationLetterExists": "...",
        "representationLetterDownloadUrl": "...",
        "requestLetterExists": "...",
        "requestLetterDownloadUrl": "..."
      },
      "patient": {
        "visitCount": "...",
        "requestCount": "...",
        "recordRequestCount": "...",
        "ccdaRequestCount": "...",
        "requestCompletedOrCanceledCount": "...",
        "feeTotal": "...",
        "lastSonarRunAt": "...",
        "lastHistoriesRunAt": "...",
        "lastEhrRunAt": "...",
        "diagnosisCount": "...",
        "procedureCount": "...",
        "prescriptionFillCount": "...",
        "labResultCount": "...",
        "authorizationExists": "...",
        "authorizationDownloadUrl": "..."
      },
      "visit": {
        "procedureCount": "...",
        "diagnosisCount": "...",
        "prescriptionFillCount": "..."
      },
      "site": {
        "id": "...",
        "name": "...",
        "npis": "...",
        "isFacility": "...",
        "inNetwork": "...",
        "hasEmbedding": "...",
        "recordRequestCount": "...",
        "visitCount": "...",
        "taxId": "...",
        "updatedAt": "...",
        "addressLine1": "...",
        "addressLine2": "...",
        "city": "...",
        "state": "...",
        "zip": "...",
        "formattedAddress": "...",
        "latitude": "...",
        "longitude": "...",
        "phone": "...",
        "mainFax": "...",
        "email": "...",
        "systemName": "...",
        "primarySpecialty": "...",
        "researchFinished": "...",
        "liteResearchFinished": "...",
        "placeId": "...",
        "addressHash": "...",
        "website": "...",
        "acceptsEsignature": "...",
        "googlePlacesName": "...",
        "fingerprintedAt": "...",
        "dedupConsideredAt": "...",
        "dataSources": "...",
        "npiEnumerationDate": "...",
        "npiDeactivationReason": "...",
        "npiDeactivationDate": "...",
        "npiReactivationDate": "...",
        "googleMapsUrl": "...",
        "medicalDepartmentId": "...",
        "facilityBillingDepartmentId": "...",
        "physicianBillingDepartmentId": "...",
        "imagingBillingDepartmentId": "...",
        "emergencyRoomBillingDepartmentId": "...",
        "anesthesiologyBillingDepartmentId": "...",
        "imagingDepartmentId": "...",
        "link": "..."
      },
      "prescriber": {
        "id": "...",
        "name": "...",
        "primarySpecialty": "...",
        "addressLine1": "...",
        "city": "...",
        "state": "...",
        "zip": "...",
        "link": "..."
      }
    }
  ],
  "aggregate": {
    "prescriptionFill": {
      "count": 0,
      "sum": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "avg": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "min": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      },
      "max": {
        "fillNumber": "...",
        "daysSupply": "...",
        "quantityDispensed": "...",
        "totalRefillsAllowed": "...",
        "companyId": "..."
      }
    },
    "drug": {
      "count": 0,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    },
    "company": {
      "count": 0,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    },
    "project": {
      "count": 0,
      "sum": {
        "companyId": "..."
      },
      "avg": {
        "companyId": "..."
      },
      "min": {
        "companyId": "..."
      },
      "max": {
        "companyId": "..."
      }
    },
    "patient": {
      "count": 0,
      "sum": {
        "companyId": "..."
      },
      "avg": {
        "companyId": "..."
      },
      "min": {
        "companyId": "..."
      },
      "max": {
        "companyId": "..."
      }
    },
    "visit": {
      "count": 0,
      "sum": {
        "claimType": "...",
        "companyId": "..."
      },
      "avg": {
        "claimType": "...",
        "companyId": "..."
      },
      "min": {
        "claimType": "...",
        "companyId": "..."
      },
      "max": {
        "claimType": "...",
        "companyId": "..."
      }
    },
    "site": {
      "count": 0,
      "sum": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "avg": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "min": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      },
      "max": {
        "recordRequestCount": "...",
        "visitCount": "...",
        "addressHash": "..."
      }
    },
    "prescriber": {
      "count": 0,
      "sum": {},
      "avg": {},
      "min": {},
      "max": {}
    }
  },
  "total": 0
}