http api question

[mlsignups]

I have various lists in googlesheets of tickers i'm watching which contains a large amount of additional data for each symbol and would love to be able to click in googlesheets to change the symbol in MedVed.

If I type the URL line - for instance this: http://127.0.0.1:16239/req?SetLinkedSymbol(MSFT,TAN)  into my browser it changes the symbol so I know the MedVed settings are right.   But it sends and OK message back in a new browser tab (on top of my current tab) which means it's not usable for me to scroll down a list from within googlesheets.

So I did some research and was told that I could create a script in googlesheets that should do it.  The script that was suggested was this:

function sendHttpRequest()  {

var url = "http://127.0.0.1:16239/req?SetLinkedSymbol(MSFT,TAN)";

var options = { 'method': 'get' };

UrlFetchApp.fetch(url, options);

}

But I am getting an error message on the URLFetchApp line.   Info about this is here: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app

I realize this is not a medved issue but wondering if you can supply any suggestions.

 

[Mike Medved]

What error are you getting?

[mlsignups]

Error

Exception: Bad request: http://127.0.0.1:16239/req?SetLinkedSymbol(MSFT,TAN)

talktomed2

@ talktomed.gs:7

 

Line 7 is this line: UrlFetchApp.fetch(url, options);

[mlsignups]

i also tried using "Put" and "Post" instead of 'get" thinking maybe that was the issue (I'm not that technical so I'm just trying different things) but they gave me the same error.

[mlsignups]

Alternatively, @Mike Medved is there any way to tell your system not to send back an "OK"?   In that case I could just make the click a hyperlink from googlesheets.

 

[Mike Medved]

Hm - it is an HTTP request. It has to receive something back... Does it expect JSON back?