When scripting SFTP jobs, it’s a good idea to include the host key fingerprint to prevent man in the middle attacks. The easiest way I have found to get this information (if not provided) is to use WinSCP.
Run WinSCP.exe, and create a new connection. When you connect, you will be prompted with host key information to add to the cache - with a very convenient option to “Copy key fingerprints to clipboard”, per below screenshot.