So I was following the instructions listed in these sites to build a proper query:
However, when I ran the following query, I got the infamous error object object error. In the below, PlNo and DgNo exists in SOMETHING table, so that is not the issue.
siteurl + "/_api/web/lists/getbytitle('SOMETHING')/items?$ top=5000&$ filter=(PlNo eq 1000) or (PlNo eq 1002)&$ orderby=DgNo asc"
I tried this as well, and it works:
siteurl + "/_api/web/lists/getbytitle('SOMETHING')/items?$ top=5000"
So I thought, maybe it is the & that is wrong, so I went forward and did the below:
siteurl + "/_api/web/lists/getbytitle('SOMETHING')/items?$ filter=(PlNo eq 1000)
But that gave me the same error message (Error object Object), which means “filter” is wrong. But really, the last statement is no different from this snippet below that I extracted from link #2. What am I missing here or misunderstood? Or is it a bug?
So after some additional testing, I determined that this sometimes crashes with [Error, object object] potentially due to a timeout issue? It crashed sometimes, but if I reload it and trace the code line by line it doesn’t happen. But after a while it pops up again and then it goes… Scratching my head here.
The first statement never worked and I tried doing different things to it to figure out what it is. Will update as I try to find the solution.
_api/web/lists/getByTitle('Books')/items?$ select=Title&$ filter=Author eq 'Mark Twain'&$ top=2
EDIT: For info, the screenshots of the error is shown below:
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
99,9% servers uptime
No usage restrictions
Perfect for SEO
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!