Fetching Data from Pardot

[Shubhamgauti879]

Hi,

I am trying to fetch Data from Pardot form 2 big Tables namely Prospects and Visitor Activity. I have created a macro that fetches records iteratively(since we are only able to fetch 200 records at one iteration). The issue that I am facing is that this workflow runs for an hour and then the api_key created expires and I start receiving the error-"Invalid api Key".

I tried resolving this issue by generating the api key in the workflow itself(tried both inside and outside the macro) but still the api_key expires after 1 hour and I am not able to fetch all the data from these tables.

Can anyone help me with an approach?

Thanks in Advance

[EricWe]

Hi @Shubhamgauti879, 

Please contact support@alteryx.com so we can review your use case in further detail. 

Thanks, 

Eric West 

Senior Customer Support Engineer

[Alekhya]

Can you share the macro you built to get more than 200 records?