StockAppScript
IMPORTJSONAPI
StockAppScript | IMPORTJSONAPI | |
---|---|---|
1 | 28 | |
4 | 235 | |
- | - | |
0.0 | 0.0 | |
7 months ago | almost 3 years ago | |
JavaScript | JavaScript | |
GNU General Public License v3.0 only | MIT License |
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.
StockAppScript
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.
What are some alternatives?
cachefinance - A custom function and trigger to supplement GOOGLEFINANCE so data is always available and unsupported stocks can get price/name/yield data. As you can guess from the name, data is cached so when '#N/A' appears it does not mess up your asset history logging/graphing.
ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
OpenBBTerminal - Investment Research for Everyone, Everywhere.
meraki-to-google-sheets - Imports Meraki devices into Google Sheet
quotable - Random Quotes API
unsubscribe-gmail - Gmail Unsubscriber is a Google Apps Script for unsubscribing from unwanted newsletters and other bulk emails.
metabase-google-sheets-add-on - Import a Metabase question directly to a Google Sheet.
ZLOOKUP - Google Sheet Fuzzy String Matching Function
deckbrew - Magic: The Gathering API
google-sheets - Custom =SCRYFALL() function for Google Sheets
libre_crm - Open source customer relationship management based on LibreOffice