Airbyte folks, since secret manager or azure vault is not yet supported, can we use rest API to trigger airbyte jobs? To build a source, destination and a connector on the fly and ingest data?

Yes, you can use the API to trigger a connection or create a new source, destination and connection. Check the API Docs here: https://airbyte-public-api-docs.s3.us-east-2.amazonaws.com/rapidoc-api-docs.html

Thank You!