I keep getting a max number of requests error in my function

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.

  3. userList = List();
  4. currentMonth = zoho.currentdate;
  5. firstDay = currentMonth.eomonth(0);
  6. lastDay = currentMonth.eomonth(-1).addDay(1);
  7. headerUser = Map();
  8. headerUser.put("X-com-zoho-expense-organizationid","643169496");
  9. usersresponse = invokeurl
  10. [
  11. url :"https://www.zohoapis.com/expense/v1/users"
  12. type :GET
  13. headers:headerUser
  14. connection:"adminexpense"
  15. ];
  16. users = usersresponse.get("users");
  17. for each  person in users
  18. {
  19. userID = person.get("user_id");
  20. userList.add(userID);
  21. }
  22. for each  ID in userList
  23. {
  24. params = Map();
  25. params.put("user_id",ID);
  26. params.put("date_start",firstDay);
  27. params.put("date_end",lastDay);
  28. headers_data = Map();
  29. headers_data.put("X-com-zoho-expense-organizationid","643169496");
  30. response = invokeurl
  31. [
  32. url :"https://www.zohoapis.com/expense/v1/reports/expensedetails"
  33. type :GET
  34. parameters:params
  35. headers:headers_data
  36. connection:"adminexpense"
  37. ];
  38. if(response.get("message") == "Please check the date range")
  39. {
  40. continue;
  41. }
  42. info response;
  43. }




        • Recent Topics

        • Notifications push : Encourager le réengagement et renforcer la fidélité des utilisateurs efficacement

          Vous avez déjà souhaité engager et communiquer de manière proactive avec les utilisateurs, y compris lorsqu'ils utilisent votre application de manière peu active ? Zoho Apptics vous offre déjà des fonctionnalités qui vous permettent d'évaluer la performance,

        • Easy way to delete attachments

          I've reached my data limit and would like to run a view/report, and mass delete attachments. Is there an easy, fast way to do this? Moderation Update: Post Summary: There are two features the post discusses a) Easy way to remove Email attachments Will

        • How to add new deal to existing contact

          Hi, I want to add new deal to existing contact.

        • Domain verification is in progress... (How long do I need to wait?)

          Trying to setup my first email domain by connecting with GoDaddy. Have been here for quite some time and the screen is not changing. How long should this take?Send DataSend Data

        • Linking an email to a Contact when the email is sent in deluge via sendmail

          The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that

        • How to restore deleted Field

          I edited a field in zoho form and by accident I deleted a field (email address). The form is ongoing to be filled by respondent. Then, when I checked to the all entries and report, the email address is gone. I checked in audit log, there is a record that

        • How to select multiple notes at once in the PC client?

          In the PC client, you can select notes using ctr+LMB. But why can't you use shift+LMB? PC version 3.2.0

        • How I can add customized Invoice

          Hi, I wanna use a customized Invoice, how i can add that

        • Zoho Analytics Pivot Table - How to compare month vs last year same month

          Hi, I had created a pivot table with setup as below: Column: - Delivery Date Row: - Customer Group Data as column - Total amount (sum > normal) (show data of the month) - Total amount (sum > % difference from previous value) (compare between this month

        • Recorded imported goods

          I have imported some goods from a foreign vendor called ABC. to Bahrain. My Customs duty and VAT are paid by an agency called XYZ to authorities. I have paid the amounts to XYZ and they have paid to authorities in behalf of us using our TRN Number. Now

        • Notes created in mobile app not syncing with web notebook

          I have created certain notes in a new notebook in mobile app. The new notebook is also created using mobile app and when I logged in through web I am unable to see notebook that I have created using mobile app. there is no trace of notes in which i have created in mobile app on the web even after days of creating in mobile app This is not the case vise-a-versa. the notes and note book created on web are accessible on mobile app on real time.  this is very inconvenient and big demotivating factor

        • Match Transaction > Filter | Allow wildcards in search

          The Filter function is useful for narrowing down to a specific set of transactions. It would be useful to have the ability to use wildcards in search. e.g. customer name "starts with" or " * " as a placeholder. e.g. "National * " instead of "National

        • Marketing Automation Emails Going to Spam

          Google is trapping all the marketing automation emails in spam. My domain has a perfect reputation and it looks like Zoho has a low reputation which is sending it to spam. When I pull the email out of spam and click on a link in the email, I get this

        • Convert Request to Forum Topic

          I know you can convert a forum topic to a request and a request to a solution in the knowledge base, but how do you convert a request to a forum topic?  Is this possible?  If not is this a feature coming down the pipe in the near future? Thanks!

        • Send To Zoho Sign not Showing

          The button send to Zoho sign is not showing on my Zoho CRM . Is there additional steps I need to take after installing Zoho Sign to CRM ?

        • Zoho Sign / Prefill By You - Editable by Them!

          Zoho Sign seems to have two field options available - an empty field for signer(s) to complete or a field that has been prefilled by you, that becomes read only once sent.  What I would like is an option on the pre-filled by you fields, to leave them

        • Is the Contacts sync between Campaigns and CRM bi-directional?

          Is the Contacts sync between Campaigns and CRM bi-directional?

        • Task does not syncing to google calendar shedual

          Hi why does the tasks activities do not syncing with the google calendar like the event option does?

        • Bug with Zobot Human transfer

          I have configured the brand, the operator, and the Zobot in Spanish. However, no matter what I do, it always says "YES" instead of "Sí" or "Sure, why not " instead of "Claro, ¿por qué no?" when asking if the user wants to contact a human operator. The

        • Error AS101 when adding new email alias

          Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.

        • This mobile number has been marked spam. Please contact support.

          Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?

        • email address autocomplete

          Is there a way to eliminate certain addresses from showing up in auto complete when entering an address? Many old and unused addresses currently show up, many of which I would like to get rid of. Thanks

        • Something went wrong. One or more fields contain errors

          I am getting this error but there is no way to debug what field is causing the issue . I have over 100 fields. Everything was working fine and then i fixed some fields that should have the same field names but had a typo and i am getting this error. It

        • Integrating Zoho Desk Instances from two separate organizations

          Is it possible to integrate Zoho Desk with an instance from another organization? For example, creating a ticket in one organization can cause the creation of a ticket in the second organization? Or certain tickets from one organization be viewable by

        • Knowledge base bug - Error: Article couldn't be updated.

          It took me a while to figure this out, truly one of the most irritating bugs in Zoho. I hope you find this information helpful. When using the knowledge base to create articles, make sure your keywords are in lowercase and separated by commas. Otherwise,

        • Is this possible with Campaigns?

          My company is currently moving CRM's from Monday to Zoho One. Currently, our marketing lead process is send out 7 sms messages over 14 days if the lead is in a certain status. If we don't get a response the lead is put into a "Closed" status. Do we buy

        • How to view two portals (Zoho CRM & Zoho Books) in single login

          Hello there, I need to create a portal access for the Customers. Customer data present in two applications namely Zoho CRM & Zoho Books. My requirement is to show the two different portals(Zoho CRM Portal & Zoho books Portal) in single login. I could

        • Invoice status on write-off is "Paid" - how do I change this to "Written off"

          HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way

        • Updating Bounced Contacts in Campaigns to the CRM

          The article explains how to update Opt-outs from Campaigns to CRM, but not bounces. While Campaigns will automatically remove any bounced emails from future campaigns, is there a process by which a bounce will update or make a notification in the CRM

        • Bandwidth, voice and poor video

          Dear Team, The webinar has made things quite easy and convenient for educators around the world. We are an art & culture-based organization where students and researchers are our major audience.  While using the Zoho webinar platform, we have observed that the audio lags and the video is of poor quality and often freezes. Some participants don't hear what is being spoken.  We also found that even a slightly slow internet connection disrupts the webinar while it should be working well even on lower

        • No Hope for Zoho Meeting

          Zoho Meeting is just the poorest meeting app I've come across in a long time. The support sucks too. I called to see if there was anything that could be done on the backend and while I was on a test meeting with support the video was lagging and freezing

        • Zoho books and venmo

          Hi, Is there a way to hook Venmo into zoho books? I have a Venmo business account and want to be able to sync that. I know you can do it with the paypal integration but I dont want to use paypal for the fees and that doesnt allow me use/integrate my current

        • Global Sets for Multi-Select pick lists

          When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.

        • 550 5.4.6 Unusual sending activity detected. Please try after sometime. <a href=https://www.zoho.com/mail/help/usage-policy.html target=_blank>Learn more.</a>

          Please help me with this. Sending of mails is blocked.

        • The Social Wall: November 2024

          Hey everyone, As we move into December, we're excited to share all the updates that went live in Social during November. View, monitor, and respond to your WhatsApp and Telegram messages from Inbox Take your communication a step further by integrating

        • Segmenting Contacts Based on Product Purchased

          I am trying to organize our main Marketing Automation email list in a way that segments contacts based on products they have purchased (for example in this case it is 3 different products). To my knowledge, this would require the sync from Zoho CRM to

        • Urgent Assistance Needed with DKIM Verification

          Hi, I have been trying to verify the DKIM for the past month using your instructions as well as other resources. Unfortunately, I have not been able to resolve the issue, and it remains persistent. I need to address this problem as soon as possible so

        • How do I attach tasks from one task to other tasks in the same project

          How do I attach tasks from one task to other tasks in the same project

        • Incorrect Handling of XLSX data

          Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. format

        • Zoho Books Invoice Salesperson: requires ID but there is no "Fetch salesperson" action

          Hi, I am trying to attach a Salesperson to a Zoho Books invoice. In Zoho Flow, the salesperson field required an ID. However, I only have the salesperson name, I need to fetch salesperson by name and then provide the ID. There is no option to fetch salesperson...

        • Next Page