Skip to main content

All Questions Answered

Search This Blog

Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Remote Job
Home

Trying to import json into Google Sheets

on June 07, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

I'm trying to import this json link into Google Sheets

https://stats.nba.com/stats/leaguedashteamstats?Conference=&DateFrom=&DateTo=&Division=&GameScope=&GameSegment=&LastNGames=0&LeagueID=00&Location=&MeasureType=Advanced&Month=0&OpponentTeamID=0&Outcome=&PORound=0&PaceAdjust=N&PerMode=PerGame&Period=1&PlayerExperience=&PlayerPosition=&PlusMinus=N&Rank=N&Season=2018-19&SeasonSegment=&SeasonType=Regular+Season&ShotClockRange=&StarterBench=&TeamID=0&TwoWay=0&VsConference=&VsDivision=

Using the below formula

=importJSON("https://stats.nba.com/stats/leaguedashteamstats?Conference=&DateFrom=&DateTo=&Division=&GameScope=&GameSegment=&LastNGames=0&LeagueID=00&Location=&MeasureType=Advanced&Month=0&OpponentTeamID=0&Outcome=&PORound=0&PaceAdjust=N&PerMode=PerGame&Period=1&PlayerExperience=&PlayerPosition=&PlusMinus=N&Rank=N&Season=2018-19&SeasonSegment=&SeasonType=Regular+Season&ShotClockRange=&StarterBench=&TeamID=0&TwoWay=0&VsConference=&VsDivision=.json","/resultSets/headers,/resultSets/rowSet","noTruncate,noInherit")

with no luck as I'm getting this back "Internal error executing the custom function."

Is this possible to import into rows? Thanks

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Work from Home

Remote Job

Popular Posts

Vue component html

Prompt please, at compilation there is an error: Component template should contain exactly one root element. If you are using v-if on multiple elements, use v-else-if to chain them instead. The error occurs in the 17th line in jsfiddle that i provide in below. <div class="ui_tabs" {{ sort === 'hot' ? 'Hot' : 'New' }}> Here is a jsfiddle: Jsfiddle Where is the problem here? Thanks in advance.

Fit horizontal scrollbar within a div

I have a little bit nested structure of divs, which, unfortunately, cannot be changed. I want content to be scrollable, but when I add horizontal scrollbar, it appears below the div. Is there any way of fitting it inside container without setting all containers width to 100%? DEMO

How to resolve ''vue' should be listed in the project's dependencies' in Nuxt.js

I am getting this error 'vue' should be listed in the project's dependencies. Run 'npm i -S vue' to add it... The Happens when I import Vue in my plugin: import Vue from 'vue'; Vue.prototype.$bannerHeight = 200 For now I can fix the error by mentioning /* eslint-disable import/no-extraneous-dependencies */ on top of the file but doing the same for all plugins that's kinda sucks. Also, in my .eslintrc.js I tried add it in rules, for some reason it doesn't work (tried switching to true/false) and more over it's not good to turn the error OFF : ... extends: [ 'plugin:vue/recommended', 'airbnb-base', ], plugins: ['vue'], rules: { 'import/no-extraneous-dependencies': ["error", {"devDependencies": true}], ... }, ... Of course the error stated appearing when I started using airbnb-base . And, In nuxt.js project you don't have to define dependency of vue in package.json,

Powered by Blogger