I have been looking at the BLS series IDs for Occupational Employment and Wage Estimates, and while I can identify the series iDs I want I cannot figure out how to pull them with Alteryx. My guess is that I need a URL?
Has anyone successfully pulled this data?
Solved! Go to Solution.
Hi @RUSA
An API isn't necessary since the Alteryx Download tool can download the text from these BLS publications::
https://download.bls.gov/pub/time.series/ce/
Using these URLs, you can use the Download tool to grab the text and parse the data as necessary. Check out the attached example where I download and parse the series lookup table.
Thank you, Charlie. That is very helpful!
Hi Charlie,
I'm new to Alteryx and am looking to download a specific series from BLS (LNS14000000). I ran your sample workflow and saved the output to a db table. Works great! However, I'm not understanding how to use Alteryx to download a series (versus a series listing).
What am I not understanding?
Thanks,
Gary
Just me jumping in over 2 years later to say THANK YOU Charlie - this has helped enable me to download the data from JOLTS for BLS data reporting. So thankful!