Paging data before calling the API

[Daniel_Figueredo]

Hello all!

I'm using the Download tool to PUT my API and send some data as the last step of my workflow but since I'm manipulating quite a lot of data I'm getting the error "413 - Request Entity is too large".

I need to know if there is a way to iterate through this data and use a paging solution to send it little by little.

Best Regards.

[AngelosPachis · Accepted solution]

Hi @Daniel_Figueredo ,

Yes you can achieve that with an iterative macro. There are quite a few threads in the community, so to begin with I will link you to two of those: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-macro-for-API-pagination-ret...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-API-call-with-pagination-amp...

Regards,

Angelos

[AkimasaKajitani]

Hi @Daniel_Figueredo 

You may also use Throttle tool. 

Just insert it into your workflow and please try it.