{"id":4078,"date":"2017-10-06T11:02:51","date_gmt":"2017-10-06T18:02:51","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4078"},"modified":"2025-06-13T17:23:09","modified_gmt":"2025-06-14T00:23:09","slug":"curl-comes-n1ql-querying-external-json-data","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/curl-comes-n1ql-querying-external-json-data\/","title":{"rendered":"CURL\uc774 N1QL\ub85c \uc81c\uacf5\ub429\ub2c8\ub2e4: \uc678\ubd80 JSON \ub370\uc774\ud130 \ucffc\ub9ac\ud558\uae30"},"content":{"rendered":"

JSON\uc740 \ub370\uc774\ud130\ub97c \uc804\uc1a1\ud558\ub294 \ub370 \uc720\uc6a9\ud55c \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\uc81c Couchbase 5.0\uc758 CURL \uc5c5\ub370\uc774\ud2b8 \ub355\ubd84\uc5d0 N1QL\uc774 \uc774\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \ub2e4\uc591\ud55c \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694.<\/b><\/p>\n

N1QL<\/a> \uc5d0\ub294 \ud2b9\uc815 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \ub9ce\uc740 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 Couchbase 5.0 DP\uc5d0 \ucd94\uac00\ub41c \uae30\ub2a5 \uc911 \ud558\ub098\ub294 CURL\uc785\ub2c8\ub2e4.<\/span><\/p>\n

CURL\uc744 \uc0ac\uc6a9\ud558\uba74 N1QL\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 JSON \uc5d4\ub4dc\ud3ec\uc778\ud2b8, \uc989 JSON \ud615\uc2dd\uc73c\ub85c \uacb0\uacfc \ubc0f \ub370\uc774\ud130\ub97c \ubc18\ud658\ud558\ub294 Rest API\uc640 \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \ud1b5\ud574 N1QL\uc740 \uc5b8\uc5b4\uc5d0 \ub0b4\uc7a5\ub41c \ubcf4\uc218\uc801\uc778 curl \uae30\ub2a5 \uc138\ud2b8\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0c1\ud638 \uc791\uc6a9\uc740 \uc8fc\ub85c http \ubc0f https \ud504\ub85c\ud1a0\ucf5c\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc11c\ubc84\uc640\uc758 \ub370\uc774\ud130 \uc804\uc1a1\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4. \uac04\ub2e8\ud788 \ub9d0\ud574, N1QL\uc758 CURL \ud568\uc218\ub294 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud45c\uc900 curl \uae30\ub2a5\uc758 \ud558\uc704 \uc9d1\ud569(<\/span>https:\/\/curl.haxx.se\/docs\/manpage.html<\/span><\/a>)\ub97c \ucffc\ub9ac \uc5b8\uc5b4 \ub0b4\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\ub2e4\ub978 \uc11c\ubc84(\uc608: \uad6c\uae00 \ub9f5, \uc57c\ud6c4 \ud30c\uc774\ub0b8\uc2a4 \ub4f1)\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uae30 \uc704\ud574 CURL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec GET \ub610\ub294 HTTP POST \uc694\uccad\uc744 \ubc1c\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uae30\ub2a5 \uc815\uc758<\/b><\/h2>\n

CURL(URL, [\uc635\uc158])<\/strong><\/p>\n

\uccab \ubc88\uc9f8 \uc778\uc218\ub294 URL\ub85c, JSON \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub97c \uac00\ub9ac\ud0a4\ub294 \ubaa8\ub4e0 URL\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. https:\/\/ \ub610\ub294 https:\/\/ \ud504\ub85c\ud1a0\ucf5c\uc744 \uc0ac\uc6a9\ud558\ub294 URL\ub9cc \uc9c0\uc6d0\ub429\ub2c8\ub2e4. \ub9ac\ub514\ub809\uc158\uc740 \ube44\ud65c\uc131\ud654\ub429\ub2c8\ub2e4. <\/span><\/p>\n

CURL() \ud568\uc218\uc5d0 \ub300\ud55c \uc785\ub825 \uc778\uc218\ub294 \uc815\uc801 \uac12\uacfc \ud3c9\uac00\ud560 \uc218 \uc788\ub294 N1QL \ud45c\ud604\uc2dd\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n

\uc774 \uae00\uc758 \ub4b7\ubd80\ubd84\uc5d0\uc11c \uad6c\uae00 \uc9c0\uc624\ucf54\ub4dc API, \uc57c\ud6c4 \ud30c\uc774\ub0b8\uc2a4 API, \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \ubc0f \uae43\ud5c8\ube0c API\uc5d0\uc11c \ucffc\ub9ac\ud558\ub294 \uc608\uc81c\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub450 \ubc88\uc9f8 \uc778\uc218\ub294 \uc635\uc158 \ubaa9\ub85d\uc785\ub2c8\ub2e4. \uc774\uac83\uc740 curl \uc635\uc158 \ubaa9\ub85d\uacfc \ud574\ub2f9 \uac12\uc744 \ud3ec\ud568\ud558\ub294 JSON \uac1d\uccb4\uc785\ub2c8\ub2e4.<\/span><\/p>\n

\uc800\ud76c\ub294 \ubaa8\ub4e0 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc640 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uc635\uc158\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc774\ub7ec\ud55c \uc635\uc158\uc740 \ubcf4\uc548 \uad00\ub828 \uc635\uc158\uacfc \uc77c\ubc18 \uc635\uc158\uc73c\ub85c \ubd84\ub958\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc9c0\uc6d0\ub418\ub294 \uc635\uc158\uc758 \ud45c\ub294 \uc774 \ubb38\uc11c\uc758 \ub9c8\uc9c0\ub9c9\uc5d0 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

 <\/p>\n

CURL\uc758 \ubcf4\uc548 \uae30\ub2a5\/\uac1c\uc120 \uc0ac\ud56d<\/b><\/h2>\n

\ubcf4\uc548 \ucde8\uc57d\uc810\uc744 \ubc29\uc9c0\ud558\uace0 \uc774\uc640 \uad00\ub828\ub41c \uc704\ud5d8\uc744 \uc81c\uc5b4\ud558\uace0 \ucd5c\uc18c\ud654\ud558\uae30 \uc704\ud574 CURL \uae30\ub2a5\uc774 \ucd94\uac00\ub428\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uac00\uc9c0 \ubcf4\uc548 \uc870\uce58\uac00 \uad6c\ud604\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

N1QL\uc758 CURL \uae30\ub2a5\uc73c\ub85c CA \uc778\uc99d\uc11c \uc0ac\uc6a9\ud558\uae30<\/b><\/h3>\n

N1QL CURL \ud568\uc218\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc778\uc99d\uc11c\ub294 \ud074\ub7ec\uc2a4\ud130 \ub0b4\uc758 \ubaa8\ub4e0 \ucffc\ub9ac \ub178\ub4dc\uc5d0 n1qlcerts \ub514\ub809\ud130\ub9ac\uc5d0 \uc800\uc7a5\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\uac00 \uc774 \ub514\ub809\ud130\ub9ac\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud558\ub294 \uc704\uce58\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc124\uce58 \uc704\uce58\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. (OS\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4). \ub2e4\uc74c\uc740 \uae30\ubcf8 \uc124\uce58 \uc704\uce58\ub97c \uac00\uc815\ud558\uc5ec n1qlcerts \ub514\ub809\ud130\ub9ac\uac00 \uc0dd\uc131\ub41c \uc704\uce58\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <\/span><\/p>\n

\n\n\n\n\n\n
Linux \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\n \/\uc635\ud2b8\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\ubcc0\/\ub77c\uc774\ube0c\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\uc5d41qlcerts \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\n<\/tr>\n
Mac OSX<\/span><\/td>\n\/\uc0ac\uc6a9\uc790\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\ub77c\uc774\ube0c\ub7ec\ub9ac\/\uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\\ \uc9c0\uc6d0\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/var\/lib\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/n1qlcerts<\/span><\/td>\n<\/tr>\n
Windows<\/span><\/td>\nC:\\\ud504\ub85c\uadf8\ub7a8 \ud30c\uc77c\\\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\\\uc11c\ubc84\\\ubcc0\uc218\\lib\\\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\\n1qlcerts<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uae30\ubcf8 \uc124\uce58 \uc704\uce58\uac00 \uc544\ub2cc \uacbd\uc6b0, cbq-\uc5d4\uc9c4\uc774 \uc2e4\ud589\ub418\ub294 bin \ub514\ub809\ud130\ub9ac\uc5d0\uc11c \uc0c1\ub300 \uacbd\ub85c\uc778 \"..\/var\/lib\/couchbase\/n1qlcerts \ub514\ub809\ud1a0\ub9ac\"\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc774 \ub514\ub809\ud130\ub9ac\ub294 \ubaa8\ub4e0 \ucffc\ub9ac \ub178\ub4dc\uc5d0 \ub300\ud574 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc774 \ub514\ub809\ud130\ub9ac\uac00 \uc0dd\uc131\ub418\uba74 \uc5ec\uae30\uc5d0 CURL\uc5d0 \uc0ac\uc6a9\ud560 \uc778\uc99d\uc11c\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \uc774 \uc778\uc99d\uc11c\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 cacert \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uace0 \uc778\uc99d\uc11c \uc774\ub984\uc744 \uc804\ub2ec\ud569\ub2c8\ub2e4. <\/span><\/p>\n

\uc608\ub97c \ub4e4\uc5b4 n1qlcerts\/user1.pem\uc774 \uc778\uc99d\uc11c \uc774\ub984\uc778 \uacbd\uc6b0, cacert \uc635\uc158\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\"cacert\":\"user1.pem\"<\/strong><\/p>\n

\uc774\ub984\ub9cc \uc720\ud6a8\ud558\uace0 \uacbd\ub85c\ub294 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc73c\uba70 \uacbd\ub85c\ub97c \uc804\ub2ec\ud558\uba74 \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \uc778\uc99d\uc11c \ubc0f \ub9cc\ub8cc\ub41c \uc778\uc99d\uc11c\uc758 \uacbd\uc6b0 CURL()\uc740 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4.<\/span><\/p>\n

\ucc38\uace0: \ud074\ub7ec\uc2a4\ud130 \ub0b4\uc758 \uac01 \ucffc\ub9ac \ub178\ub4dc\uc5d0 \ub300\ud574 n1qlcerts \ub514\ub809\ud130\ub9ac\uc640 \uadf8 \ub0b4\uc6a9\uc744 \ubcf5\uc81c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/b><\/p>\n

\uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud5e4\ub354 \ubc0f \uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8<\/b><\/h3>\n

CURL()\uc740 \ud074\ub7ec\uc2a4\ud130 \ub0b4\uc758 \ucffc\ub9ac \ub178\ub4dc\uc5d0\uc11c \uc2e4\ud589\ub429\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ud568\uc218\uac00 \ucffc\ub9ac \uc11c\ube44\uc2a4\ub97c \ud1b5\ud574 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 REST \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\ud568\uc218\uac00 \uc2e4\ud589\ub418\ub294 \uacf3\uc774\uae30 \ub54c\ubb38\uc5d0). \uc774\ub7ec\ud55c \uc548\uc804\ud558\uc9c0 \uc54a\uc740 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\uc790\uac00 \ubcc0\uacbd\ud560 \uc218 \uc5c6\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud5e4\ub354\uac00 N1QL curl \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc804\uc1a1\ub418\ub294 \ubaa8\ub4e0 \uc694\uccad\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4. \uc774 \ud5e4\ub354\uc758 \ud615\uc2dd\uc740 \"X-N1QL-User-Agent: couchbase\/n1ql\/1.7.0-N1QL\"\uc785\ub2c8\ub2e4. <\/span><\/p>\n

\uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8\ub3c4 \ud56d\uc0c1 \uae30\ubcf8\uc801\uc73c\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8\ub294 -user-agent \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc7ac\uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \uc124\uc815\ub41c \uac12\uc740 \"couchbase\/n1ql\/1.7.0-N1QL\"\uc785\ub2c8\ub2e4.<\/span><\/p>\n

\uc774 \ub450 \uac12\uc740 \ub0b4\ubd80 \ubc0f \uc678\ubd80 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uac00 \ubaa8\ub450 \ud5e4\ub354\/\uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8\ub97c \ud655\uc778\ud558\uace0 \ucf54\ub4dc\uc5d0\uc11c \uc561\uc138\uc2a4\ub97c \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uace0 \ud574\ub2f9 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub97c \uac70\ubd80\ud560 \uc218 \uc788\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774\ub97c \uc0ac\uc6a9\ud560 \ub54c \ud55c \uac00\uc9c0 \uc8fc\uc758\ud560 \uc810\uc740 \uc774 \ud5e4\ub354\ub97c \ud655\uc778\ud558\uc9c0 \uc54a\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc640 \ub85c\uceec\uc5d0 \uc124\uce58\ub41c \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc758 \uae30\uc874 \ubc84\uc804(\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubc0f \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \uc544\ub2cc \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubaa8\ub450)\uc744 \uc5ec\uc804\ud788 \ubcf4\ud638\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0\ub97c \uc704\ud574 \uceec \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4(\uc544\ub798 \ucc38\uc870).<\/span><\/p>\n

 <\/p>\n

\ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\ub97c \uc0dd\uc131\ud558\uc5ec CURL \uc561\uc138\uc2a4\ub97c \uc81c\ud55c\ud569\ub2c8\ub2e4.<\/b><\/h3>\n

\ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\ub294 CURL() \ud568\uc218\uac00 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294 \ud5c8\uc6a9\ub41c REST \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc640 URL\uc744 \ub098\uc5f4\ud558\ub294 JSON \ubb38\uc11c\uc785\ub2c8\ub2e4. URL \uc790\uccb4\ub294 \uc811\ub450\uc0ac\uac00 \uc77c\uce58\ud574\uc57c \ud569\ub2c8\ub2e4. \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8 \ubb38\uc11c\ub294 n1qlcerts \ub514\ub809\ud130\ub9ac(\uc704\uce58\ub294 \uc704 \ucc38\uc870) \ub0b4\uc5d0 \ub9cc\ub4e4\uc5b4\uc9c0\uba70, \uc774\ub984\uc740 curl_whitelist.json\uc785\ub2c8\ub2e4(\uc774 \uc774\ub984\uc740 \uace0\uc815\ub418\uc5b4 \uc788\uc73c\uba70 \uc0ac\uc6a9\uc790\uac00 \ubcc0\uacbd\ud560 \uc218 \uc5c6\uc74c). \uad00\ub9ac\uc790(\ub610\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \uc124\uce58\ub41c \ucef4\ud4e8\ud130\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4 \uad8c\ud55c\uc774 \uc788\ub294 \uc0ac\uc6a9\uc790)\uac00 \uc774 \ud30c\uc77c(curl_whitelist.json)\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/span><\/p>\n

\ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\uac70\ub098(....\/n1qlcerts\/curl_whitelist.json\uc774 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc74c) \uc874\uc7ac\ud558\uc9c0\ub9cc \ube44\uc5b4 \uc788\ub294 \uacbd\uc6b0 CURL \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n

\ubaa8\ub4e0 \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\uc5d0\ub294 \ub2e4\uc74c \ud544\ub4dc\uac00 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/span><\/p>\n

\n\n\n\n\n\n\n
\ud544\ub4dc<\/span><\/td>\n\uc720\ud615<\/span><\/td>\n\uc124\uba85<\/span><\/td>\n\uae30\ubcf8\uac12<\/span><\/td>\n<\/tr>\n
all_access<\/span><\/td>\n\ubd80\uc6b8<\/span><\/td>\n\uc774\ub807\uac8c \ud558\uba74 \uc0ac\uc6a9\uc790\uac00 \ubaa8\ub4e0 URL\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294\uc9c0 \uc544\ub2c8\uba74 allowed_urls \ubc30\uc5f4\uc5d0 \uc9c0\uc815\ub41c URL\uc5d0\ub9cc \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294\uc9c0 \uacb0\uc815\ub429\ub2c8\ub2e4.<\/span><\/td>\nfalse<\/span><\/td>\n<\/tr>\n
allowed_urls<\/span><\/td>\n\ubc30\uc5f4<\/span><\/td>\n\ud5c8\uc6a9\ud558\ub824\ub294 URL\uc758 \uc811\ub450\uc0ac \ubaa9\ub85d\uc785\ub2c8\ub2e4.<\/span><\/td>\n\ube48<\/span><\/td>\n<\/tr>\n
disallowed_urls<\/span><\/td>\n\ubc30\uc5f4<\/span><\/td>\n\uc5b4\ub5a4 \uacbd\uc6b0\uc5d0\ub3c4 \uc81c\ud55c\ub418\ub294 URL\uc758 \uc811\ub450\uc0ac \ubaa9\ub85d<\/span><\/td>\n\ube48<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

all_access \ud544\ub4dc\uac00 \uac70\uc9d3\uc774\uba74 CURL \ud568\uc218\uc5d0 \ub300\ud55c \uc0ac\uc6a9\uc774 \uc644\uc804\ud788 \uc81c\ud55c\ub429\ub2c8\ub2e4. N1QL\uc758 \ubaa8\ub4e0 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0\uc11c CURL()\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \uad00\ub9ac\uc790\uac00 \ud5c8\uc6a9\ub41c_urls \ubc0f \ud5c8\uc6a9\ub418\uc9c0 \uc54a\uc740_urls\ub97c \uc801\uc808\ud788 \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \ubaa8\ub4e0 URL\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub97c \ud5c8\uc6a9\ud558\ub824\uba74 all_access\ub97c true\ub85c \uc124\uc815\ud558\uba74 \ub429\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uae30\ubcf8\uc801\uc73c\ub85c \uc804\uccb4 CURL \uc561\uc138\uc2a4 \uad8c\ud55c\uc774 \ubd80\uc5ec\ub429\ub2c8\ub2e4.<\/span><\/p>\n

\uc608\ub97c \ub4e4\uc5b4 \ubaa8\ub4e0 Google \uc9c0\ub3c4 API \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub294 \ud5c8\uc6a9\ud558\ub418 \ub2e4\ub978 \ubaa8\ub4e0 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub294 \uc81c\ud55c\ud558\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\uc758 \ub0b4\uc6a9\uc785\ub2c8\ub2e4. <\/span><\/p>\n

Curl_whitelist.json <\/span><\/p>\n

{\r\n\u00a0\"all_access\":false,\r\n\u00a0\"allowed_urls\":[\"https:\/\/maps.googleapis.com\"]\r\n}\r\n\r\n<\/pre>\n
\uc811\ub450\uc0ac\uac00 \uc55e\uc5d0 \ubd99\uc740 CURL()\uc758 \ubaa8\ub4e0 URL https:\/\/maps.googleapis.com\/<\/b><\/a> \uac00 \ud5c8\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n
\ucc38\uace0: \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\ub294 \ud074\ub7ec\uc2a4\ud130 \ub0b4\uc758 \uac01 \ucffc\ub9ac \ub178\ub4dc\uc5d0 \ub300\ud574 \ubcf5\uc81c\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/b><\/p>\n
CURL \ud568\uc218\uc5d0 \ub300\ud55c \uc5ed\ud560 \uae30\ubc18 \uc561\uc138\uc2a4<\/b><\/h3>\n
\uc5ec\uae30\uc11c \uc5b8\uae09\ud560 \ub9cc\ud55c \uc911\uc694\ud55c \uc810\uc740 CURL\uc774 \uc784\uc758\ub85c \ud638\ucd9c\ub420 \uc218 \uc5c6\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. UPDATE \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc8fc\uc785\ub418\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 \uc0c8\ub85c\uc6b4 \uc5ed\ud560\uc778 QUERY_EXTERNAL_ACCESS\uac00 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uc5ed\ud560\uc774 \ud560\ub2f9\ub41c \uc0ac\uc6a9\uc790\ub9cc CURL \ud568\uc218\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \uc774 \uc5ed\ud560 \uba64\ubc84\uc2ed\uc740 \ube44\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. CURL \ud568\uc218\ub294 FULL_ADMIN \ub610\ub294 FULL_ADMIN\uc5d0 \uc758\ud574 QUERY_EXTERNAL_ACCESS \uc5ed\ud560\uc774 \ubd80\uc5ec\ub41c \uc0ac\uc6a9\uc790\ub9cc \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ed\ud560 \uae30\ubc18 \uc561\uc138\uc2a4 \uc81c\uc5b4\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \uc774\uc804 \ubc84\uc804\uc758 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uacbd\uc6b0 \ube44\ubc00\ubc88\ud638\ub85c \ubcf4\ud638\ub41c \ubc84\ud0b7\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c CURL() \uae30\ub2a5\uc758 \uacbd\uc6b0 \ub0b4\ubd80\uc801\uc73c\ub85c \ud2b9\uc815 SSL \uc554\ud638 \uc138\ud2b8(MEDIUM \ub610\ub294 HIGH)\uac00 \uc9c0\uc6d0\ub429\ub2c8\ub2e4. \uc774\ub294 COUCHBASE_SSL_CIPHER_LIST\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/span><\/p>\n
 <\/p>\n
CURL()\uc758 \uacb0\uacfc \ud06c\uae30 \uc81c\ud55c\ud558\uae30<\/b><\/h3>\n
CURL() \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \ub54c \uc911\uc694\ud55c \ubb38\uc81c\ub294 \uc0ac\uc6a9\uc790\uac00 64MB\uac00 \ub118\ub294 \ub9e4\uc6b0 \uae34 \ud30c\uc77c\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uc77d\uc73c\ub824\uace0 \ud560 \ub54c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uba54\ubaa8\ub9ac\uc5d0 \ub85c\ub4dc\ub418\ubbc0\ub85c \uacb0\uacfc \ud06c\uae30\uac00 \uc81c\ud55c\ub418\uc9c0 \uc54a\uc73c\uba74 \ucffc\ub9ac \uc11c\ube44\uc2a4\uac00 \uc911\ub2e8\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uac00\ub2a5\uc131 \ub54c\ubb38\uc5d0 CURL()\uc774 \ubc18\ud658\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\uc758 \ucd5c\ub300 \uacb0\uacfc \ud06c\uae30\ub294 64MB(67,108,864\ubc14\uc774\ud2b8)\uc785\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 CURL \uacb0\uacfc\uc758 \uba54\ubaa8\ub9ac \uc591\uc744 \uc81c\ud55c\ud558\uae30 \uc704\ud574 <\/span>\uacb0\uacfc-\ucea1<\/i><\/b> \uc635\uc158\uc758 \ucd5c\uc18c(\uae30\ubcf8)\uac12\uc740 20MB(2097120\ubc14\uc774\ud2b8)\uc785\ub2c8\ub2e4.<\/span><\/p>\n
\uc608\ub97c \ub4e4\uc5b4 \ucffc\ub9ac\uc5d0\uc11c \uacb0\uacfc-\ucea1\uc744 20MB\ub85c \uc124\uc815\ud558\ub294 \uacbd\uc6b0 - \"result-cap\":20971520 - \uc774\ubcf4\ub2e4 \ud070 \ud06c\uae30\uc758 \uc751\ub2f5\uc740 \uc624\ub958\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/span><\/p>\n
 <\/p>\n
\ub2e4\uc591\ud55c \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc640\uc758 \uc0c1\ud638 \uc791\uc6a9<\/b><\/h2>\n
N1QL\uc758 CURL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub97c \ucffc\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
Google \uc9c0\ub3c4 \uc9c0\uc624\ucf54\ub529 API<\/b><\/h3>\n
Google \uc9c0\ub3c4\uc758 \uc9c0\uc624\ucf54\ub529 API\ub97c \uc0ac\uc6a9\ud558\uba74 HTTP \uc694\uccad\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc815\uc801 \uc8fc\uc18c\ub97c \uc88c\ud45c\ub85c \ubcc0\ud658\ud558\uac70\ub098 \uadf8 \ubc18\ub300\ub85c \ubcc0\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <\/span>https:\/\/developers.google.com\/maps\/documentation\/geocoding\/intro<\/span><\/a> )<\/span><\/p>\n
Google \uac1c\ubc1c\uc790 API \ud0a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud398\uc778\uc758 \uc0b0\ud0c0\ud06c\ub8e8\uc988\ub97c \uac80\uc0c9\ud558\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
\uceec \uc694\uccad<\/b><\/h4>\n
curl https:\/\/maps.googleapis.com\/maps\/api\/geocode\/json?address=santa+cruz&components=country:ES&key=<Your Developer API key><\/pre>\n
 <\/p>\n
\ud574\ub2f9 \ucffc\ub9ac<\/b><\/h4>\n
SELECT CURL(\"https:\/\/maps.googleapis.com\/maps\/api\/geocode\/json\", {\"get\":true,\"data\":\"address=santa+cruz&components=country:ES&key=<Your Developer API key>\"}) GEO;<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"GEO\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"address_components\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"Santa Cruz de Tenerife\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"Santa Cruz de Tenerife\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"locality\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"Santa Cruz de Tenerife\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"TF\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"administrative_area_level_2\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"Canary Islands\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"CN\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"administrative_area_level_1\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"Spain\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"ES\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"country\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"formatted_address\": \"Santa Cruz de Tenerife, Spain\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"geometry\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"bounds\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"northeast\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 28.487616,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -16.2356646\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"southwest\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 28.4280248,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -16.3370045\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"location\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 28.4636296,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -16.2518467\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"location_type\": \"APPROXIMATE\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"viewport\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"northeast\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 28.487616,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -16.2356646\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"southwest\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 28.4280248,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -16.3370045\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"place_id\": \"ChIJcUElzOzMQQwRLuV30nMUEUM\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"locality\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"status\": \"OK\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n
\uc774 \ucffc\ub9ac\ub294 \uc8fc\uc18c\uc778 Santa Cruz, ES\uc758 \uc8fc\uc18c \ubc0f \uc9c0\ub9ac\uc801 \uc704\uce58 \uacbd\uacc4\ub97c \uac80\uc0c9\ud569\ub2c8\ub2e4. Google Maps \uc9c0\uc624\ucf54\ub529 REST API\uc758 \uc8fc\uc18c, \uad6c\uc131 \uc694\uc18c \ubc0f \uc8fc\uc694 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. '\ub370\uc774\ud130' \uc635\uc158\uc740 HTTP POST \ub370\uc774\ud130\ub97c \ub098\ud0c0\ub0b4\ub294 curl \ub370\uc774\ud130 \uc635\uc158\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.  \uadf8\ub7ec\ub098 \uc774\uac83\uc740 \uac00\uc838\uc624\uae30 \uc694\uccad\uc774\ubbc0\ub85c \"get\" \uc635\uc158\uc744 true\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uc635\uc158 \ub0b4\uc758 \ubaa8\ub4e0 REST \ub9e4\uac1c\ubcc0\uc218\uc5d0 \uac12\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc774\uc81c \ud558\ud504\ubb38 \ubca0\uc774\ub97c \uac80\uc0c9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
SELECT CURL(\"https:\/\/maps.googleapis.com\/maps\/api\/geocode\/json\", {\"data\":\"address=Half+Moon+Bay\", \"get\":true}) GEO;<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"GEO\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"address_components\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"Half Moon Bay\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"Half Moon Bay\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"locality\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"San Mateo County\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"San Mateo County\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"administrative_area_level_2\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"California\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"CA\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"administrative_area_level_1\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"long_name\": \"United States\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"short_name\": \"US\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"country\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"formatted_address\": \"Half Moon Bay, CA, USA\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"geometry\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"bounds\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"northeast\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 37.5226389,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -122.4165183\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"southwest\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 37.4249286,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -122.4778879\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"location\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 37.4635519,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -122.4285862\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"location_type\": \"APPROXIMATE\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"viewport\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"northeast\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 37.5226389,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -122.4165183\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"southwest\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lat\": 37.4249286,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lng\": -122.4778879\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"place_id\": \"ChIJC8sZCqULj4ARVJvnNcic_V4\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"types\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"locality\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"political\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"status\": \"OK\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n
\uc57c\ud6c4 \ud30c\uc774\ub0b8\uc2a4 API<\/b><\/p>\n
\uc57c\ud6c4 \ud30c\uc774\ub0b8\uc2a4 API\ub97c \uc0ac\uc6a9\ud558\uba74 \uc57c\ud6c4 \ucffc\ub9ac \uc5b8\uc5b4(YQL)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc8fc\uc2dd \uc2dc\uc138\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4( <\/span>https:\/\/meumobi.github.io\/stocks%20apis\/2016\/03\/13\/get-realtime-stock-quotes-yahoo-finance-api.html<\/span><\/a> ). \ub2e4\uc74c\uc740 Hortonworks Inc(HDP)\uc758 \uc8fc\uc2dd\uc5d0 \uc561\uc138\uc2a4\ud558\ub294 YQL SELECT \ubb38\uc785\ub2c8\ub2e4.<\/span><\/p>\n
select * from yahoo.finance.quotes where symbol in (\"HDP\")<\/pre>\n
\uacb0\uacfc\ub97c JSON\uc73c\ub85c \uac00\uc838\uc624\ub824\uba74 \ub2e4\uc74c URL\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
https:\/\/query.yahooapis.com\/v1\/public\/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22HDP%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=<\/span><\/a><\/p>\n
\uceec \uc694\uccad<\/b><\/h4>\n
curl https:\/\/query.yahooapis.com\/v1\/public\/yql --data 'q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22HDP%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback='<\/pre>\n
\ud574\ub2f9 \ucffc\ub9ac<\/b><\/h4>\n
SELECT temp.query.results from\r\nCURL(\"https:\/\/query.yahooapis.com\/v1\/public\/yql\",\r\n\u00a0\u00a0\u00a0{\"data\":\"q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22HDP%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=\"})temp;<\/pre>\n
"results": [\r\n      {\r\n          "results": {\r\n              "quote": {\r\n                  "AfterHoursChangeRealtime": null,\r\n                  "AnnualizedGain": null,\r\n                  "Ask": "16.950",\r\n                  "AskRealtime": null,\r\n                  "AverageDailyVolume": "952135",\r\n                  "Bid": "16.940",\r\n                  "BidRealtime": null,\r\n                  "BookValue": "-0.654",\r\n                  "Change": "+0.075",\r\n                  "ChangeFromFiftydayMovingAverage": "0.377",\r\n                  "ChangeFromTwoHundreddayMovingAverage": "3.625",\r\n                  "ChangeFromYearHigh": "-0.755",\r\n                  "ChangeFromYearLow": "10.525",\r\n                  "ChangePercentRealtime": null,\r\n                  "ChangeRealtime": null,\r\n                  "Change_PercentChange": "+0.075 - +0.445%",\r\n                  "ChangeinPercent": "+0.445%",\r\n                  "Commission": null,\r\n                  "Currency": "USD",\r\n                  "DaysHigh": "17.010",\r\n                  "DaysLow": "16.780",\r\n                  "DaysRange": "16.780 - 17.010",\r\n                  "DaysRangeRealtime": null,\r\n                  "DaysValueChange": null,\r\n                  "DaysValueChangeRealtime": null,\r\n                  "DividendPayDate": null,\r\n                  "DividendShare": null,\r\n                  "DividendYield": null,\r\n                  "EBITDA": "-223.00M",\r\n                  "EPSEstimateCurrentYear": "-1.720",\r\n                  "EPSEstimateNextQuarter": "-0.380",\r\n                  "EPSEstimateNextYear": "-1.190",\r\n                  "EarningsShare": "-3.737",\r\n                  "ErrorIndicationreturnedforsymbolchangedinvalid": null,\r\n                  "ExDividendDate": null,\r\n                  "FiftydayMovingAverage": "16.568",\r\n                  "HighLimit": null,\r\n                  "HoldingsGain": null,\r\n                  "HoldingsGainPercent": null,\r\n                  "HoldingsGainPercentRealtime": null,\r\n                  "HoldingsGainRealtime": null,\r\n                  "HoldingsValue": null,\r\n                  "HoldingsValueRealtime": null,\r\n                  "LastTradeDate": "10\/5\/2017",\r\n                  "LastTradePriceOnly": "16.945",\r\n                  "LastTradeRealtimeWithTime": null,\r\n                  "LastTradeTime": "12:50pm",\r\n                  "LastTradeWithTime": "12:50pm - <b>16.945<\/b>",\r\n                  "LowLimit": null,\r\n                  "MarketCapRealtime": null,\r\n                  "MarketCapitalization": "700.96M",\r\n                  "MoreInfo": null,\r\n                  "Name": "Hortonworks, Inc.",\r\n                  "Notes": null,\r\n                  "OneyrTargetPrice": "18.930",\r\n                  "Open": "17.010",\r\n                  "OrderBookRealtime": null,\r\n                  "PEGRatio": "-0.400",\r\n                  "PERatio": null,\r\n                  "PERatioRealtime": null,\r\n                  "PercebtChangeFromYearHigh": "-4.266%",\r\n                  "PercentChange": "+0.445%",\r\n                  "PercentChangeFromFiftydayMovingAverage": "+2.275%",\r\n                  "PercentChangeFromTwoHundreddayMovingAverage": "+27.214%",\r\n                  "PercentChangeFromYearLow": "+163.941%",\r\n                  "PreviousClose": "16.870",\r\n                  "PriceBook": null,\r\n                  "PriceEPSEstimateCurrentYear": null,\r\n                  "PriceEPSEstimateNextYear": null,\r\n                  "PricePaid": null,\r\n                  "PriceSales": "3.212",\r\n                  "SharesOwned": null,\r\n                  "ShortRatio": "3.640",\r\n                  "StockExchange": "NMS",\r\n                  "Symbol": "HDP",\r\n                  "TickerTrend": null,\r\n                  "TradeDate": null,\r\n                  "TwoHundreddayMovingAverage": "13.320",\r\n                  "Volume": "217430",\r\n                  "YearHigh": "17.700",\r\n                  "YearLow": "6.420",\r\n                  "YearRange": "6.420 - 17.700",\r\n                  "symbol": "HDP"\r\n              }\r\n          }\r\n      }\r\n  ]<\/pre>\n
\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \ub370\uc774\ud130 \uc635\uc158\uc758 \uac12\uc5d0\ub294 Yahoo REST \ub9e4\uac1c \ubcc0\uc218\uc778 q(YQL \ucffc\ub9ac\uc758 \uacbd\uc6b0), \ud615\uc2dd(JSON\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubc18\ud658\ud558\uae30 \uc704\ud55c) \ubc0f \uae30\ud0c0 \uba87 \uac00\uc9c0 \ub9e4\uac1c \ubcc0\uc218\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9<\/b><\/h3>\n
Couchbase\uc758 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc0ac\uc6a9\ud558\uba74 Couchbase\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc5d0 \ud37c\uc9c0 \uac80\uc0c9\uc744 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. https:\/\/www.couchbase.com\/blog\/couchbase-4.5-developer-preview-couchbase-fts\/<\/a><\/span>.<\/span><\/p>\n
Couchbase\uc758 \ub9e5\uc8fc \uc0d8\ud50c \ubc84\ud0b7\uc5d0 beer\ub77c\ub294 FTS \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uc774 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec N1QL\uc758 CURL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub9e5\uc8fc \uc885\ub958 \ud398\uc77c \uc5d0\uc77c\uc744 \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. FTS\ub294 \ud604\uc7ac GET \ub300\uc2e0 HTTP POST\ub97c \ud5c8\uc6a9\ud55c\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud574\uc57c \ud569\ub2c8\ub2e4. POST \uc694\uccad \ubc29\ubc95\uc744 \uba85\uc2dc\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub824\uba74 \uc694\uccad \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. <\/span><\/p>\n
\uceec \uc694\uccad<\/b><\/h4>\n
curl \u2013u beer-sample:pass -XPOST -H \"Content-Type: application\/json\" https:\/\/127.0.0.1:8094\/api\/index\/beers\/query -d '{ \"explain\": true, \"fields\": [\"*\"],\"highlight\": {},\"query\": {\"query\": \"pale ale\"}}'<\/pre>\n
\ud574\ub2f9 \ucffc\ub9ac<\/b><\/h4>\n
SELECT result.total_hits, array_length(result.hits) hits_per_page\r\nFROM CURL(\"https:\/\/localhost:8094\/api\/index\/beers\/query\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\"request\":\"POST\",\"header\":\"Content-Type: application\/json\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"data\":'{\"explain\":false,\"fields\": [\"*\"],\"highlight\": {},\"query\": {\"query\": \"pale ale\"}}',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"user\":\"Administrator:password\"}) result;<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"hits_per_page\": 10,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"total_hits\": 3815\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n]<\/pre>\n
\uc774 \ucffc\ub9ac\uc5d0\ub294 \uc5ec\ub7ec \uc635\uc158\uc774 \uc81c\uacf5\ub429\ub2c8\ub2e4. \ud5e4\ub354 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud5e4\ub354\ub97c \uc11c\ubc84\uc5d0 \uc804\ub2ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Content-Type : application\/json\uc740 \ub370\uc774\ud130\uac00 JSON \ud615\uc2dd\uc73c\ub85c \uc81c\uacf5\ub428\uc744 \uc11c\ubc84\uc5d0 \uc54c\ub824\uc90d\ub2c8\ub2e4. Couchbase\uc5d0 \ube44\ubc00\ubc88\ud638\ub85c \ubcf4\ud638\ub41c \ubc84\ud0b7\uc774 \uc788\ub294 \uacbd\uc6b0 \ucffc\ub9ac\uc640 \ud568\uaed8 \ud574\ub2f9 \uc790\uaca9 \uc99d\uba85\uc744 \uc804\ub2ec\ud574\uc57c \ud569\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc635\uc158\uc740 \ucf5c\ub860\uc73c\ub85c \uad6c\ubd84\ub41c \uc0ac\uc6a9\uc790 \uc774\ub984\uacfc \ube44\ubc00\ubc88\ud638\ub97c \uc804\ub2ec\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc694\uccad \uc635\uc158\uc740 POST \uc694\uccad \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/span><\/p>\n
\uc704\uc758 \uac80\uc0c9\uc5d0\uc11c \ubc18\ud658\ub41c \ub9e5\uc8fc \uc0d8\ud50c\uc758 \ubb38\uc11c\ub9cc \uac80\uc0c9\ud558\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 N1QL JOIN \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><\/p>\n
SELECT ARRAY x.id for x in b1.result.hits END as hits,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0b1.result.total_hits as total,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0array_length(b1.result.hits),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0b\r\nFROM (SELECT CURL(\"https:\/\/localhost:8094\/api\/index\/beers\/query\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\"request\":\"POST\",\"header\":\"Content-Type: application\/json\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"data\":'{\"explain\":false,\"fields\": [\"*\"],\"highlight\": {},\"query\": {\"query\": \"pale ale\"}}',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"user\":\"Administrator:password\"}) result) b1\r\nINNER JOIN `beer-sample` b ON KEYS b1.result.hits[*].id LIMIT 1;<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"$1\": 10,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"b\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"abv\": 5.4,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"brewery_id\": \"stone_brewing_co\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"category\": \"North American Ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"description\": \"Our flagship ale, Stone Pale Ale is our Southern California interpretation of the classic British pale ale style. Deep amber in color, Stone Pale Ale is robust and full flavored. A delicate hop aroma is complemented by a rich maltiness. This is an ale for those who have learned to appreciate distinctive flavor. Stone Pale Ale is great by itself, or with food that requires a beer of character.\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"ibu\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"name\": \"Stone Pale Ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"srm\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"style\": \"American-Style Pale Ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"type\": \"beer\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"upc\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"updated\": \"2010-07-22 20:00:20\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"hits\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"stone_brewing_co-stone_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"flying_dog_brewery-classic_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"yards_brewing-yards_philadelphia_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"bell_s_brewery_inc-pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"sierra_nevada_brewing_co-sierra_nevada_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"cooper_s_cave_ale_company-cooper_s_cave_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"appalachian_brewing_company-hoppy_trails_india_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"cooperstown_brewing_company-backyard_india_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"mogollon_brewing_company-superstition_pale_ale\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"troegs_brewing-troegs_pale_ale\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"total\": 3815\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n
\uc774\ub807\uac8c \ud558\uba74 \ud398\uc77c \uc5d0\uc77c\uc744 \uac80\uc0c9\ud558\ub294 FTS \ucffc\ub9ac\uac00 \ubc18\ud658\ud55c \ubb38\uc11c\uc758 ID\uc640 \ud568\uaed8 \ub9e5\uc8fc \uc0d8\ud50c\uc758 \ud574\ub2f9 \ubb38\uc11c\uc5d0\uc11c \ucd1d \uc870\ud68c\uc218 \ubc0f \ubaa8\ub4e0 \uc138\ubd80 \uc815\ubcf4\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
Github API <\/b><\/h2>\n
Github\uc758 API\ub294 \uacb0\uacfc \uac12\uc758 JSON \ubc30\uc5f4 \ud615\ud0dc\ub85c \uc5ec\ub7ec \uacb0\uacfc\ub97c \ubc18\ud658\ud55c\ub2e4\ub294 \uc810\uc5d0\uc11c \uc774\uc804 API\uc640 \uc57d\uac04 \ub2e4\ub985\ub2c8\ub2e4. \uc774\ub294 \uc5ec\ub7ec \uac1c\uc758 \ubb38\uc11c\ub85c \ucde8\uae09\ub420 \uc218 \uc788\uc73c\uba70, Github API \ubb38\uc11c\uc5d0\uc11c <\/span>https:\/\/developer.github.com\/v3\/<\/span><\/a> \ub97c \ud074\ub9ad\ud558\uc5ec \uc870\ud68c\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694.<\/span><\/p>\n
Github \uacc4\uc815\uc5d0 \uc5f0\uacb0\ub41c \ubaa8\ub4e0 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\ub97c \ucc3e\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ucffc\ub9ac\ub294 \uc774\ub97c \uc218\ud589\ud569\ub2c8\ub2e4.<\/span><\/p>\n
\uceec \uc694\uccad<\/b><\/h4>\n
curl -H \"User-Agent: ikandaswamy\" https:\/\/api.github.com\/users\/ikandaswamy\/repos\r\n<\/pre>\n
\ud574\ub2f9 \ucffc\ub9ac<\/b><\/h4>\n
SELECT RAW list FROM CURL(\"https:\/\/api.github.com\/users\/ikandaswamy\/repos\")list LIMIT 1;\r\n<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"archive_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/{archive_format}{\/ref}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"assignees_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/assignees{\/user}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"blobs_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/git\/blobs{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"branches_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/branches{\/branch}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"clone_url\": \"https:\/\/github.com\/ikandaswamy\/ds-algo.git\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"collaborators_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/collaborators{\/collaborator}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"comments_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/comments{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"commits_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/commits{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"compare_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/compare\/{base}...{head}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"contents_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/contents\/{+path}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"contributors_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/contributors\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"created_at\": \"2017-09-07T22:42:03Z\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"default_branch\": \"master\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"deployments_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/deployments\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"description\": \"Use this to implement various fun problems while relearning Data Structures and Algorithms\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"downloads_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/downloads\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"events_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/events\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"fork\": false,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"forks\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"forks_count\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"forks_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/forks\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"full_name\": \"ikandaswamy\/ds-algo\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"git_commits_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/git\/commits{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"git_refs_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/git\/refs{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"git_tags_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/git\/tags{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"git_url\": \"git:\/\/github.com\/ikandaswamy\/ds-algo.git\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"has_downloads\": true,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"has_issues\": true,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"has_pages\": false,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"has_projects\": true,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"has_wiki\": true,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"homepage\": null,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"hooks_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/hooks\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"html_url\": \"https:\/\/github.com\/ikandaswamy\/ds-algo\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"id\": 102792479,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"issue_comment_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/issues\/comments{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"issue_events_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/issues\/events{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"issues_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/issues{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"keys_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/keys{\/key_id}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"labels_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/labels{\/name}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"language\": null,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"languages_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/languages\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"merges_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/merges\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"milestones_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/milestones{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"mirror_url\": null,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"name\": \"ds-algo\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"notifications_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/notifications{?since,all,participating}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"open_issues\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"open_issues_count\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"owner\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"avatar_url\": \"https:\/\/avatars1.githubusercontent.com\/u\/9203396?v=4\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"events_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/events{\/privacy}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"followers_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/followers\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"following_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/following{\/other_user}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"gists_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/gists{\/gist_id}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"gravatar_id\": \"\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"html_url\": \"https:\/\/github.com\/ikandaswamy\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"id\": 9203396,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"login\": \"ikandaswamy\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"organizations_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/orgs\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"received_events_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/received_events\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"repos_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/repos\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"site_admin\": false,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"starred_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/starred{\/owner}{\/repo}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"subscriptions_url\": \"https:\/\/api.github.com\/users\/ikandaswamy\/subscriptions\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"type\": \"User\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"url\": \"https:\/\/api.github.com\/users\/ikandaswamy\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"private\": false,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"pulls_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/pulls{\/number}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"pushed_at\": \"2017-09-07T22:42:04Z\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"releases_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/releases{\/id}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"size\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"ssh_url\": \"git@github.com:ikandaswamy\/ds-algo.git\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"stargazers_count\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"stargazers_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/stargazers\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"statuses_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/statuses\/{sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"subscribers_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/subscribers\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"subscription_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/subscription\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"svn_url\": \"https:\/\/github.com\/ikandaswamy\/ds-algo\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"tags_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/tags\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"teams_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/teams\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"trees_url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\/git\/trees{\/sha}\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"updated_at\": \"2017-09-07T22:42:03Z\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"url\": \"https:\/\/api.github.com\/repos\/ikandaswamy\/ds-algo\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"watchers\": 0,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"watchers_count\": 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n
\uacc4\uc815\uc5d0 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\uac00 3\uac1c \uc788\ub294 \uacbd\uc6b0 \ucffc\ub9ac\ub294 3\uac1c\uc758 \uacb0\uacfc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4(\uc5ec\uae30\uc11c\ub294 \uc81c\ud55c 1\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4). RAW \ud0a4\uc6cc\ub4dc\ub294 \ub798\ud37c \uac1d\uccb4 \uc5c6\uc774 \ucffc\ub9ac\uac00 \ubc18\ud658\ud558\ub294 \ubb38\uc11c \ubc30\uc5f4\uc744 \ubc18\ud658\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ud55c \uac00\uc9c0 \ub208\uc5d0 \ub744\ub294 \uc810\uc740 \ud5e4\ub354 \uc635\uc158\uc5d0 \uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8\uc640 github \uc0ac\uc6a9\uc790 \uc774\ub984\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uc635\uc158\uc740 \uc774\uc81c \ubaa8\ub4e0 Github API \uc694\uccad\uc5d0 \ud544\uc218\uc785\ub2c8\ub2e4.<\/span><\/p>\n
\uc774\uc81c \uc774 \ubaa9\ub85d\uc5d0\uc11c \uac01 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\uc758 \ubcf5\uc81c URL\uc774 \ubb34\uc5c7\uc778\uc9c0 \uc54c\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ucffc\ub9ac\ub294 \uc774\ub97c \uc218\ud589\ud569\ub2c8\ub2e4.<\/span><\/p>\n
SELECT clone_url FROM\r\n(SELECT RAW list\r\nFROM CURL(\"https:\/\/api.github.com\/users\/ikandaswamy\/repos\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\"header\":\"User-Agent: ikandaswamy\"}) list) s;<\/pre>\n
\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"clone_url\": \"https:\/\/github.com\/ikandaswamy\/ds-algo.git\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"clone_url\": \"https:\/\/github.com\/ikandaswamy\/github-cheat-sheet.git\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"clone_url\": \"https:\/\/github.com\/ikandaswamy\/jsapp.git\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n
\uc694\uc57d<\/b><\/p>\n
\uc704\uc758 \uc608\uc81c\uc5d0\uc11c \ubcfc \uc218 \uc788\ub4ef\uc774, \uc774\uc81c N1QL \uc0ac\uc6a9\uc790\ub294 CURL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacb0\uacfc\ub97c JSON \ud615\uc2dd\uc73c\ub85c \ubc18\ud658\ud558\ub294 \ubaa8\ub4e0 \uc678\ubd80 API\uc640 \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ub9ce\uc740 \uac00\ub2a5\uc131\uc744 \uc5f4\uc5b4\uc90d\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 Couchbase\uc5d0 \uc5ec\ub7ec \ud638\ud154\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0 Google \uc9c0\ub3c4 API\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01 \ud638\ud154\uc758 \uc778\uadfc \uc704\uce58\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
CURL()\uc744 \ucd94\uac00\ud558\uc5ec \uc548\uc804\ud55c \ud658\uacbd\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574 \uc5ec\ub7ec \uac00\uc9c0 \ubcf4\uc548 \uac15\ud654 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uac04\ub2e8\ud55c \ubaa9\ub85d\uc785\ub2c8\ub2e4.<\/span><\/p>\n