Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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