FormatException (FormatException: Unexpected character (at character 1)

Question

I am trying to get data from a json from a link and decode it to display data in a calendar, so it worked fine until this error appears in this line

dynamic jsonAppData = convert.jsonDecode(data.body);

Which trows this:

Exception has occurred. FormatException (FormatException: Unexpected character (at character 1) <!doctype html><base href="https://accou... ^ )

I don't really know why it is caused, I searched for solutions but I didn't find anything for my case.

I hope you can help me.

Future<List> getDataFromGoogleSheet() async { Response data = await http.get( Uri.parse( "https://script.google.com/macros/s/AKfycbybaFrTEBrxTIni8izFKMQYNNAe7ciVMlqF0OUHyWujjRR2AQ8zDyQzh96tleRKMHSN/exec"), );

dynamic jsonAppData = convert.jsonDecode(data.body);
final List<Meeting> appointmentData = [];

for (dynamic data in jsonAppData) {
  var recurrence = data['byday'];

  Meeting meetingData = Meeting(
    eventName: data['subject'],
    from: _convertDateFromString(data['starttime']),
    to: _convertDateFromString(data['endtime']),
    background: Colors.grey.shade800,
    recurrenceRule: 'FREQ=DAILY;INTERVAL=7;BYDAY:$recurrence;COUNT=10',
  );
  appointmentData.add(meetingData);
  String notes = data['notes'];
}
return appointmentData;   }

score 0 · Answer 1 · answered Aug 30 '22 at 19:44

0

Your response body is not of json type.

You should check your request before

answered Aug 30 '22 at 19:44

F Perroch

1,988
2
11
23

score 0 · Answer 2 · answered Aug 30 '22 at 19:45

You can't parse the json because you have to authenticate with google first. If you call the page in the browser, where you are not logged in with Google, then you are redirected to the login page of Google. And my guess is this page is parsed, not the json.

FormatException (FormatException: Unexpected character (at character 1)

2 Answers2