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 |
Hard to tell what might be wrong, we never worked with this specific API. I guess someone needs to go through their documentation and see what kind of authentication is required. According to what I see they support API keys and OAuth. I guess HTTP Basic autorization won't work here. I works in the borwser because you are logged in to Google which is a totally different story. Anyway, if you need help with this, you can contact support directly and we will help you configure it. |
R
|
rmac author 10/21/2022 |
Thanks for the input. I thought this would be the easiest solution, but if it's an outlier in this case I'll move on to using one of the other methods and file a support request if I have issues with that. |