Node.js Backend for Azure Mobile App Android Client - Limitation of 50 Rows

Frontend and Backend Development
1

I’m facing challenges with retrieving more than 50 rows from my Azure Mobile App. I’ve attempted the following approaches without success:

  1. Used Top(100) and Skip(100) – which isn’t applicable to my situation.
  2. Followed a suggestion to modify the pageSize to 200 in the app.js file, but it still limits me to 50 rows.

Can anyone provide guidance on how I can overcome this limitation? Thank you in advance.

  • Sankar
2

hey Sankar! check the server-side settings for maxPageSize. it’s a server limit, maybe it’s defaulted to 50. try modifying that and redeploy. might solve ur issue. good luck!

3

have you looked into using server-side scripts to handle large datasets? maybe azure’s query options have limitations u could workaround with some custom logic. what’s ur setup like now, and how big are the datasets you usually work with? :eyes: let’s brainstorm some solutions together!

4

From my personal experience, you might want to explore leveraging server-side pagination and caching mechanisms for efficient data retrieval. Azure Mobile Services is quite flexible, and server-side pagination would allow you to load data in chunks while managing memory more effectively. Additionally, consider checking if there are any constraints imposed by any middleware or custom API proxies that might be limiting the row count. Ensure any API calls you make have the appropriate permissions to fetch the desired volume of data.

5

consider checking the client-side table.access permissions too, sometimes they restrict data access. u might be able to adjust those settings in the azure portal to get more rows. hope this helps a bit! :crossed_fingers: