Sheet data request msxml2.ServerXMLHTTP60

488 views
Skip to first unread message

benoit deguffroy

unread,
Nov 7, 2022, 5:09:13 AM11/7/22
to Google Apps Script Community
Hi,

I created a small script to send the sheet data in JSON format to an webapp
, the webapp is VB6 or VBA i use the reference msxml2.ServerXMLHTTP60 to
read out the data but i get the source code of the script instead of the data

<!doctype html><html lang="nl" dir="ltr"><head><base href="https://accounts.google.com/v3/signin/"><meta name="referrer" content="origin"><meta name="viewport" content="width=device-width, initial-scale=1"><style data-href="https://www.gstatic.com/_/mss/boq-identity/_/ss/k=boq-identity.AccountsSignInUi.fa_8j5_uaA8.L.X.O/am=ZwAABSAAAAUCAAAAAAAAAAAAIBEB/d=1/ed=1/rs=AOaEmlFrSnV0T0rsGxkirl88H9BB3y2Izg/m=identifierview,_b,_tp,_r" nonce=

the output in the webbrowser is well correct

[["name"],["Benoit1"],["Benoit2"],["Benoit3"],["Benoit4"],["Benoit5"],["Benoit6"],["Benoit7"],["Benoit8"],["Benoit9"],["Benoit10"],[""],[""],[""]]

Any idea how to correct format it?
Reply all
Reply to author
Forward
0 new messages