Sharepoint List items returning empty

Question

After getting permissions for Sharepoint Online Site, It is returning empty set(though we could see data) when trying to perform get() operation.

Here is the code snippet:
ctx = ClientContext(test_site_url).with_client_credentials(test_client_id, test_client_secret)

tasks_list = ctx.web.lists.get_by_title("X X X X")

items = tasks_list.items.get().execute_query()

result of items: []

Note: Previously, it gave "'Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))'"; It was resolved after getting permission

Answer 1

Hi @Sankaralingam.DhilipanSomasundaram,

Thank you for posting in this community.

Please try to use this code to get items of a list:

items = tasks_list.get_items()
ctx.load(items)
ctx.execute_query()

print(items)

---

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.