• Courses
    • User Courses
    • Partner Courses
  • Forums
  • Contact
  • SIGN UP
    • Login
Spire AcademySpire Academy
  • Courses
    • User Courses
    • Partner Courses
  • Forums
  • Contact
  • SIGN UP
    • Login

Reply To: Connecting to Excel via Spire API

March 15, 2021 at 9:05 am #12182
Luca Del Mastro
Participant

Thank you for the reply. I am using it on Chrome browser on a Windows 10 PC. I have done it the same way on each module and keep getting the limit too high error. The only one that does not give me that is sales orders which has 7,517 current orders.

This led me to believe that there is some sort of hard limit programmed in. Every other module is too large and it looks like there is a hard limit set up of possibly 10,000 records only. I was ok when typing in ?limit=10000 but as soon as I switched it to ?limit=10001 it returned with limit too high.

This tool is  very powerful and I’m assuming the limit is there for a reason but it does hinder our ability to utilize it as I am not even able to extract the sales order details list. Some other modules are also potentially very powerful through this API link as well and I was wondering if there was any way of removing the hard limit?

If not, is  a consistent method to filter only to see the most recent records? I noticed in the reply above you added a filter code for invoice date, but is that format specific to getting the invoice date?

Thank you for all the help.

Copyright © 2021 Spire Systems Inc. All Rights Reserved.

Privacy Policy
Terms & Conditions

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now