Cannot get Webservice tinyurl

[dindaisme]

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=1MbT3WQ2m4yQp3wInFCu6Bl7HiRUIPlo1

[erAck]

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

=WEBSERVICE(B4&ENCODEURL(C4))

[dindaisme]

WOOWWWW…thx it work like a charm

[erAck]

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