Slow API & Eventual Memory issue

Posts about the simPRO API. Help/support/how-to etc.
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
KevWheeldon
Posts: 1
Joined: Tue Apr 21, 2026 3:44 pm

Slow API & Eventual Memory issue

Post by KevWheeldon » Tue Apr 21, 2026 3:54 pm

Hi All,

I've recently taken over for someone who has left the business. They've created a single AWS Glue script that gets all data from the following endpoints,

Code: Select all

    endpoints = ["contractors", "vendorOrders", "catalogs", "vendors", "invoices", "employees", "jobs",
                 "quotes", "sites", "setup/teams", "contractorInvoices", "jobWorkOrders", "jobCostCenters", "schedules"]
This includes Hierarchical data. However, the duration of this is over 7 hours and it's only going to get longer as more data is downloaded. Recently, we're getting Command failed with exit code 137. (ran out of memory and the OS killed it).

Any suggestions on getting this to work without the issues of Memory?

Would you recommend splitting each Endpoint into it's own run (Excluding the hierarchical ones)

TIA

:)
Top
FFsimprouser
Posts: 19
Joined: Tue Feb 15, 2022 1:57 pm

Re: Slow API & Eventual Memory issue

Post by FFsimprouser » Wed May 06, 2026 4:08 pm

I am also interested in any response to this
Top
SimproAPITeam
Posts: 831
Joined: Wed May 01, 2024 2:31 am

Re: Slow API & Eventual Memory issue

Post by SimproAPITeam » Mon Jun 01, 2026 12:27 am

Hello, yes this would be a substantially massive request, I would for sure be breaking up the request into a staged approach of some sort in order to make it so if a single request fails it does not fail the whole script. Also depending on the specifics I'd look into running it in parallel.

We specify an internal maximum page size to each endpoint but I'd ensure your script isn't just using the default of 30 and then requesting the following 30 as this would also be a substantial increase to the time.

Hope this helps, if you can provide anymore information on the context of the script we might be able to make some more suggestions.

Regards,
Simpro API Team | Simpro Software Group
Top
Post Reply

Return to “General Discussion”