[REQUEST] Add API key authentication support to GET /api/workflows list endpoint for programmatic discovery

[Lutherwaves]

Is your feature request related to a problem? Please describe.
I think it makes a lot of sense to be able to programmatically discover and list workflows from SimStudio (per api key), but the /api/workflows endpoint only supports session-based authentication (cookies) for now. This makes it impossible to use SimStudio's API for automation, CI/CD pipelines, or third-party integrations that need to list workflows without maintaining browser sessions.

Describe the solution you'd like
Add support for API key authentication (X-API-Key header) to the /api/workflows endpoint, similar to how other SimStudio endpoints like /api/workflows/[id] and /api/workflows/[id]/execute already support API key authentication. This would allow programmatic access to workflow listings using the same authentication method that's already supported for individual workflow operations.

Describe alternatives you've considered

1. Session-based authentication: Storing SimStudio credentials and creating sessions programmatically, but this is complex, fragile, and requires storing sensitive login credentials
2. Individual workflow endpoints: Using /api/workflows/[id] for known workflow IDs, but this requires knowing the IDs beforehand, which is what I am trying to avoid

Additional context

# This currently fails with 401 Unauthorized
curl -H "X-API-Key: sim_abc123..." http://localhost:3000/api/workflows

# But this works for individual workflows
curl -H "X-API-Key: sim_abc123..." http://localhost:3000/api/workflows/workflow-id/execute

[Lutherwaves]

@waleedlatif1 looking at the referenced PR #1338, I believe this issue was incorrectly referenced and instead it should have referenced #1330 d73a97f

Let me know if there is a more generic "external api auth exposure" type of issue we can link this to, as the more I use sim the more endpoints I see that use the default session auth and do not provide the option to connect via an api key

[waleedlatif1]

@Lutherwaves You are right about the incorrect reference, thank you for the heads up.

We have a function called 'checkHybridAuth' that we can use in place of the 'getSession' to make this possible for you.

[Lutherwaves]

@Lutherwaves You are right about the incorrect reference, thank you for the heads up.

We have a function called 'checkHybridAuth' that we can use in place of the 'getSession' to make this possible for you.

Yeah I saw that, but was not sure if that is how you planned on having it work. If that is feasible I can also submit a PR.

[waleedlatif1]

that'd be great @Lutherwaves

[Lutherwaves]

that'd be great @Lutherwaves

I had #1443 opened up but did not satisfy the desired setup I guess. Will standby to see your inputs so we have this in a matter that fits simstudio vision