http://nubiz.tistory.com/541
이 예제로 구글 스프레드 시트를 이용해서 DB를 사용하는 것을 해보았는데요,
1. 자료를 잘 넣어보았고,
https://docs.google.com/spreadsheets/d/1-mzhB2PORoX2GAkLKw1D-A79rEJQ4Wr5AwBAP1cwczY/gviz/tq?tqx=out:html
2. SQL도 해 보아서 잘 결과가 조회되었고,
https://docs.google.com/spreadsheets/d/1-mzhB2PORoX2GAkLKw1D-A79rEJQ4Wr5AwBAP1cwczY/gviz/tq?tqx=out:html&tq=select%20*%20where%20A%3D1%20and%20B%3D%27%EC%A7%80%EC%98%A4%27%20and%20C%3D1&gid=0
3. 안드로이드에서도 jsoup 파싱을 통해 필요한 내용의 조회가 잘 되었는데,
4. 새로만드는 프로젝트에서는 왜 잘 안될까요?
3.4번의 차이는 3은 액티비티고, 4는 프래그먼트인것 밖에 없는데..
같은 주소를 넣고 Jsoup 파싱을 했는데 안되네요..
Jsoup 파싱을 하면 아래와 같은 메시지가 나와요.. SQL 이 안되는 것 같긴한데..안되는 이유를 모르겠어요..
<html>
<head></head>
<body>
{"version":"0.6","reqId":"0","status":"error","errors":[{"reason":"invalid_query","message":"INVALID_QUERY","detailed_message":"Invalid query: PARSE_ERROR: Encountered \u0022%\u0022 at line 1, column 7.\nWas expecting one of:\n \u0022true\u0022 ...\n \u0022false\u0022 ...\n \u0022date\u0022 ...\n \u0022timeofday\u0022 ...\n \u0022datetime\u0022 ...\n \u0022timestamp\u0022 ...\n \u0022min\u0022 ...\n \u0022max\u0022 ...\n \u0022avg\u0022 ...\n \u0022count\u0022 ...\n \u0022sum\u0022 ...\n \u0022no_values\u0022 ...\n \u0022no_format\u0022 ...\n \u0022is\u0022 ...\n \u0022null\u0022 ...\n \u0022year\u0022 ...\n \u0022month\u0022 ...\n \u0022day\u0022 ...\n \u0022hour\u0022 ...\n \u0022minute\u0022 ...\n \u0022second\u0022 ...\n \u0022millisecond\u0022 ...\n \u0022with\u0022 ...\n \u0022contains\u0022 ...\n \u0022starts\u0022 ...\n \u0022ends\u0022 ...\n \u0022matches\u0022 ...\n \u0022like\u0022 ...\n \u0022now\u0022 ...\n \u0022dateDiff\u0022 ...\n \u0022quarter\u0022 ...\n \u0022lower\u0022 ...\n \u0022upper\u0022 ...\n \u0022dayOfWeek\u0022 ...\n \u0022toDate\u0022 ...\n \u003cID\u003e ...\n \u003cINTEGER_LITERAL\u003e ...\n \u003cDECIMAL_LITERAL\u003e ...\n \u003cSTRING_LITERAL\u003e ...\n \u003cQUOTED_ID\u003e ...\n \u0022(\u0022 ...\n \u0022*\u0022 ...\n \u0022-\u0022 ...\n "}]}
</body>
</html>