อีกหนึ่งความสามารถของ Google app script คือเราสามารถใช้ spreadsheet ของเราเป็นฐานข้อมูลเพื่อสร้าง API ให้เว็บภายนอกมาดึงข้อมูลไปใช้ได้ (ซึ่งเราจะมาดึงข้อมูลไปทำเว็บแอพในบทความต่อไป) ไปดูกันเลยครับ
// Presented by BrilliantPy function doGet() { let ss = SpreadsheetApp.getActive(); let sheet = ss.getSheetByName('ชีต1'); let values = sheet.getDataRange().getDisplayValues(); values.shift(); let result = values.map(([a,b,c,d,e,f,g,h,i]) => { return ({unix:a,date:b,symbol:c,open:d,high:e,low:f,close:g,vol_btc:h,vol_usdt:i}); }) let data = JSON.stringify(result); console.log('data:',data); return ContentService.createTextOutput(data).setMimeType(ContentService.MimeType.JSON); }
I went over this web site and I believe you have a lot of superb information, saved to favorites (:.
Thank you.
Can I just say what a comfort to find somebody who truly understands what theyre talking about on the net. You certainly understand how to bring a problem to light and make it important. A lot more people really need to look at this and understand this side of the story. I cant believe youre not more popular because you definitely possess the gift.
Thank you.
I’m impressed, I have to say. Really rarely do I encounter a blog that’s both educative and entertaining, and let me inform you, you may have hit the nail on the head. Your idea is outstanding; the issue is one thing that not enough people are speaking intelligently about. I am very completely happy that I stumbled throughout this in my search for one thing regarding this.
Thank you.
you have a great blog here! would you like to make some invite posts on my blog?
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
Very nice info and right to the point. I am not sure if this is in fact the best place to ask but do you folks have any ideea where to employ some professional writers? Thanks in advance 🙂
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I really like your writing style, excellent information, thanks for putting up : D.
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I have been exploring for a bit for any high-quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this website. Reading this information So i am happy to convey that I’ve a very good uncanny feeling I discovered exactly what I needed. I most certainly will make certain to do not forget this site and give it a glance regularly.
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I really enjoy reading on this internet site, it contains excellent articles. “We find comfort among those who agree with us–growth among those who don’t.” by Frank A. Clark.
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
Just a smiling visitor here to share the love (:, btw great design.
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I think this is among the most vital information for me. And i’m glad reading your article. But should remark on few general things, The web site style is great, the articles is really excellent : D. Good job, cheers
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I love your blog.. very nice colors & theme. Did you create this website yourself? Plz reply back as I’m looking to create my own blog and would like to know wheere u got this from. thanks
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
Wow, fantastic blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your website is magnificent, as well as the content!
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I do not even know how I ended up here, but I thought this post was good. I don’t know who you are but certainly you are going to a famous blogger if you are not already 😉 Cheers!
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
I’ve read several excellent stuff here. Definitely price bookmarking for revisiting. I surprise how much attempt you place to create this sort of excellent informative website.
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy
This is the appropriate blog for anyone who desires to search out out about this topic. You notice a lot its nearly hard to argue with you (not that I really would need…HaHa). You undoubtedly put a new spin on a subject thats been written about for years. Nice stuff, just great!
Thank you. You can follow us either way.
youtube : https://www.youtube.com/@brilliantpy/videos
Facebook: https://web.facebook.com/BrilliantPy