TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
TmallYoupinSellinOrderOfflineQueryRequest req = new TmallYoupinSellinOrderOfflineQueryRequest();
TmallYoupinSellinOrderOfflineQueryRequest.SellInOrderOfflineReq obj1 = new TmallYoupinSellinOrderOfflineQueryRequest.SellInOrderOfflineReq();
obj1.setIsPy("Y");
obj1.setPageSize(1000L);
obj1.setAreaOrgId(2L);
obj1.setBrandIds(new Long[] { 1 };
);
obj1.setPageNum(1L);
obj1.setCateLevel2Id(1L);
obj1.setStartTime(StringUtils.parseDateTime("2023-11-01 00:00:00"));
obj1.setCateLevel1Id(2L);
obj1.setEndTime(StringUtils.parseDateTime("2023-11-01 00:00:00"));
req.setSellInOrderOfflineReq(obj1);
TmallYoupinSellinOrderOfflineQueryResponse rsp = client.execute(req);
System.out.println(rsp.getBody());

ITopClient client = new DefaultTopClient(url, appkey, secret);
TmallYoupinSellinOrderOfflineQueryRequest req = new TmallYoupinSellinOrderOfflineQueryRequest();
TmallYoupinSellinOrderOfflineQueryRequest.SellInOrderOfflineReqDomain obj1 = new TmallYoupinSellinOrderOfflineQueryRequest.SellInOrderOfflineReqDomain();
obj1.IsPy = "Y";
obj1.PageSize = 1000L;
obj1.AreaOrgId = 2L;
obj1.BrandIds = new long[] { 1 };
;
obj1.PageNum = 1L;
obj1.CateLevel2Id = 1L;
obj1.StartTime = DateTime.Parse(2023-11-01 00:00:00");
obj1.CateLevel1Id = 2L;
obj1.EndTime = DateTime.Parse(2023-11-01 00:00:00");
req.SellInOrderOfflineReq_ = obj1;
TmallYoupinSellinOrderOfflineQueryResponse rsp = client.Execute(req);
Console.WriteLine(rsp.Body);

$c = new TopClient;
$c->appkey = $appkey;
$c->secretKey = $secret;
$req = new TmallYoupinSellinOrderOfflineQueryRequest;
$sell_in_order_offline_req = new SellInOrderOfflineReq;
$sell_in_order_offline_req->is_py="Y";
$sell_in_order_offline_req->page_size="1000";
$sell_in_order_offline_req->area_org_id="2";
$sell_in_order_offline_req->brand_ids="[1]";
$sell_in_order_offline_req->page_num="1";
$sell_in_order_offline_req->cate_level2_id="1";
$sell_in_order_offline_req->start_time="2023-11-01 00:00:00";
$sell_in_order_offline_req->cate_level1_id="2";
$sell_in_order_offline_req->end_time="2023-11-01 00:00:00";
$req->setSellInOrderOfflineReq(json_encode($sell_in_order_offline_req));
$resp = $c->execute($req);

curl -X POST 'http://gw.api.taobao.com/router/rest' \
-H 'Content-Type:application/x-www-form-urlencoded;charset=utf-8' \
-d 'app_key=12129701' \
-d 'format=json' \
-d 'method=tmall.youpin.sellin.order.offline.query' \
-d 'partner_id=apidoc' \
-d 'sign=40DB3D85C6038B3BE5DD6AEF446B08D6' \
-d 'sign_method=hmac' \
-d 'timestamp=2025-12-15+05%3A19%3A47' \
-d 'v=2.0' \
-d 'sell_in_order_offline_req=null'

# -*- coding: utf-8 -*-
import top.api

req=top.api.TmallYoupinSellinOrderOfflineQueryRequest(url,port)
req.set_app_info(top.appinfo(appkey,secret))

req.sell_in_order_offline_req="数据结构示例JSON格式"
try:
	resp= req.getResponse()
	print(resp)
except Exception,e:
	print(e)

pTopRequest pRequest = alloc_top_request();
pTopResponse pResponse = NULL;
pTaobaoClient pClient = alloc_taobao_client(url, appkey, appsecret);
set_api_name(pRequest,"tmall.youpin.sellin.order.offline.query");
add_param(pRequest,"sell_in_order_offline_req","数据结构JSON示例");
pResponse = top_execute(pClient,pRequest,NULL);
printf("ret code:%d\n",pResponse->code);
if(pResponse->code == 0){
	pTopResponseIterator ite = init_response_iterator(pResponse);
	pResultItem pResultItem = alloc_result_item();
	while(parseNext(ite, pResultItem) == 0){
		printf("%s:%s\n",pResultItem->key,pResultItem->value);
	}
	destroy_response_iterator(ite);
	destroy_result_item(pResultItem);
}
destroy_top_request(pRequest);
destroy_top_response(pResponse);
destroy_taobao_client(pClient);

TopClient = require('./topClient').TopClient;
var client = new TopClient({
	'appkey': 'appkey',
	'appsecret': 'secret',
	'REST_URL': 'http://gw.api.taobao.com/router/rest'
});

client.execute('tmall.youpin.sellin.order.offline.query', {
	'sell_in_order_offline_req':'数据结构JSON示例'
}, function(error, response) {
	if (!error) console.log(response);
	else console.log(error);
})

<tmall_youpin_sellin_order_offline_query_response>
    <result>
        <total>6718444</total>
        <pages>67185</pages>
        <first_page>1</first_page>
        <last_page>8</last_page>
        <next_page>2</next_page>
        <page_size>100</page_size>
        <items>
            <long>
                <item_qty>1</item_qty>
                <xcat2_name>洗护</xcat2_name>
                <ind1_id>105</ind1_id>
                <order_id>3519984279411118000</order_id>
                <pay_time>2023-09-13 12:10:03</pay_time>
                <virtual_region_id>500001</virtual_region_id>
                <year>FY24</year>
                <station_mode_name>电器体验店</station_mode_name>
                <city_id>220100</city_id>
                <town_id>220103171</town_id>
                <confirm_paid_amt>214900</confirm_paid_amt>
                <cate_name>洗衣机</cate_name>
                <ds>20230913</ds>
                <xcat1_name>大家电</xcat1_name>
                <state_name>开业中</state_name>
                <ind1_name>消费电子</ind1_name>
                <season>2</season>
                <state>SERVICING</state>
                <station_id>277114</station_id>
                <is_jp>N</is_jp>
                <town_name>合隆镇</town_name>
                <brand_name>Haier/海尔</brand_name>
                <ms>202309</ms>
                <virtual_region_name>经营管理一部</virtual_region_name>
                <is_yushou>N</is_yushou>
                <item_id>66</item_id>
                <cate_level1_name>大家电</cate_level1_name>
                <xcat_group>大家电</xcat_group>
                <month>9月</month>
                <cate_level2_id>350301</cate_level2_id>
                <cate_id>350301</cate_id>
                <brand_id>11</brand_id>
                <large_area_org_name>东北内蒙</large_area_org_name>
                <refund>0</refund>
                <is_ycmb>N</is_ycmb>
                <week>37</week>
                <item_title>大容量变频家用滚筒全自动洗衣机XQG100-BD14126L</item_title>
                <large_area_org_id>702446</large_area_org_id>
                <cate_level2_name>洗衣机</cate_level2_name>
                <special_team_org_id>702879</special_team_org_id>
                <srv_date>20210810</srv_date>
                <gmv>214900</gmv>
                <city_name>长春</city_name>
                <is_stru_itm>N</is_stru_itm>
                <county_org_id>701237</county_org_id>
                <station_name>合隆镇街道天猫优品电器体验店</station_name>
                <mord_id>3519984279474458000</mord_id>
                <is_py>N</is_py>
                <station_mode>1</station_mode>
                <is_wuhuo>N</is_wuhuo>
                <dw_ins_time>1701294348000</dw_ins_time>
                <county_org_name>宽城区服务中心</county_org_name>
                <refund_ord_qty>0</refund_ord_qty>
                <cate_level1_id>50022703</cate_level1_id>
                <open_date>20211008</open_date>
                <gmv_re>214900</gmv_re>
                <pay_ord_qty_re>1</pay_ord_qty_re>
                <special_team_org_name>吉林网格中心</special_team_org_name>
            </long>
        </items>
        <page_num>1</page_num>
    </result>
    <rlt>true</rlt>
    <message>null</message>
    <exception_code>null</exception_code>
</tmall_youpin_sellin_order_offline_query_response>

{
    "tmall_youpin_sellin_order_offline_query_response":{
        "result":{
            "total":6718444,
            "pages":67185,
            "first_page":1,
            "last_page":8,
            "next_page":2,
            "page_size":100,
            "items":{
                "long":[
                    {
                        "item_qty":1,
                        "xcat2_name":"洗护",
                        "ind1_id":105,
                        "order_id":3519984279411118000,
                        "pay_time":"2023-09-13 12:10:03",
                        "virtual_region_id":500001,
                        "year":"FY24",
                        "station_mode_name":"电器体验店",
                        "city_id":220100,
                        "town_id":220103171,
                        "confirm_paid_amt":214900,
                        "cate_name":"洗衣机",
                        "ds":"20230913",
                        "xcat1_name":"大家电",
                        "state_name":"开业中",
                        "ind1_name":"消费电子",
                        "season":"2",
                        "state":"SERVICING",
                        "station_id":277114,
                        "is_jp":"N",
                        "town_name":"合隆镇",
                        "brand_name":"Haier\/海尔",
                        "ms":"202309",
                        "virtual_region_name":"经营管理一部",
                        "is_yushou":"N",
                        "item_id":66,
                        "cate_level1_name":"大家电",
                        "xcat_group":"大家电",
                        "month":"9月",
                        "cate_level2_id":350301,
                        "cate_id":350301,
                        "brand_id":11,
                        "large_area_org_name":"东北内蒙",
                        "refund":0,
                        "is_ycmb":"N",
                        "week":37,
                        "item_title":"大容量变频家用滚筒全自动洗衣机XQG100-BD14126L",
                        "large_area_org_id":702446,
                        "cate_level2_name":"洗衣机",
                        "special_team_org_id":702879,
                        "srv_date":"20210810",
                        "gmv":214900,
                        "city_name":"长春",
                        "is_stru_itm":"N",
                        "county_org_id":701237,
                        "station_name":"合隆镇街道天猫优品电器体验店",
                        "mord_id":3519984279474458000,
                        "is_py":"N",
                        "station_mode":1,
                        "is_wuhuo":"N",
                        "dw_ins_time":"1701294348000",
                        "county_org_name":"宽城区服务中心",
                        "refund_ord_qty":0,
                        "cate_level1_id":50022703,
                        "open_date":"20211008",
                        "gmv_re":214900,
                        "pay_ord_qty_re":1,
                        "special_team_org_name":"吉林网格中心"
                    }
                ]
            },
            "page_num":1
        },
        "rlt":true,
        "message":"null",
        "exception_code":"null"
    }
}

<error_response>
    <code>50</code>
    <msg>Remote service error</msg>
    <sub_code>isv.invalid-parameter</sub_code>
    <sub_msg>非法参数</sub_msg>
</error_response>

{
	"error_response":{
		"msg":"Remote service error",
		"code":50,
		"sub_msg":"非法参数",
		"sub_code":"isv.invalid-parameter"
	}
}