JSON from API call not returning all results
Hi Team, I have made API call in postman to fetch the results from general enquiry but the number of rows I am getting in the in MYOB UI are different (35224) vs json from api call(35213). Can I...
Forum Discussion
Hi psn55 ,
I'm not familiar with that exact issue, but my suspicions are either:
- Does your API user have the same roles/restriction groups as the user you're accessing the UI through?
The most common reason for different data is that the API is obeying all of the restrictions from the security context of the API user. I'd check these first to see if a like-for-like setup resolves your issue. - Assuming your API User and UI user have the same security context, I'd be looking to compare the records themselves to see if there's a difference. This is more to do with my background as a SQL developer/support team member and that being the second place I check.
- Are any of the records deleted? GI's can be configured to show deleted records, but that flag might be getting missed from your API call?
Ditto for any other filters in the GI, I've not seen your exact calls to compare.
As always, API work can get pretty technical, I recommend talking to your implementation consultant if you're getting stuck.