Simple get rows filter in SQL returning empty

[Anonymous]

Hello,

Not sure why this is happening and can't figure it out but im using a simple get rows odata filter and it returns empty even though I know the value exist. Any ideas?

If I take the top 20 rows, one of them I know is a return of property ID of p0503

If I filter on that row it's returning nothing

Thanks!

[Anonymous · Accepted solution]

I was able to get this working by using the column name without the brackets. So Property_x0020_ID instead of [Property ID].