Node JS to OData serivce using SAP Destination Method

[former_member610100]

I have followed this sap-cf-destination package and I've deployed in sap cloud foundry but I am getting connection tunnel error.

• On-Premise system URL also same error & Public Northwind Odata service also same error.

I have given my error and file snap.

Please give some solutions.

Thank you.

{
  "name": "RequestError",
  "message": "Error: tunneling socket could not be established, statusCode=405",
  "cause": {
    "code": "ECONNRESET"
  },
  "error": {
    "code": "ECONNRESET"
  },
  "options": {
    "url": "https://aaaaaa.gdssap.net:8001/sap/opu/odata/sap/ZFIORI7_SRV/ZFIORIPRACSet",
    "resolveWithFullResponse": true,
    "simple": false,
    "proxy": "http://connectivityproxy.internal.cf.eu10.hana.ondemand.com:20003",
    "method": "GET",
    "headers": {
      "Proxy-Authorization": "Bearer eyJhbGciOiJSUzI1NiIsImprdSI6Imh0dHBzOi8vcDIwMDEzMDY4MDB0cmlhbC5hdXRoZW50aWNhdGlvbi5ldTEwLmhhbmEub25kZW1hbmQuY29tL3Rva2VuX2tleXMiLCJraWQiOiJrZXktaWQtMSIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJjZDk2NmZiNGNmMDM0ZTM1ODRkODUyNjY0NTQwNDgxNyIsImV4dF9hdHRyIjp7ImVuaGFuY2VyIjoiWFNVQUEiLCJ6ZG4iOiJwMjAwMTMwNjgwMHRyaWFsIiwic2VydmljZWluc3RhbmNlaWQiOiI1M2I5MDRmOS03NTViLTQzNGQtYTM1Yy1kZjYwMWRkMzg3NzcifSwic3ViIjoic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyIsImF1dGhvcml0aWVzIjpbInVhYS5yZXNvdXJjZSIsImNvbm5lY3Rpdml0eSFiMTcucHJveHkiXSwic2NvcGUiOlsidWFhLnJlc291cmNlIiwiY29ubmVjdGl2aXR5IWIxNy5wcm94eSJdLCJjbGllbnRfaWQiOiJzYi1jbG9uZTUzYjkwNGY5NzU1YjQzNGRhMzVjZGY2MDFkZDM4Nzc3IWIxNDQ0MHxjb25uZWN0aXZpdHkhYjE3IiwiY2lkIjoic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyIsImF6cCI6InNiLWNsb25lNTNiOTA0Zjk3NTViNDM0ZGEzNWNkZjYwMWRkMzg3NzchYjE0NDQwfGNvbm5lY3Rpdml0eSFiMTciLCJncmFudF90eXBlIjoiY2xpZW50X2NyZWRlbnRpYWxzIiwicmV2X3NpZyI6IjQzOGZkMzZlIiwiaWF0IjoxNTU4NjgwNDMyLCJleHAiOjE1NTg3MjM2MzIsImlzcyI6Imh0dHA6Ly9wMjAwMTMwNjgwMHRyaWFsLmxvY2FsaG9zdDo4MDgwL3VhYS9vYXV0aC90b2tlbiIsInppZCI6ImZmMDkyMjhjLTY4YTEtNDg3Ni04MGI5LWIzN2E2MzM2MWZjZSIsImF1ZCI6WyJ1YWEiLCJjb25uZWN0aXZpdHkhYjE3Iiwic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyJdfQ.NZ6ihvF2gnv-jomFPN6jhyk3ACKI-JcPIZCDq-WRFYnSs7qrv5U8tOklqA1TBWS9zrKAb7FVauaOZCdqoxS7sg5kcaDcWQtEtPb6cNEN5eFnmBAdYemuQAw6t0BtLHOKBt5dyPXYuV-95DBxtlJGU-6unqlprr_O2ASmnO3-KXOhWvnlgL1w-yp8yQfSQeGf30jhFpm3CPCbNsNazRLdEczyrpz6sqsjTg_pLqVGTeLnHihXrYwQSaA1n1ZxkWgHKRcOpOvvqB-nBCALSP7K4eyzLPGndoT6qMWFmeGFT2So6hSqaBGwKrUO0HT-dqXPUmy-P8zN74nSvHA93V111EOSWPXV8IoHT2_CjNaBEFojnvPHj_ygVTS7rDvtcvBlKfB6rHvm4PWr5AEoeZR-I0pjUQ1wh9sM7srXFulFgnprpbH0rcCUleXmyi7ylSlVEZCnue4G0AsgO3ybV3Rt7WjpXdy7Fue1iLP_v_WOyZ8Xszqjp0LrkVpmz8fUpJMG9QsPlFK1af5X6XMgkciFBKMIzCXLItPVF-mrAfBIQRsHxqxeNZwr83UHRWWfNu00HvEpn4Cb9tHEEN1f-WEoivoDHcVg2uS85Qhcsj8rKYt0t_tDalXRWN-OSBH5A3AzCh8qm9yDSMRKdoCUFZESMBzcbPUT3aDU-_H7qYEup7o",
      "Authorization": "Basic dmVtdWxhZDpFbHVydUAxNDM=",
      "Content-type": "application/json"
    },
    "transform2xxOnly": false
  }
}


Public service

{
  "name": "RequestError",
  "message": "Error: tunneling socket could not be established, statusCode=405",
  "cause": {
    "code": "ECONNRESET"
  },
  "error": {
    "code": "ECONNRESET"
  },
  "options": {
    "url": "https://services.odata.org/V3/Northwind/Northwind.svc",
    "resolveWithFullResponse": true,
    "simple": false,
    "proxy": "http://connectivityproxy.internal.cf.eu10.hana.ondemand.com:20003",
    "method": "GET",
    "headers": {
      "Proxy-Authorization": "Bearer eyJhbGciOiJSUzI1NiIsImprdSI6Imh0dHBzOi8vcDIwMDEzMDY4MDB0cmlhbC5hdXRoZW50aWNhdGlvbi5ldTEwLmhhbmEub25kZW1hbmQuY29tL3Rva2VuX2tleXMiLCJraWQiOiJrZXktaWQtMSIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMGRjNmU4OGEyNmY0NDFjODMwYmZhNTRkMjY1MTdjNSIsImV4dF9hdHRyIjp7ImVuaGFuY2VyIjoiWFNVQUEiLCJ6ZG4iOiJwMjAwMTMwNjgwMHRyaWFsIiwic2VydmljZWluc3RhbmNlaWQiOiI1M2I5MDRmOS03NTViLTQzNGQtYTM1Yy1kZjYwMWRkMzg3NzcifSwic3ViIjoic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyIsImF1dGhvcml0aWVzIjpbInVhYS5yZXNvdXJjZSIsImNvbm5lY3Rpdml0eSFiMTcucHJveHkiXSwic2NvcGUiOlsidWFhLnJlc291cmNlIiwiY29ubmVjdGl2aXR5IWIxNy5wcm94eSJdLCJjbGllbnRfaWQiOiJzYi1jbG9uZTUzYjkwNGY5NzU1YjQzNGRhMzVjZGY2MDFkZDM4Nzc3IWIxNDQ0MHxjb25uZWN0aXZpdHkhYjE3IiwiY2lkIjoic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyIsImF6cCI6InNiLWNsb25lNTNiOTA0Zjk3NTViNDM0ZGEzNWNkZjYwMWRkMzg3NzchYjE0NDQwfGNvbm5lY3Rpdml0eSFiMTciLCJncmFudF90eXBlIjoiY2xpZW50X2NyZWRlbnRpYWxzIiwicmV2X3NpZyI6IjQzOGZkMzZlIiwiaWF0IjoxNTU4NjgyMTUwLCJleHAiOjE1NTg3MjUzNTAsImlzcyI6Imh0dHA6Ly9wMjAwMTMwNjgwMHRyaWFsLmxvY2FsaG9zdDo4MDgwL3VhYS9vYXV0aC90b2tlbiIsInppZCI6ImZmMDkyMjhjLTY4YTEtNDg3Ni04MGI5LWIzN2E2MzM2MWZjZSIsImF1ZCI6WyJ1YWEiLCJjb25uZWN0aXZpdHkhYjE3Iiwic2ItY2xvbmU1M2I5MDRmOTc1NWI0MzRkYTM1Y2RmNjAxZGQzODc3NyFiMTQ0NDB8Y29ubmVjdGl2aXR5IWIxNyJdfQ.Q9Gt166PkcMlWpaRmHSTSn-pHmLbJ2k9jtUGOGYOAywUIJtpBaSZv_yQjaAZGYQpeKonKfxzN7WKo_H9oBlYsIuW4lqbb0MsbicHhOUgWmZz8248RlembTuqsv8nQditescenda7qiU-foM7lVTUWpZlaScFLO0jSAZmB2pYXfUtDXklgHlCv2KZrdlc889Ne2P-9HBQxYLdfln-4fKc62sx6UF2bpZZxL4ICMVOfMhC8jmmiydxVamuqMQNZzKYHH1A9dmajqUqoWB24hMNhxcL4qvakYNLROnBkXkuzt6zmhRkW00rKPHxpQ1KQI4Vfxr7NCxAsHZpoOfIR4x5NhRWu6XEBeXTFF99F9NX40sO0xYZuv5v9rY-9o7373A8--mhnWESpaAeCp2yvRPXwEG8vZBWDOyXtHhQGA_rniAqU9DjPoKP0enFXTi2UbSIRBQljiqGKUWc2TXoLPfBASK_TeGKYkBv_pBbiunvvz-21l9asikELxeK0Wp3IqNpCLJIt4aS4bX-8YijRZEWsEBZal1bwBp2BO-s9MIL9LsEftU2TTpXZ33SnmZSOpCw4XDOPZIWqKam-h2E67gVBGiG8GSu8HiCy8KSwnl-yQE2ewMGxi7rhhjsmZHqoqzAI9KalZQ5uX14QQkfIhLV5Vyy_gXqU84I7otXnqniJKw",
      "Content-type": "application/json"
    },
    "transform2xxOnly": false
  }
}

[joachimvanpraet]

You can try to use sap-cf-axios.

https://blogs.sap.com/2019/11/13/consuming-destinations-in-cloud-foundry-using-axios-in-a-nodejs-app...

[Subit]

@pugazhkrishna

Could you please share the solution if you are able to solve the issue?

[gregorw]

As the project you're using from GitHub isn't a SAP one I would suggest you try it first the standard way by following this Tutorial Group: Create an App Using SAP Cloud SDK for JavaScript. Also I would suggest this tutorial: Create a Business Service with Node.js using Visual Studio Code