is it possible to use the python API to get a flow_id given a project name and flow name?

You need to use the GraphQL API. You can query like this:

query {
  flow (where: {name: {_eq: "artifact_test"},
                project: {name: {_eq: "databricks"}}}){
    name
    id
    project {
      name
    }
  }
}

Wrap it as a string and then use

from prefect.client import Client
client = Client()
client.graphql(query)

thanks @Kevin Kho

If you have many versions, you may get multiple flows returned. Just add archived=False in the GraphQL query

@Kevin Kho - any ideas on how to use literal string interpolation when constructing one of these graphql queries? I have this:

query = """
        query {
            flow (
                where: {
                    name: {_eq: "test"},
                    project: {name: {_eq: "default"}},
                    archived: {_eq: false}
                }
            )
            {
                id
            }
        }
    """

but I want “test” to be substituted with a variable called

flow_name

To be honest with you I just do:

query = """
        query {
            flow (
                where: {
                    name: {_eq: + """ + str(flow_name) + """},
                    project: {name: {_eq: "default"}},
                    archived: {_eq: false}
                }
            )
            {
                id
            }
        }
    """

and it works for me

I think you can just use the modulo operator

Oh I see, nice!