Rest API Explore Get Response always Empty

Fahim_Zare
Tera Contributor

Hello,

 

When I run Rest API Explorer with Get function on the tables in my application in Dev-instance, the result is always empty. This problem only exists for 3 tables and the rest of the tables return the answer totally correct.

With the empty Results the Status Code is 200 OK but the X-Total-Count is 0 though there are 4 Rows in the table!

 

What is wrong with these 3 tables? Is there an ACL issue and if so what is it?

 

Many thanks for your help!

 

Best Regards

Fahimeh

3 REPLIES 3

jasonu
Tera Contributor

Hi - did you ever find a reason that this was happening?  or a solution?  I am having the same issue with some of my REST API calls.  

jasonu
Tera Contributor

There was a before query business rule running on the table that needed to be updated before the REST API user could have access.

Hi Jasonu,

 

thank you for your answer. I didn't find the antwort yet. I only understood, this problem appears, when I add a reference table (for example table x) in my table (for example table y).

When I test Rest API Explorer Get function for table x, it works properly.

When I  I test Rest API Explorer Get function for table y without field reference to table x it works properly too.

But when I add a variable as Reference to table x and test Rest API Explorer for Get, it doesn't work more. 

Have you any idee, where the problem is?

 

Thank you very much.

 

Best Regards

Fahimeh