Hi. I’m really not sure why our REST snap’s OAuth 1 account type is requiring so many things that Postman does not (the Endpoints), and not allowing you to enter some of the values that you do need to specify (the Token and Token Secret). I’m unfamiliar with our REST OAuth1 account type. It seems to be designed for some other OAuth 1 use case for a different SAS.
Let me ask this: Are you trying to call a NetSuite RESTlet or are you trying to call NetSuite’s REST API? They are different. We have a new NetSuite RESTlet snap that can be used for RESTlets, but we don’t yet have direct support in our NetSuite snap pack for calling the NetSuite REST API. It’s planned for a future release.
Quite honestly, I do not know which one my attempt falls under. Essentially, I am trying to send a suiteql query through https://xxxxx.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql with an OAuth 1.0 authentication method. I apologize if this does not answer your questions.
Thanks,
Johnny
The current issue I encounter is, I am able to connect the SQL server outside snaplogic but not with snaplogic.
There were two errors, one while using groundplex(which is preferred) and an other using cloudplex.
Also, there are other SQL servers accounts which I’ve created in the past and still working on with them. So, for this account alone I see ‘Unexpected rethrowing’ error.
I really appreciate your responses. Thank you.
A couple things to try on your Groundplex.
If you don’t specify a JDBC jar, the SQL Server snap pack will use the jdbc driver bundled with the snap pack (a 4.0 driver). So, try that if you haven’t already.
Try adding this property to the Url Properties at the bottom of the account.
trustServerCertificate=true
If neither of the above help, let’s trying pinning the TLS version. Add this property to Url Properties. Try v1 then v1.2. I’m not sure of TLS version enabled for 2016 sql server.
sslProtocol=TLSv1
OR
sslProtocol=TLSv1.2
Let us know results.
Hi Bowen,
many thanks for your response.
I have tried again with 4 different JDBC drivers, and also the default ones(by not specifying anything) and also by adding the URL properties as mentioned above, adding one at a time and both of the properties at a time, in my Dev and Test environments on 4 different groundplexes and yet the error remains the same. ‘Unexpected Rethrowing’ as the driver couldn’t establish a secure connection to SQL server.
so, we are still at square one I suppose.
Thanks.
