Тёмный

Google Sheets JSON API, Read & Write Data, Wep App - e.j1 p.2 

Get __it Done!
Подписаться 11 тыс.
Просмотров 18 тыс.
50% 1

In this tutorial we'll read spreadsheet data & return as JSON, and then write data to our spreadsheet by making API calls from our web page.
Full Series Playlist • Google Sheets Self-Mad...
#GoogleSheets #JSON #API #read #write #tutorial

Опубликовано:

 

21 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 31   
@sudoalex
@sudoalex 4 года назад
This is the best channel I've ever subscribed to
@BarakAlmog
@BarakAlmog 3 года назад
Following your train of thoughts is a fascinating process
@larryacademy
@larryacademy 3 года назад
Big up. I can now close the 20 tabs I had opened. Thank you very much
@daytodatainc
@daytodatainc 3 года назад
Outstanding video! Really helped me with a major Integromat issue. Now I can simply call the Web App which will capture all the data I need.
@karanshete6534
@karanshete6534 4 года назад
Thanku so much.. Please give more tutorials
@dmitriyrudakov4555
@dmitriyrudakov4555 3 года назад
Can you explain how you configuered your Terminal with bash? I have the Powershell instead the bash... Is it settings for your Mac, but how to make wor Win? Thank you very much for your videos!)
@rtspigeons9951
@rtspigeons9951 2 года назад
Hi... it is possible to add query in this script? for example we want to find Name=Jhon... the query is in the URL and the result only show the Name=Jhon... Thank You...
@SteveShepherd100Rails
@SteveShepherd100Rails 3 года назад
Do you have a copy of this code anywhere we can just copy and then edit
@michaelryder9885
@michaelryder9885 3 года назад
Question: What is the Chrome extension or settings you are using to display the JSON object on the page? I like your layout and navigation, but I am only getting the raw data.
@getitdonetube
@getitdonetube 3 года назад
I use Firefox with no extensions. If you search Chrome JSON format extension, I'm sure something will show up.
@googlesheetsph
@googlesheetsph 3 года назад
is it possible to do just.. function compareArrays(array1,array2) { if(array1.join() === array2.join()) { return true } }
@phecdu
@phecdu 3 года назад
yes! you are best
@Toleh
@Toleh 3 года назад
I got error "postData" not define. Not sure why, since postData is coming from the request.
@tazulislam2698
@tazulislam2698 2 года назад
Posible to post 2d array of data using this api?
@getitdonetube
@getitdonetube 2 года назад
sure. you can send an array.
@tazulislam2698
@tazulislam2698 2 года назад
@@getitdonetube could you please help me giving source code?
@bang-naim
@bang-naim 2 года назад
My mind is blown.. 😀👍 awesome video as always!
@dmtryfrom4e
@dmtryfrom4e 3 года назад
I did everything like author but I get mistake: index.html:1 Access to fetch at 'script.google.com/macros/s/AKfycbzZe824lIxa-hNsO71xoFfq5qXbFaDKhHZeACrQgLMCjU_EjvY/exec' from origin '127.0.0.1:5500' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.
@getitdonetube
@getitdonetube 3 года назад
Note sure why you have the array around the whole thing but the request seems to work fine for me fetch("script.google.com/macros/s/AKfycbzZe824lIxa-hNsO71xoFfq5qXbFaDKhHZeACrQgLMCjU_EjvY/exec").then(d => d.json()).then(d => console.log(d[0].data))
@dmtryfrom4e
@dmtryfrom4e 3 года назад
@@getitdonetube Yes, the object is the one thing different I did. But this from another blog ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1toLqGwMRVc.html isn't this method suitable for it?
@dmtryfrom4e
@dmtryfrom4e 3 года назад
@@getitdonetube May be it because of I save this project locally and it's a result of browser privacy?
@dmtryfrom4e
@dmtryfrom4e 3 года назад
@@getitdonetubeCan I give you the link of my project for help? Do you have the time for look?))
@getitdonetube
@getitdonetube 3 года назад
Upload on github like I did in the video and see if it works. If it does then you'll know it has something to do with local environment. Generally, I find errors are a result of request itself not being accurate. Try to copy paste the code I did in the comment and see if you still get errors.
@yousefyousef7996
@yousefyousef7996 Год назад
Thank you alot but i got an error like as the shown on the following screenshot drive.google.com/file/d/1GbRbhGU2dDZxtArSJ4cx8rE4z3MMaqJz/view?usp=share_link Could you Help?
@getitdonetube
@getitdonetube Год назад
Make sure under settings you are using V8 engine.
Далее
Google Sheets - JSON API, Wep App - e.j1 p.1
23:04
Просмотров 36 тыс.
Angry bird PIZZA?
00:20
Просмотров 7 млн
Google Sheets - Python API, Read & Write Data
28:01
Просмотров 191 тыс.
How is this Website so fast!?
13:39
Просмотров 479 тыс.
Web App w/ Google Charts, Google Sheets & Apps Script
33:25
Google Sheets API - JavaScript NodeJS Tutorial
45:29
Просмотров 115 тыс.
Angry bird PIZZA?
00:20
Просмотров 7 млн