文档
测试

insertReviewBatch

POST
http://medialytics.hku-nft.com/v1/Glassdoor/insertReviewBatch

接口描述

往数据库的新classification_new表和review_internal_data表插入review列表

使用说明

**2023/06/29 : dataVendorId如果没有则可以不传入,默认以reviewId作为dataVendorId** 类似insertReview接口,不过把data_dict参数换成了data_list,格式可以参考示例

请求参数

参数名
类型
描述
必填
api_key
str
admin权限的key
必填
data_list
list
数据列表,list中的元素为insertReview接口里的data_dict
必填
dataVendorId
新加字段
可选
reviewId
必填
glassdoorId
必填
reviewDetailUrl
新加字段
必填
advice
必填
summary
必填
pros
必填
cons
必填
reviewDateTime
必填
isCurrentJob
必填
lengthOfEmployment
必填
ratingOverall
必填
ratingCareerOpportunities
必填
ratingCompensationAndBenefits
必填
ratingCultureAndValues
必填
ratingSeniorLeadership
必填
ratingWorkLifeBalance
必填
ratingDiversityAndInclusion
必填
ratingBusinessOutlook
必填
ratingCeo
必填
ratingRecommendToFriend
必填
countHelpful
必填
countNotHelpful
必填

响应参数

参数名
类型
描述
必填
status
str
必填
message
str
必填
data
list
必填

示例

python调用示例 ```python import requests import json url = 'http://medialytics.hku-nft.com/v1/Glassdoor/insertReviewBatch' headers = {'Content-Type': 'application/json'} data = { "api_key": "kMTth6GAtWDCUohrTwjosQwIT58p8oBYl831uMQKyY9dh73J", "data_list":[{ "dataVendorId": "CUSIP1234567233", "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": 75291358, "summary": "Great job!", "summaryOriginal": None, "topLevelDomainId": 1, "translationMethod": None },{ "dataVendorId": "CUSIP12349999", "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": 75291358, "summary": "Great job!", "summaryOriginal": None, "topLevelDomainId": 1, "translationMethod": None }] } response = requests.post(url, headers=headers, data=json.dumps(data)) print(response.text) ``` 返回值示例: ```language { "data": "insert success", "message": "success", "status": 200 } ```