I keep getting a max number of requests error in my function
There was a change in how report automation is made and it caused us having to create a custom function in zoho expense. I'm trying to grab all expenses of the month from each user and create a report. However, I'm getting too many API Calls error. How am i able to fix that? try used a try-catch but I was still getting the same error. This is my current code, there are over 100 users.
- userList = List();
- currentMonth = zoho.currentdate;
- firstDay = currentMonth.eomonth(0);
- lastDay = currentMonth.eomonth(-1).addDay(1);
- headerUser = Map();
- headerUser.put("X-com-zoho-expense-organizationid","643169496");
- usersresponse = invokeurl
- [
- url :"https://www.zohoapis.com/expense/v1/users"
- type :GET
- headers:headerUser
- connection:"adminexpense"
- ];
- users = usersresponse.get("users");
- for each person in users
- {
- userID = person.get("user_id");
- userList.add(userID);
- }
- for each ID in userList
- {
- params = Map();
- params.put("user_id",ID);
- params.put("date_start",firstDay);
- params.put("date_end",lastDay);
- headers_data = Map();
- headers_data.put("X-com-zoho-expense-organizationid","643169496");
- response = invokeurl
- [
- url :"https://www.zohoapis.com/expense/v1/reports/expensedetails"
- type :GET
- parameters:params
- headers:headers_data
- connection:"adminexpense"
- ];
- if(response.get("message") == "Please check the date range")
- {
- continue;
- }
- info response;
- }
Access your files securely from anywhere
Zoho Developer Community
Deliver unforgettable customer experiences
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.