Create bulk export

POST /public/v1/bulk-export

Create bulk export

cURL

curl --request POST \
  --url https://app.silnahealth.com/api/public/v1/bulk-export/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "export_params": {
    "date_range_start_date": "2024-01-01",
    "date_range_end_date": "2024-02-01",
    "date_range_key": null,
    "specialties": null,
    "service_location_ids": null,
    "payor_entity_ids": null,
    "statuses": null,
    "authorization_types": null,
    "patient_id": null,
    "patient_plan_ids": null,
    "patient_status": null
  },
  "provider_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
'

201

{
  "bulk_export_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}

This API will kick off an asynchronous job to create a bulk export csv and return a bulk_export_id. To know when your export is complete, you will have to poll with the Get Bulk Exports API.

The body of the bulk export request allows you to set filters on the data you want. For example, if you only wanted to get all payor approved prior authorizations in 2024, you would make a request like the below, replacing the example provider_id with the provider ID you want to get data for.

{
  "export_params": {
    "export_type": "PRIOR_AUTHORIZATION",
    "date_range_start_date": "2024-01-01",
    "date_range_end_date": "2025-01-01",
    "date_range_key": "created_at",
    "statuses": ["PAYOR_APPROVED"]
  },
  "provider_id": "0194a843-5821-70e2-bbe9-0f986c05984d"
}

If you want to make requests for eligibility checks, benefits checks, payor detections/discovery, or patients, you can replace the export_type with ELIGIBILITY_CHECK, BENEFITS_CHECK, PAYOR_DETECTION, or PATIENT respectively.

CSV Schemas Generated

Prior Authorizations

• patient_ehr_id (optional)
• created_at (YYYY-MM-DD)
• submitted_on (YYYY-MM-DD, optional)
• first_name
• last_name
• patient_code
• service_location_name
• authorization_type
• start_date (YYYY-MM-DD)
• end_date (YYYY-MM-DD, optional)
• authorization_reference_number (optional)
• status
• treatment_codes (list of treatment code objects containing):
  • treatment_code
  • modifiers (optional list)
  • units (decimal)
  • unit_type
  • time_frame
• specialty (optional)
• payor
• member_number (optional)

Benefits Checks

• patient_ehr_id (optional)
• created_at (YYYY-MM-DD)
• date_verified (YYYY-MM-DD, optional)
• first_name
• last_name
• patient_code
• service_location_name
• patient_status
• patient_date_of_birth (YYYY-MM-DD, optional)
• eligibility_status (optional)
• network_status (optional)
• payor
• member_number (optional)
• group_number (optional)
• plan_start_date (YYYY-MM-DD, optional)
• plan_end_date (YYYY-MM-DD, optional)
• plan_type (optional)
• subscriber_first_name (optional)
• subscriber_last_name (optional)
• subscriber_date_of_birth (YYYY-MM-DD, optional)
• subscriber_address (optional)
• subscriber_city (optional)
• subscriber_state (optional)
• subscriber_zip_code (optional)
• subscriber_patient_relationship (optional
• copay (decimal, optional)
• coinsurance (decimal, optional)
• individual_deductible (decimal, optional)
• individual_deductible_met (decimal, optional)
• family_deductible (decimal, optional)
• family_deductible_met (decimal, optional)
• individual_out_of_pocket (decimal, optional)
• individual_out_of_pocket_met (decimal, optional)
• family_out_of_pocket (decimal, optional)
• family_out_of_pocket_met (decimal, optional)
• hard_visit_limit_present (boolean, optional)
• hard_visit_limit_units (integer, optional)
• hard_visit_limit_unit_type (optional)
• referral_required (boolean, optional)
• authorization_required (boolean, optional)
• authorization_not_required (boolean, optional)
• authorization_requirement_time (optional)
• authorization_requirement_quantity (decimal, optional)
• authorization_requirement_unit (optional)
• specialty (optional)
• cost_estimate_copy (optional)
• payor_type (optional)
• exclusions_and_limitations (optional)

If you are using Rates, we will also include each rate that you have set up as a column in the CSV.

Eligibility Checks

• patient_ehr_id (optional)
• created_at (YYYY-MM-DD)
• date_verified (YYYY-MM-DD, optional)
• first_name
• last_name
• patient_code
• service_location_name
• patient_status
• patient_date_of_birth (YYYY-MM-DD, optional)
• payor
• member_number (optional)
• group_number (optional)
• eligibility_status (optional)

Payor Detections

• patient_ehr_id (optional)
• first_name
• last_name
• patient_code
• payor
• member_number (optional)
• date_found (YYYY-MM-DD)
• status

Patients

• patient_ehr_id (optional)
• first_name
• last_name
• patient_code
• date_of_birth (YYYY-MM-DD)
• status
• specialties (list)
• plans (list of plan objects containing):
  • payor_name
  • plan_order_number
  • member_number (optional)
• service_location (optional)

Authorizations

Authorization · string · header · required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Body

application/json

Create Parameters for Bulk Export

Create Parameters for Bulk Export

export_params · Prior Auth Export Params · object · required

Prior Auth Export Params

Prior Auth Export Params

Benefits Export Params

Eligibility Export Params

Payor Detection Export Params

Patient Export Params

Show child attributes

provider_id · string<uuid> · required

Response

201

application/json

bulk_export_id · string<uuid> · required