Unable to send more than 7K records using API post request (download tool) with Json body

Question

Hello,

We are trying to send an API Post request to an external software/tool. And we are unable to push more than 7K records. We are using the body as Json and please find the following configurations of Download tool.

URL Field - is API endpoint link

Output to a field - String

Payload: HTTP Action - POST

Take Query String/Body from field - is Json file

Connection:  We are using a username and password as authentication

Maximum Connections : 4

I cannot send you the endpoints and Json file due to confidentiality. We have used the external's tools Swagger page to push more than 7K records with the same user name and password that we configured to download tool and it seems to be working fine. So, it's a clear sign that we do not have any network is open to push as many records as needed and the third party software confirms that there are no limitations in sending the records. And everything works fine when we send less than 7K records.

Can you please confirm if there are any limitations set in the performance of Download tools?

apathetichell · Answer

divide this up to multiple rows/api posts.

Nagendra_Vuppala · Answer

Hi @apathetichell - Thanks for your swift response!

As mentioned in my initial request, there are no limitations set in the API that I use. I have tried to push more than 10K+ records using the same user name and password on Postman application and it seems to be working. This may be because of the string size limitation as you said. Currency, the string length of my Json is 13860453. Can you please let me know the maximum size a cell can handle to perform Post API request? Unfortunately, I cannot send you the endpoint of the service provider on community.

I am happy to share my contact details for a catch-up.

apathetichell · Answer

@Nagendra_Vuppala  - The limitation is in the specific API you are pinging which has a set max size to the payload or the number of records processed. If you provide more information on the API - perhaps someone can help? In addition you could be facing a filed size limit - ie the string size you are using for your body is too small. Perhaps you need to split your post into multiple calls?