1828 自由获取一条数据接口 App.Table.FreeFindOne

<?php

// 引入文件
require_once dirname(__FILE__) . '/OkayApiClient.php';

// 调用小白开放接口
$rs = OkayApiClient::request('App.Table.FreeFindOne', array('model_name'=>'telephone','where'=>json_encode(array(array("id",">","1"),array("id",">","3"))),'logic'=>'and'));

// 输出结果
print_r($rs);

/*
Array 
( 
	[ret] => 200 
	[data] => Array 
	( 
		[err_code] => 0 
		[err_msg] => 
		[data] => Array 
		( 
			[id] => 2 
			[uuid] =>
			[add_time] => 2019-02-02 22:49:18 
			[update_time] => 
			[ext_data] => 
			[mobile] => 13902985399 
			[mobile_status] => 1 
		) 
	) 
	
	[msg] => 小白开放接口：App.Table.FreeFindOne 
)
*/

#!/usr/bin/python
#coding=utf-8

import requests
import hashlib

# TODO: 请根据需要，换成您的HOST，app_key和app_secrect
API_URL     = '你的小白接口域名，例如：http://api.okayapi.com/'
APP_KEY     = '你的app_key'
APP_SECRET  = '你的app_secrect'

# 生成签名
def Signature(params, key=None, secret=None):
    key = key or APP_KEY
    secret = secret or APP_SECRET
    params.pop('app_secrect', None)
    params['app_key'] = key
    md5_ctx = hashlib.md5()
    md5_ctx.update(''.join([params[value] for value in sorted([key for key in params])]) + secret)
    return md5_ctx.hexdigest().upper()
    

# 调用小白开放接口
def HTTPGet(url, params):
    params['sign'] = Signature(params)
    resp = requests.get(url, params)
    return resp.json()


def main():
    # 待请求的接口与相关参数（根据需要，可动态调整请求参数）
    params = {
        's': 'App.Table.FreeFindOne',
        'model_name': 'okayapi_message',
        'logic': 'or',
        'where': json.dumps([['message_nickname', '=', 'hehe'], ['message_key', '=', 'a']])
    }

    # 发起请求
    return HTTPGet(API_URL, params)


pprint.pprint(main())

# {u'data': {u'data': {u'add_time': u'2019-01-31 15:11:20',
#                      u'ext_data': None,
#                      u'id': u'4',
#                      u'message_content': u'<p><img src="http://img.baidu.com/hi/jx2/j_0002.gif"/></p><p>wala</p><pre class="brush:cpp;toolbar:false">#include&nbsp;&lt;stdio.h&gt;</pre><p><br/></p>',
#                      u'message_key': u'a',
#                      u'message_nickname': u'hehe',
#                      u'message_pid': u'0',
#                      u'message_post_time': u'0000-00-00 00:00:00',
#                      u'update_time': None,
#                      u'uuid': u''},
#            u'err_code': 0,
#            u'err_msg': u''},
#  u'msg': u'\u5f53\u524d\u5c0f\u767d\u63a5\u53e3\uff1aApp.Table.FreeFindOne',
#  u'ret': 200}