List facility credentialing workflows with filters

End at document ID, for backward cursor-based pagination

Filter Criteria

The filter parameter must be URL encoded when sent. Filters are specified as JSON objects where each field can have one or more filter operations.

Filterable Fields

Core Workflow Fields

• id: Workflow unique identifier (String)
• createdAt: Workflow creation timestamp (Timestamp)
• updatedAt: Workflow last update timestamp (Timestamp)

Data Fields - Workflow Information

• data.credentialingCycle: Credentialing cycle (String)
• data.facilityFileType: Type of facility file (String)
• data.assignedTo: User assigned to the workflow (String)
• data.assignedBy: User who assigned the workflow (String)

Data Fields - Status & Dates

• data.credentialingStatus: Current workflow status (String)
• data.psvReadyDate: PSV ready date (Timestamp)
• data.psvCompletedDate: PSV completed date (Timestamp)
• data.credentialingStatusLastUpdatedDate: Status last updated date (Timestamp)
• data.previousCredentialedDate: Previous credentialing date (Date)
• data.credentialingDueDate: Credentialing due date (Date)
• data.nextCredentialingDate: Next credentialing date (Date)
• data.credentialingDecisionDate: Credentialing decision date (Date)

Data Fields - Facility Information

• data.facility.npi: National Provider Identifier (String)
• data.facility.name: Facility name (String)
• data.facility.tin: Tax Identification Number (String)
• data.facility.externalId: External identifier (String)
• data.facility.primaryEmail: Primary email address (String)
• data.facility.facilityType: Type of facility (String)
• data.facility.lineOfBusiness: Array of lines of business (Array - eq/in only)
• data.facility.licensedStates: Array of licensed states (Array - eq/in only)

Supported Filter Operations

String Fields (eq, neq, in, nin, contains)

• eq: Exact match - {"field":{"eq":"value"}}
• neq: Not equal - {"field":{"neq":"value"}}
• in: Match any value in array - {"field":{"in":["value1","value2"]}}
• nin: Not match any value in array - {"field":{"nin":["value1","value2"]}}
• contains: Substring match - {"field":{"contains":"partial"}}

Timestamp/Date Fields (eq, neq, gt, gte, lt, lte)

• eq: Exact match - {"field":{"eq":"2023-01-01T00:00:00Z"}}
• neq: Not equal - {"field":{"neq":"2023-01-01T00:00:00Z"}}
• gt: Greater than - {"field":{"gt":"2023-01-01T00:00:00Z"}}
• gte: Greater than or equal - {"field":{"gte":"2023-01-01T00:00:00Z"}}
• lt: Less than - {"field":{"lt":"2023-01-01T00:00:00Z"}}
• lte: Less than or equal - {"field":{"lte":"2023-01-01T00:00:00Z"}}

Array Fields (eq, in only)

• eq: Array contains value - {"field":{"eq":"value"}}
• in: Array contains any of these values - {"field":{"in":["value1","value2"]}}

Filter Examples

Basic Filters (before URL encoding)

// Filter by id
{"id":{"eq":"123"}}

// Filter by credentialing status
{"data.credentialingStatus":{"eq":"PSV_READY"}}

// Filter by assigned user
{"data.assignedTo":{"eq":"user123"}}

// Filter by facility file type
{"data.facilityFileType":{"eq":"INITIAL"}}

Facility Filters

// Search by facility name
{"data.facility.name":{"contains":"Hospital"}}

// Filter by NPI (exact match)
{"data.facility.npi":{"eq":"1234567890"}}

// Filter by TIN
{"data.facility.tin":{"eq":"12-3456789"}}

// Filter by email
{"data.facility.primaryEmail":{"contains":"@example.com"}}

// Filter by facility type
{"data.facility.facilityType":{"eq":"HOSPITAL"}}

// Filter by external ID
{"data.facility.externalId":{"eq":"EXT123"}}

Array Field Filters

// Filter by line of business
{"data.facility.lineOfBusiness":{"eq":"MEDICARE"}}

// Filter by multiple lines of business
{"data.facility.lineOfBusiness":{"in":["MEDICARE","MEDICAID"]}}

// Filter by licensed states
{"data.facility.licensedStates":{"in":["CA","NY","TX"]}}

Date/Timestamp Filters

// Workflows created after a date
{"createdAt":{"gt":"2023-01-01T00:00:00Z"}}

// PSV ready within a date range
{"data.psvReadyDate":{"gte":"2023-01-01T00:00:00Z","lte":"2023-12-31T23:59:59Z"}}

// Workflows updated in last 7 days
{"updatedAt":{"gte":"2023-01-15T00:00:00Z"}}

// Credentialing due date in range
{"data.credentialingDueDate":{"gte":"2023-01-01","lte":"2023-12-31"}}

Combined Filters

// Multiple conditions (AND logic)
{
  "data.facility.name":{"contains":"Hospital"},
  "data.facility.npi":{"eq":"1234567890"},
  "data.credentialingStatus":{"eq":"PSV_READY"}
}

// Filter by status and date range
{
  "data.credentialingStatus":{"eq":"CRED_APPROVED"},
  "data.credentialingDecisionDate":{"gte":"2023-01-01","lte":"2023-12-31"}
}

// Filter by facility type and line of business
{
  "data.facility.facilityType":{"eq":"HOSPITAL"},
  "data.facility.lineOfBusiness":{"in":["MEDICARE","MEDICAID"]}
}

cURL Examples

# Filter by id
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22id%22%3A%7B%22eq%22%3A%22123%22%7D%7D'

# Filter by facility name (case-sensitive)
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.facility.name%22%3A%7B%22contains%22%3A%22Hospital%22%7D%7D'

# Filter by NPI
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.facility.npi%22%3A%7B%22eq%22%3A%221234567890%22%7D%7D'

# Filter by licensed states
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.facility.licensedStates%22%3A%7B%22in%22%3A%5B%22CA%22%2C%22NY%22%5D%7D%7D'

# Filter by credentialing status
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.credentialingStatus%22%3A%7B%22eq%22%3A%22PSV_READY%22%7D%7D'

# Combined filter
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.facility.name%22%3A%7B%22contains%22%3A%22Hospital%22%7D%2C%22data.credentialingStatus%22%3A%7B%22eq%22%3A%22PSV_READY%22%7D%7D'

Note: Always URL encode the JSON filter string before sending the request.

Sorting/Ordering

Sort results by specifying a field name and direction. The order parameter must be URL encoded when sent.

Sortable Fields

You can sort by any of the following fields:

• id: Workflow unique identifier
• createdAt: Workflow creation timestamp
• createdBy: User who created the workflow (sortable only, not filterable)
• updatedAt: Last update timestamp
• updatedBy: User who last updated the workflow (sortable only, not filterable)
• data.credentialingDueDate: Credentialing due date (index-backed)
• data.nextCredentialingDate: Next credentialing date (index-backed)
• data: JSON data field (lexicographic ordering)

Sort Direction

• ASC: Ascending order (default)
• DESC: Descending order

Note: Sort direction is case-insensitive, but uppercase is recommended (ASC/DESC).

Sort Format

{
  "orderBy": "fieldName",
  "orderByDirection": "ASC|DESC"
}

Sort Examples

Basic Sorting (before URL encoding)

// Sort by creation date (newest first)
{"orderBy":"createdAt","orderByDirection":"DESC"}

// Sort by id (ascending)
{"orderBy":"id","orderByDirection":"ASC"}

// Sort by last update (newest first)
{"orderBy":"updatedAt","orderByDirection":"DESC"}

cURL Examples

# Sort by creation date (newest first)
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?order=%7B%22orderBy%22%3A%22createdAt%22%2C%22orderByDirection%22%3A%22DESC%22%7D'

# Sort by id (ascending)
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?order=%7B%22orderBy%22%3A%22id%22%2C%22orderByDirection%22%3A%22ASC%22%7D'

# Sort by last update (newest first)
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?order=%7B%22orderBy%22%3A%22updatedAt%22%2C%22orderByDirection%22%3A%22DESC%22%7D'

# Combine filter and sort
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.credentialingStatus%22%3A%7B%22eq%22%3A%22PSV_READY%22%7D%7D&order=%7B%22orderBy%22%3A%22createdAt%22%2C%22orderByDirection%22%3A%22DESC%22%7D'

# Combine filter, sort, and pagination
curl -X GET 'http://localhost:8080/facility-credentialing-workflows?filter=%7B%22data.facility.name%22%3A%7B%22contains%22%3A%22Hospital%22%7D%7D&order=%7B%22orderBy%22%3A%22updatedAt%22%2C%22orderByDirection%22%3A%22DESC%22%7D&size=20&page=0'

Note: Always URL encode the JSON order string before sending the request.

Page number (0-based), for offset-based pagination

Page size

Start after document ID, for forward cursor-based pagination

Tenant ID