
Things might have been posted or bought from the AH since the last time the scan was run. In addition to this the TSM API may not be completely up to date. It weights the current minimum price at 1/3 and the current DBmarket at 2/3. This gives my profitability calculations better accuracy over longer horizons, but worse right now. I use a weighted average of minbuyout and dbmarket. Why is the price different to the current AH price? Make sure you go through all of your old versions and delete they API key from them and remove the API key from the B1 cell whenever you’re not using the spreadsheet and you should be good. This will also happen in any older versions of my spreadsheet you have copied, even if they are in the thrash folder. Postman simplifies each step of the API lifecycle and streamlines collaboration so you can create better APIsfaster. The google Sheets import function automatically calls the TSM API atleast 3 times every hour regardless of if your sheet is open or not. Postman is an API platform for building and using APIs. Realm names with two words are written using a dash between the words like this: shattered-hand In addition you should ignore any special characters e.g. This is usually only a problem in the google sheets version and it has several causes:įor #1 just double check that you have pasted correctly.įor #2 you solve it by checking the realm name. If you want to run the spreadsheet in excel make sure you download the Excel Version. The Google sheets version of the spreadsheet only works when used through google sheets. Downloading the Google sheets version to excel Truncated server response: rel="shortcut icon" sizes="16x16" href=".This is a list of the most common issues and questions that you can encounter using my spreadsheet. So i try to make an script on to automate data entry from google spreadsheet to google forms but i always receiving this code error "Request failed for returned code 400.
