How to retrieve kintone record information in WeChat

Summary

In recent years, more and more people are using WeChat official accounts, and our lifestyles have also undergone tremendous changes.

Kintone is naturally not to be left behind and keeps up with the times.

This article will introduce you to the method of retrieving kintone record information in the WeChat public account.

To put it simply, we will create a new application for managing corporate information in kintone, and then enter keywords in the WeChat official account to retrieve the information in the application.

Since the official public account requires certification, this time we temporarily use the WeChat public account test account.

What it looks like after completion

After the application is successfully created, enter three pieces of data

WeChat public account settings

1. VisitWeChat public platformand click "Enter the WeChat public account test account application system" and apply for the WeChat public account test account

2. Enter the WeChat public test account

for testing In the account management page, we can see the appID and appsecret. Write down these two pieces of information, it will be useful later.

3. Fill in the interface configuration information

This information requires its own server resources. There are many cloud server resources online, and everyone can choose freely.

If you have a server with a public IP, you can also use it. Below we mainly use the PHP environment (the specific server configuration method is omitted)

Next, write the server verification code to make it Can correctly respond to the Token verification sent by WeChat. For details, please refer toAccess Guide.

##Code

class WeChat { private $_appid; private $_appsecret; private $_token; public function __construct($appid, $appsecret, $token) { $this->_appid = $appid; $this->_appsecret = $appsecret; $this->_token = $token; } public function valid() { $echoStr = $_GET["echostr"]; //valid signature , option if($this->checkSignature()) { echo $echoStr; exit; } } private function checkSignature() { $signature = $_GET["signature"]; $timestamp = $_GET["timestamp"]; $nonce = $_GET["nonce"]; $token = $this->_token; $tmpArr = array($token, $timestamp, $nonce); sort($tmpArr); $tmpStr = implode( $tmpArr ); $tmpStr = sha1( $tmpStr ); if( $tmpStr == $signature ) { return true; } else { return false; } } }

php documentationandkintone API: Get records in batches (specify conditions in the query).

All codes can be viewed here

WeChat public platform technical documentation

valid(); //Token验证 ?>

// 请求头部 $header = array( "Host: " . $this->_subDomain . ".cybozu.com:443", "X-Cybozu-API-Token: " . $this->_apiToken ); $queryStr = 'company like "'. $keyword. '"'; $params = "?app=$this->_appId&query=".urlencode($queryStr) . "&fields[0]=". urlencode("company") . "&fields[1]=". urlencode("representative") . "&fields[2]=". urlencode("area") . "&fields[3]=". urlencode("address") . "&fields[4]=". urlencode("tel"); $url = "https://" . $this->_subDomain . ".cybozu.com/k/v1/records.json". $params; $response = $this->_request($url, true, "get", null, $header); //curl提交 $result = json_decode($response, true); if (count($result["records"]) > 0) { foreach($result["records"] as $value) { if ($contentStr != '') { $contentStr .= "\n\n"; } $contentStr .= "公司名：". $value["company"]["value"]."\n" . "公司代表：". $value["representative"]["value"]."\n" . "地域：". $value["area"]["value"]."\n" . "所在地：". $value["address"]["value"]."\n" . "电话：". $value["tel"]["value"]; } } else { $contentStr = "未找到该企业信息"; }

The above is the detailed content of How to retrieve kintone record information in WeChat. For more information, please follow other related articles on the PHP Chinese website!