IMPORTJSONAPI
ImportJSON
IMPORTJSONAPI | ImportJSON | |
---|---|---|
28 | 52 | |
251 | 1,943 | |
- | - | |
0.0 | 0.0 | |
over 3 years ago | almost 2 years ago | |
JavaScript | HTML | |
MIT License | GNU Lesser General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
IMPORTJSONAPI
-
Hello, I am trying to implement a live tracker from a website on some prices, does anyone know how?
You can access the API with IMPORTJSONAPI or a custom script.
-
Good job lil bro
I used https://github.com/qeet/IMPORTJSONAPI to bring it in to Google Sheets -- but there are a lot of ways to get it.
-
Alternative to Cloud community for function information with different ussage examples ?
IMPORTJSONAPI or just a direct API call with Apps Script would probably be easier.
-
help with importxml. trying to parse prices from websites
IMPORTJSONAPI has graphQL support.
-
importHTML only prints table colum names
Try IMPORTJSONAPI() and this url:
-
show auto update status
Well you can check out https://github.com/qeet/IMPORTJSONAPI as a script solution. Or just grab the data yourself with UrlFetchApp.
-
IMPORTXML "Could Not Fetch URL" Error
You can use tcgplayers api (https://docs.tcgplayer.com/docs/getting-started) and IMPORTJSONAPI (https://github.com/qeet/IMPORTJSONAPI)
-
Scraping data using JSON files
Use https://github.com/qeet/importjsonapi. However, that url seems to require a url key or some form of authentication so you'll have to pass those parameters.
-
IMPORTXML problem
I usually use this script for interacting with APIs: https://github.com/qeet/IMPORTJSONAPI/
-
Scraping Data from a Grafana website
I also tried using the IMPORTJSONAPI from https://github.com/qeet/importjsonapi but I am not sure if I can find the correct path and parameters.
ImportJSON
- I'm just starting to learn coding and wanted to do a small profit spreadsheet with some API stuff as a project. Can someone link a spreadsheet or guide on how to actually use the TFT API?
-
Reducing load with IMPORTXML
The following scripts leverage the UrlFetchApp library and are less likely to cross rate limits at the scale you're operating at. I'd start with importRegex but if that doesn't work try the much more powerful ImportJSON
- March Madness 2023 in Google Sheets!
-
Software til afstemning af budget?
I use ImportJSON to put it the sheet: https://github.com/bradjasper/ImportJSON
- Help importing NBA data from the online api URL/file .json
-
Get URL traffic from Google Search Console to Google Sheets
You may also be able to use something as simple as the import json custom function https://github.com/bradjasper/ImportJSON
-
LongRun Solution to use with IMPORTJSON script
Here's a link to the GitHub repo: https://github.com/bradjasper/ImportJSON/blob/master/ImportJSON.gs
-
Apps Script "Minutes" Trigger refreshes at 00:32 seconds not 00:00
Thanks for the tip, I'll try running just one script and see if that fixes it. As far as precision, I'm using a free script created by Brad Jasper and it works great. https://github.com/bradjasper/ImportJSON/blob/master/ImportJSON.gs
-
Best way to use JSONImport
are you talking about Brad jasper's custom function?
-
Impossible to fetch character list from third party website
I've been using the public api https://www.pathofexile.com/character-window/get-characters?&accountName=vindoq to get my characters on a google spread sheet and it doesn't work anymore since a little more than one month (using a third party script : https://github.com/bradjasper/ImportJSON). I've been trying to get around it using my own github project (https://github.com/antilogos/SimpleFiltre/blob/master/DataTranslate/characters.html) to try getting the content of the public api with an additional step, using github.io, but the fetch is receiving a null body in the response (https://antilogos.github.io/SimpleFiltre/DataTranslate/characters.html).
What are some alternatives?
OpenBB - Investment Research for Everyone, Everywhere.
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
meraki-to-google-sheets - Imports Meraki devices into Google Sheet
nba_api - An API Client package to access the APIs for NBA.com
quotable - Random Quotes API
dataconnector - Connect to any API, website or database in Google Sheets.
libre_crm - Open source customer relationship management based on LibreOffice
Hoppscotch - Open source API development ecosystem.
unsubscribe-gmail - Gmail Unsubscriber is a Google Apps Script for unsubscribing from unwanted newsletters and other bulk emails.
tft-data-prices
metabase-google-sheets-add-on - Import a Metabase question directly to a Google Sheet.
SpreadsheetView - Full configurable spreadsheet view user interfaces for iOS applications. With this framework, you can easily create complex layouts like schedule, gantt chart or timetable as if you are using Excel.