Sub hhh()
Dim x As MSXML2.XMLHTTP60
Set x = New MSXML2.XMLHTTP60
Dim a As String
Dim data As String
With x
.Open "POST", "https://main.xlbsoft.com/tms/hxl.tms.transportorder.read", False
.setRequestHeader "Content-Type", "application/json"
.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36"
.setRequestHeader "Cookie", "有的"
data = "{transport_order_id:'TS6655500006620',store_id: 6655500039171,store_name: '有数据',}"
.send (data)
a = .responseText
Range("m1") = a
End With
End Sub
抓出来的结果是这个:{"timestamp":"2024-08-29 21:24:30","status":400,"error":"Bad Request","path":"/tms/hxl.tms.transportorder.read"}
不知道是不是data写错了!帮忙指正下!蟹蟹