Build a Supplier Credential Expiry and Re-Certification Coordinator
Process supplier compliance certificates and track expiration dates using tabular Frictionless Data packages. Orchestrate automated re-certification alerts and verify renewed credential integrity.
What you are building
Process supplier compliance certificates and track expiration dates using tabular Frictionless Data packages. Orchestrate automated re-certification alerts and verify renewed credential integrity.
Vendor Risk Manager
Read supplier credential records and certification schedules encoded as Frictionless tabular resources.
Validate document validity periods against system renewal horizons and regulatory accreditation mandates.
Identify certificates with expired status or incomplete issuing jurisdiction data.
Generate prioritized re-certification outreach schedules with standardized document checklist attachments.
Operational Kanban board organizing vendors by credential expiration urgency with tabular error logs.
Generate synthetic tabular CSVs describing supplier licenses and insurance policies along with Frictionless schema descriptors. Starter examples below are synthetic. They are not downloaded records.
Frictionless data validation Employ Frictionless Data resource schema formats and type validation methods for vendor credential catalogs.
mastra-ai, frictionless, typescript. Mastra AI provides structured workflows to coordinate scheduled state transitions and alerting steps. OpenAI-compatible LLM endpoint for drafting structured re-certification notices.
Submit runnable source, pinned dependencies, setup commands, a working interface, example outputs, and a recorded end-to-end demo. Include tests and an action log.
Infers and validates supplier tabular schemas using Frictionless schema rules.
Correctly partitions suppliers into thirty, sixty, and ninety day renewal tranches.
Constructs automated request payloads listing only missing or expiring documentation.
Outputs valid re-certification manifests suitable for vendor portal consumption.
```json [ { "input": { "vendor_code": "VND-551", "vendor_name": "Apex Security Logistics", "evaluation_date": "2024-04-01", "credentials": [ { "name": "ISO27001_Certificate", "expires_on": "2024-04-20", "status": "active" }, { "name": "General_Liability_Policy", "expires_on": "2024-11-30", "status": "active" } ] }, "expected_output": { "vendor_code": "VND-551", "action_priority": "urgent", "tranche": "0_to_30_days", "documents_requiring_action": [ "ISO27001_Certificate" ], "notification_draft": "Notice: ISO27001_Certificate for Apex Security Logistics expires on 2024-04-20. Submit renewal within 19 days." } }, { "input": { "vendor_code": "VND-702", "vendor_name": "Northern Freight lines", "evaluation_date": "2024-04-01", "credentials": [ { "name": "Hazardous_Materials_Permit", "expires_on": "2024-08-15", "status": "active" } ] }, "expected_output": { "vendor_code": "VND-702", "action_priority": "normal", "tranche": "90_plus_days", "documents_requiring_action": [], "notification_draft": "No urgent renewal actions required. Next expiration on 2024-08-15." } } ] ```
Simulates vendor documentation and communications in an isolated sandbox with mock company data. Use mock external writes. Require human review before any real deployment.
Rules
Simulates vendor documentation and communications in an isolated sandbox with mock company data. Use mock external writes and human review.
How work is evaluated
Infers and validates supplier tabular schemas using Frictionless schema rules. Correctly partitions suppliers into thirty, sixty, and ninety day renewal tranches. Constructs automated request payloads listing only missing or expiring documentation. Outputs valid re-certification manifests suitable for vendor portal consumption.
Runnable source, pinned dependencies, setup commands, working interface, example outputs, recorded demo, tests, and action logs.
Datasets
Public datasets, plus the private datasets you have access to.
How submissions are scored
Complete workflow
Read supplier credential records and certification schedules encoded as Frictionless tabular resources. Validate document validity periods against system renewal horizons and regulatory accreditation mandates. Identify certificates with expired status or incomplete issuing jurisdiction data. Generate prioritized re-certification outreach schedules with standardized document checklist attachments.
Missing or incorrect.
Partly complete, with documented gaps.
Complete, with reproducible evidence.
Correctness and evidence
Infers and validates supplier tabular schemas using Frictionless schema rules. Correctly partitions suppliers into thirty, sixty, and ninety day renewal tranches. Constructs automated request payloads listing only missing or expiring documentation. Outputs valid re-certification manifests suitable for vendor portal consumption.
Missing or incorrect.
Partly complete, with documented gaps.
Complete, with reproducible evidence.
Review interface
Operational Kanban board organizing vendors by credential expiration urgency with tabular error logs.
Missing or incorrect.
Partly complete, with documented gaps.
Complete, with reproducible evidence.
Safe execution
Simulates vendor documentation and communications in an isolated sandbox with mock company data.
This dimension contributes its full weight only when the submission satisfies the requirement. Partial credit is not awarded.
Learning goals
Read supplier credential records and certification schedules encoded as Frictionless tabular resources.
Validate document validity periods against system renewal horizons and regulatory accreditation mandates.
Identify certificates with expired status or incomplete issuing jurisdiction data.
Generate prioritized re-certification outreach schedules with standardized document checklist attachments.
Resources
Generate synthetic tabular CSVs describing supplier licenses and insurance policies along with Frictionless schema descriptors. Supplied starter examples are synthetic, not source extracts.
Challenge setup
Challenge input
Input details are not configured.
Mastra AI
TypeScript agent framework.
Evaluated output
No output checks are configured.
- Read supplier credential records and certification schedules encoded as Frictionless tabular resources. Val...
- Infers and validates supplier tabular schemas using Frictionless schema rules. Correctly partitions supplie...
- Operational Kanban board organizing vendors by credential expiration urgency with tabular error logs.
- 2 public reference cases
- 2 configured tools
Shows the first task, up to three tools, and up to three evidence items.
View technical recipe
Configured tools
- Mastra AI · Optional
- Mastra AI · Optional
Evaluation contract
- Complete workflow · Weight 40
- Correctness and evidence · Weight 30
- Review interface · Weight 20
- Safe execution · Weight 10
Reference cases
- 2 public reference cases
Workflow tasks
No workflow tasks are configured.
Recipe freeze marker
No recipe freeze time is recorded.