anyone know if you can use a ppk file to do sftp connection with NS?

I think the recommended way is to generate a credential field in NetSuite. That's how I've done it. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_159073608341.html

convert the ppk to pem using puttygen, then upload the key so that you can use the keyId for sftp.createConnection

ok awesome