texlytics

Loading

Category Business Intelligence

07/08/ 2026
Your Warehouse Is the Index the API Won’t Give You

A pull I had run cleanly for months started dying. Same endpoint, same code, same credentials. It would page through tens of thousands of AP registered invoices and then, somewhere north of 19,000 records, fall over. The frustrating part was the consistency. It did not fail randomly. It failed at the same place every time. That consistency turned out to be the whole story. By the time I was done, the ceiling had moved on me twice, and the most dangerous version of the failure was the one…

Read more