Python Shareplum getListItems query

Question

Looking for direction with Python & Shareplum.

I am trying to run the following query (very much from the shareplum document),


fields = ['ID', 'Title', 'RaceDate', 'RaceNumber']
    query = {'Where': ['And', 
                        ('Eq', 'Title', location),
                        ('Eq', 'RaceDate', current_date),
                        ('Eq', 'RaceNumber', raceNumber)]}
    sp_raceChecklist_query = sp_raceChecklist.GetListItems(fields=fields, query=query)

however i get the following error: shareplum.errors.ShareplumRequestError: Shareplum HTTP Post Failed : 500 Server Error: Internal Server Error for url: https://tsite.com/sites/list//_vti_bin/lists.asmx

The thing is that if my query has only to arguments, it works. So for example, this works:

fields = ['ID', 'Title', 'RaceDate', 'RaceNumber']
    query = {'Where': ['And', 
                        ('Eq', 'Title', location),
                        ('Eq', 'RaceNumber', raceNumber)]}
    sp_raceChecklist_query = sp_raceChecklist.GetListItems(fields=fields, query=query)

Is my where query incorrect when trying to qualify against three columns? Or is it not supported?

Thank you in advance.

score 0 · Accepted Answer · edited Sep 05 '21 at 15:09

0

I figured it out

query = {'Where': ['And', ('Eq', 'Title', location),
                        'And',  ('Eq', 'RaceDate', current_date),
                                ('Eq', 'RaceNumber', raceNumber)]}

Just didn't look hard enough :-(

edited Sep 05 '21 at 15:09

Wai Ha Lee

8,598
83
57
92

answered Sep 04 '21 at 20:19

MdM

81
2
9

Python Shareplum getListItems query

1 Answers1