Web.GotText get responseContent returns HTML instead of Text from Google Sheet

[mher_cadz]

The google app script:

MIT Block:

[mher_cadz]

Need help. I cant get the correct response.

[HarshVardhanSolanki]

Post you aia if you want to. I will try to help you.

[Taifun]

Post your raw response content
It is most probably an error message in html format

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

Taifun

[AyProductions]

@HarshVardhanSolanki

PM me aia if you want to.

I think it is better for you to help them out in the public, that way others can also learn the solution.

[HarshVardhanSolanki]

Sure! I edited that, I asked in PM because everyone are not comfortable to share their hard earned
projects to the public directly.