Katalyst: Failures when importing data via API integration

Description

• Integrations push experiments or analytical results into Katalyst via API (REST or similar).
• Occasionally, imports fail with errors:
  • Invalid payload formats.
  • Missing or duplicate identifiers.
  • Authorization issues.

Solution

• Validate API requests:
  • Compare failing requests to working examples (payload structure, required fields).
  • Ensure IDs (e.g., experiment IDs, material IDs) are unique and correctly formatted.
• Check authentication/authorization:
  • Confirm API tokens/credentials are valid and have correct scopes or roles.
  • Verify that integration accounts are not locked or expired.
• Examine Katalyst logs for API‑related errors:
  • Identify which validations failed (missing fields, invalid types, DB constraints).
• Correct integration logic:
  • Update the external system to send valid, complete JSON/XML payloads.
  • Implement retries where appropriate, but only after fixing payload problems.
• For large or critical integrations:
  • Implement a test harness or staging environment to validate changes before hitting production.