Problem with Alteryx and FRED API

Question

Hi,

I have tried to download large amount of macro economic and industrial indicators from FRED (https://fred.stlouisfed.org/) Economic Research of St. Louis FED. My workflow is basic, just creating bunch of URL:s in the right format for the API, feeding those to the download tool and lastly parsing the XML data to a more usable format.

Everything works well with 50-100ish data series but for larger amounts (200-1000 series) the workflow returns null values. Has someone used this particular API and knows if there is some sort of hard cap for amount of requests per workflow? Has anyone noticed similar issues when dealing with other (REST) APIs?

matthew_foster · Answer

I encountered the same issue.  I placed a Throttle tool just before the download tool and throttled to 100 records per minute. Each record in my case was 1 FRED Series, so this kept me under the 120 series per minute limit that FRED allows.

apathetichell · Answer

@bmack- attach a text to columns tool. split that field to rows. use /n as your delimiter.

bmack · Answer

@danilang

On this subject, I'm having trouble with the URL setup and where to input my API

You can see that no data is downloaded.

THanks