koubei.marketing.campaign.activity.batchquery(口碑营销活动列表查询)java版

简介: 说明: 本帖是利用支付宝正式环境测试账号测试口碑营销活动列表查询接口,请求中根据文档传入了必传参数,大家可以配置自己的环境,根据自己的需求严格按照文档要求添加相关的可选参数,此demo仅供参考 测试环境:Eclipse+JDK1.6及以上+Tomcat6.0及以上     当开发者需要提供按一定条件批量查询功能时,可以使用口碑营销活动列表查询接口,下面以活动起止时间为例批量查询活动。

说明: 
本帖是利用支付宝正式环境测试账号测试口碑营销活动列表查询接口,请求中根据文档传入了必传参数,大家可以配置自己的环境,根据自己的需求严格按照文档要求添加相关的可选参数,此demo仅供参考 
测试环境:Eclipse+JDK1.6及以上+Tomcat6.0及以上     
当开发者需要提供按一定条件批量查询功能时,可以使用口碑营销活动列表查询接口,下面以活动起止时间为例批量查询活动。 
koubei.marketing.campaign.activity.batchquery(口碑营销活动列表查询)接口示例代码 

package com.alipay.demo;  import java.util.ArrayList;import java.util.List;  import com.alipay.api.AlipayApiException;import com.alipay.api.AlipayClient;import com.alipay.api.DefaultAlipayClient;import com.alipay.api.domain.Condition;import com.alipay.api.domain.KoubeiMarketingCampaignActivityBatchqueryModel;import com.alipay.api.request.KoubeiMarketingCampaignActivityBatchqueryRequest;import com.alipay.api.response.KoubeiMarketingCampaignActivityBatchqueryResponse;import com.alipay.config.AlipayConfig;  public class KoubeiMarketingCampaignActivityBatchquery {      /**     * koubei.marketing.campaign.activity.batchquery 口碑营销活动列表查询     *     * @param args     */    public static void main(String[] args) {        AlipayClient alipayClient = new DefaultAlipayClient(AlipayConfig.gatewayUrl, AlipayConfig.app_id,                AlipayConfig.merchant_private_key, AlipayConfig.format, AlipayConfig.charset,                AlipayConfig.alipay_public_key, AlipayConfig.sign_type);        KoubeiMarketingCampaignActivityBatchqueryRequest request = new KoubeiMarketingCampaignActivityBatchqueryRequest();        KoubeiMarketingCampaignActivityBatchqueryModel model = new KoubeiMarketingCampaignActivityBatchqueryModel();        model.setQueryCriterias(getQueryCriterias());        // 页码,默认为1        // model.setPageNumber("1");        // 操作人id,必须和operator_type配对存在,不填时默认是商户        // model.setOperatorId(operatorId);        // 操作人类型,有以下值可填:MER(外部商户),MER_OPERATOR(外部商户操作员),        // PROVIDER(外部服务商),PROVIDER_STAFF(外部服务商员工),默认不需要填这个字段,默认为MER        // model.setOperatorType("MER");        // 页大小,默认为20        // model.setPageSize("10");        request.setBizModel(model);        KoubeiMarketingCampaignActivityBatchqueryResponse response;        try {            response = alipayClient.execute(request);            if (response.isSuccess()) {                System.out.println("调用成功");                System.out.println(response.getBody());            } else {                System.out.println("调用失败");                System.out.println(response.getBody());            }          } catch (AlipayApiException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }      }      /**     * 查询条件     *     * @return     */    private static List getQueryCriterias() {        List queryCriteriasList = new ArrayList();        Condition condition = new Condition();        // 字段名称,目前支持以下字段:        // name: 活动名称        // startTime: 开始时间        // endTime: 结束时间        // status:活动状态        condition.setFieldName("status");        // 对应于field_name的字段值,当field_name为status时,field_value支持STARTED、        // STARTING、MODIFYING、CLOSED、CLOSING、DISABLED几种值,用|分隔,代表查询这些状态中的活动,        // 此时operator只能为IN,field_name为name时候value表示要查询的活动名,        // field_name为时间时,field_value为开始或结束时间,格式如2016-10-01 00:00:00        condition.setFieldValue("STARTING|STARTED");        // 操作符,EQUAL:等于,IN:范围。目前支持field_name=status且operator=IN,多个状态以"|"分隔        condition.setOperator("IN");        queryCriteriasList.add(condition);        return queryCriteriasList;    }  }

 

请求参数注意事项: 
1.app_auth_token:ISV/开发者可以通过第三方应用授权:[url]https://openclub.alipay.com/read.php?tid=1649[/url]得到商家授权令牌(app_auth_token)作为请求参数传入,实现代商家发起请求的能力 
调用成功返回信息:

{"koubei_marketing_campaign_activity_batchquery_response":{"code":"10000","msg":"Success","camp_sets":[{"activity_orders":[{"creator_id":"mpromocenter-40-5217","creator_type":"SYSTEM","order_id":"20180314000000010097427000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180314000000010239345000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-13 00:00:00","id":"20180314000000002577674000151339","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"STARTED","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180314000000009958268000155335","order_status":"DOING","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-49-5009","creator_type":"SYSTEM","order_id":"20180314000000010015838000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180314000000010009890000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-15 00:00:00","id":"20180314000000002549728000151335","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"MODIFYING","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180314000000009986135000155339","order_status":"DOING","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-49-5014","creator_type":"SYSTEM","order_id":"20180314000000010173068000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180314000000010174038000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-15 00:00:00","id":"20180314000000002574688000151336","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"MODIFYING","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010090676000155337","order_status":"DOING","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-40-5221","creator_type":"SYSTEM","order_id":"20180313000000010035702000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010162099000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-15 00:00:00","id":"20180313000000002622163000151339","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"MODIFYING","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010220307000155337","order_status":"DOING","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-40-5215","creator_type":"SYSTEM","order_id":"20180313000000010089680000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000009936206000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-15 00:00:00","id":"20180313000000002591874000151339","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"MODIFYING","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010220306000155335","order_status":"DOING","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-40-5206","creator_type":"SYSTEM","order_id":"20180313000000010165072000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010169004000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-15 00:00:00","id":"20180313000000002609464000151332","name":"口碑门店消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"MODIFYING","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-40-5218","creator_type":"SYSTEM","order_id":"20180313000000010018974000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000010141093000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-13 00:00:00","id":"20180313000000002536752000151339","name":"消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"STARTED","type":"RECHARGE_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-49-5023","creator_type":"SYSTEM","order_id":"20180313000000010200310000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180313000000009869577000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-13 00:00:00","id":"20180313000000002587837000151330","name":"消费满10元送1元代金券","start_time":"2018-03-13 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-40-5213","creator_type":"SYSTEM","order_id":"20180308000000009935451000155332","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180308000000010044073000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-07 00:00:00","id":"20180308000000002545682000151338","name":"消费满10元送1元代金券","start_time":"2018-03-07 00:00:00","status":"STARTED","type":"REAL_TIME_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-40-5211","creator_type":"SYSTEM","order_id":"20180307000000009947601000155330","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180307000000009825124000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-07 00:00:00","id":"20180307000000002546625000151334","name":"消费满10元送1元代金券","start_time":"2018-03-07 00:00:00","status":"STARTED","type":"REAL_TIME_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-40-5195","creator_type":"SYSTEM","order_id":"20180307000000009901971000155332","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180307000000009752531000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-07 00:00:00","id":"20180307000000002599555000151334","name":"消费满10元送1元代金券","start_time":"2018-03-07 00:00:00","status":"STARTED","type":"REAL_TIME_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-49-5025","creator_type":"SYSTEM","order_id":"20180307000000009777278000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180307000000009937642000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-27 00:00:00","id":"20180307000000002561076000151336","name":"西瓜测试一次性购买四个,买三送一","start_time":"2017-04-01 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-49-5015","creator_type":"SYSTEM","order_id":"20180307000000009935662000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180307000000009884779000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-05-27 00:00:00","id":"20180307000000002506757000151333","name":"西瓜测试一次性购买四个,买三送一","start_time":"2017-04-01 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"mpromocenter-40-5195","creator_type":"SYSTEM","order_id":"20180302000000009758975000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180302000000009607524000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"N","creator_type":"MER","end_time":"2018-06-01 00:00:00","id":"20180302000000002612911000151336","name":"西瓜测试一次性购买四个,买三送一","start_time":"2017-04-01 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180224000000009542416000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180125000000008942167000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171226000000008203802000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171126000000007433793000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171027000000006593043000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170927000000006021861000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-40-5219","creator_type":"SYSTEM","order_id":"20170926000000005907529000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170926000000006004086000155332","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-03-27 00:00:00","id":"20170926000000001740144000151338","name":"消费满1元减1元","start_time":"2017-06-23 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180224000000009608661000155330","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180125000000009115677000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171226000000008196262000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171126000000007573609000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171027000000006495167000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170927000000006022887000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-49-5011","creator_type":"SYSTEM","order_id":"20170926000000006007023000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170926000000006020268000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-03-27 00:00:00","id":"20170926000000001739272000151331","name":"消费满1元减1元","start_time":"2017-06-23 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180221000000009485882000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180122000000008954917000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171223000000008169990000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171123000000007461335000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171024000000006510083000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170924000000005935894000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-49-5023","creator_type":"SYSTEM","order_id":"20170922000000005956645000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170922000000006070353000155330","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-03-24 00:00:00","id":"20170922000000001696813000151338","name":"消费满0.01元送10元兑换券","start_time":"2017-06-23 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180221000000009377238000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180122000000008953916000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171223000000008128251000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171123000000007136528000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171024000000006359592000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170924000000005968299000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-49-5021","creator_type":"SYSTEM","order_id":"20170922000000005894855000155339","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170922000000005925240000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-03-24 00:00:00","id":"20170922000000001723216000151339","name":"消费满0.01元送10元兑换券","start_time":"2017-06-23 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180221000000009624026000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180122000000008917862000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171223000000008222473000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171123000000007347238000155337","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171024000000006449771000155333","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170924000000006000639000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-40-5198","creator_type":"SYSTEM","order_id":"20170922000000006074394000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170922000000006076301000155334","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-03-24 00:00:00","id":"20170922000000001718611000151331","name":"消费满0.01元送10元兑换券","start_time":"2017-06-23 00:00:00","status":"STARTED","type":"DIRECT_SEND"},{"activity_orders":[{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180307000000009807146000155331","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180205000000009334444000155330","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20180106000000008566931000155336","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171207000000007718153000155330","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171107000000006854296000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20171008000000006195069000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_MODIFY_ORDER"},{"creator_id":"mpromocenter-70-6","creator_type":"SYSTEM","order_id":"20170711000000004757433000155338","order_status":"SUCCESS","order_type":"CAMPAIGN_ENABLE_ORDER"},{"creator_id":"2088501624560335","creator_type":"MER","order_id":"20170711000000004756471000155335","order_status":"SUCCESS","order_type":"CAMPAIGN_CREATE_ORDER"}],"auto_delay_flag":"Y","creator_type":"MER","end_time":"2018-04-07 00:00:00","id":"20170711000000001401297000151333","name":"消费满0.01元送10元兑换券","start_time":"2017-07-09 00:00:00","status":"STARTED","type":"CONSUME_SEND"}],"total_number":28},"sign":"G7m9lJicsCZJEw3Xsc2QVkolJXu+l2gLa2vBTQ3H6IqoY7HRYMmJOjAipVIrKTQc7vwA1gt2KzKnuJbiN5XckpUdUX7WlJ9AHH4OlZYmNYWyGhkvSILKvE6ppQMWwVjp7RYCFFw7i6RQe9KkgrNosF2KPkhV0k9lmHkKNzcxGsQ="}

 

如有疑问欢迎跟帖提问,不足之处欢迎多多吐槽!!!

目录
相关文章
|
17天前
|
SQL NoSQL Java
Java使用sql查询mongodb
通过MongoDB Atlas Data Lake或Apache Drill,可以在Java中使用SQL语法查询MongoDB数据。这两种方法都需要适当的配置和依赖库的支持。希望本文提供的示例和说明能够帮助开发者实现这一目标。
37 17
|
19天前
|
SQL Java 数据库连接
【潜意识Java】MyBatis中的动态SQL灵活、高效的数据库查询以及深度总结
本文详细介绍了MyBatis中的动态SQL功能,涵盖其背景、应用场景及实现方式。
70 6
|
2月前
|
SQL NoSQL Java
Java使用sql查询mongodb
通过使用 MongoDB Connector for BI 和 JDBC,开发者可以在 Java 中使用 SQL 语法查询 MongoDB 数据库。这种方法对于熟悉 SQL 的团队非常有帮助,能够快速实现对 MongoDB 数据的操作。同时,也需要注意到这种方法的性能和功能限制,根据具体应用场景进行选择和优化。
96 9
|
3月前
|
SQL Java
使用java在未知表字段情况下通过sql查询信息
使用java在未知表字段情况下通过sql查询信息
52 8
|
4月前
|
SQL Java 关系型数据库
java连接mysql查询数据(基础版,无框架)
【10月更文挑战第12天】该示例展示了如何使用Java通过JDBC连接MySQL数据库并查询数据。首先在项目中引入`mysql-connector-java`依赖,然后通过`JdbcUtil`类中的`main`方法实现数据库连接、执行SQL查询及结果处理,最后关闭相关资源。
374 6
|
8月前
自适应IT互联网营销企业网站pbootcms模板
一款蓝色自适应IT互联网营销企业网站pbootcms模板,该模板采用响应式设计,可自适应手机端,适合一切网络技术公司、互联网IT行业,源码下载,为您提供了便捷哦。
75 2
|
SQL 数据采集 运维
《实时数仓助力互联网实时决策和精准营销》|学习笔记
快速学习《实时数仓助力互联网实时决策和精准营销》
266 0
|
Web App开发 监控
从AIPL到GROW,谈互联网大厂的营销分析模型
上一篇《一文看懂:搭建活动分析体系》分享以后,有小伙伴问:那做活动分析,是不是也有模型呢?答:不但有,而且很多。而且互联网大厂尤其热衷于创造新模型,以至于每年都有新词冒出来,诸如:AIPL、FAST、GROW、RISE、5A……等等,看得人头晕目眩。今天就跟大家简单聊聊这些营销模型背后的底层逻辑。
529 0
从AIPL到GROW,谈互联网大厂的营销分析模型
|
存储 缓存 搜索推荐
聊聊互联网营销的第4门功课(详细)
本文面向对互联网营销技术领域感兴趣的人群,介绍广告投放系统的背景,设计和实现
1558 0
聊聊互联网营销的第4门功课(详细)