Netsuite2.com TBA failure
Hi Everyone,
Would anybody be able to provide some assistance?
Hi,
Firstly, you don’t need to use TBA but it is required is you want to use the “Data Warehouse Integrator” role.
You shouldn’t be using the Token Password, instead you should be generating a signature:
https://netsuite.custhelp.com/app/answers/detail/a_id/101883
See also:
https://netsuite.custhelp.com/app/answers/detail/a_id/101877
Thanks,
Chris
Yea you need a script like this to generate the signature on the fly because it uses the current timestamp. You can’t really do this if you’re just using the ODBC driver on your laptop because you have to generate it each time you want to login. But if you have some Python script running, then you can generate the signature and pass it to the ODBC driver as the password parameter. Here is the actual script that I use in Postman:
See:
let account = ‘12345678_SB2’; let consumerKey = ‘xxxxx’; let consumerSecret = ‘xxxx’; let tokenId = ‘xxxx’; let tokenSecret = ‘xxxx’;
let timestamp = new Date().getTime().toString().substring(0, 10); let nonce = CryptoJS.lib.WordArray.random(10).toString(); let baseString = account + ‘&’ + consumerKey + ‘&’ + tokenId + ‘&’ + nonce + ‘&’ + timestamp; let key = consumerSecret + ‘&’ + tokenSecret; let signature = CryptoJS.HmacSHA256(baseString, key).toString(CryptoJS.enc.Base64);
pm.environment.set(“account”, account); pm.environment.set(“consumerKey”, consumerKey); pm.environment.set(“tokenId”, tokenId); pm.environment.set(“nonce”, nonce); pm.environment.set(“timestamp”, timestamp); pm.environment.set(“signature”, signature);
Does anyone know how to fix this?
I also want to use ODBC with Netsuite2.com as a source but am not able to generate a signature for the TBA.
Many thanks,
Hi,
To be clear, there’s nothing to fix here. If you want to use Netsuite2.com with the “Data Warehouse Integrator” role or any other role that requires TBA, they you need a solution that can generate the signature in line with what has been described in other replies.
Alternatively, create a custom role that does not require TBA.
Thanks,
Chris