I'm having trouble getting the filter right in the OData filter query:
The column name in the Sharepoint list is
Opp Status (Win Loss)
This is what I am looking for:
Opp Status (Win Loss) eq 'Open'
I've tried:
Opp_x0020_Status_x0020_(Win_x0020_Loss)
OppStatus(WinLoss)
'Opp Status (Win Loss)' eq 'Open'
both come back with the below error:
The query is not valid.