insertReview

**2023/06/29 : dataVendorId如果没有则可以不传入，默认以reviewId作为dataVendorId** 一条review有两张相关的表，分别是classification_new表(原版的旧表叫classification)以及review_internal_data表，结构如下： create table classification_new ( dataVendorId varchar(255) not null primary key, reviewId int null, glassdoorId varchar(255) null, reviewDateTime datetime null, reviewDetailUrl varchar(255) null, isCurrentJob tinyint(1) null, lengthOfEmployment int null, jobtitle_ref int null, location_ref int null, ratingOverall int null, ratingCareerOpportunities int null, ratingCompensationAndBenefits int null, ratingCultureAndValues int null, ratingSeniorLeadership int null, ratingWorkLifeBalance int null, ratingDiversityAndInclusion int null, ratingBusinessOutlook varchar(255) null, ratingCeo varchar(255) null, ratingRecommendToFriend varchar(255) null, countHelpful int null, countNotHelpful int null ); create table review_internal_data ( dataVendorId varchar(255) not null primary key, reviewId int null, summary text null, pros text null, cons text null, advice text null, other_data json null, constraint fk_classification_new foreign key (dataVendorId) references classification_new (dataVendorId) ); classification_new表相比之前的classification表，把classification表中的 ‘data’ 这个json字段内一定存在的一些值放到了表里作为字段。对于‘summary’、‘pros’等review评论文本以及剩下的暂时不对外的值放到了review_internal_data表里。这样用户在调用接口时一般只查询classification_new表，加快了处理速度。这个接口每次只接收一行review数据，在最下方有个示例可以参考使用。

python调用示例 ```python import requests import json url = 'http://medialytics.hku-nft.com/v1/Glassdoor/insertReview' headers = {'Content-Type': 'application/json'} data_dict = { "dataVendorId": "CUSIP1236766", "glassdoorId": -10086, "reviewDetailUrl": "http://jlj~qowne.com/123/guonaw", "__typename": "EmployerReview", "advice": None, "adviceOriginal": None, "cons": "No cons at this time", "consOriginal": None, "countHelpful": 0, "countNotHelpful": 0, "divisionLink": None, "divisionName": None, "employer": { "__ref": "Employer:100" }, "employerResponses": [], "employmentStatus": "REGULAR", "isCovid19": False, "isCurrentJob": True, "isLanguageMismatch": False, "isLegal": True, "jobEndingYear": None, "jobTitle": { "__ref": "JobTitle:20346" }, "languageId": "eng", "lengthOfEmployment": 0, "location": None, "originalLanguageId": None, "pros": "Leadership is amazing. Communication is great.", "prosOriginal": None, "ratingBusinessOutlook": "POSITIVE", "ratingCareerOpportunities": 5, "ratingCeo": "APPROVE", "ratingCompensationAndBenefits": 5, "ratingCultureAndValues": 5, "ratingDiversityAndInclusion": 5, "ratingOverall": 5, "ratingRecommendToFriend": "POSITIVE", "ratingSeniorLeadership": 5, "ratingWorkLifeBalance": 5, "reviewDateTime": "2023-04-07T12:18:49.053", "reviewId": 752913589, "summary": "Great job!", "summaryOriginal": None, "topLevelDomainId": 1, "translationMethod": None } data = { "api_key": "kMTth6GAtWDCUohrTwjosQwIT58p8oBYl831uMQKyY9dh73J", "data_dict": data_dict } response = requests.post(url, headers=headers, data=json.dumps(data)) print(response.status_code) print(response.json()) ``` 返回值示例： ```language { "data": "insert success", "message": "success", "status": 200 } ```

insertReview

接口描述

使用说明

请求参数

参数名

类型

描述

必填

响应参数

参数名

类型

描述

必填

示例