Reading remotely the API response from spreadsheet's script code

26 views

Skip to first unread message

Ebolisa

unread,

May 15, 2018, 5:46:06 AM5/15/18

to AdWords API and Google Ads API Forum

Hi,

I’m having a microprocessor sending data to a worksheet and the code is working fine. The data sent is logged in each cell correctly.

If I launch via browser the link “ https://script.google.com/macros/s/<my_code>/exec?temperature=10&humidity=20 ”, my spreadsheet’s script code answers with the word “Ok”. Inspecting the results, I see the following, which is all correct:

<html>
<head>
<link rel="alternate stylesheet" type="text/css" href="resource://content-accessible/plaintext.css" title="Wrap Long Lines">
<style></style>
</head>
<body>
<pre>Ok</pre>
</body>
</html>

However, when I read the web response via the microcontroller (String line = client.readStringUntil('\r');), I get different results:

<HTML>
<HEAD> 
<TITLE>Moved Temporarily</TITLE> 
</HEAD> 
<BODY BGCOLOR="#FFFFFF" TEXT="#000000"> 
<H1>Moved Temporarily</H1> 
The document has moved <A HREF="https://script.googleusercontent.com/macros/echo?user_content_key=bla bla bla">here</A>. 
</BODY> 
</HTML>

Can someone please tell me why I cannot read the response remotely? I’m new to this and I’m a bit lost.

TIA

Dhanya Sundararaju (AdWords API Team)

unread,

May 15, 2018, 2:25:49 PM5/15/18

to AdWords API and Google Ads API Forum

Hi,

Is your question related to AdWords Scripts or AdWords API? If AdWords scripts, could you please post in the AdWords Scripts Forum so that the experts there can assist you? If AdWords API, could you please reply back with client customer id and complete SOAP logs so that we can troubleshoot further?

Regards,
Dhanya, AdWords API Team

Reply all

Reply to author

Forward

0 new messages