mlsignups Posted April 3, 2023 Report Share Posted April 3, 2023 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. Quote Link to comment Share on other sites More sharing options...
Mike Medved Posted April 3, 2023 Report Share Posted April 3, 2023 What error are you getting? Quote Link to comment Share on other sites More sharing options...
mlsignups Posted April 3, 2023 Author Report Share Posted April 3, 2023 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); Quote Link to comment Share on other sites More sharing options...
mlsignups Posted April 3, 2023 Author Report Share Posted April 3, 2023 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. Quote Link to comment Share on other sites More sharing options...
mlsignups Posted April 4, 2023 Author Report Share Posted April 4, 2023 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. Quote Link to comment Share on other sites More sharing options...
Mike Medved Posted April 4, 2023 Report Share Posted April 4, 2023 Hm - it is an HTTP request. It has to receive something back... Does it expect JSON back? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.