SharePoint REST API Limitation

Workaround #2

This kind of problem can be solved, using CAML query. For it, we will have to make a POST request in the end-point, mentioned below.
The request body is mentioned below.
$filter does not work with Multi Valued column

$filter also does not work with the multi valued columns like multiple choices and multi valued user type columns.

Workaround #3

It’s similar to my previous workaround. We will have to make a POST request and request body will be a CAML query. See workaround #2.

Term Store Management is not supported

There is no end-point to manage Term Store in REST API.

Workaround #4

Using JSOM or CSOM, we can manage Term Store. Find JSOM API reference in MSDN.

Maximum URL length GET request

In GET request, maximum URL length is 260 characters. In SharePoint On Premise, we can modify this value from web.config file but in SharePoint online, there is no way.

Workaround #5

In most cases, I have noticed that URL length crosses the 260 characters because of $filter and $select query. Thus, we can solve this issue, using POST request and CAML query. See workaround #2.

Date Time functions are not supported

As per OData protocol, DateTime type column should support day(), month(), year(), hour(), minute() and second() function but /_api/web endpoint does not support it.

Workaround #6

The old end-point /_vti_bin/listdata.svc supports these functions. This end-point was first introduced in SharePoint 2010. It still works in later SharePoint versions as well. An example is mentioned below.
$batch request support

Batch request only works with SharePoint online and SharePoint 2016 (On Premise). In SharePoint 2013, it does not work.

Workaround #7

In some cases, we can solve this issue, using JSOM. My idea is that we can use clientContext.load() as many as we need and finally we can call clientContext.executeQueryAsync(). As a result, the single request will be made to the Server.

Conclusion

The issues, mentioned above are faced in different times and I tried to solve them in this way. If you are familiar with any limitations, please leave a comment. It will help me to update this article.