RobertSmith8

Results 12 comments of RobertSmith8

My ugly workaround is to use a helper column like = A1*1 ``` rawData.getCell(min+j, 4).formula = '=F' + String(min+j+1)+'*1' rawData.getCell(min+j, 5).value = moment().format('YYYY-MM-DD HH:mm') ``` => Correct date without the...

same problem, this code stores date as a string `rawData.getCell(min+j, 4).value = moment().format('YYYY-MM-DD HH:mm')` How can I store is as a Date object? _it was working in the older version...

> I think you would need to update the formatting rules for those cells. > https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells#NumberFormat > > You could either do it beforehand in the UI on the whole...

Hi I have a similarly problem the "driver" has fps = 30 but the preview and DL video has only fps = 20. My 35 sec video results in an...

I have a similar problem I know there is 50 rows per page but... My workaround was to use QUERY `=QUERY(IMPORTJSONAPI("url/?date=2021-04-21&"&page=1", "$..*[*]","date, user.id, start_time, end_time, created_by_id, created_at","headers={ 'Authorization' : 'Bearer...

Current urlFetchWhitelist ``` "urlFetchWhitelist": [ "https://api.binance.com/", "https://api1.binance.com/", "https://api2.binance.com/", "https://api3.binance.com/", "https://fapi.binance.com/", "https://dapi.binance.com/" ] ```

I might have found a work around to get some prices but obvious not balance, open orders etc. since I don't have a US account. replace: const SPOT_API_URL = "https://api.binance.com";...

> So I played a round a bit. It seamed strange that https://api.binance.com/api/v1/ticker/allPrices was working in chrome, but I was getting the stupid 451 (I am not in US) when...

> > I might have found a work around to get some prices but obvious not balance, open orders etc. since I don't have a US account. > > replace:...

Update: **https://data.binance.com** can be used for getting market data. @diegomanuel https://binance-docs.github.io/apidocs/spot/en/#change-log