I have this Trial Balance Read API, and tried to request the data from 1st Jan to 31 Jul this year, I only requested 8 columns, 18000+ rows, but it gave me a 502 error.
Talked to our consultant, they said it is because the payload is heavy. They suggested that I should select Top 100.
However, when I requested another API which loaded 50,000+rows and 85+ columns, it loaded successfully.
So my question is, is there any limit to load for the C_TRIALBALANCEResults?