[Python] Shareplum: Queries do not support DateTime variables

Discussão em 'Python' iniciado por Stack, Abril 14, 2025.

  1. Stack

    Stack Membro Participativo

    Shareplum is unable to retrieve entries from a Sharepoint list using DateTime variables (for example, to find entries that were modified after a certain date).

    Code:

    from requests_negotiate_sspi import HttpNegotiateAuth
    from shareplum import Site
    import datetime

    site = Site("sharepoint.com", version=Version.v2016, auth=HttpNegotiateAuth())
    date = datetime.datetime(2025, 4, 8, 0, 0, 0)

    query = {'Where' : [('Gt', 'Modified', date)]}
    sp_list = site.List('Sharepoint List')
    data = sp_list.GetListItems('All Items', query=query)


    If a datetime object is provided, the following error occurs:

    TypeError : Argument must be bytes or unicode, got 'datetime'


    If a string/integer is provided, the following error occurs instead:

    Failed to download list items Shareplum HTTP Post Failed : 500 Server Error


    As mentioned in these issues:


    Continue reading...
    Stack, Abril 14, 2025
    #1

Compartilhe esta Página