SharePoint REST API is not able to get an item

Question

I have this list inside SharePoint online:-

Now when i write this REST API I will not get the item:-

DestinationItemID2 eq '​b!B_cp4O1z3UWJZwD0nLlCD30PN0T59jBInsAjZKgerapT_CbZ-9oRS7oTEHC0zg-T.01DZCLQ3ZMKDHIM6B27ZHK2POEGQXSSXGX' and ListName eq 'Zoho' and ReadCount eq 2

but if i submit those parameters >> i will get the item:-

DestinationItemID2 eq 'b!B_cp4O1z3UWJZwD0nLlCD30PN0T59jBInsAjZKgerapT_CbZ-9oRS7oTEHC0zg-T.01DZCLQ3ZMKDHIM6B27ZHK2POEGQXSSXGX' and ListName eq 'Zoho'

any advice?

Thanks

Answer 1

Hi @john john Pter,

Thank you for posting in this community.

I tested your first Rest API. I was able to get the items correctly. I checked your Rest API without problems.

I suggest clearing the cache and retesting.

Or I suggest you test your request directly through Internet Explorer, although the return value of the page is hard to read. However, we can read the return value through the Xml parser. This is the most direct way to check if your Rest API is correct. (Since I can't use post man, this is how I tested it.)

Attached is the Rest API I used.

https://{site url}/_api/web/lists/getbytitle('ListName')/items?$filter=(DestinationItemID2 eq 'b!B_cp4O1z3UWJZwD0nLlCD30PN0T59jBInsAjZKgerapT_CbZ-9oRS7oTEHC0zg-T.01DZCLQ3ZMKDHIM6B27ZHK2POEGQXSSXGX') and (ListName eq 'Zoho') and (ReadCount eq 2)

Here is my test result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Ling Zhou_MSFT after 4 hours this is working well