bug in parsing of env.yaml we are trying to use sling to call an api from a SQLAgent job on windows. We used the following api configuration in the env file:

type: api
        spec: "local/C:\BIPROD\BI_Runtime\Environments\Prod\slinghome\api_spec_releasy.yaml"

The effect of this was that sling could not find any connections at all. No parsing error messages. sling conns list suddenly listed nothing. We know now that it should be written like this instead:

type: api
        spec: "local/C:/BIPROD/BI_Runtime/Environments/Prod/slinghome/api_spec_releasy.yaml"

Finding this was not easy. Maybe you should add some more informative error messges? Also, it would be nice with a trace-level log that shows what places are searched for the env.yaml file, and the path of the file that is actually used. And a question: When you use a relative spec like spec: "local/api_spec_releasy.yaml" Where does it look for this file? Is it relative to the current working folder, or the env file, or the replication file?

thanks, will do, easy fix. there is actually a [CleanWindowsPath](https://github.com/slingdata-io/sling-cli/blob/main/core/env/env.go#L678-L680) function for this, but isn't applied for spec path. For abosolute/relative on local, you can just use use the

file://

prefix, so

file://relative/file.yaml

and

file:///absolute/path/to/file.yaml

Yes, but what is the relative path relative to?

it uses the current working dir

ok, sounds obvious, in my situation it is a problem because the cwd for sql agent is C:\WINDOWS\SYSTEM32 or something like that.

I think the best way would be to add a placeholder like

$SLING_HOME_DIR

in the spec path to do relative from there. but yea, other users for example save their spec path in the repo, and use absolute path from CWD

Is $SLING_HOME_DIR in the spec path supported today?

not yet, will add.

Nice!

ok this works now for next release:

convertkit:
    type: api
    spec: file://${SLING_HOME_DIR}/test_convertkit.yaml

So you'll need

${SLING_HOME_DIR}

along with

--home-dir /tmp/sling-test-home

great! And how do I use --home-dir from windows? C:\temp\slinghome ?

both should work