获取案件列表 API 接口 - 智能化催收系统

let url = 'https://icmp.zhilingxingchen.com/collection-v2/api/omega/cf-collection/', headers = [ #'Content-Type' = 'application/json', Cookie = 's_v_web_id=verify_lhxb5pym_2yznMMNM_Nmmh_40E3_8Tqx_mJbOAIkkwp3s; passport_csrf_token=cc945399e4de891907fe153d870ddc6c; passport_csrf_token_default=cc945399e4de891907fe153d870ddc6c; n_mh=GSIKU7ioW0UTAM5IEpPHkirPTRyu6EOAWi9WptTr_3U; sid_guard=b6aec423b72f6d33ff5cb68eacd082b4|1684666880|43200|Sun,+21-May-2023+23:01:20+GMT; uid_tt=1e74a19ea294a216d9882631bee104a2; uid_tt_ss=1e74a19ea294a216d9882631bee104a2; sid_tt=b6aec423b72f6d33ff5cb68eacd082b4; sessionid=b6aec423b72f6d33ff5cb68eacd082b4; sessionid_ss=b6aec423b72f6d33ff5cb68eacd082b4; sid_ucp_v1=1.0.0-KDM5OGM4MmM2Y2RhZjc3MzdiMWMyY2U2ODY3ZWUyNzcxMGYxODhlMmUKEQj3ARCA9KejBhjFNTgEQOoHGgJsZiIgYjZhZWM0MjNiNzJmNmQzM2ZmNWNiNjhlYWNkMDgyYjQ; ssid_ucp_v1=1.0.0-KDM5OGM4MmM2Y2RhZjc3MzdiMWMyY2U2ODY3ZWUyNzcxMGYxODhlMmUKEQj3ARCA9KejBhjFNTgEQOoHGgJsZiIgYjZhZWM0MjNiNzJmNmQzM2ZmNWNiNjhlYWNkMDgyYjQ; store-region=cn-hb; store-region-src=uid; x-icmp-rc=247; x-icmp-cp=jlx' ], query = [query = 'query GetCaseList($data: GetCaseListRequest!) {\n GetCaseList(request: $data) {\n Code\n Message\n Data {\n CaseList {\n RandomDigit\n CaseId\n CustName\n CurQueueId\n OverdueDays\n OverdueAmount\n ReceiveAmount\n CurTeam\n CurCollector\n InTeamTime\n InCollectorTime\n LastActionCode\n LastActionTime\n RepayTotal\n CaseStatus\n OutColDate\n CaseMark\n CaseRemark\n IdNumber\n Gender\n Age\n ProductName\n OverdueStatus\n InColDate\n Loans\n LoanAmount\n ArrearsAmount\n RemainingPrincipal\n OverduePrincipal\n OverdueInterest\n Penalty\n BlockCode\n CurRepayAmount\n LastRepayAmount\n LastRepayTime\n CurPeriodAmount\n CurPeriodPrincipal\n CurPeriodInterest\n DueAmount\n CustType\n DebtTransferStatus\n LastPtpTime\n FxAccountID\n HasDefer\n GraceDate\n SelfCall\n SelfCallEndDate\n ThreePartyCall\n ThreePartyCallEndDate\n }\n TotalCount\n OverdueAmountSum\n ReceiveAmountSum\n CurRepayAmountSum\n RemainingPrincipalSum\n NeedRepayAmountSum\n }\n BaseResp {\n StatusMessage\n StatusCode\n Extra {\n key\n value\n }\n }\n }\n}', variables = [data = [ProductCodeSearch = '10000', QueueSearch = 'S2', OverdueDaysStartSearch = '', OverdueDaysEndSearch = '', OverdueStatusStartSearch = '', OverdueStatusEndSearch = '', OvdAmountStartSearch = '', OvdAmountEndSearch = '', RepayDayStartSearch = '', RepayDayEndSearch = '', CaseMarkerSearch = '', CurTeamSearch = '', CurCollectorSearch = '', CaseFlagSearch = [], InTeamTimeStartSearch = '', InTeamTimeEndSearch = '', InCollectorTimeStartSearch = '', InCollectorTimeEndSearch = '', LastActionTimeStartSearch = '', LastActionTimeEndSearch = '', LastActionCodeSearch = [], CaseStatusSearch = '', LawLetterStatusSearch = '', OutColDateStartSearch = '', OutColDateEndSearch = '', RemainingPrincipalStartSearch = '', RemainingPrincipalEndSearch = '', OverdueDaysOrderType = '', OverdueAmountOrderType = '', ReceiveAmountOrderType = '', LastRepayTimeOrderType = '', LastActionTimeOrderType = '', InTeamTimeOrderType = '', InCollectorTimeOrderType = '', RemainingPrincipalOrderType = '', LastAIResultSearch = '', LastAITimeStartSearch = '', LastAITimeEndSearch = '', PageNo = '1', PageSize = '20', CaseIdSearch = '']]], content = '{'query':'query GetCaseList($data: GetCaseListRequest!) {\n GetCaseList(request: $data) {\n Code\n Message\n Data {\n CaseList {\n RandomDigit\n CaseId\n CustName\n CurQueueId\n OverdueDays\n OverdueAmount\n ReceiveAmount\n CurTeam\n CurCollector\n InTeamTime\n InCollectorTime\n LastActionCode\n LastActionTime\n RepayTotal\n CaseStatus\n OutColDate\n CaseMark\n CaseRemark\n IdNumber\n Gender\n Age\n ProductName\n OverdueStatus\n InColDate\n Loans\n LoanAmount\n ArrearsAmount\n RemainingPrincipal\n OverduePrincipal\n OverdueInterest\n Penalty\n BlockCode\n CurRepayAmount\n LastRepayAmount\n LastRepayTime\n CurPeriodAmount\n CurPeriodPrincipal\n CurPeriodInterest\n DueAmount\n CustType\n DebtTransferStatus\n LastPtpTime\n FxAccountID\n HasDefer\n GraceDate\n SelfCall\n SelfCallEndDate\n ThreePartyCall\n ThreePartyCallEndDate\n }\n TotalCount\n OverdueAmountSum\n ReceiveAmountSum\n CurRepayAmountSum\n RemainingPrincipalSum\n NeedRepayAmountSum\n }\n BaseResp {\n StatusMessage\n StatusCode\n Extra {\n key\n value\n }\n }\n }\n}','variables':{'data':{'ProductCodeSearch':'10000','QueueSearch':'S2','OverdueDaysStartSearch':'','OverdueDaysEndSearch':'','OverdueStatusStartSearch':'','OverdueStatusEndSearch':'','OvdAmountStartSearch':'','OvdAmountEndSearch':'','RepayDayStartSearch':'','RepayDayEndSearch':'','CaseMarkerSearch':'','CurTeamSearch':'','CurCollectorSearch':'','CaseFlagSearch':[],'InTeamTimeStartSearch':'','InTeamTimeEndSearch':'','InCollectorTimeStartSearch':'','InCollectorTimeEndSearch':'','LastActionTimeStartSearch':'','LastActionTimeEndSearch':'','LastActionCodeSearch':[],'CaseStatusSearch':'','LawLetterStatusSearch':'','OutColDateStartSearch':'','OutColDateEndSearch':'','RemainingPrincipalStartSearch':'','RemainingPrincipalEndSearch':'','OverdueDaysOrderType':'','OverdueAmountOrderType':'','ReceiveAmountOrderType':'','LastRepayTimeOrderType':'','LastActionTimeOrderType':'','InTeamTimeOrderType':'','InCollectorTimeOrderType':'','RemainingPrincipalOrderType':'','LastAIResultSearch':'','LastAITimeStartSearch':'','LastAITimeEndSearch':'','PageNo':'1','PageSize':'20','CaseIdSearch':''}}}', options = [ Headers = headers, Query = query, Content = Text.ToBinary(content) ], web = Text.FromBinary(Web.Contents(url, options)) in web