Share via

Filtering rest api call by calculated column

Anonymous
2016-06-13T14:45:03+00:00

I am not getting any results when I try to filter by a calculated column/field. The calculated field returns yes/no and it displays YESes and NOs in the view on browser. But when filtered for Yes or No or 1 or 0, I get the HTTP 400 error (webpage not found). Does any one know if it supported at all?

 I have a numeric column called Num and it has integer values. The calculated column IsNumhas this formula in it =Num>10 . So if the Num value is greater than 10 then IsNum returns Yes, otherwise No. This is exactly what I see in the list view, but not working for the REST call

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2016-06-13T23:47:58+00:00

    Hi Aamir,

    For further help about "_api/web/" format, we suggest you post to our MSDN forum which is a specific support channel for the REST API related questions.

    In addition, a related article for your reference:

    https://msdn.microsoft.com/en-us/library/office/jj860569.aspx https://msdn.microsoft.com/en-us/library/office/dn600182.aspx

    Thanks,

    Hale

    Was this answer helpful?

    0 comments No comments