[amazon-pa-api50] Using in Google App Script

191 views
Skip to first unread message

Play Game

unread,
Jul 31, 2022, 5:33:53 AM7/31/22
to Google Apps Script Community
Hello,

I'm trying to use the AmazonPaapi5 API in Google App Script.
But in GAS we are unable to maintain the crypto-js in GAS.

is there any documentation or example of running AmazonPaAPI in Google Sheet 
script?


N A

unread,
Jul 31, 2022, 7:55:30 AM7/31/22
to Google Apps Script Community
For crypto-js, will the Apps Script Utilities ( https://developers.google.com/apps-script/reference/utilities/utilities ) help? 

Clark Lind

unread,
Jul 31, 2022, 9:15:06 AM7/31/22
to Google Apps Script Community
The best way to do something like this is to develop it outside of GAS, say using node. Get all your dependencies, etc, and get it working. Then compile everything into a single html page that you can then upload to GAS and use as a webapp.
Even better, if you don't need Google to host this, then simply interact with Sheets using the Sheets API from your app using Node. You only need to get a Client secret which serves as your Auth.
I've never used this, but that is where I would start. 
You want to be using Sheets Advanced services.

Play Game

unread,
Jul 31, 2022, 10:35:59 AM7/31/22
to Google Apps Script Community
Thanks for the replies...

Tried using the Utilities.computeHmacSha256Signature(data, key) 
These types of changes are done, still, authorization keys are breaking.

if we continue this type of API testing, will be blocked in API. 
Reply all
Reply to author
Forward
0 new messages