Ask Your Question
0

Cannot get Webservice tinyurl [closed]

asked 2018-10-08 06:48:24 +0100

dindaisme gravatar image

Hi Need some help

I want to use Webservice function as a tinyurl API, but im having a problem when the link that i want to connect with tiny url is from google drive link. It always came up with #Value Result. im using the same function in Microsoft Excel 2016 and it work flawlesly.

Here is the File result link https://drive.google.com/open?id=1MbT...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by dindaisme
close date 2018-10-09 03:56:54.081155

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-08 14:35:42 +0100

erAck gravatar image

The URL in C4 contains a ? query parameter, you have to encode the URL:

=WEBSERVICE(B4&ENCODEURL(C4))
edit flag offensive delete link more

Comments

WOOWWWW...thx it work like a charm :)

dindaisme gravatar imagedindaisme ( 2018-10-09 03:46:30 +0100 )edit

Clicking the Up-vote and checkmark for a correct answer would be appreciated as well.

erAck gravatar imageerAck ( 2018-10-09 10:46:03 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2018-10-08 06:48:24 +0100

Seen: 193 times

Last updated: Oct 08 '18