REST API and Google Sheets |
10/20/2022 10:21:24 AM |
PHPRunner General questions | |
R
rmac author
I'm using 10.8/ 39925 and having an issue trying to do a simple HTTP GET request to a Google spreadsheet. All I can get in the response is a 302 redirect error. Hitting the the same link with a browser returns JSON data as expected. Here's what I've done:
<HTML> <HEAD> <TITLE>Moved Temporarily</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF" TEXT="#000000"> <H1>Moved Temporarily</H1> The document has moved <A HREF="https://www.google.com/a/mrits.com/ServiceLogin?passive=1209600&continue=https%3A ... I've tried a few times with different spreadsheets and always get the same results. I've tried the demo samples (soccer, HK Covid, etc) and they all work as expected. I suspect that the redirect has something to do with authentication, but that's just a guess. Have I missed a step somewhere? I really want to get this working. We have several clients that use spreadsheets for job tracking and having API read/ write access to them from our database would be VERY helpful. (even though I'd need to upgrade to Enterprise to do that) TIA Ray |
|
![]() |
admin 10/20/2022 | |
|
R
|
rmac author 10/21/2022 | |
|