python - Unable to parse data from UrlFetchApp in Google Apps Script

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65642899/unable-to-parse-data-from-urlfetchapp-in-google-apps-script

Answer 1

Issue:

Using a r'' raw string flag makes and , a literal and n/t respectively and not a new line or a tab character. This explains why you were able to copy the "displayed" logs to a variable and execute it successfully.

Solution:

Don't use r flag.

Snippet:

    linetext = column + "
" #no flag
    long_string = long_string+linetext
else:
    text = column + "" #no flag