KT call URL -
sample queries -
select msg_source,fps_id,esmeaddr,acode,cust_send,send,dest,mid,file_id,logicid,country,operator,circle,dcs,split_msg_parts,split_msg_part_no,msg,submit_routeid,routeid,sdate,stime,dtime,delive_latency_sla_sec,plat_latency_sla_millis,sub_status,sub_status_flag,dn_status,dn_status_flag,reason,carrier_sys_id,carrier_ackid,carrier_full_dn,err,dlt_template_id,entity_id,cust_ip,udh,vp,message_journey,api_source,cust_mid,msgtag,tag1,tag2,tag3,tag4,tag5,tag6,tag7,tag8,tag9,tag10,tag11,tag12,tag13,tag14,tag15,tag16,tag17,tag18,tag19,tag20 from billing.sms_log where sdate between {str} and {str} and esmeaddr IN ({list-str}) order by stime desc limit {num} offset 100000
select msg_source,fps_id,esmeaddr,acode,cust_send,send,dest,mid,file_id,logicid,country,operator,circle,dcs,split_msg_parts,split_msg_part_no,msg,submit_routeid,routeid,sdate,stime,dtime,delive_latency_sla_sec,plat_latency_sla_millis,sub_status,sub_status_flag,dn_status,dn_status_flag,reason,carrier_sys_id,carrier_ackid,carrier_full_dn,err,dlt_template_id,entity_id,cust_ip,udh,vp,message_journey,api_source,cust_mid,msgtag,tag1,tag2,tag3,tag4,tag5,tag6,tag7,tag8,tag9,tag10,tag11,tag12,tag13,tag14,tag15,tag16,tag17,tag18,tag19,tag20 from billing.sms_log where sdate between {str} and {str} and esmeaddr IN ({list-str}) order by stime desc limit {num}