Kungani i-Apps Script ingakwazi ukufinyelela uhlelo lwakho lwangaphakathi nge-VPN

Idashboard ivuleka kahle kusiphequluli kukhompyutha ephathekayo, kodwa iskripthi esifanayo sespreadsheet sihluleka ngephutha lekheli elingatholakali. Ukuvula noma ukuvala i-VPN akushintshi lutho, ngoba isicelo asiphumi nakancane kukhompyutha ephathekayo. I-Apps Script isebenza engqalasizinda ye-Google futhi ivula uxhumano lwayo khona. Lelo qiniso elilodwa linquma wonke umklamo.

Hlukanisa imibuzo emibili ngaphambi kokushintsha noma yini: yimuphi umshini othumela isicelo, futhi yibuphi ubufakazi obamukelwa ngumamukeli.

Isicelo asiqali nakancane kukhompyutha yakho ephathekayo

Ithebhu yesiphequluli ithumela kusukela kukhompyutha ephathekayo, nge-adaptha ye-VPN, isijobelelo se-DNS sangaphakathi futhi ingene kusubneti eyimfihlo. I-UrlFetchApp ithumela kusukela kumpheki elawulwa yi-Google, ngakho ibona izixazululi ze-Google, amakheli okuphuma e-Google futhi ayiboni neyodwa yezindlela zakho ze-split-tunnel. Lezi zindlela ezimbili zabelana ngombhalo wespreadsheet, hhayi ngendawo yenethiwekhi. Kulogi yokufinyelela yohlelo, umzamo weskripthi ubonakala njengekheli le-Google hhayi ikheli elivela echibini le-VPN, futhi lokho kuyisiqinisekiso esisheshayo ozosithola.

Yingakho izilungiso zasendaweni zingenzi lutho. Ukukhomba ikhompyutha ephathekayo kwesinye isixazululi, ukuqalisa kabusha iklayenti le-VPN noma ukwengeza ingeno ku-hosts kushintsha indlela yesiphequluli futhi kushiye indlela yeskripthi injengoba yayinjalo.

Lokho kususa ini

Iphuzu lokugcina elingaphakathi kuphela alifinyeleleki kusuka ku-Apps Script, futhi uhlu lwamakheli e-IP avunyelwe luyisikhali esibuthakathaka sokulawula ukufinyelela kule ndawo. Izikhathi zokuphuma ze-Google zibanzi, zabelwa namanye amakhasimende futhi akunakwenzeka ukuzixhuma kuskripthi esisodwa. Incwadi ye-UrlFetchApp ithi izicelo zivela echibini le-IP le-Google, okuyinguqulo enegunya yalokho kusho. Ukuvula uhlelo lwangaphakathi kulezo zikhathi kungenisa ithrafikhi ongakwazi ukuyabela.

Amaseshini esiphequluli enza okufanayo. Ikhuphukhula noma iseshini ye-SSO kusiphequluli sekhompyutha ephathekayo akuhambi ngesicelo, okuyiklayenti elisha le-HTTPS elingenasimo seshini. Noma yini encike ekudlulisweni kabusha kwe-SSO yesiphequluli igcina kulelo dluliso hhayi kudatha yakho.

Izinhlobo ezimbili ezingenza

Uhlobo lokuqala lunikeza iskripthi i-API evunyiwe. Shicilela insebenzo yangaphakathi ngemuva kwesango eliqinisekisa umshayi, bese uvumela iskripthi ukuthi sethule ubufakazi obamukelwa isango, njenge-tokheni ye-akhawunti yensizakalo. Ku-Apps Script lokho kusho ilabhulali ye-OAuth2 noma i-ScriptApp.getOAuthToken(), kanye nohlu lwemibhalo yobuwena yabashayi evunyelwe ohlangothini lwe-API esikhundleni sohlu lwe-IP.

Uhlobo lwesibili luhlanekezela isiqondiso. Umsebenzi wangaphakathi ubuza uhlelo oluyimfihlo futhi ushicilela umphumela olawulwayo ku-Sheet, entweni ye-Cloud Storage noma kuthebula le-BigQuery elifundwa iskripthi. Umsebenzi we-Cloud Run, isihleli sesikhathi sasendaweni noma isinyathelo se-ETL esivele sikhona konke kungaba lowo msebenzi, futhi akukho kulokho okudinga ukwamukela uxhumano olungena. Isipredishithi bese sisebenzisa isethi yedatha esikhundleni se-interface.

Uluphi uhlobo oluzonqoba kuncike ekutsha, ekulawuleni kwezinga lensimu nasekutheni ubani okufanele akwazi ukuhlola umfundi.

Umphumela oshicilelwe kufanele uqukathe ini

Ukugeleza kwesiqondiso esihlanekezelwe kudinga isivumelwano esicacile: izinkambu ezizithwalayo, isikhawu sokuvuselela, iqembu labafundi nokuthi kwenzekani lapho umsebenzi wangaphakathi uhluleka. Ngaphandle kwalezo ezine, isipredishithi sikhombisa izinombolo zayizolo buthule. Engeza ikholomu yesikhathi esidalwe kanye nenani lemigqa ukuze ukushicilelwa okudlulele noma okungaphelele kubonakale kuyo ngqo ishidi, ngaphandle kokuthi othile avule ilogi.

Isiqondiso se-API naso sidinga isivumelwano: yibuphi ubufakazi obamukelwa isango, yimiphi imikhakha (scopes) ethwalwa itokheni futhi yibaphi ubuwena babashayi abavunyelwe. Impendulo engu-200 equkethe ikhasi lokungena ayisona isicelo esiphumelelayo, ngakho hlola umzimba hhayi ikhodi yesimo kuphela.

Funda iphutha ngohlangothi olufanele

I-Apps Script ibika umpheki ongafinyeleleki njengokuhlukile kwekheli elingatholakali, okungeyona imiyalezo yesiphequluli yoxhumano olunqatshiwe. I-403 evela esangweni isho ukuthi isicelo safika futhi ubufakazi noma inqubomgomo yenqatshiwe. Ikhasi lokungena le-HTML lisho ukuthi isicelo safinyelela isendlalelo sokuxhumana iskripthi esingakwazi ukusiqedela. Izingxaki ezintathu ezihlukene nabaphathi abathathu abahlukene.

Gcina ilogi yeskripthi eceleni komphumela wesiphequluli esikhundleni sokufaka enye esikhundleni senye. Umbuzo osele bese uba isinqumo esivamile sokuxhumanisa: nikeza leyo ndawo ukufinyelela okudingayo, noma yilethele umphumela olawulwayo.