Code: Select all
req := ComObjCreate("Msxml2.XMLHTTP")
req.open("GET", "https://mysite/_api/Web/Lists/GetByTitle('My Title')/items?$select=id,Title,Facility,SSN,Last_Name,NewColumn1,Urgent ne '' and startswith(Title, '20211215-123019')", false)
req.SetRequestHeader("Content-Type", "application/json;odata=verbose")
req.send()
clipboard := req.ResponseText
ClipWait, 1
MsgBox % clipboard
I copy the number to the clipboard prior to running and confirm the number is indeed on my clipboard using a MsgBox.
Code: Select all
Ltitle := clipboard
req.open("GET", "https://mysite/_api/Web/Lists/GetByTitle('My Title')/items?$select=id,Title,Facility,SSN,Last_Name,NewColumn1,Urgent ne '' and startswith(Title, '%Ltitle%')", false)