Forum Discussion

JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago

JavaScript API_DoQuery failing to give the proper xml response

function getAndSetList() { var url = "blahblah"; getPerm(); $.get(url, { act: "API_DoQuery", query: "{66.IR.'last wk'}", clist: "66" }).then(function(xm...
APIs and custom code
UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
7 years ago
What type of field is  [End Mileage] ? is it a text field, or numeric, or date? If it is not a text field, then it will never return anything, since you are searching for text: 'last wk'.
If it is a text field, then maybe last week, there were no records. I would test this by putting in other text, like 'last month' or 'two weeks' or any other responses this field may have. It may be possible that it isn't returning anything due to that. 
JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago
No, I am using QuickBase's relative date ranges. IR is (Is During), and 'last wk' is a built in command with their API based on the documentation