是否有任何方法在谷歌应用程序脚本中获取cors受保护的API



我正在尝试获取API这在Google脚本中是受保护的但是当我尝试时它不会获取任何东西它只是加载加载和超时

这是我的代码

function myFunction() { 
var opt ={
"method":"GET",
"user-agent": "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1",
"accept-language": "en-US,en;q=0.9",    
"followRedirects": false,
'muteHttpExceptions': true,
'accept-encoding': 'gzip, deflate, br',
'cookie': '_gid=GA1.2.188967080.1668968635; nseQuoteSymbols=[{"symbol":"NIFTY","identifier":"FUTIDXNIFTY24-11-2022XX0.00","type":"equity"}]; _ga=GA1.1.753386304.1667588874; AKA_A2=A; nsit=rU4hZ33yI2F82dXwkJ-o8Y2-; nseappid=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJhcGkubnNlIiwiYXVkIjoiYXBpLm5zZSIsImlhdCI6MTY2OTA0MzUxOCwiZXhwIjoxNjY5MDQ3MTE4fQ.plLtltT9TyR8IGoUyjeXeOo2l6srioCF_8DC0uG-P7s; bm_mi=2AFC42F7F039C7FF8176F96984ED6B74~YAAQN0YDFxplTICEAQAAcPy+mhF30iMx0dHIGMjV5v9+cAoyqsT3nihC92fAyAlJiTENTDZ2ZkFMjveBygSXTlpFnOcmapEiYFXk3ddQQYBY+Kz1cmtwKVF7pOYWwv6I/Lr0SOKqzKU3IeSVoRiTjIYFdsC8rKR8SA22xmxskC729+X6fSM7L/9yKlld/Ie1fAgG+gCWoBcK/UazfvY7FIhlzWqpd2zL4IU8tDkbZ/djNZwDi2A2xFcq4aLVbviTqfzgDnTYxhrdjAgHVWuQ1Vj8GsAwAM8ZzGawtTsXEXe35l8mCK9gt3r2K7x6MDz3~1; ak_bmsc=695E6827BCD153E89F719653ECF32A78~000000000000000000000000000000~YAAQN0YDF35lTICEAQAAagi/mhGZVNGhWCiPANwXFrka9eehlq4zYzwHDcAPZECJD7hSCoBaZB5Qty4J4Xyqk3C7DnjBxgyYUhY7fv7YqK7O615QNjhXp3eJARMMXGll4hklD1OFDay5ut8KRF5Yq5TCVw4D9pPJhwilbkTs4gr4wpP+ZyCTyxgLBxbWM+6wJgyd/A+4EFBe83PkpbaOHYa8z4hK7qKU+qgnn3X+5/G0yRFele9awkxV/j6pxxXcU+hHZ31awxbOEWRZZTDT9NjGaWEIY5NAFedl3BPMAi5Cte701km0SxQvCBj+M/e3BVcZZdUVFYrB5ck1mJhV40o62bAsSyoky2mYZ2eaVycPJuUudse5L/IjAzbk+vKWb7byqLEsglnpR/fjjCE7PrIh1vccBOcr; bm_sv=46C61EC672300FE4B4927990D1101964~YAAQN0YDF39lTICEAQAAagi/mhGrWF57UKd/fk8manXdN8aSkgBv4w6XLLdhfBt/BE8izuUIi3X3OljmLRFgGPQl0T9GascZQs0oukzywj8dk3oa4++oxpYRbNdz0y3ekALF5B3tdEBSPYoM/k/4hSuCcCgkabwble4JbnZ+VmwQsivbPAUK2U07Od0QWxAfQJwq+NG+dk+uJ/toYC+vgEzv9Z5Yj18hM0BoUmTCwORDj/viQ0iQ3GHvz7oY7Q/JuEM=~1; RT="z=1&dm=nseindia.com&si=7c73c83e-79f8-4d82-a7b9-3177b775117c&ss=laqxf0w8&sl=1&tt=1or&bcn=%2F%2F684d0d45.akstat.io%2F&hd=2jh"; _ga_PJSKY6CFJH=GS1.1.1669043520.9.0.1669043521.59.0.0',
'authority': 'www.nseindia.com',
'path': '/api/liveEquity-derivatives?index=nse50_fut',
'scheme':'https',
'dnt': '1',
'referer': 'https://www.nseindia.com/api/liveEquity-derivatives?index=nse50_futn',
'sec-ch-ua-mobile': '?0',
'sec-fetch-dest': 'empty',
'sec-fetch-mode': 'cors',
'sec-fetch-site': 'same-origin'
};

var url = "https://www.nseindia.com/api/liveEquity-derivatives?index=nse50_fut";
var response = UrlFetchApp.fetch(
url, opt);


var json = response.getContentText();
console.info(json);
}
如果我错了,请让我知道。我想把这个API获取到我的Google表单

由于用户代理无法修改,因此无法从该URL获取数据。

你需要一个不同的方法,这种情况下,谷歌应用程序脚本将无法从该URL返回响应。

Tedinoz提到的回应在这方面是明确的,并指出未来对google脚本的改进https://issuetracker.google.com/issues/36758197

最新更新