-
Notifications
You must be signed in to change notification settings - Fork 0
/
openapi_org_cd.py
45 lines (32 loc) · 1.31 KB
/
openapi_org_cd.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
import requests
from bs4 import BeautifulSoup
from pymongo import MongoClient
from dotenv import load_dotenv
import os
load_dotenv()
mongodb_URL = os.environ.get('mongodbURL')
client = MongoClient(mongodb_URL)
db = getattr(client, os.environ.get('DB_NAME')) #"test"
API_Key = os.environ.get("ApiKey")
page = 1
URL = "http://apis.data.go.kr/1543061/abandonmentPublicSrvc/sido?numOfRows=1000&pageNo={Page}&serviceKey={API}".format(Page=page, API=API_Key)
rq = requests.get(URL)
soup = BeautifulSoup(rq.text, "html.parser")
totalCnt = int(soup.find("totalcount").text)
print(totalCnt)
pageCnt = int(totalCnt/1000) + 1
print(pageCnt)
for item in soup.find_all("item"):
orgCd = item.find("orgcd").text
orgdownNm = item.find("orgdownnm").text
db.orgCd.insert_one({"orgCd": orgCd, "orgdownNm": orgdownNm })
if totalCnt > 1000:
while page < pageCnt:
page += 1
URL = "http://apis.data.go.kr/1543061/abandonmentPublicSrvc/sido?numOfRows=1000&pageNo={Page}&serviceKey={API}".format(Page=page, API=API_Key)
rq = requests.get(URL)
soup = BeautifulSoup(rq.text, "html.parser")
for item in soup.find_all("item"):
orgCd = item.find("orgcd").text
orgdownNm = item.find("orgdownnm").text
db.orgCd.insert_one({"orgCd": orgCd, "orgdownNm": orgdownNm })